Fatal NTSB investigations: Cessna 336
13 cases on aircraft the registry lists as Cessna 336. 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 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 2004 | 1 |
| 2022 | 1 |
| 2024 | 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 ('2075602'))
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 ('2075602'))
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 ERA25FA008Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 336 · Savannah, GAOn October 13, 2024, about 2230 eastern daylight time, a Cessna 336, N336LV, was destroyed when it was involved in an accident near Savannah, Georgia. The commercial pilot was fatally injured, and a pilot-rated passenger sustained minor injuries. The flight…NTSB WPR22FA216Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Porterville, CAMaintenance personnel’s failure to properly secure the elevator control assembly hardware, which resulted in an in-flight disconnection of the elevator and elevator counterweight and the pilot’s inability to maintain pitch control.NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB LAX92FA283Accident · 5 fatalField investigationFinal reportCessna 336A · Big Bear City, CA1) The pilot inadequately evaluating the weather, and 2) the pilot making the inflight decision to continue flight into adverse weather conditions. Factors in this accident were 1) the inability of the pilot to see the mountainous terrain due to the ambient…NTSB MIA79FA115Accident · 2 fatalClosedCessna 336 · San Juan, PRNTSB MIA78FA104Accident · 4 fatalClosedCessna 336 · Lakeland, FLNTSB MKC76AK046Accident · 4 fatalClosedCessna 336 · Mcgregor, IANTSB CHI70AC074Accident · 2 fatalClosedCessna 336 · Chicago, ILNTSB LAX70A0023Accident · 5 fatalClosedCessna 336 · Cabazon, CANTSB MIA69R0001Accident · 1 fatalClosedCessna 336 · Wms Isle, Burkina FasoNTSB OAK68A0004Accident · 1 fatalClosedCessna 336 · Bishop, CANTSB UNK65X1355Accident · 4 fatalClosedCessna 336 · Mexico City, MexicoNTSB UNK65X1354Accident · 4 fatalClosedCessna 210 · Mexico City, Mexico