Skip to content

Fatal NTSB investigations: Cessna 337A

20 cases on aircraft the registry lists as Cessna 337A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('2075704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2075704'))
  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 ('2075704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…May 17, 2008 · N5382S · Substantial damage NTSB IAD00FA024Accident · 1 fatalField investigationFinal reportCessna 337 · Prnce Frederick, MDwas the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…Feb 28, 2000 · N53HS · Destroyed NTSB DEN92FA078Accident · 2 fatalField investigationFinal reportCessna 337A · Ruidoso, NMThe pilot experiencing spatial disorientation and the resultant excessive descent rate. Factors were: the dark night conditions.Aug 1, 1992 · N337LS · Destroyed NTSB FTW89FA024Accident · 2 fatalField investigationFinal reportCessna 337A · Weatherford, TXThe pilot failed to maintain minimum required airspeed for slow flight (vs), resulting in a stall with insufficient altitude to recover. A contributing factor was the Piper pilot's unannounced fly-by, which diverted the Cessna pilot's attention.Nov 24, 1988 · N5337S · Destroyed NTSB SEA89FA001Accident · 3 fatalField investigationFinal reportCessna Robertson 337A · Eliza Island, WAThis Cessna/robertson 337 was departing from a 1600 foot grass strip in VFR conditions. There were gusting head winds estimated at 15 knots. At the midpoint of the runway the aircraft made a steep climbing left turn, stalling after about 180 degrees of turn.…Oct 2, 1988 · N6314F · Destroyed NTSB MIA85LAMS2Accident · 4 fatalFinal reportCessna 337 · Atlantic Ocean, FLThe acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index…Jan 14, 1985 · N505CX · Destroyed NTSB FTW81FA089Accident · 2 fatalClosedCessna 337A · Evant, TXMay 15, 1981 · N6345F · Destroyed NTSB FTW80FA087Accident · 4 fatalClosedCessna 337A · Aledo, TXJun 16, 1980 · N7DT · Destroyed NTSB MIA76AM070Accident · 1 fatalClosedCessna 337A · Greenville, ALMar 2, 1976 · N6346F · Destroyed NTSB IAD74AI061Accident · 4 fatalClosedCessna 337 · Clinton, MDMay 24, 1974 · N6363F · Destroyed NTSB MIA74AM044Accident · 1 fatalClosedCessna 337 · Ft Lauderdale, FLNov 19, 1973 · N333DD · Destroyed NTSB CHI74AC020Accident · 2 fatalClosedCessna 337A · Gary, INSep 4, 1973 · N6270F · 2 aircraft · Destroyed NTSB NYC72AN041Accident · 3 fatalClosedCessna 337A · Boonsboro, MDSep 18, 1971 · N6333F · Destroyed NTSB MIA72AM004Accident · 4 fatalClosedCessna 337A · B.W.I., BarbadosJul 23, 1971 · N5310S · Destroyed NTSB MIA71AM097Accident · 2 fatalClosedCessna 337A · Jackson, MSMay 16, 1971 · N5388S · Destroyed NTSB IAD71AI037Accident · 2 fatalClosedCessna 337A · Charlotte, NCFeb 2, 1971 · N5385S · Destroyed NTSB SEA68A0054Accident · 2 fatalClosedCessna 337A · Ariel, WAFeb 20, 1968 · N5326S · Destroyed NTSB MKC67A0079Accident · 1 fatalClosedCessna 337A · Medora, NDJun 10, 1967 · N5376S · Destroyed NTSB OAK67A0083Accident · 1 fatalClosedCessna 337 · Manchester, CAMay 27, 1967 · N5359S · Destroyed NTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCDec 19, 1966 · N5303S · Destroyed