NTSB investigations: Cessna 140, LA
11 cases on aircraft the registry lists as Cessna 140. 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
| 1967 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1979 | 1 |
| 1982 | 3 |
| 1993 | 1 |
| 2019 | 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.\"eventStateOrRegion\" = 'LA' 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 ('2071602', '2071603'))
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" = 'LA' 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 ('2071602', '2071603'))
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 CEN24LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Schriever, LAThe pilot’s inadvertent application of the toe brakes during the takeoff roll.NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB FTW83LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ruston, LAOn takeoff the pilot heard a loud bang sound then lost engine power. The pilot made a 180 degree descending turn back toward the airport. At the edge of the airport the pilot made a hard touchdown on all three gear assemblies. Investigation revealed the…NTSB FTW83LA015Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Iota, LAThe pilot chose to land on a private farm landing strip with a 2000 foot sod-surface runway and 50 foot trees at the north end of the strip. The pilot touched down long, and attempted a go-around but the aircraft contacted tall brush. The aircraft veered to…NTSB FTW82DA063Accident · No injuriesFinal reportCessna 140 · Krotz Springs, LADuring the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed…NTSB FTW79DA093Accident · 1 fatalClosedCessna 140 · Basile, LANTSB FTW71FRJ38Accident · Serious injuriesClosedCessna 140 · Alexandria, LANTSB FTW71FRD23Accident · No injuriesClosedCessna 140 · Westwego, LANTSB FTW69F0370Accident · No injuriesClosedCessna 140 · Cecilia, LANTSB FTW67D0425Accident · No injuriesClosedCessna 140 · Baton Rouge, LA