Skip to content

NTSB investigations: Cessna 172, 1966

84 cases on aircraft the registry lists as Cessna 172. 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 172, 1966 per year, 1964–2026: 1,096 cases
1964	80
1965	77
1966	84
1967	85
1968	65
1969	35
1970	32
1971	37
1972	40
1973	35
1974	35
1975	15
1976	29
1977	25
1978	27
1979	15
1980	21
1981	27
1982	11
1983	6
1984	8
1985	13
1986	8
1987	13
1988	21
1989	15
1990	6
1991	11
1992	12
1993	10
1994	10
1995	9
1996	12
1997	4
1998	13
1999	9
2000	9
2001	9
2002	6
2003	2
2004	2
2005	11
2006	4
2007	9
2008	8
2009	3
2010	4
2011	6
2012	4
2013	7
2014	3
2015	5
2016	3
2017	6
2018	6
2019	6
2020	3
2021	8
2022	4
2023	3
2024	2
2025	5
2026	3

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCDec 26, 1966 · N8062B · Substantial damage NTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMDec 19, 1966 · N5038A · Substantial damage NTSB LAX67D0248Accident · No injuriesClosedCessna 172 · Shafter, CADec 15, 1966 · N6228E · Substantial damage NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNov 28, 1966 · N6663A · Substantial damage NTSB SEA67A0039Accident · 5 fatalClosedCessna 172G · Chinook, MTNov 25, 1966 · N6068R · Destroyed NTSB FTW67D0334Accident · No injuriesClosedCessna 172 · Lubbock, TXNov 20, 1966 · N5717A · Substantial damage NTSB OAK67D0163Accident · No injuriesClosedCessna 172 · Wendover, NVNov 3, 1966 · N8613B · Substantial damage NTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damage NTSB FTW67D0298Accident · No injuriesClosedCessna 172 · Tahoka, TXOct 29, 1966 · N6191E · Substantial damage NTSB NYC67D0336Accident · No injuriesClosedCessna 172 · Charleston, WVOct 20, 1966 · N6272E · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB MKC67D0275Accident · No injuriesClosedCessna 172 · Anita, IAOct 9, 1966 · N8799B · Substantial damage NTSB OAK67D0109Accident · No injuriesClosedCessna 172 · Livermore, CAOct 2, 1966 · N5953A · Substantial damage NTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTOct 2, 1966 · N6188E · Substantial damage NTSB MKC67F0243Accident · No injuriesClosedCessna 172 · So.St.Paul, MNSep 26, 1966 · N8746B · Substantial damage NTSB OAK67F0096Accident · Serious injuriesClosedRyan PT-22 · Sparks, NVSep 25, 1966 · N56243 · 2 aircraft · Substantial damage NTSB LAX67F0165Accident · Serious injuriesClosedCessna 172 · Apple Valley, CASep 25, 1966 · N7034A · Destroyed NTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILSep 25, 1966 · N5194A · Destroyed NTSB FTW67D0219Accident · No injuriesClosedCessna 172 · Hammond, LASep 23, 1966 · N5740A · Substantial damage NTSB NYC67D0207Accident · No injuriesClosedCessna 172 · Slocum, RISep 18, 1966 · N7062A · Substantial damage NTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage NTSB FTW67F0199Accident · Minor injuriesClosedCessna 172 · Yukon, OKSep 7, 1966 · N6686A · Substantial damage NTSB CHI67A0035Accident · 1 fatalClosedCessna 172 · Detroit, MISep 3, 1966 · N6725A · Destroyed NTSB MIA67D0175Accident · No injuriesClosedCessna 172 · Sun City, FLSep 1, 1966 · N7965B · Substantial damage NTSB CHI67D0184Accident · No injuriesClosedCessna 172 · Milwaukee, WIAug 25, 1966 · N6428E · Substantial damage NTSB MIA67A0024Accident · 3 fatalClosedCessna 172 · Flamingo, FLAug 12, 1966 · N6484E · Destroyed NTSB CHI67F0119Accident · Minor injuriesClosedCessna 172 · Shelbyville, KYAug 7, 1966 · N8590B · Substantial damage NTSB UNK66X0162Accident · No injuriesClosedCessna 172 · Suffolk, United KingdomAug 6, 1966 · N9188B · Substantial damage NTSB MIA67D0225Accident · No injuriesClosedCessna 172 · High Springs, FLAug 2, 1966 · N6102E · Substantial damage NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6332E · 2 aircraft · Substantial damage NTSB OAK67A0013Accident · 2 fatalClosedCessna 172 · Orleans, CAJul 26, 1966 · N6229E · Destroyed NTSB SEA67A0006Accident · 3 fatalClosedCessna 172 · Cascade, IDJul 24, 1966 · N988TA · Substantial damage NTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMJul 23, 1966 · N8182B · Destroyed NTSB MKC67A0004Accident · 3 fatalClosedCessna 172 · Lorimor, IAJul 22, 1966 · N8823B · Destroyed NTSB CHI67F0118Accident · Serious injuriesClosedCessna 172 · Dekalb, ILJul 16, 1966 · N6917A · Substantial damage NTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damage NTSB CHI67F0084Accident · Minor injuriesClosedCessna 172 · Circleville, OHJul 4, 1966 · N6462B · Substantial damage NTSB OAK67D0038Accident · Serious injuriesClosedCessna 172 · Monache Medow, CAJul 2, 1966 · N8903B · Destroyed NTSB MIA67A0152Accident · 2 fatalClosedCessna 172 · Hatteras, NCJun 26, 1966 · N4106F · Destroyed NTSB CHI67D0080Accident · No injuriesClosedCessna 172 · Richland Cntr, WIJun 24, 1966 · N6202E · Destroyed NTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MOJun 17, 1966 · N7287A · Substantial damage NTSB OAK66A0056Accident · 2 fatalClosedCessna 172 · Seigler Sprgs, CAJun 11, 1966 · N7204A · Destroyed NTSB FTW67D0037Accident · No injuriesClosedCessna 172 · Alba, TXJun 11, 1966 · N5621A · Substantial damage NTSB SEA66D0290Accident · No injuriesClosedCessna 172 · Camas Prairi, MTJun 5, 1966 · N5008A · Substantial damage NTSB MIA67F0158Accident · Serious injuriesClosedCessna 172 · Palatka, FLJun 4, 1966 · N4139F · Substantial damage