Fatal NTSB investigations: Cessna 320E
16 cases on aircraft the registry lists as Cessna 320E. 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
| 1968 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1989 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2016 | 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 ('2074514'))
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 ('2074514'))
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 CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…NTSB CEN13FA039Accident · 1 fatalField investigationFinal reportCessna 320E · San Marcos, TXThe non-instrument-rated pilot’s decision to takeoff in night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB MIA06LA122Accident · 1 fatalLimited investigationFinal reportCessna 320E · Wimauma, FLPilot's inadequate preflight planning and exceeding the weight and balance limitations of the airplane.NTSB FTW01RA008Accident · 6 fatalForeign investigationCessna 320E · Ensenada, MexicoNTSB FTW94FA183Accident · 2 fatalField investigationFinal reportCessna 320E · Battle Mountain, NVThe pilot's failure to maintain terrain clearance while maneuvering during a low level aerial mapping flight. A factor was the box canyon.NTSB MIA89FA088Accident · 2 fatalField investigationFinal reportCessna 320E · Melrose, FLThe failure of the pilot to comply promptly with ATC instructions and his loss of control due to spatial disorientation.NTSB LAX79FA052Accident · 2 fatalClosedCessna 320E · Tucson, AZNTSB FTW79FA076Accident · 3 fatalClosedCessna 320E · Covington, LANTSB SEA78FA018Accident · 1 fatalClosedCessna 320E · Steptoe, WANTSB DEN76AD034Accident · 2 fatalClosedCessna 320E · Sinclair, WYNTSB MIA75AM049Accident · 5 fatalClosedCessna 320 · Tallahassee, FLNTSB SEA73AS023Accident · 4 fatalClosedCessna 320E · Walla Walla, WANTSB NYC73AN098Accident · 4 fatalClosedCessna 320E · Avoca, PANTSB MKC73AK044Accident · 4 fatalClosedCessna 320E · Goodland, KSNTSB MIA72AM104Accident · 5 fatalClosedCessna 320E · Charleston, SCNTSB CHI69A0054Accident · 1 fatalClosedCessna 320E · Pontiac, MI