NTSB investigations: Cessna 140A, 1989
4 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 | 14 |
|---|---|
| 1965 | 12 |
| 1966 | 9 |
| 1967 | 9 |
| 1968 | 5 |
| 1969 | 6 |
| 1970 | 7 |
| 1971 | 3 |
| 1972 | 3 |
| 1973 | 7 |
| 1974 | 5 |
| 1975 | 4 |
| 1976 | 1 |
| 1977 | 5 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2023 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1989
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 year(c."eventDate") = 1989
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 ANC90LA008Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKPilot's failure to assure condition of runway prior to landing and failure to maintain runway alignment during landing.NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.