Fatal NTSB investigations: Cessna 337G
13 cases on aircraft the registry lists as Cessna 337G. 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
| 1976 | 1 |
|---|---|
| 1978 | 3 |
| 1979 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1986 | 1 |
| 1990 | 2 |
| 2006 | 1 |
| 2011 | 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 ('2075730'))
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 ('2075730'))
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 CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB NYC90FA129Accident · 2 fatalField investigationFinal reportCessna 337G · Harrison, NYThe pilot's decision to continue VFR flight into IMC and his subsequent loss of control of the airplane. The weather conditions and the pilot's lack of instrument flight experience were factors in the accident.NTSB FTW90GA088Accident · 1 fatalFinal reportCessna 337G · Notrees, TXThe pilot's decision to continue VFR flight into known IMC.NTSB ATL86FA062Accident · 5 fatalField investigationFinal reportCessna 337G · Blairsville, GAAcft was flown VFR from ravenna, Ohio en route to atlanta, GA. It departed ravenna about 0930 01/17 & failed to arrive at its destination. Family reported acft missing. Air force rescue center notified at 2020 01/19. Cap commenced air search 01/20, hampered…NTSB FTW83AA024Accident · 4 fatalFinal reportPiper PA-31P · Carrollton, TXA PA-31, N100FD, was being vectored by dfw approach control (apch ctl) for a landing on rwy 13L at dallas-love fld. The plt's last received & acknowledged instructions were to descend & maintain 2000' & turn left to 190 deg. Simultaneously,a Cessna 337,…NTSB ATL81FA069Accident · 1 fatalClosedCessna 337G · Greensboro, NCNTSB MIA81FA059Accident · 2 fatalClosedCessna 337G · Vero Beach, FLNTSB NYC80FA011Accident · 3 fatalClosedCessna 337G · Bennington, VTNTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GANTSB LAX78FA024Accident · 1 fatalClosedCessna 182A · Los Angeles, CANTSB CHI78FA015Accident · 2 fatalClosedCessna 337G · Marion, ILNTSB MIA77DA015Accident · 2 fatalClosedCessna 337G · Summer Haven, FL