Fatal NTSB investigations: Cessna 501
9 cases on aircraft the registry lists as Cessna 501. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1979 | 1 |
|---|---|
| 1985 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2020 | 1 |
| 2021 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 ('2076603'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 ('2076603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA21FA234Accident · 7 fatalClass 3 · FieldFinal reportCessna 501 · Smyrna, TNThe pilot’s loss of airplane control during climb due to spatial disorientation.NTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB CEN14WA216Accident · 4 fatalForeign investigationCessna 501 · Trier-Föhren Airport, GermanyOn January 12, 2014, approximately 1200 universal coordinated time, a Cessna 501 Citation I SP airplane, US registration N452TS, was destroyed when it impacted terrain about 2.5 nautical miles from runway 22, Trier-Fohren Airport, Germany. The pilot,…NTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.NTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicNTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.NTSB CHI01FA111Accident · 1 fatalField investigationFinal reportCessna 501 · Ashwaubenon, WIThe pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…NTSB MKC85FA110Accident · 2 fatalField investigationFinal reportCessna 501 · Harrison, ARAt 2003 CDT, the flt was cleared for an ILS localizer apch to rwy 36 at the Harrison/boon county arpt. About 7 min later, the aircrew reported making a missed apch & the flt was cleared to the outer compass locator for another apch. The crew asked the…NTSB CHI79FA064Accident · 1 fatalField investigationClosedCessna 501 · Canton, OHthe pilot's failure to recognize the need for, and to take action to maintain, sufficient airspeed to prevent a stall into the ground during an attempted landing. The pilot also failed to recognize the need for timely and sufficient power application to…