NTSB investigations: Cessna 140, 2023
4 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\") = 2023
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") = 2023
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 WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.NTSB WPR23LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · American Falls, IDThe pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB ERA23LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Keystone Heights, FLThe pilot’s improper decision to perform an impromptu off-airport landing and his failure to maintain control of the airplane during the landing, which resulted in a nose-over.