To have that amount of "intact" evidence will hopefully help to determine the primary cause quickly.
There are only 2 primary cause possibilities in my opinion, another epicyclic module failure or maintenance error. Of course, if its epicyclic failure, there will be dozens of contributing factors to analyze, HUMS, monitoring, gear manufacture, just like REDL.
If its an MGB failure, I think the 225 is finished for offshore use. The Eurocopter re-branding to Airbus Helicopters to distance itself from the 2x NS ditching accidents may prove to tarnish more than polish the Airbus name. It will certainly advertise deep pockets for the lawyers who will represent the poor families affected by this tragedy.
If its a maintenance error, the 225 will survive. Whichever is the cause, the fallout will be very difficult to bear.
CHC could end up as being simple collateral damage caused by no revenue being generated by the 225. Oil and gas companies won't pay again for an extended grounding.
My positive thoughts are with everyone, I am genuinely very saddened by this.