This sort of flying is called scud running.
And airline fixed wing flying pressure rating is single digits percentage wise compared to what these corporate charter rotary pilots do.
The customer is usually late, they have a fixed time to get somewhere. 9 times out of 10 if they are using a helicopter then they are picking up and landing off airport with no landings aids/lights. If there are no landing aids they have to be able to get visual with the ground somehow. If there is complete cover of cloud then they have to stay below it for the whole trip. Or go to an airport with landings aids get below the cloud then break off and fly visually to the landing site. But this can add an extra 30 mins onto the flight time.
This guy will have been under the cloud so he can land at his site with his prime. Looking at the flight track he was navigating by following the freeway. The area where he wanted to land was inside an airport control zone. That airport did have landing aids to its runway and had traffic on them. Now Special VFR rules have different rules for ATC than normal VFR. VFR they can presume that the pilot can see and avoid IFR traffic doing approaches into the airport. SVFR they have to positively separate it somehow usually by radar. If the helicopter is so low that it doesn't paint on radar they have a problem and have to increase the separation from 5 miles and 1000ft up to 10 miles and 3000ft. While they are sorting out this unplanned wild zone penetration they still have to keep the traffic flowing onto the main runway. To create a gap it takes 10 mins or so because they have to start playing with the sequence 20 miles out to create a hole. So when the helicopter rocks up, which ATC can't see on radar and know nothing about, they get told to remain clear of the control zone. The pilot then has a problem, they are low, below minimum safe sector altitude and they have restrictions about flying over built up areas. As soon as they start turning they loose their navigation fix which was the freeway. Now we are into how well do they know the local area in good weather. Plus they have the added pressure of there prime has to get to where they are going and they are late already so they will be heading fast towards the control zone boundary and at the last moment been told to remain clear. To note its been 15 odd years since I have flown in the USA so the SVFR rules might have changed.
The rotary peeps can do a thing called quick stop which is where they stick the nose up and give max torque to the main rotor and that kills the forward motion but they keep the same alt. There is also another manoeuvre where they transition the machine to nearly vertical and use gravity to slow it down. When they get to zero speed up wards they swing the back end round using the yaw pedals and then accelerate away in the opposite direction. its called a U turn.
Here is an example.
I am fixed wing and only flown a helicopter a couple of times. Everything is about the rotor speed and how much torque you are pulling in these sorts of manoeuvres and controlling the yaw. If you let the nr decay your in the poo. Big rotor and two engines you would have to be pulling some amount of torque well over red line to kill the Nr I would have thought in a S76 but if you have a big lump of ground coming towards you needs must.
Said in the nicest possible way about my mates that fly helicopters, they are all slightly off their heads. The machines are in my view death traps before you even start the engines. As soon as you do you are having to constantly fly them because they are fundamentally unstable. They have one nut which keeps the rotor on which is called the Jesus nut. The amount of fuel on board they take off with I would be declaring a mayday before engine start due hitting my min reserve. I have enough for 30 mins holding and 1 instrument approach plus fuel to get to another airport at the absolute minimum at the end of the planned flight. They are happy if there is 30 mins on board plus 5-10 mins left in the tanks. Operating all day inside the dead mans curve is normal. Their close calls happen weekly not every 10 years like mine do and require more luck to survive than mine do to boot as well on fixed wing. The 3 seconds to react which we have been discussing on the MAX threads as being insufficient is an eternity when things go wrong at sub 30 knts and low level which they spend a lot of there time, doing long lining etc.
This video caused quiet a stir in the UK even amongst military pilots. It is the UK special forces helicopter in Wales following a road to try and get out of fog.
Please note I have not expressed an opinion about what has happened in this case just given some pointers about what the general situation setup would have been like and the reasons why the holes in the cheese started lining up. My gut feel though is it will not be an engineering failure.
NTSB will have the preflight paper work. The flight radar24 type plots which have limitations because it was below radar cover. The wreckage which to be honest they can perform miracles with to see if there was a mechanical fault. How the various bits of metal are bent apparently tells a story like reading a book. And various weather statements from witnesses in the area.
Unfortunately the NTSB have vast experience with this sort of accident. Usually though its an air ambulance (HEMS) which has crashed in similar circumstances.