Skip to content

NTSB investigations: Cessna 140, 1973

40 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Cessna 140, 1973 per year, 1964–2026: 1,320 cases
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

Latest cases

Query with SQL

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") = 1973 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

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\") = 1973
    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") = 1973
  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

Run 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 MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GADec 3, 1973 · N2220N · Substantial damage NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNov 5, 1973 · N72391 · Substantial damage NTSB NYC74DNC29Accident · No injuriesClosedCessna 140 · Gilmanton, NHNov 4, 1973 · N353T · Substantial damage NTSB LAX74DUJ29Accident · No injuriesClosedCessna 140 · Willcox, AZNov 3, 1973 · N2256N · Substantial damage NTSB NYC74FNE10Accident · No injuriesClosedCessna 140 · Simsbury, CTNov 2, 1973 · N4220N · Substantial damage NTSB LAX74FUG23Accident · Serious injuriesClosedCessna 140 · Simi Valley, CAOct 29, 1973 · N89259 · Substantial damage NTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, OROct 8, 1973 · N3086N · Substantial damage NTSB DEN74AD013Accident · 1 fatalClosedCessna 140 · Divide, COOct 2, 1973 · N89304 · Substantial damage NTSB MIA74FKG26Accident · Minor injuriesClosedCessna 140 · Stockbridge, GASep 8, 1973 · N76217 · Destroyed NTSB IAD74DKM18Accident · No injuriesClosedCessna 140 · Greensboro, NCSep 3, 1973 · N2652N · Substantial damage NTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDAug 30, 1973 · N76057 · Substantial damage NTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSAug 26, 1973 · N4190N · Substantial damage NTSB SEA74FTA06Accident · Serious injuriesClosedCessna 140 · Ekalaka, MTAug 13, 1973 · N77002 · Substantial damage NTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GAAug 12, 1973 · N77166 · Substantial damage NTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MOAug 10, 1973 · N2314N · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB OAK74DVG04Accident · No injuriesClosedCessna 140 · Georgetown, CAJul 14, 1973 · N2168N · Substantial damage NTSB IAD74DLT01Accident · No injuriesClosedCessna 140 · Arlington, TNJul 8, 1973 · N89330 · Substantial damage NTSB CHI74AEV01Accident · No injuriesClosedCessna 140 · Metamora, ILJul 7, 1973 · N2123N · Substantial damage NTSB CHI74DEI01Accident · No injuriesClosedCessna 140 · Canton, OHJul 3, 1973 · N89784 · Substantial damage NTSB OAK74FVG01Accident · Serious injuriesClosedCessna 140 · Grass Vally, CAJul 1, 1973 · N2392V · Substantial damage NTSB FTW73DRA39Accident · No injuriesClosedCessna 140 · Normangee, TXJun 29, 1973 · N2119N · Substantial damage NTSB MIA73DLA47Accident · No injuriesClosedCessna 140 · Cross City, FLJun 26, 1973 · N72737 · Substantial damage NTSB NYC73FGT14Accident · No injuriesClosedCessna 140 · Thomasville, PAJun 19, 1973 · N89171 · Substantial damage NTSB CHI73FEG28Accident · Serious injuriesClosedCessna 140 · Union, OHJun 10, 1973 · N76126 · Destroyed NTSB CHI73DEK27Accident · No injuriesClosedCessna 140 · Spring Mtn, OHJun 9, 1973 · N89205 · Substantial damage NTSB CHI73DEM69Accident · Minor injuriesClosedCessna 140 · Sanford, MIMay 30, 1973 · N76013 · Substantial damage NTSB SEA73FYC30Accident · Serious injuriesClosedCessna 140 · Sisters, ORMay 28, 1973 · N2051N · Destroyed NTSB MKC73FCA27Accident · Minor injuriesClosedCessna 140 · Valley Park, MOMay 24, 1973 · N2835N · Destroyed NTSB MIA73DKG80Accident · No injuriesClosedCessna 140 · Marietta, GAMay 23, 1973 · N89180 · Substantial damage NTSB MKC73FER58Accident · Minor injuriesClosedCessna 140 · Grand Rapids, MNMay 14, 1973 · N2917N · Substantial damage NTSB MKC73FER57Accident · No injuriesClosedCessna 140 · Anoka, MNMay 9, 1973 · N77095 · Substantial damage NTSB MKC73FTG11Accident · Serious injuriesClosedCessna 140 · Hillsboro, NDApr 22, 1973 · N1971N · Destroyed NTSB FTW73FPJ13Accident · No injuriesClosedCessna 140 · Goldsby, OKMar 28, 1973 · N3548V · Substantial damage NTSB ANC73DAA20Accident · No injuriesClosedCessna 140 · Rampart, AKMar 18, 1973 · N2934N · Substantial damage NTSB LAX73FUQ22Accident · Minor injuriesClosedCessna 140 · Van Nuys, CAMar 4, 1973 · N234YD · Substantial damage NTSB NYC73FNC50Accident · No injuriesClosedCessna 140 · Manchester, NHJan 24, 1973 · N1995N · Substantial damage NTSB CHI73DEM42Accident · Minor injuriesClosedCessna 140 · Levering, MIJan 20, 1973 · N76836 · Substantial damage NTSB CHI73FEC21Accident · Serious injuriesClosedCessna 140 · Plymouth, MIJan 7, 1973 · N2177V · Destroyed