NTSB investigations: Cessna 140, 1988
8 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
| 1964 | 108 |
|---|---|
| 1965 | 106 |
| 1966 | 80 |
| 1967 | 95 |
| 1968 | 74 |
| 1969 | 66 |
| 1970 | 50 |
| 1971 | 44 |
| 1972 | 55 |
| 1973 | 40 |
| 1974 | 46 |
| 1975 | 31 |
| 1976 | 23 |
| 1977 | 32 |
| 1978 | 24 |
| 1979 | 18 |
| 1980 | 14 |
| 1981 | 21 |
| 1982 | 15 |
| 1983 | 23 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 16 |
| 1987 | 12 |
| 1988 | 8 |
| 1989 | 11 |
| 1990 | 11 |
| 1991 | 16 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 18 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 11 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 1 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 8 |
| 2026 | 5 |
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\") = 1988
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 year(c."eventDate") = 1988
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 LAX89LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Corona, CAThe aircraft was found abandoned at the airport. A witness reported that the aircraft had flipped over on runway 25. The sole occupant, a male, was not injured. The aircraft was moved by the occupant and several other unidentified people to a tiedown area on…NTSB MKC89LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · Lawrence, KSThe plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.…NTSB FTW89LA003Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Fairfax, OKThe plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the…NTSB MKC89LA002Accident · No injuriesLimited investigationFinal reportCessna 140 · Quinter, KSThe pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.…NTSB FTW88LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Clifton, TXThe student pilot was on her third landing during her first solo flight. The pilot reported that she lost control and the airplane ground looped during the landing roll.NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…NTSB NYC88LA103Accident · No injuriesLimited investigationFinal reportCessna 140 · Schroon Lake, NYDuring landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.'NTSB BFO88LA021Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Orange, VAAccording to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He…