The Galloping Ghost is one of my favorites: https://www.ntsb.gov/investigations/AccidentReports/Reports/...

It's a terrible accident (that happened during an air show/race), but the work that went into figuring out exactly what went wrong and where is awe-inspiring. Also a very interesting (but tragic) story from a human standpoint. Here's the video of the accident: https://www.youtube.com/watch?v=JyWUTXuXjr0

(No gore, but still: viewer discretion advised. Eleven people lost their lives and sixty-nine were injured.)

This one from 2004 involves a modern regional jet (Bombardier RJ) dead-stick crashing on a reposition flight. The crew's decision-making & remedial actions boggle the mind. I'd call it a case study in horrendous pilotage. Thankfully, no innocents died.

https://www.ntsb.gov/investigations/AccidentReports/Reports/...

Any of these, these are major investigations carried out by the NTSB:

https://huntlibrary.erau.edu/collections/aerospace-and-aviat...