NTSB investigations: Cessna 140A, CA
19 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 |
| 1967 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2025 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 ANC25LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Los Banos, CAThe pilot’s failure to maintain directional control during the landing roll with a crosswind, resulting in a ground loop and nose over.NTSB WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB GAA17CA118Accident · No injuriesData collectionFinal reportCessna 140 · Markleeville, CAThe pilot’s failure to maintain altitude during a low pass and the subsequent impact with a snow berm, which resulted in a nosed-over.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 WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.NTSB OAK78FVD50Accident · No injuriesClosedCessna 140A · Concord, CANTSB LAX75AL024Accident · No injuriesClosedBell 47G-5 · Riverside, CANTSB LAX73AL002Accident · 1 fatalClosedCessna 140A · Rialto, CANTSB OAK72DVG68Accident · No injuriesClosedCessna 140A · Hayfork, CANTSB LAX71DUM38Accident · No injuriesClosedCessna 140A · Borrego Spg, CANTSB LAX71FUA28Accident · No injuriesClosedCessna 140 · Santa Ana, CANTSB OAK69D0259Accident · No injuriesClosedCessna 140A · Exeter, CANTSB LAX67F0408Accident · No injuriesClosedCessna 140A · Santa Ana, CANTSB LAX67D0284Accident · No injuriesClosedCessna 140A · Essex, CANTSB LAX66D0216Accident · No injuriesClosedCessna 140A · Lancaster, CANTSB UNK64X3747Accident · No injuriesClosedCessna 140A · Fresno, CANTSB UNK64X3179Accident · No injuriesClosedCessna 140A · San Diego, CANTSB UNK64X2204Accident · No injuriesClosedCessna 140 · Winters, CANTSB UNK64X0532Accident · 1 fatalClosedCessna 140A · Shafter, CA