Skip to content

Final NTSB investigations, 1971

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, 1971 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") = 1971 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\") = 1971
    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") = 1971
  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 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