Skip to content

NTSB investigations: Cessna 172, 1964

80 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, 1964 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") = 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 ('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\") = 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 ('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") = 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 ('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 UNK65X1161Accident · Serious injuriesClosedCessna 172 · Swan Valley, IDDec 27, 1964 · N7026A · Destroyed NTSB UNK65X1148Accident · No injuriesClosedCessna 172 · Grants, NMDec 26, 1964 · N5156A · Substantial damage NTSB UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WIDec 19, 1964 · N4271F · Substantial damage NTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSDec 12, 1964 · N8812B · Destroyed NTSB UNK65X0971Accident · 4 fatalClosedCessna 172 · Torrance, CADec 10, 1964 · N8022B · Destroyed NTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GADec 4, 1964 · N5625A · Substantial damage NTSB UNK65X0908Accident · 5 fatalClosedCessna 172 · Shelby, NCDec 3, 1964 · N8992B · Destroyed NTSB UNK65X0865Accident · No injuriesClosedCessna 172 · Blackwood, NJNov 28, 1964 · N6049A · Substantial damage NTSB UNK65X0843Accident · 1 fatalClosedCessna 172 · Troy, TNNov 26, 1964 · N8059B · Destroyed NTSB UNK65X0796Accident · No injuriesClosedCessna 172 · East Prairie, MONov 22, 1964 · N6833A · Substantial damage NTSB UNK65X0762Accident · No injuriesClosedCessna 172 · Cedar Lake, MINov 20, 1964 · N5769A · Destroyed NTSB UNK65X0742Accident · 4 fatalClosedCessna 172E · Kelleys Isld, OHNov 16, 1964 · N7758U · Destroyed NTSB UNK65X0737Accident · No injuriesClosedCessna 172 · Ashland, MTNov 16, 1964 · N7132A · Substantial damage NTSB UNK65X0731Accident · 1 fatalClosedCessna 172F · Shrewsbury, NJNov 15, 1964 · N8274U · Destroyed NTSB UNK65X0616Accident · No injuriesClosedCessna 172 · Blossvale, NYNov 8, 1964 · N7157A · Substantial damage NTSB UNK65X0562Accident · 1 fatalClosedCessna 172 · Springboro, OHNov 4, 1964 · N8158B · Destroyed NTSB UNK65X0508Accident · No injuriesClosedCessna 172 · Waller, TXNov 1, 1964 · N4101F · Substantial damage NTSB UNK65X0364Accident · Serious injuriesClosedCessna 172 · Van, TXOct 21, 1964 · N8233B · Destroyed NTSB UNK65X0308Accident · No injuriesClosedCessna 172 · Ouray, UTOct 17, 1964 · N5031A · Substantial damage NTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 15, 1964 · N8118B · Substantial damage NTSB UNK65X0269Accident · No injuriesClosedCesna 172 · Amarillo, TXOct 13, 1964 · N4114F · Substantial damage NTSB UNK65X0223Accident · No injuriesClosedCessna 172 · Seville, OHOct 10, 1964 · N16QB · Substantial damage NTSB UNK65X0116Accident · No injuriesClosedCessna 172 · Alder Point, CAOct 2, 1964 · N6184E · Substantial damage NTSB UNK64X4178Accident · No injuriesClosedCessna 172 · Lancaster, PASep 27, 1964 · N5150A · Substantial damage NTSB UNK64X4095Accident · No injuriesClosedCessna 172 · Carrington Is, UTSep 22, 1964 · N8926B · Substantial damage NTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSSep 8, 1964 · N7991B · Substantial damage NTSB UNK64X3839Accident · No injuriesClosedCessna 172 · Madison, CTSep 7, 1964 · N6471E · Substantial damage NTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WAAug 19, 1964 · N7045T · Substantial damage NTSB UNK64X3455Accident · No injuriesClosedCessna 172 · Selma, CAAug 18, 1964 · N7195A · Substantial damage NTSB UNK64X3401Accident · Serious injuriesClosedCessna 172 · Crossville, TNAug 15, 1964 · N6687A · Destroyed NTSB UNK64X3316Accident · No injuriesClosedCessna 172 · Hill City, KSAug 10, 1964 · N8812B · Substantial damage NTSB UNK64X3227Accident · No injuriesClosedCessna 172 · Ft Pierce, FLAug 5, 1964 · N6146E · Substantial damage NTSB UNK64X3191Accident · No injuriesClosedCessna 172 · Muleshoe, TXAug 3, 1964 · N8541B · Substantial damage NTSB UNK64X2915Accident · No injuriesClosedCessna 172 · Waterford, CTJul 19, 1964 · N6434B · Destroyed NTSB UNK64X2896Accident · No injuriesClosedCessna 172 · Fresno, CAJul 18, 1964 · N6268E · Substantial damage NTSB UNK64X2759Accident · No injuriesClosedCessna 170B · Mahopac, NYJul 11, 1964 · N8804B · Substantial damage NTSB UNK64X2648Accident · 2 fatalClosedCessna 172 · Tulsa, OKJul 4, 1964 · N6496E · Substantial damage NTSB UNK64X2590Accident · No injuriesClosedCessna 172 · Rehobeth, DEJul 1, 1964 · N3949F · Substantial damage NTSB UNK64X2531Accident · No injuriesClosedCessna 172 · Clinton, ILJun 28, 1964 · N8841B · Substantial damage NTSB UNK64X2521Accident · No injuriesClosedCessna 172 · Gadsen, ALJun 27, 1964 · N7300A · Substantial damage NTSB UNK64X2516Accident · Minor injuriesClosedCessna 172 · Little York, NJJun 27, 1964 · N8653B · Destroyed NTSB UNK64X2447Accident · No injuriesClosedCessna 172A · Farmersburg, INJun 23, 1964 · N6982A · Destroyed NTSB UNK64X2418Accident · Minor injuriesClosedCessna 172 · Ansonia, OHJun 21, 1964 · N5776A · Destroyed NTSB UNK64X2406Accident · 1 fatalClosedCessna 172 · Hampton, NHJun 20, 1964 · N4213F · Destroyed NTSB UNK64X2316Accident · Minor injuriesClosedCessna 172 · Van Buren, INJun 16, 1964 · N6498E · Substantial damage NTSB UNK64X2288Accident · No injuriesClosedCessna 172 · Cairo, GAJun 14, 1964 · N6886A · Substantial damage NTSB UNK64X2238Accident · No injuriesClosedDehavilland DH-104 · Detroit, MIJun 11, 1964 · N1300H · 2 aircraft · Substantial damage NTSB UNK64X2223Accident · No injuriesClosedCessna 172 · Foremost, CanadaJun 11, 1964 · N7304A · Substantial damage NTSB UNK64X2170Accident · No injuriesClosedCessna 172 · Lathrop Wells, NVJun 7, 1964 · N7954B · Substantial damage NTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZJun 7, 1964 · N6221E · Substantial damage