NTSB investigations: Cessna 140, 2019
5 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\") = 2019
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") = 2019
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 WPR20CA045Accident · Minor injuriesData collectionFinal reportCessna 140 · Lancaster, CAThe student pilot's failure to maintain directional control and his use of excessive braking while taxiing.NTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…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 WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.NTSB CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.