Fatal NTSB investigations: Cessna 337C
13 cases on aircraft the registry lists as Cessna 337C. 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
| 1969 | 2 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2009 | 2 |
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 ('2075712'))
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 ('2075712'))
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 CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.NTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB ANC00FA081Accident · 1 fatalField investigationFinal reportCessna 337C · Marshall, AKThe pilot's attempted takeoff with known deficiencies in equipment (an inoperable rear engine) and an inadvertent stall. Factors associated with the accident were the pilot's improper retraction of the landing gear, his over confidence in the airplane's…NTSB NYC99FA222Accident · 2 fatalField investigationFinal reportCessna 337C · North Adams, MAthe failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.NTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, CubaNTSB ATL91FA043Accident · 1 fatalField investigationFinal reportCessna 337C · Bryson City, NCThe inadvertent flight into instrument meteorological conditions in mountainous terrain by the noninstrument rated pilot.NTSB SEA76AS037Accident · 1 fatalClosedCessna 337C · Government Cmp, ORNTSB MIA76AM019Accident · 2 fatalClosedCessna 337C · San Juan, PRNTSB CHIMJAC070Accident · 1 fatalClosedCessna 337C · Kokomo, INNTSB MIA73AM022Accident · 3 fatalClosedCessna 337C · Mount Vernon, GANTSB NYC70F0161Accident · 1 fatalClosedCessna 337C · Toms River, NJNTSB SEA69A0060Accident · 3 fatalClosedCessna 337C · North Bend, OR