Skip to content

NTSB investigations: Cessna 140, 1966

80 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, 1966 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") = 1966 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\") = 1966
    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") = 1966
  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 MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NEDec 30, 1966 · N2397V · Substantial damage NTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CADec 29, 1966 · N89981 · Destroyed NTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damage NTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CADec 23, 1966 · N3556R · 2 aircraft · Substantial damage NTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHDec 17, 1966 · N2424V · Substantial damage NTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB MKC67D0297Accident · No injuriesClosedCessna 140 · Moorhead, IANov 12, 1966 · N76487 · Substantial damage NTSB FTW67F0285Accident · No injuriesClosedCessna 140 · Arlington, TXNov 5, 1966 · N1710V · Substantial damage NTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PAOct 30, 1966 · N1992V · Substantial damage NTSB MKC67D0301Accident · No injuriesClosedCessna 140 · Winona, MNOct 27, 1966 · N2181N · Substantial damage NTSB LAX67D0196Accident · No injuriesClosedCessna 140 · Chino, CAOct 25, 1966 · N2133N · Substantial damage NTSB LAX67D0206Accident · No injuriesClosedCessna 140 · Blythe, CAOct 2, 1966 · N89923 · Substantial damage NTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYSep 28, 1966 · N89262 · Substantial damage NTSB CHI67D0202Accident · No injuriesClosedCessna 140 · Napoleon, MISep 18, 1966 · N89822 · Substantial damage NTSB OAK67D0128Accident · No injuriesClosedCessna 140 · Columbia, CASep 17, 1966 · N77083 · Substantial damage NTSB MKC67F0238Accident · Minor injuriesClosedCessna 140 · Franklin, MNSep 17, 1966 · N2237V · Substantial damage NTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTSep 15, 1966 · N72308 · Substantial damage NTSB FTW67D0270Accident · No injuriesClosedCessna 140 · Grapevine, TXSep 13, 1966 · N1710V · Substantial damage NTSB LAX67D0141Accident · No injuriesClosedCessna 140 · San Diego, CASep 12, 1966 · N2351V · Substantial damage NTSB LAX67D0144Accident · No injuriesClosedCessna 140 · Santa Susana, CASep 7, 1966 · N72677 · Substantial damage NTSB SEA67F0109Accident · Minor injuriesClosedCessna 140 · Walla Walla, WASep 4, 1966 · N2222N · Substantial damage NTSB OAK67D0121Accident · No injuriesClosedCessna 140 · Las Vegas, NVSep 3, 1966 · N72685 · Substantial damage NTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARAug 30, 1966 · N1408U · Substantial damage NTSB CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYAug 28, 1966 · N4022N · Substantial damage NTSB CHI67D0589Accident · No injuriesClosedCessna 140 · Spring Bay, ILAug 24, 1966 · N1965N · Substantial damage NTSB FTW67F0388Accident · No injuriesClosedCessna 140 · Lipan, TXAug 18, 1966 · N1722V · Substantial damage NTSB NYC67F0188Accident · Minor injuriesClosedCessna 140 · Princess Anne, MDAug 15, 1966 · N76942 · Substantial damage NTSB LAX67D0076Accident · No injuriesClosedCessna 140A · Daggett, CAAug 13, 1966 · N2497V · Substantial damage NTSB MKC67D0155Accident · No injuriesClosedCessna 140 · La Porte Cty, IAAug 10, 1966 · N1999N · Substantial damage NTSB FTW67F0145Accident · Minor injuriesClosedCessna 140 · Canton, TXAug 9, 1966 · N2193V · Substantial damage NTSB MKC67D0098Accident · No injuriesClosedCessna 140 · Wells, MNAug 7, 1966 · N76346 · Substantial damage NTSB ANC67D0037Accident · No injuriesClosedCessna 140 · Elmendorf Ab, AKJul 29, 1966 · N76619 · Substantial damage NTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARJul 24, 1966 · N3192N · Destroyed NTSB CHI67F0093Accident · 1 fatalClosedCessna 140 · Freaser, MIJul 22, 1966 · N2378N · Destroyed NTSB NYC67F0113Accident · No injuriesClosedCessna 140 · Ilion, NYJul 15, 1966 · N1931N · Substantial damage NTSB LAX67D0051Accident · No injuriesClosedCessna 140 · Roll, AZJul 6, 1966 · N89408 · Substantial damage NTSB NYC67F0017Accident · No injuriesClosedCessna 140 · Fitchburg, MAJun 30, 1966 · N4194N · Substantial damage NTSB DEN67F0176Accident · 1 fatalClosedCessna 140 · Broomfield, COJun 30, 1966 · N72276 · Destroyed NTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damage NTSB MKC67D0092Accident · No injuriesClosedCessna 140 · Kirkville, MOJun 26, 1966 · N76387 · Substantial damage NTSB MKC67F0015Accident · No injuriesClosedCessna 140 · Des Moines, IAJun 21, 1966 · N3621V · Substantial damage NTSB MKC67D0014Accident · No injuriesClosedCessna 140 · Corning, IAJun 11, 1966 · N76644 · Substantial damage NTSB CHI67D0029Accident · No injuriesClosedCessna 140 · Madison, WIJun 10, 1966 · N72919 · Substantial damage NTSB OAK67D0089Accident · No injuriesClosedCessna 140 · Las Vegas, NVJun 4, 1966 · N3588V · Substantial damage NTSB MIA67D0047Accident · No injuriesClosedCessna 140 · Blairsville, GAJun 3, 1966 · N2511N · Substantial damage NTSB FTW66A0111Accident · 2 fatalClosedCessna 140 · Gordonville, TXJun 1, 1966 · N72385 · Destroyed NTSB LAX66F0375Accident · Minor injuriesClosedCessna 140 · San Diego, CAMay 31, 1966 · N3135N · Substantial damage NTSB OAK66F0286Accident · No injuriesClosedCessna 140 · Truckee, CAMay 21, 1966 · N76395 · Substantial damage