Skip to content

NTSB investigations, 1971

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, newest first

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 SEA72DYA22Accident · No injuriesClosedAeronca 11AC · Brogan, ORDec 25, 1971 · N3175E · Substantial damage NTSB NYC72FGM27Accident · Serious injuriesClosedBeech 23 · Mcmurray, PADec 25, 1971 · N2379Z · Substantial damage 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 MIA72OKA10Accident · No injuriesClosedPiper PA-31 · Anguilla, WNDec 25, 1971 · N9005Y · Substantial damage NTSB MIA72FKG62Accident · Serious injuriesClosedMooney M-20F · Columbus, GADec 25, 1971 · N9592M · Substantial damage NTSB MIA72DLT11Accident · No injuriesClosedRobertson 205 · Dyer, TNDec 25, 1971 · N1825Z · Substantial damage NTSB FTW72DRJ17Accident · No injuriesClosedCessna 170B · Robson, LADec 25, 1971 · N2309D · Substantial damage NTSB OAK72FVD29Accident · Serious injuriesClosedCessna 150 · Livermore, CADec 24, 1971 · N6675G · Substantial damage NTSB NYC72AN083Accident · 1 fatalClosedCessna 150B · Allentown, PADec 24, 1971 · N1180Y · Destroyed NTSB MKC72FCJ42Accident · No injuriesClosedTemco GC-1B · Grand Island, NEDec 24, 1971 · N2329B · Substantial damage NTSB MKC72DTK13Accident · No injuriesClosedPiper PA-11 · Miller, SDDec 24, 1971 · N78636 · Substantial damage NTSB MKC72DCJ43Accident · No injuriesClosedCessna 150 · Taylor, NEDec 24, 1971 · N7989F · Substantial damage NTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLDec 24, 1971 · N8470K · Substantial damage NTSB MIA72FLA23Accident · Minor injuriesClosedCessna 177 · Carrabelle, FLDec 24, 1971 · N2393Y · Substantial damage NTSB MIA72FKT36Accident · No injuriesClosedCallair A-9B · W Palm Beach, FLDec 24, 1971 · N7992V · Substantial damage NTSB MIA72FKJ37Accident · Minor injuriesClosedTaylorcraft DCO-65 · Mobile, ALDec 24, 1971 · N52423 · Substantial damage NTSB MIA72FKJ36Accident · 1 fatalClosedCessna 172F · Oneonta, ALDec 24, 1971 · N7856U · Destroyed NTSB MIA72FKG70Accident · No injuriesClosedMaule M-4 · Statesboro, GADec 24, 1971 · N2052U · Substantial damage NTSB MIA72FKG63Accident · Minor injuriesClosedPiper PA-28 · Homerville, GADec 24, 1971 · N7260F · Substantial damage NTSB FTW72DRJ18Accident · No injuriesClosedCessna P206B · Hooks, TXDec 24, 1971 · N4778F · Substantial damage NTSB FTW72AF040Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 24, 1971 · N9633J · Destroyed NTSB DEN72FQD20Accident · Minor injuriesClosedAero-Comdr 100 · Deming, NMDec 24, 1971 · N4127X · Substantial damage NTSB CHI72FEE51Accident · No injuriesClosedBeech 18 · Chicago, ILDec 24, 1971 · N588K · Substantial damage NTSB SEA72DYG23Accident · No injuriesClosedCessna 182A · Pulman, WADec 23, 1971 · N5948B · Substantial damage NTSB SEA72DVG22Accident · No injuriesClosedLuscombe 8F · Walla Walla, WADec 23, 1971 · N1870B · Substantial damage NTSB NYC72FHD24Accident · Minor injuriesClosedChampion 7FC · Moorestown, NJDec 23, 1971 · N9974Y · Substantial damage NTSB NYC72DHD25Accident · No injuriesClosedCessna 177 · Rehoboth Bch, DEDec 23, 1971 · N3198T · Substantial damage NTSB MIA72DKW11Accident · No injuriesClosedChampion 7ECA · Lafollette, TNDec 23, 1971 · N7585F · Substantial damage NTSB MIA72DKT35Accident · No injuriesClosedCessna 172G · Miami, FLDec 23, 1971 · N3778L · Substantial damage NTSB MIA72DKG61Accident · Minor injuriesClosedCessna 172H · Athens, GADec 23, 1971 · N3852R · Substantial damage NTSB MIA72AM060Accident · Serious injuriesClosedDouglas DC-8 · No.Atlantic Ocean (Atlantic Ocean)Dec 23, 1971 · N8613 · No damage NTSB FTW72DRD18Accident · No injuriesClosedCessna 172K · Gonzales, LADec 23, 1971 · N46421 · Substantial damage NTSB OAK72AP021Accident · 2 fatalClosedCessna 177A · Las Vegas, NVDec 22, 1971 · N30521 · Destroyed NTSB NYC72FNE19Accident · Minor injuriesClosedCessna 172F · Kent, CTDec 22, 1971 · N7857U · Substantial damage NTSB MKC72FCD49Accident · Serious injuriesClosedMitsubishi MU-2B · Lemars, IADec 22, 1971 · N251M · No damage NTSB MKC72DER33Accident · No injuriesClosedCessna 150L · Wht Br Lake, MNDec 22, 1971 · N1601Q · Substantial damage NTSB MIA72OM063Accident · No injuriesClosedBrittnorman BN-2A · Dajabon, DRDec 22, 1971 · N42JA · Substantial damage NTSB MIA72FLG19Accident · Serious injuriesClosedPiper PA-28 · Charleston, SCDec 22, 1971 · N8253N · Substantial damage NTSB MIA72FKQ27Accident · No injuriesClosedHiller Acft FH1100 · Hattiesburg, MSDec 22, 1971 · N5035F · Substantial damage NTSB MIA72DLA27Accident · No injuriesClosedCessna 182 · Apalachicola, FLDec 22, 1971 · N3367U · Substantial damage NTSB LAX72FUG42Accident · Serious injuriesClosedBeech 23 · Big Bear, CADec 22, 1971 · N2366Q · Substantial damage NTSB LAX72AL042Accident · 3 fatalClosedCessna 172K · Newhall, CADec 22, 1971 · N46509 · Destroyed NTSB FTW72AF039Accident · 1 fatalClosedCessna 172 · Seguin, TXDec 22, 1971 · N3941L · Destroyed NTSB FTW72AF038Accident · No injuriesClosedLockheed 18 · Hobart, OKDec 22, 1971 · N10P · Substantial damage NTSB CHI72FEC20Accident · No injuriesClosedCessna 172G · Corunna, MIDec 22, 1971 · N4142L · Substantial damage NTSB ANC72AA032Accident · Minor injuriesClosedPiper PA-32 · Galena, AKDec 22, 1971 · N8942N · Substantial damage NTSB ANC72AA031Accident · 1 fatalClosedCessna U206 · Wainwright, AKDec 22, 1971 · N3978G · Destroyed NTSB OAK72FVA38Accident · No injuriesClosedCessna 150 · Selma, CADec 21, 1971 · N6684G · Substantial damage NTSB MIA72OM062Accident · Serious injuriesClosedBeech D18S · Kingston, JamaicaDec 21, 1971 · N711K · Substantial damage