Fatal NTSB investigations: Cessna 140A
17 cases on aircraft the registry lists as Cessna 140A. 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
| 1964 | 4 |
|---|---|
| 1965 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1978 | 1 |
| 1983 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2014 | 1 |
| 2020 | 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 ('2071604'))
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 ('2071604'))
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 WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB WPR15FA039Accident · 2 fatalField investigationFinal reportCessna 140A · Gilroy, CAThe pilot’s failure to maintain clearance from power lines while flying at a low altitude. Contributing to the accident was the obscuration of the pilot’s visibility due to sun glare.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB FTW98FA291Accident · 1 fatalField investigationFinal reportCessna 140A · Edgewood, TXThe pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.NTSB DEN83FA203Accident · 2 fatalField investigationFinal reportCessna 140A · Sevier, UTThe flt was returning to san jose,CA after an extended x-country flt to oshkosh,WI which began in the latter part of July. Earlier on the day of the accident, at 0645, the plt received a wx briefing at miles city,MT. He requested the general outlook to the…NTSB FTW79FA032Accident · 1 fatalClosedCessna 140A · Ferndale, ARNTSB NYC74FFA17Accident · 1 fatalClosedCessna 140A · Scotia, NYNTSB MIA73AM105Accident · 1 fatalClosedCessna 140A · Burkville, ALNTSB LAX73AL002Accident · 1 fatalClosedCessna 140A · Rialto, CANTSB MKC70AK046Accident · 1 fatalClosedCessna 140A · Mexico, MONTSB MIA70AM052Accident · 1 fatalClosedCessna I40A · Miami, FLNTSB CHI70A0009Accident · 2 fatalClosedCessna 140 · Hulbert, MINTSB MKC66A0011Accident · 1 fatalClosedCessna 140A · Ava, MONTSB UNK65X0744Accident · 1 fatalClosedCessna 140A · Tulsa, OKNTSB UNK64X2237Accident · 1 fatalClosedCessna 140A · Fort Worth, TXNTSB UNK64X1715Accident · 1 fatalClosedCessna 140A · Gateway, CONTSB UNK64X0532Accident · 1 fatalClosedCessna 140A · Shafter, CA