https://en.wikipedia.org/wiki/Armavia_Flight_967 https://en.wikipedia.org/wiki/Indonesia_AirAsia_Flight_8501 https://www.youtube.com/watch?v=8F5bRxTIn24
A pretty extreme UX issue.
AF447 seems like a pretty important case study for figuring out where to put the balance of trust. Along with the very final stage of Aeroflot 593 (after the child had left the seat), also mentioned.
There's a few more: Colgan Air 3407, AirAsia 8501, Korean 501, etc, where flight crew ignored or overrode systems. Which is not to deny that in the majority of cases the flight crew are the best judge of what is needed, just that one surely has to look critically and honestly at counter examples.
There is of course also Germanwings 9525, though as the GP implies, systems protecting against malicious piloting will probably be counter-productive.
One plane actually crashed because the prevention system disabled itself and the pilots believed it was still there to protect them from bad actions on their part:
> caused the autopilot to disconnect, after which the crew reacted incorrectly and ultimately caused the aircraft to enter an aerodynamic stall, from which it did not recover
https://en.wikipedia.org/wiki/Air_France_Flight_447