Skip to content

NTSB investigations: Cessna 140, 1964

108 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, 1964 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1110Accident · No injuriesClosedCessna 140 · Inyokern, CADec 24, 1964 · N76736 · Substantial damage NTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSDec 20, 1964 · N89799 · Substantial damage NTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · Destroyed NTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLDec 5, 1964 · N81089 · Destroyed NTSB UNK65X0848Accident · No injuriesClosedCessna 140 · Vero Beach, FLNov 26, 1964 · N89208 · Substantial damage NTSB UNK65X0835Accident · No injuriesClosedCessna 140 · Longmont, CONov 25, 1964 · N2895N · Substantial damage NTSB UNK65X0786Accident · No injuriesClosedCessna 182 · San Carlos, CANov 22, 1964 · N3751V · No damage NTSB UNK65X0577Accident · Minor injuriesClosedCessna 140 · Palm Beach Gd, FLNov 6, 1964 · N76035 · Substantial damage NTSB UNK65X0551Accident · No injuriesClosedCessna 140 · Farmington, MONov 4, 1964 · N2459N · Substantial damage NTSB UNK65X0518Accident · No injuriesClosedCessna 140 · Sparrevohn, AKNov 1, 1964 · N72770 · Substantial damage NTSB UNK65X0517Accident · No injuriesClosedCessna 140 · San Jose, CANov 1, 1964 · N2207N · Substantial damage NTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSOct 20, 1964 · N2274N · Substantial damage NTSB UNK65X0329Accident · No injuriesClosedCessna 140 · Houghton, MIOct 18, 1964 · N72856 · Substantial damage NTSB UNK65X0295Accident · No injuriesClosedCessna 140 · Edgely, NDOct 16, 1964 · N72307 · Substantial damage NTSB UNK65X0242Accident · No injuriesClosedCessna 140 · Palmyra, WIOct 11, 1964 · N2050V · Destroyed NTSB UNK65X0204Accident · No injuriesClosedCessna 140 · Lake Berryess, CAOct 9, 1964 · N72458 · Substantial damage NTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PAOct 8, 1964 · N89012 · Destroyed NTSB UNK65X0186Accident · No injuriesClosedCessna 140 · Camas, WAOct 7, 1964 · N76645 · No damage NTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, OROct 4, 1964 · N2291N · Substantial damage NTSB UNK65X0140Accident · No injuriesClosedCessna 140 · Saugus, CAOct 4, 1964 · N72351 · Destroyed NTSB UNK64X4183Accident · No injuriesClosedCessna 140 · Ames, IASep 27, 1964 · N77075 · Destroyed NTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNSep 13, 1964 · N72393 · Substantial damage NTSB UNK64X3970Accident · No injuriesClosedCessna 140 · Amarillo, TXSep 13, 1964 · N72807 · Destroyed NTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSSep 12, 1964 · N1806V · Substantial damage NTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GASep 12, 1964 · N76246 · Substantial damage NTSB UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILSep 11, 1964 · N89049 · Substantial damage NTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damage NTSB UNK64X3869Accident · Minor injuriesClosedCessna 140 · Mt Pleasant, PASep 8, 1964 · N140FC · Substantial damage NTSB UNK64X3825Accident · No injuriesClosedCessna 140 · Burnet, TXSep 6, 1964 · N2340V · Substantial damage NTSB UNK64X3727Accident · No injuriesClosedCessna 140 · Northbrook, ILSep 1, 1964 · N89918 · Substantial damage NTSB UNK64X3686Accident · No injuriesClosedCessna 140 · Greely, COAug 30, 1964 · N89408 · Substantial damage NTSB UNK64X3664Accident · No injuriesClosedCessna 140 · Gualala, CAAug 29, 1964 · N76587 · Substantial damage NTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MIAug 29, 1964 · N2981N · Substantial damage NTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WAAug 24, 1964 · N3624V · Substantial damage NTSB UNK64X3561Accident · No injuriesClosedCessna 140 · San Diego, CAAug 23, 1964 · N2927N · Minor damage NTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VAAug 22, 1964 · N72134 · Substantial damage NTSB UNK64X3488Accident · No injuriesClosedCessna 140 · Mesa, AZAug 20, 1964 · N1915V · Substantial damage NTSB UNK64X3476Accident · No injuriesClosedCessna 140 · Nacogdoches, TXAug 19, 1964 · N4131N · Substantial damage NTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NMAug 16, 1964 · N2787N · Destroyed NTSB UNK64X3423Accident · Minor injuriesClosedCessna 140 · Waukesea, WIAug 16, 1964 · N89345 · Destroyed NTSB UNK64X3363AccidentClosedCessna 140 · Sterling, COAug 13, 1964 · N72394 · Substantial damage NTSB UNK64X3298Accident · No injuriesClosedCessna 140 · Denver, COAug 9, 1964 · N76147 · Substantial damage NTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTAug 3, 1964 · N2362V · Substantial damage NTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WIAug 3, 1964 · N2084V · Substantial damage NTSB UNK64X3194Accident · No injuriesClosedCessna 140 · Minneapolis, MNAug 3, 1964 · N76346 · Destroyed NTSB UNK64X3152Accident · No injuriesClosedCessna 140 · Van Nuys, CAAug 1, 1964 · N3747V · Substantial damage NTSB UNK64X3145Accident · No injuriesClosedCessna 140 · Parrish, FLAug 1, 1964 · N89196 · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X3033Accident · No injuriesClosedCessna 140 · Barre, VTJul 25, 1964 · N89746 · Substantial damage NTSB UNK64X3029Accident · Minor injuriesClosedCessna 140 · Schoolcraft, MIJul 25, 1964 · N3626V · Destroyed