Skip to content

NTSB investigations: Cessna 140, 1967

95 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, 1967 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") = 1967 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\") = 1967
    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") = 1967
  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 LAX68F0260Accident · Serious injuriesClosedCessna 140 · Redlands, CADec 25, 1967 · N72100 · Destroyed NTSB CHI68D0523Accident · No injuriesClosedCessna 140 · Fitchburg, WIDec 24, 1967 · N1914N · Substantial damage NTSB SEA68D0222Accident · Minor injuriesClosedCessna 140 · Davenport, WADec 1, 1967 · N72232 · Substantial damage NTSB MIA68D0277Accident · No injuriesClosedCessna 140 · White Bluff, TNNov 18, 1967 · N4228N · Substantial damage NTSB UNK68X0108Accident · No injuriesClosedCessna 140 · Egelsbach, GeorgiaNov 16, 1967 · N2211V · Substantial damage NTSB DEN68F0144Accident · No injuriesClosedCessna 140 · Crown Pt, NMNov 11, 1967 · N89436 · Substantial damage NTSB MIA68D0251Accident · No injuriesClosedCessna 140 · Collegedale, TNNov 4, 1967 · N2026V · Substantial damage NTSB FTW68F0327Accident · No injuriesClosedCessna 140 · Dallas, TXNov 4, 1967 · N2242V · Substantial damage NTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJOct 30, 1967 · N89161 · Destroyed NTSB CHI68D0411Accident · No injuriesClosedCessna 140 · Norwalk, WIOct 21, 1967 · N89033 · Substantial damage NTSB LAX68F0199Accident · No injuriesClosedCessna 140 · Santa Paula, CAOct 16, 1967 · N81074 · Substantial damage NTSB ANC68D0066Accident · No injuriesClosedCessna 140 · Eureka, AKOct 14, 1967 · N2215V · Substantial damage NTSB LAX68D0154Accident · No injuriesClosedCessna 140 · Hunt.Beach, CAOct 3, 1967 · N89517 · Substantial damage NTSB SEA68D0148Accident · No injuriesClosedCessna 140 · Seattle, WASep 29, 1967 · N76441 · Substantial damage NTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSSep 28, 1967 · N3604V · Substantial damage NTSB SEA68F0199Accident · Serious injuriesClosedCessna 140 · Hardin, MTSep 25, 1967 · N76931 · Destroyed NTSB CHI68F0367Accident · No injuriesClosedCessna 140 · Mt.Sterling, ILSep 21, 1967 · N89883 · Substantial damage NTSB NYC68F0279Accident · No injuriesClosedCessna 140 · Bedford, PASep 18, 1967 · N89747 · Substantial damage NTSB MKC68D0334Accident · No injuriesClosedCessna 140 · Fairmont, MNSep 17, 1967 · N73081 · Substantial damage NTSB CHI68D0313Accident · No injuriesClosedCessna 140 · Dekalb, ILSep 16, 1967 · N2905N · Substantial damage NTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSSep 13, 1967 · N89378 · Substantial damage NTSB FTW68F0234Accident · Serious injuriesClosedCessna 140A · Dayton, TXSep 9, 1967 · N4210N · Substantial damage NTSB CHI68D0348Accident · No injuriesClosedCessna 140 · Brownsburg, INSep 3, 1967 · N2848N · Substantial damage NTSB DIA68F0075Accident · No injuriesClosedCessna 140 · Wilmington, DEAug 29, 1967 · N89842 · Substantial damage NTSB MKC68D0214Accident · Minor injuriesClosedCessna 140 · Independence, MOAug 24, 1967 · N76939 · Substantial damage NTSB FTW68D0208Accident · No injuriesClosedCessna 140 · Tyler, TXAug 22, 1967 · N89245 · Substantial damage NTSB LAX68D0110Accident · No injuriesClosedCessna 140 · Hawthorne, CAAug 21, 1967 · N2299N · Substantial damage NTSB MKC68F0175Accident · Serious injuriesClosedCessna 140 · Two Harbors, MNAug 20, 1967 · N1824V · Substantial damage NTSB FTW68D0186Accident · No injuriesClosedCessna 140 · Menard, TXAug 17, 1967 · N2020V · Substantial damage NTSB MIA68F0136Accident · No injuriesClosedCessna 140 · Dawson, GAAug 14, 1967 · N76110 · Substantial damage NTSB CHI68F0233Accident · Minor injuriesClosedCessna 140 · Bunker Hill, ILAug 13, 1967 · N89480 · Substantial damage NTSB CHI68F0187Accident · No injuriesClosedCessna 140 · Columbus, OHAug 12, 1967 · N4116N · Substantial damage NTSB DIA68F0059Accident · Minor injuriesClosedCessna 140 · Davidsonville, MDAug 11, 1967 · N76539 · Substantial damage NTSB SEA68D0180Accident · No injuriesClosedCessna 140A · Worden, MTAug 10, 1967 · N3785V · Substantial damage NTSB LAX68D0106Accident · No injuriesClosedCessna 140 · Hesperia, CAAug 10, 1967 · N2276N · Substantial damage NTSB MIA68F0117Accident · No injuriesClosedCessna 140 · State Coll., MSAug 3, 1967 · N76151 · Substantial damage NTSB ANC68F0029Accident · No injuriesClosedCessna 140 · Fairbanks, AKJul 31, 1967 · N2210N · Substantial damage NTSB NYC68D0101Accident · No injuriesClosedCessna 140 · Hopewell Jctn, NYJul 29, 1967 · N72319 · Substantial damage NTSB DIA68A0004Accident · Serious injuriesClosedCessna 140 · Baileys Crsrds, VAJul 27, 1967 · N76124 · Substantial damage NTSB LAX68F0080Accident · No injuriesClosedCessna 140 · Tucson, AZJul 24, 1967 · N1634V · Substantial damage NTSB CHI68F0152Accident · No injuriesClosedCessna 140 · Bartonville, ILJul 20, 1967 · N89912 · Substantial damage NTSB LAX68A0007Accident · 3 fatalClosedCessna 140 · Florence, AZJul 16, 1967 · N89482 · Destroyed NTSB MKC68D0123Accident · No injuriesClosedCessna 140 · Springfield, MOJul 15, 1967 · N72938 · Substantial damage NTSB FTW68D0093Accident · No injuriesClosedCessna 140 · Carrier, OKJul 13, 1967 · N72510 · Substantial damage NTSB MIA68D0090Accident · No injuriesClosedCessna 140 · Dunedin, FLJul 12, 1967 · N90175 · Substantial damage NTSB CHI68D0153Accident · No injuriesClosedCessna 140 · Lake Orion, MIJul 12, 1967 · N89252 · Substantial damage NTSB FTW68D0091Accident · No injuriesClosedCessna 140 · Blackwell, OKJul 11, 1967 · N72750 · Substantial damage NTSB MKC68D0116Accident · No injuriesClosedCessna 140 · Rutland, NDJul 10, 1967 · N81065 · Substantial damage NTSB OAK68F0074Accident · Serious injuriesClosedCessna 140 · San Carlos, CAJul 8, 1967 · N81043 · Substantial damage NTSB NYC68D0040Accident · No injuriesClosedCessna 140 · Corry, PAJul 4, 1967 · N89338 · Substantial damage