Skip to content

Final NTSB investigations, 1972

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

Final NTSB investigations, 1972 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

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") = 1972 AND c."completionStatus" = 'Completed' 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\") = 1972
    AND c.\"completionStatus\" = 'Completed'
  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") = 1972
  AND c."completionStatus" = 'Completed'
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 SEA73DTA04Accident · No injuriesClosedPiper PA-18 · Outlook, MTDec 31, 1972 · N4050Z · Substantial damage NTSB SEA73AS017Accident · 2 fatalClosedPiper PA-22 · Portland, ORDec 31, 1972 · N2730P · Destroyed NTSB OAK73DVG39Accident · No injuriesClosedCessna 172H · Nut Tree, CADec 31, 1972 · N1641F · Destroyed NTSB NYC73DLJ16Accident · No injuriesClosedPiper PA-28 · Cape Lookout, NCDec 31, 1972 · N9410W · Substantial damage NTSB NYC73AN094Accident · 5 fatalClosedDouglas DC-7CF · San Juan, PRDec 31, 1972 · N23N · Destroyed NTSB MIA73RKT44Accident · Minor injuriesClosedLake LA-4 · Governors Hrbr (Atlantic Ocean)Dec 31, 1972 · N39384 · Destroyed NTSB MIA73FKW14Accident · No injuriesClosedPiper PA-28 · Chuckey, TNDec 31, 1972 · N8032W · Substantial damage NTSB MIA73AM071Accident · 4 fatalClosedCessna 210D · Hollins, ALDec 31, 1972 · N3773Y · Destroyed NTSB LAX73FUM13Accident · No injuriesClosedBeech A35 · El Cajon, CADec 31, 1972 · N506B · Substantial damage NTSB FTW73DRA14Accident · No injuriesClosedCessna 177 · Tomball, TXDec 31, 1972 · N29434 · Substantial damage NTSB DEN73FQD13Accident · No injuriesClosedErco 415-CD · Alamogordo, NMDec 31, 1972 · N2431H · Substantial damage NTSB CHI73FEC20Accident · Minor injuriesClosedLuscombe 8A · Belleville, MIDec 31, 1972 · N1468K · Substantial damage NTSB ANC73DAG71Accident · No injuriesClosedAeronca 7AC · Palmer, AKDec 31, 1972 · N2597E · Substantial damage NTSB OAK73DVG38Accident · No injuriesClosedPiper PA-28 · Grass Vally, CADec 30, 1972 · N6351J · Substantial damage NTSB OAK73DVD23Accident · No injuriesClosedChampion 7ECA · Sonoma, CADec 30, 1972 · N7512F · Substantial damage NTSB OAK73DVA36Accident · No injuriesClosedAeronca 7AC · Auberry, CADec 30, 1972 · N2566E · Substantial damage NTSB NYC73IN092Incident · No injuriesClosedBoeing 737 · Fayetteville, NCDec 30, 1972 · N749N · Minor damage NTSB NYC73AN093Accident · 2 fatalClosedBellanca 14-132 · Blairs, VADec 30, 1972 · N132K · Destroyed NTSB MIA73FLG31Accident · No injuriesClosedErco 415-C · Inman, SCDec 30, 1972 · N99543 · Substantial damage NTSB MIA73FKG54Accident · 2 fatalClosedN. American F-51D · Flowery Branch, GADec 30, 1972 · N9149R · Destroyed NTSB MIA73FKA07Accident · 1 fatalClosedAmer Avco AA1 · San Juan, PRDec 30, 1972 · N6230L · Destroyed NTSB LAX73DUJ47Accident · Minor injuriesClosedAmer Avco AA1-A · Show Low, AZDec 30, 1972 · N6370L · Substantial damage NTSB FTW73FQD12Accident · No injuriesClosedHelio Acft H-391B · El Paso, TXDec 30, 1972 · N316HW · Substantial damage NTSB NYC73FHM19Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYDec 29, 1972 · N5451P · No damage NTSB NYC73FHJ11Accident · Minor injuriesClosedCessna 172L · Deer Park, NYDec 29, 1972 · N4507Q · Substantial damage NTSB NYC73AGM14Accident · Serious injuriesClosedCessna 310N · Bedford, PADec 29, 1972 · N4101Q · Substantial damage NTSB MKC73DCQ24Accident · No injuriesClosedCessna 210 · Manhattan, KSDec 29, 1972 · N19BB · Substantial damage NTSB MIA73FLD51Accident · Minor injuriesClosedCessna 150L · St.Petersburg, FLDec 29, 1972 · N1423Q · Destroyed NTSB MIA73FKG56Accident · Serious injuriesClosedPiper PA-22 · Peachtree City, GADec 29, 1972 · N3649A · Substantial damage NTSB FTW73AF033Accident · 4 fatalClosedBeech 65-80 · Kent, TXDec 29, 1972 · N9867 · Destroyed NTSB DCA73AZ005Accident · 99 fatalClosedLockheed 1011 · Miami, FLDec 29, 1972 · N310EA · Destroyed NTSB CHI73FEV19Accident · Minor injuriesClosedCessna 150H · Albion, ILDec 29, 1972 · N50344 · Substantial damage NTSB OAK73DVW13Accident · Minor injuriesClosedPiper PA-15 · Henderson, NVDec 28, 1972 · N4355H · Substantial damage NTSB OAK73DVG36Accident · No injuriesClosedCessna 170B · Sacramento, CADec 28, 1972 · N2466D · Substantial damage NTSB NYC73FHM18Accident · Serious injuriesClosedBell 47G-4A · Suffern, NYDec 28, 1972 · N2238W · Substantial damage NTSB NYC73AN125Accident · No injuriesClosedLockheed 1011 · Atlantic City, NJDec 28, 1972 · N305EA · Substantial damage NTSB MKC73DER30Accident · No injuriesClosedChampion 7KCAB · Red Wing, MNDec 28, 1972 · N5167X · Substantial damage NTSB MIA73FLD50Accident · No injuriesClosedBell 47G · Orlando, FLDec 28, 1972 · N184B · Substantial damage NTSB MIA73FLD49Accident · No injuriesClosedLake LA-4P · Redington Bch, FLDec 28, 1972 · N261B · Substantial damage NTSB MIA73DKG55Accident · Minor injuriesClosedSidewinder Smith · Milledgeville, GADec 28, 1972 · N2285 · Substantial damage NTSB FTW73FRG40Accident · No injuriesClosedCessna 150 · Rockport, TXDec 28, 1972 · N8724G · Substantial damage NTSB FTW73FRD14Accident · No injuriesClosedBeech B95 · New Orleans, LADec 28, 1972 · N635B · Substantial damage NTSB FTW73FQG27Accident · Serious injuriesClosedCessna 150 · Adrian, TXDec 28, 1972 · N50030 · Substantial damage NTSB FTW73AF034Accident · 2 fatalClosedPiper PA-28 · Octavia, OKDec 28, 1972 · N4899T · Destroyed NTSB DEN73AD029Accident · 7 fatalClosedPiper PA-32 · Kearney, NEDec 28, 1972 · N8915N · Destroyed NTSB CHI73FEE38Accident · No injuriesClosedCessna 150J · West Chicago, ILDec 28, 1972 · N106DP · Substantial damage NTSB CHI73FEA23Accident · Minor injuriesClosedCessna 210G · Chrisney, INDec 28, 1972 · N5864F · Substantial damage NTSB OAK73FXG20Accident · No injuriesClosedPiper PA-28 · Carson City, NVDec 27, 1972 · N9555W · Substantial damage NTSB NYC73AN090Accident · 3 fatalClosedLockheed L1329 · Saranac Lake, NYDec 27, 1972 · N400M · Destroyed NTSB NYC73AN089Accident · 2 fatalClosedCessna 170A · Turner, MEDec 27, 1972 · N1452D · Destroyed