The AF447 was 100% crew error, the FO completely fucked up and froze. There was some code that did mess up the pilots in recovering, but the FO panicked an put the plane into a deep stall then held the nose up. If he had just let go of the fucking stick, the plane would have recovered on its own.
Pitot tube freezing can occur under rare conditions and yes they did redesign these to make it even less likely but it can still happen and you can still get inaccurate speed data from any plane. Ironically, MCAS might have saved AF447.
This was not an insulated incident. The modern planes are designed not to crush. It's up to the airlines to make sure that the pilots know and understand the systems. In the Venezuelan crash the pilots rode the plane into the ground from 30 k feet despite the stick shaker. In Brazil, the pilot overpowered the system designed to save the plane after the thrust reverser deployed. It's rare, but it happens. These two will probably be another cases of operators failing to master the type.

