Skip to content

Fatal NTSB investigations, 1971

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

Fatal NTSB investigations, 1971 per year, 1962–2026: 30,835 cases
1962	11
1963	13
1964	539
1965	560
1966	581
1967	625
1968	718
1969	655
1970	643
1971	664
1972	697
1973	731
1974	727
1975	692
1976	707
1977	713
1978	800
1979	691
1980	672
1981	705
1982	638
1983	651
1984	617
1985	555
1986	507
1987	496
1988	502
1989	484
1990	499
1991	482
1992	494
1993	437
1994	445
1995	456
1996	421
1997	402
1998	422
1999	404
2000	443
2001	412
2002	417
2003	440
2004	418
2005	428
2006	408
2007	387
2008	373
2009	359
2010	363
2011	398
2012	389
2013	344
2014	360
2015	365
2016	341
2017	338
2018	361
2019	381
2020	294
2021	321
2022	330
2023	295
2024	292
2025	275
2026	247

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
  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."highestInjuryLevel" = 'Fatal'
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 NYC72AN085Accident · 1 fatalClosedPiper PA-28 · Malvern, PADec 30, 1971 · N6047W · Destroyed NTSB CHI72AC056Accident · 2 fatalClosedPiper PA-24 · Rockford, ILDec 30, 1971 · N5518P · Destroyed NTSB MIA72AM061Accident · 3 fatalClosedSiai-Marche S205 · Carters, GADec 28, 1971 · N995WA · 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 NTSB MKC72AK041Accident · 2 fatalClosedPiper PA-28R · Davenport, IADec 25, 1971 · N7477J · Destroyed NTSB MKC72AK040Accident · 2 fatalClosedCessna 150L · Clay Center, KSDec 25, 1971 · N1776Q · Destroyed NTSB NYC72AN083Accident · 1 fatalClosedCessna 150B · Allentown, PADec 24, 1971 · N1180Y · Destroyed NTSB MIA72FKJ36Accident · 1 fatalClosedCessna 172F · Oneonta, ALDec 24, 1971 · N7856U · Destroyed NTSB FTW72AF040Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 24, 1971 · N9633J · Destroyed NTSB OAK72AP021Accident · 2 fatalClosedCessna 177A · Las Vegas, NVDec 22, 1971 · N30521 · Destroyed NTSB LAX72AL042Accident · 3 fatalClosedCessna 172K · Newhall, CADec 22, 1971 · N46509 · Destroyed NTSB FTW72AF039Accident · 1 fatalClosedCessna 172 · Seguin, TXDec 22, 1971 · N3941L · Destroyed NTSB ANC72AA031Accident · 1 fatalClosedCessna U206 · Wainwright, AKDec 22, 1971 · N3978G · Destroyed NTSB MIA72AM059Accident · 1 fatalClosedCessna 150J · Missing AircraftDec 21, 1971 · N61155 · Destroyed NTSB MIA72AM056Accident · 2 fatalClosedCessna 150F · Dalton, GADec 21, 1971 · N8014F · Destroyed NTSB OAK72AP020Accident · 1 fatalClosedCessna 182G · Fresno, CADec 20, 1971 · N3180S · Destroyed NTSB MKC72AK039Accident · 1 fatalClosedCessna 150 · Ashland, NEDec 20, 1971 · N23217 · Destroyed NTSB SEA72AS025Accident · 1 fatalClosedPiper PA-22 · Portland, ORDec 19, 1971 · N3535Z · Destroyed NTSB MKC72AK038Accident · 1 fatalClosedErco 415C · Lake Mills, IADec 19, 1971 · N93703 · Destroyed NTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSDec 19, 1971 · N7436M · Destroyed NTSB MIA72AM054Accident · 2 fatalClosedLuscombe 8A · Santee, SCDec 19, 1971 · N45961 · Destroyed NTSB DEN72AD027Accident · 1 fatalClosedAmer Avco AA1A · Tucson, AZDec 19, 1971 · N9249L · Destroyed NTSB CHI72AC053Accident · 2 fatalClosedPiper PA-30 · Bowlng Green, OHDec 18, 1971 · N8083Y · Destroyed NTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INDec 16, 1971 · N8641C · Destroyed NTSB OAK72FVM20Accident · 1 fatalClosedN.American SNJ-5B · Gonzales, CADec 14, 1971 · N3437G · Destroyed NTSB OAK72AP018Accident · 1 fatalClosedCessna 182M · Reno, NVDec 14, 1971 · N71592 · Destroyed NTSB DEN72AD026Accident · 1 fatalClosedN.American AT-6G · Eldora, CODec 14, 1971 · N160JN · Destroyed NTSB SEA72AS028Accident · 3 fatalClosedCessna T337D · Vale, ORDec 13, 1971 · N86371 · Destroyed NTSB NYC72AN080Accident · 4 fatalClosedBeech 95-C55 · Charlotte, NCDec 13, 1971 · N4877J · Destroyed NTSB MKC72AK035Accident · 2 fatalClosedPiper PA-28 · Success, MODec 13, 1971 · N2185T · Destroyed NTSB FTW72AF036Accident · 1 fatalClosedCessna 310 · San Antonio, TXDec 13, 1971 · N5203A · Destroyed NTSB NYC72FIA09Accident · 2 fatalClosedLake LA-4A · Laplata, MDDec 12, 1971 · N1001L · Destroyed NTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damage NTSB NYC72AN078Accident · 4 fatalClosedChampion 7KCAB · Erwinna, PADec 12, 1971 · N5197X · 2 aircraft · Destroyed NTSB MIA72AM052Accident · 1 fatalClosedSchweizer SGS233 · Williamson, GADec 12, 1971 · N1201S · Substantial damage NTSB FTW72AF035Accident · 2 fatalClosedPiper J3C-65 · Marlow, OKDec 12, 1971 · N6382H · Destroyed NTSB CHI72AC051Accident · 2 fatalClosedCessna 320D · Springfield, ILDec 12, 1971 · N777K · Destroyed NTSB NYC72AN077Accident · 1 fatalClosedCessna 172 · Buckhannon, WVDec 11, 1971 · N2501Y · Destroyed NTSB MIA72FKG60Accident · 1 fatalClosedFly Baby Swords · Winder, GADec 11, 1971 · N2011 · Destroyed NTSB FTW72AF034Accident · 1 fatalClosedPiper PA-28 · Piedmont, OKDec 11, 1971 · N5461S · Destroyed NTSB UNK72X0102Accident · 3 fatalClosedBeech 65-B80 · Frbshr By, CanadaDec 10, 1971 · N929V · Destroyed NTSB SEA72AS023Accident · 3 fatalClosedPiper PA-23 · American Falls, IDDec 10, 1971 · N5006Y · Destroyed NTSB FTW72AF033Accident · 7 fatalClosedBeech 65-80 · Okla.City, OKDec 9, 1971 · N252Q · Destroyed NTSB FTW72AF032Accident · 2 fatalClosedMooney M21 · Encino, TXDec 8, 1971 · N5603Q · Destroyed NTSB CHI72AC050Accident · 1 fatalClosedHughes 269C · Clarkston, MIDec 8, 1971 · N9652F · Destroyed NTSB OAK72FJA11Accident · 1 fatalClosedPiper PA-28 · Hilo, HIDec 7, 1971 · N774FC · Destroyed NTSB MIA72AM053Accident · 2 fatalClosedPiper PA-24 · Lamont, FLDec 7, 1971 · N7867P · Destroyed