# Fatal NTSB investigations: Cessna 500

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA17FA135](https://openairdocs.org/ntsb/ERA17FA135.md): Cessna 500 · Marietta, GA · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N8DX · Destroyed
  > The pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…
- [NTSB CEN14FA009](https://openairdocs.org/ntsb/CEN14FA009.md): Cessna 500 · Derby, KS · Accident · 2 fatal · Field investigation · Final report · Oct 18, 2013 · N610ED · Destroyed
  > The airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…
- [NTSB DFW08MA076](https://openairdocs.org/ntsb/DFW08MA076.md): Cessna 500 · Oklahoma City, OK · Accident · 5 fatal · Class 1 · Major · Final report · Mar 4, 2008 · N113SH · Destroyed
  > Airplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.
- [NTSB CHI07FA187](https://openairdocs.org/ntsb/CHI07FA187.md): Cessna 500 · Conway, AR · Accident · 2 fatal · Field investigation · Final report · Jun 30, 2007 · N771HR · Destroyed
  > The pilot's failure to fly a stabilized approach and his delayed decision to abort the landing. Contributing to the accident was the standing water on the runway.
- [NTSB DFW06FA019](https://openairdocs.org/ntsb/DFW06FA019.md): Cessna 500 · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2005 · N505K · Destroyed
  > The pilot's failure to maintain directional control of the airplane resulting in an inadvertent stall/mush. Contributing factors were the unsecured passenger door and the pilot's diverted attention.
- [NTSB LAX90FA332](https://openairdocs.org/ntsb/LAX90FA332.md): Cessna 500 · San Luis Obispo, CA · Accident · 4 fatal · Field investigation · Final report · Sep 24, 1990 · N79DD · Destroyed
  > The pilot's improper IFR (instrument) procedure, and his failure to maintain the minimum descent altitude (mda) for the approach. The adverse weather was a related factor.
- [NTSB DCA81AA007](https://openairdocs.org/ntsb/DCA81AA007.md): Cessna 500 · Bluefield, WV · Accident · 5 fatal · Closed · Jan 21, 1981 · N501GP · Destroyed
- [NTSB DEN80FA009](https://openairdocs.org/ntsb/DEN80FA009.md): Cessna 500 · Castle Rock, CO · Accident · 2 fatal · Closed · Nov 19, 1979 · N555AJ · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076602'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=2076602

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.