Fatal NTSB investigations: Cessna 337
16 cases on aircraft the registry lists as Cessna 337. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1971 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1980 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2004 | 1 |
| 2022 | 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 ('2075702'))
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 ('2075702'))
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 WPR22FA160Accident · 1 fatalClass 3 · FieldFinal reportCessna 337 · Sylmar, CAThe pilot’s loss of airplane control while troubleshooting a landing gear issue, which resulted in an aerodynamic stall/spin at an altitude too low to recover. Contributing to the accident was the pilot’s impairment from alcohol consumption.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB MIA92FA070Accident · 3 fatalField investigationFinal reportCessna 337 · Moore Haven, FLThe pilot-in-command's in flight loss of control due to spatial disorientation. Contributing to the accident was the pilot-in-command's lack of total experience in night flight, and the lack of natural horizon or surface reference while flying over a sparsely…NTSB SEA91FA071Accident · 1 fatalField investigationFinal reportCessna 337 · Boise, IDThe pilot's failure to remove the aircraft control locks prior to attempting flight. Factors include an inadequate preflight.NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB MIA80FA060Accident · 1 fatalClosedCessna 337 · Atlanta, GANTSB FTW76ORG71Accident · 2 fatalClosedCessna 337 · Amatlan, MexicoNTSB LAX76AL052Accident · 2 fatalClosedCessna 337 · Maricopa, AZNTSB CHI76AC004Accident · 1 fatalClosedCessna 337 · St Johns, MINTSB CHI75AC042Accident · 1 fatalClosedCessna 337B · Griffith, INNTSB LAX75OL004Accident · 4 fatalClosedCessna 337 · Punta Chivato, MexicoNTSB OAK72AP006Accident · 1 fatalClosedCessna 337 · Grass Valley, CANTSB LAX72AL012Accident · 4 fatalClosedCessna 337 · Calexico, CANTSB DEN67A0061Accident · 4 fatalClosedCessna 337 · Huntington, UTNTSB UNK66X0145Accident · 2 fatalClosedCessna 337 · Z, CanadaNTSB NYC66A0062Accident · 1 fatalClosedCessna 337 · Glen Falls, NY