Skip to content

NTSB investigations: Cessna 140, 1965

106 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, 1965 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") = 1965 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\") = 1965
    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") = 1965
  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 MKC66F0342Accident · No injuriesClosedCessna 140 · Monticello, MNDec 27, 1965 · N3587V · Substantial damage NTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damage NTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CADec 19, 1965 · N76403 · Substantial damage NTSB SEA66D0169Accident · No injuriesClosedCessna 140 · Wenatchee, WADec 5, 1965 · N89528 · Substantial damage NTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORDec 4, 1965 · N3701V · Substantial damage NTSB LAX66D0158Accident · No injuriesClosedCessna 140 · Hawthorne, CANov 24, 1965 · N77268 · Substantial damage NTSB SEA66D0162Accident · No injuriesClosedCessna 140A · Seattle, WANov 13, 1965 · N358TA · Substantial damage NTSB CHI66D0403Accident · No injuriesClosedCessna 140 · Cleveland, OHNov 7, 1965 · N1998V · Substantial damage NTSB CHI66F0408Accident · No injuriesClosedCessna 140 · Houghton, MIOct 29, 1965 · N72856 · Substantial damage NTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTOct 28, 1965 · N77103 · Destroyed NTSB MIA66F0280Accident · Minor injuriesClosedCessna 140 · Shelby, NCOct 27, 1965 · N76477 · Substantial damage NTSB CHI66A0042Accident · 2 fatalClosedCessna 140 · Ralph, MIOct 24, 1965 · N72146 · Destroyed NTSB ANC66A0019Accident · 1 fatalClosedCessna 140 · Napakiah, AKOct 24, 1965 · N2853N · Destroyed NTSB DEN66D0158Accident · No injuriesClosedCessna 140 · Yuma, AZOct 23, 1965 · N2321V · Substantial damage NTSB FTW66D0369Accident · No injuriesClosedCessna 140 · Merkel, TXOct 21, 1965 · N2851N · Substantial damage NTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDOct 10, 1965 · N2318N · Substantial damage NTSB MIA66F0258Accident · No injuriesClosedCessna 140 · Fayetteville, TNOct 10, 1965 · N72849 · Substantial damage NTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSOct 9, 1965 · N76939 · Substantial damage NTSB MIA66A0038Accident · 1 fatalClosedCessba 140 · Trenton, ALOct 1, 1965 · N77409 · Destroyed NTSB LAX66D0133Accident · No injuriesClosedCessna 140 · Burbank, CAOct 1, 1965 · N76258 · Substantial damage NTSB SEA66D0139Accident · No injuriesClosedCessna 140 · Everett, WASep 24, 1965 · N89983 · Substantial damage NTSB MKC66F0255Accident · No injuriesClosedCessna 140 · Michigan, NDSep 19, 1965 · N89525 · Substantial damage NTSB MKC66D0266Accident · No injuriesClosedCessna 140 · Melrose, MNSep 19, 1965 · N76280 · Substantial damage NTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSSep 11, 1965 · N3604V · Substantial damage NTSB FTW66D0308Accident · Minor injuriesClosedCessna 140 · Bartonville, TXSep 6, 1965 · N2221N · Substantial damage NTSB MIA66F0218Accident · No injuriesClosedCessna 140 · Meridian, MSSep 4, 1965 · N2020V · Substantial damage NTSB FTW66F0307Accident · Minor injuriesClosedCessna 140 · Tulsa, OKSep 4, 1965 · N76029 · Substantial damage NTSB DEN66F0094Accident · No injuriesClosedCessna 140 · Aurora, COAug 29, 1965 · N77045 · Substantial damage NTSB NYC66F0249Accident · Minor injuriesClosedCessna 140 · Victoria, VAAug 28, 1965 · N89491 · Substantial damage NTSB OAK66D0059Accident · No injuriesClosedCessna 140 · Modesto, CAAug 26, 1965 · N72507 · Substantial damage NTSB MKC66F0218Accident · No injuriesClosedCessna 140 · Grand Forks, NDAug 21, 1965 · N2302N · Substantial damage NTSB CHI66F0209Accident · No injuriesClosedCessna 140 · Trivoli, ILAug 17, 1965 · N4158N · Substantial damage NTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PAAug 16, 1965 · N76066 · Substantial damage NTSB CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INAug 14, 1965 · N3627V · Substantial damage NTSB FTW66F0193Accident · Minor injuriesClosedCessna 140 · Orange, TXAug 8, 1965 · N2196V · Destroyed NTSB CHI66D0136Accident · Minor injuriesClosedCessna 140 · Plymouth, MIAug 5, 1965 · N72873 · Destroyed NTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damage NTSB UNK65X1522Accident · No injuriesClosedCessna 140 · Alpine, TXAug 2, 1965 · N72499 · Substantial damage NTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NEAug 1, 1965 · N4279N · Substantial damage NTSB MKC66F0201Accident · No injuriesClosedCessna 140 · Robbinsdale, MNJul 29, 1965 · N77095 · Substantial damage NTSB OAK66F0082Accident · Minor injuriesClosedCessna 140 · Dunsmuir, CAJul 24, 1965 · N76963 · Substantial damage NTSB MIA66F0112Accident · Minor injuriesClosedCessna 140 · Williston, FLJul 19, 1965 · N72663 · Substantial damage NTSB FTW66D0149Accident · Minor injuriesClosedCessna 140 · Cashion, OKJul 15, 1965 · N72688 · Substantial damage NTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damage NTSB OAK66F0021Accident · Minor injuriesClosedCessna 140 · Dos Palos, CAJun 27, 1965 · N2244N · Substantial damage NTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDJun 27, 1965 · N72455 · Destroyed NTSB DEN66D0043Accident · No injuriesClosedCessna 140 · Hereford, AZJun 27, 1965 · N1634V · Substantial damage NTSB LAX66F0003Accident · Serious injuriesClosedCessna 140 · Lathrop Wells, NVJun 21, 1965 · N72467 · Substantial damage NTSB MIA66D0043Accident · Minor injuriesClosedCessna 140 · Chattanooga, TNJun 20, 1965 · N72386 · Substantial damage NTSB DEN66D0025Accident · No injuriesClosedCessna 140 · Clovis, NMJun 18, 1965 · N89428 · Substantial damage