Fatal NTSB investigations: Cessna 337B
15 cases on aircraft the registry lists as Cessna 337B. 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
| 1967 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2004 | 1 |
Where
Latest 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 ('2075706'))
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 ('2075706'))
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 LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB DEN01FA162Accident · 1 fatalField investigationFinal reportCessna 337B · St. George, UTtotal loss of engine power on both engines due to fuel starvation and the pilot's inability to access the available fuel supply. Contributing factors were the pilot's inadequate supervision of the refueling operation, and his intentional operation of the…NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).NTSB NYC97FA170Accident · 1 fatalField investigationFinal reportCessna 337B · Warren Township, NJthe pilot's loss of control in flight for undetermined reasons and the subsequent collision with terrain.NTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, CubaNTSB MKC86FA028Accident · 1 fatalField investigationFinal reportCessna 337B · Fayetteville, ARThe plt and his wife were flying to Alaska with the first en route stop to be canton, TX. The non-plt wife stated that as the acft passed over the departure end of the rwy on takeoff, her husband released the controls and threw his head back. She kept the…NTSB FTW81FA122Accident · 3 fatalClosedCessna 337 · Pampa, TXNTSB MIA80FA092Accident · 2 fatalClosedCessna 337B · Osteen, FLNTSB MIA76AM095Accident · 1 fatalClosedCessna 337B · Augusta, GANTSB MKC76AK034Accident · 1 fatalClosedCessna 337B · St Paul, MNNTSB CHI73AC033Accident · 4 fatalClosedCessna 337B · Chicago, ILNTSB FTW71AF065Accident · 2 fatalClosedCessna 337B · Spring, TXNTSB FTW71AF031Accident · 2 fatalClosedCessna 337B · Houston, TXNTSB MIA70AM053Accident · 2 fatalClosedCessna 337B · Cedar Key, FLNTSB FTW67A0100Accident · 2 fatalClosedCessna 337 · La Porte, TX