Skip to content

NTSB investigations, 1971

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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

NTSB investigations, 1971 per year, 1962–2026: 180,581 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,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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") = 1971 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\") = 1971
  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") = 1971
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 SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · Destroyed NTSB NYC72FNA25Accident · No injuriesClosedPiper PA-24 · Newburyport, MADec 31, 1971 · N8865P · Substantial damage NTSB NYC72DIG17Accident · No injuriesClosedPiper PA-28 · Montgomery, MDDec 31, 1971 · N3978K · Substantial damage NTSB MIA72FKW12Accident · Serious injuriesClosedCessna 140 · Knoxville, TNDec 31, 1971 · N76180 · Destroyed NTSB MIA72FKT37Accident · No injuriesClosedPiper PA-30 · Boca Chica, FLDec 31, 1971 · N718JR · Substantial damage NTSB CHI72DEV20Accident · No injuriesClosedTaylorcraft BC12-D · Jacksonville, ILDec 31, 1971 · N95057 · Substantial damage NTSB CHI72DEP28Accident · No injuriesClosedPiper PA-28 · Waukesha, WIDec 31, 1971 · N2371T · Substantial damage NTSB CHI72DEM41Accident · No injuriesClosedPiper PA-28 · Alma, MIDec 31, 1971 · N8111W · Substantial damage NTSB ANC72DAG83Accident · No injuriesClosedCessna 170 · Toksook Bay, AKDec 31, 1971 · N8001A · Substantial damage NTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDDec 30, 1971 · N50534 · Substantial damage NTSB NYC72AN085Accident · 1 fatalClosedPiper PA-28 · Malvern, PADec 30, 1971 · N6047W · Destroyed NTSB MKC72DTK15Accident · No injuriesClosedCessna 172I · Aberdeen, SDDec 30, 1971 · N8477L · Substantial damage NTSB MIA72OKT41Accident · No injuriesClosedCessna 172E · Exuma (Atlantic Ocean)Dec 30, 1971 · N5733T · Substantial damage NTSB FTW72DRG56Accident · No injuriesClosedCessna 182H · Tijuana, MexicoDec 30, 1971 · N376LA · Substantial damage NTSB CHI72AC056Accident · 2 fatalClosedPiper PA-24 · Rockford, ILDec 30, 1971 · N5518P · Destroyed NTSB ANC72AA033Accident · Minor injuriesClosedHelio H-250 · Lttl Diomede, AKDec 30, 1971 · N8868E · Substantial damage NTSB NYC72FIA11Accident · Minor injuriesClosedPiper PA-28 · Front Royal, VADec 29, 1971 · N1953T · Substantial damage NTSB NYC72FHM24Accident · Minor injuriesClosedCessna 150 · West Caldwell, NJDec 29, 1971 · N8735S · Substantial damage NTSB MKC72AK042Accident · Serious injuriesClosedBoeing 727 · Kansas City, MODec 29, 1971 · N7277F · No damage NTSB MIA72FKW13Accident · No injuriesClosedPiper PA-24 · Brentwood, TNDec 29, 1971 · N6425P · Substantial damage NTSB DEN72FQA30Accident · Minor injuriesClosedCessna 411 · Alameda, NMDec 29, 1971 · N4977T · Substantial damage NTSB CHI72DEI26Accident · No injuriesClosedBellanca 14-193 · Painesville, OHDec 29, 1971 · N6553N · Substantial damage NTSB NYC72DKM18Accident · No injuriesClosedLuscombe 8A · Winston-Salem, NCDec 28, 1971 · N2698K · Substantial damage NTSB MKC72DTK14Accident · No injuriesClosedAeronca 7AC · De Smet, SDDec 28, 1971 · N3731E · Substantial damage NTSB MIA72DLG21Accident · No injuriesClosedCessna 172 · Lancaster, SCDec 28, 1971 · N8560X · Substantial damage NTSB MIA72AM061Accident · 3 fatalClosedSiai-Marche S205 · Carters, GADec 28, 1971 · N995WA · Destroyed NTSB LAX72DVA41Accident · No injuriesClosedPiper PA-24 · Bakersfield, CADec 28, 1971 · N9085P · Substantial damage NTSB FTW72FRA28Accident · No injuriesClosedPiper PA-28 · Houston, TXDec 28, 1971 · N6615J · Substantial damage NTSB FTW72FPJ27Accident · Serious injuriesClosedMooney M20C · Blair, OKDec 28, 1971 · N7896V · Destroyed NTSB FTW72DRA33Accident · No injuriesClosedBeech V35B · Leona, TXDec 28, 1971 · N4382A · Substantial damage NTSB SEA72DTI12Accident · No injuriesClosedCessna 172G · Loma, MTDec 27, 1971 · N3636L · Substantial damage NTSB OAK72FVM18Accident · No injuriesClosedDehavilland DH104 · San Carlos, CADec 27, 1971 · N6307T · Substantial damage NTSB NYC72AN084Accident · No injuriesClosedPiper PA-23 · Glenn Falls, NYDec 27, 1971 · N5434Y · Substantial damage NTSB MIA72OKT38Accident · No injuriesClosedBeech B90 · No.Atlantic Ocean (Atlantic Ocean)Dec 27, 1971 · N480K · Destroyed NTSB MIA72FKW10Accident · No injuriesClosedBeech B95 · Rockwood, TNDec 27, 1971 · N9890R · Substantial damage NTSB MIA72DLA24Accident · No injuriesClosedPiper PA-28 · High Springs, FLDec 27, 1971 · N5202L · Substantial damage NTSB LAX72DUJ61Accident · No injuriesClosedCessna 172 · Tucson, AZDec 27, 1971 · N78220 · Destroyed NTSB FTW72FRA27Accident · No injuriesClosedCessna 310 · Tomball, TXDec 27, 1971 · N5307A · Substantial damage NTSB FTW72FPD25Accident · No injuriesClosedCessna 172F · Cisco, TXDec 27, 1971 · N8179U · Substantial damage NTSB FTW72DPG58Accident · No injuriesClosedCessna 150 · Heth, ARDec 27, 1971 · N61242 · Substantial damage NTSB DEN72DTE52Accident · Minor injuriesClosedCessna 150 · Walsenburg, CODec 27, 1971 · N3082S · Substantial damage NTSB NYC72DHA28Accident · No injuriesClosedBeech B23 · Doylestown, PADec 26, 1971 · N6127N · Substantial damage NTSB MIA72FLG20Accident · Minor injuriesClosedCessna 172D · Clinton, SCDec 26, 1971 · N2441U · Destroyed NTSB LAX72FUD05Accident · No injuriesClosedErco 415-CD · Pasadena, CADec 26, 1971 · N3148H · Substantial damage NTSB LAX72DUQ53Accident · No injuriesClosedCessna 140 · Van Nuys, CADec 26, 1971 · N3585V · Substantial damage NTSB LAX72DUG50Accident · No injuriesClosedCessna 150 · Perris, CADec 26, 1971 · N22940 · Substantial damage NTSB FTW72FPA11Accident · Serious injuriesClosedSchweizer TG-3A · Valley Mills, TXDec 26, 1971 · N59432 · Destroyed NTSB DEN72AD030Accident · 5 fatalClosedCessna 411 · Stockton, UTDec 26, 1971 · N411Q · Destroyed NTSB CHI72IC055Incident · 1 fatalClosedLockheed Ga 382 · Chicago, ILDec 26, 1971 · N9258R · No damage NTSB CHI72AC054Accident · 2 fatalClosedPiper PA-30 · Chesterfield, MODec 26, 1971 · N7756Y · Destroyed