Skip to content

NTSB investigations: Cessna 172F, 1966

57 cases on aircraft the registry lists as Cessna 172F. 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 172F, 1966 per year, 1964–2026: 563 cases
1964	2
1965	60
1966	57
1967	47
1968	24
1969	14
1970	24
1971	23
1972	21
1973	19
1974	10
1975	16
1976	15
1977	15
1978	10
1979	10
1980	3
1981	13
1982	6
1983	6
1984	7
1985	5
1986	7
1987	5
1988	10
1989	7
1990	3
1992	4
1993	6
1994	7
1995	8
1996	7
1997	4
1998	7
1999	3
2000	1
2001	5
2002	4
2003	4
2004	3
2005	5
2006	4
2007	2
2008	3
2009	2
2010	1
2011	4
2012	2
2013	3
2014	3
2015	3
2016	3
2017	2
2018	1
2019	7
2020	2
2021	3
2022	4
2023	1
2024	2
2025	3
2026	1

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 ('2072414')) 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 ('2072414'))
  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 ('2072414'))
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 DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VADec 30, 1966 · N8556U · Substantial damage NTSB LAX67D0221Accident · No injuriesClosedCessna 172 · Mojave, CADec 7, 1966 · N8848U · Substantial damage NTSB MKC67D0352Accident · No injuriesClosedCessna 172 · Bixby, MONov 21, 1966 · N5607R · Destroyed NTSB MIA67D0313Accident · No injuriesClosedCessna 172 · Opa Locka, FLNov 10, 1966 · N5359R · Substantial damage NTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALOct 19, 1966 · N5372R · Substantial damage NTSB OAK67A0041Accident · 3 fatalClosedCessna 172F · Woodford, CAOct 2, 1966 · N5655R · Destroyed NTSB FTW67A0040Accident · 2 fatalClosedCessna 172F · Hempstead, TXSep 30, 1966 · N5306R · Destroyed NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB OAK67D0125Accident · Serious injuriesClosedCessna 172 · Alvarado, CASep 17, 1966 · N5388R · Destroyed NTSB NYC67D0253Accident · No injuriesClosedCessna 172 · Stratford, CTSep 10, 1966 · N8445U · Substantial damage NTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damage NTSB FTW67F0195Accident · No injuriesClosedCessna 172F · Lubbock, TXSep 2, 1966 · N7832U · Substantial damage NTSB CHI67D0196Accident · No injuriesClosedCessna 172 · Vestaburg, MIAug 26, 1966 · N8487U · Substantial damage NTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GAAug 23, 1966 · N8309U · Substantial damage NTSB LAX67D0068Accident · No injuriesClosedCessna 172F · Oceanside, CAAug 5, 1966 · N8846U · Substantial damage NTSB NYC67F0074Accident · No injuriesClosedCessna 172F · Reading, PAJul 24, 1966 · N8691U · Substantial damage NTSB FTW67F0110Accident · No injuriesClosedCessna 172 · Amarillo, TXJul 24, 1966 · N8368U · Substantial damage NTSB FTW67F0229Accident · No injuriesClosedCessna 172 · Grand Prairie, TXJul 21, 1966 · N8261U · Substantial damage NTSB NYC67F0387Accident · No injuriesClosedCessna 172F · Sharon, PAJul 9, 1966 · N5721R · Substantial damage NTSB NYC67F0066Accident · Serious injuriesClosedCessna 172F · Glens Falls, NYJul 2, 1966 · N643MA · Destroyed NTSB MKC67D0063Accident · No injuriesClosedCessna 172F · Kennett, MOJun 30, 1966 · N7871U · Substantial damage NTSB UNK66X0150Accident · No injuriesClosedCessna 172 · Perrault Flls, CanadaJun 22, 1966 · N8116U · Destroyed NTSB OAK67D0022Accident · No injuriesClosedCessna 172C · Petaluma, CAJun 18, 1966 · N7966U · Substantial damage NTSB FTW67F0022Accident · No injuriesClosedCessna 172F · Bethany, OKJun 5, 1966 · N5327R · Substantial damage NTSB MIA66F0563Accident · Minor injuriesClosedCessna 172 · Hendersonville, NCJun 2, 1966 · N5498R · Substantial damage NTSB LAX66D0368Accident · No injuriesClosedCessna 172 · Apple Valley, CAMay 29, 1966 · N8863U · Destroyed NTSB ANC66A0045Accident · 2 fatalClosedCessna 172F · Galena, AKMay 22, 1966 · N8809U · Destroyed NTSB MKC66D0585Accident · No injuriesClosedCessna 172 · Camdenton, MOMay 21, 1966 · N5597R · Substantial damage NTSB MIA66A0134Accident · 1 fatalClosedCessna 172F · Dothan, ALMay 16, 1966 · N5701R · Destroyed NTSB ANC67A0038Accident · 2 fatalClosedCessna 172F · Anchorage, AKApr 22, 1966 · N8690U · Destroyed NTSB MKC66F0563Accident · Minor injuriesClosedCessna 172 · Neodesha, KSApr 17, 1966 · N5638R · Substantial damage NTSB NYC66D0592Accident · No injuriesClosedCessna 172 · Reading, PAApr 16, 1966 · N8691U · Substantial damage NTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoApr 8, 1966 · N8305U · Substantial damage NTSB SEA66F0259Accident · No injuriesClosedCessna 172E · Anacortes, WAApr 5, 1966 · N3559S · Substantial damage NTSB MIA66F0487Accident · No injuriesClosedCessna 172 · Tchula, MSApr 5, 1966 · N5483R · Substantial damage NTSB CHI66D0696Accident · No injuriesClosedCessna 172 · New London, OHApr 3, 1966 · N5489R · Substantial damage NTSB NYC66F0593Accident · Minor injuriesClosedCessna 172F · Haverhill, MAMar 30, 1966 · N8556U · Substantial damage NTSB NYC66F0608Accident · Minor injuriesClosedCessna 172 · Roscoe, NYMar 29, 1966 · N8675U · Substantial damage NTSB MKC67D0001Accident · Minor injuriesClosedCessna 172F · Rich Fountain, MOMar 26, 1966 · N8703U · Substantial damage NTSB MIA66D0473Accident · No injuriesClosedCessna 172 · Ft Lauderdale, FLMar 25, 1966 · N8625U · Substantial damage NTSB MIA66D0496Accident · No injuriesClosedCessna 172 · Morristown, TNMar 13, 1966 · N7883U · Substantial damage NTSB MIA66D0456Accident · No injuriesClosedCessna 172 · Villa Rica, GAMar 9, 1966 · N8595U · Substantial damage NTSB MKC66F0494Accident · No injuriesClosedCessna 172F · Blodgett, MOMar 4, 1966 · N5634R · Substantial damage NTSB NYC66F0499Accident · No injuriesClosedCessna 172 · West Mifflin, PAMar 1, 1966 · N5439R · Substantial damage NTSB FTW66F0550Accident · No injuriesClosedCessna 172 · Amarillo, TXMar 1, 1966 · N8136U · Substantial damage NTSB MIA66A0095Accident · 1 fatalClosedCessna 172 · Portland, TNFeb 27, 1966 · N8177U · Destroyed NTSB MKC66F0495Accident · No injuriesClosedCessna 172 · S. St Paul, MNFeb 16, 1966 · N7824U · Substantial damage NTSB MIA66A0089Accident · 3 fatalClosedCessna 172F · Palmer, PRFeb 15, 1966 · N7848U · Destroyed NTSB CHI66D0562Accident · No injuriesClosedCessna 172 · Mt Vernon, OHFeb 9, 1966 · N5660R · Substantial damage NTSB OAK66D0210Accident · No injuriesClosedCessna 172 · Sacramento, CAFeb 7, 1966 · N5571R · Substantial damage