Skip to content

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, 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 MIA72IM055Incident · No injuriesClosedBoeing 727 · Atlanta, GADec 21, 1971 · N8168G · Minor damage NTSB MIA72AM059Accident · 1 fatalClosedCessna 150J · Missing AircraftDec 21, 1971 · N61155 · Destroyed NTSB MIA72AM057Accident · Serious injuriesClosedBrittnorman BN-2 · Culebra, PRDec 21, 1971 · N589JA · Destroyed NTSB MIA72AM056Accident · 2 fatalClosedCessna 150F · Dalton, GADec 21, 1971 · N8014F · Destroyed NTSB OAK72AP020Accident · 1 fatalClosedCessna 182G · Fresno, CADec 20, 1971 · N3180S · Destroyed NTSB NYC72FKM17Accident · Minor injuriesClosedCessna 182 · Charlotte, NCDec 20, 1971 · N2152G · Substantial damage NTSB NYC72FIA10Accident · No injuriesClosedBeech A23-24 · Lexington Park, MDDec 20, 1971 · N5773V · Destroyed NTSB MKC72AK039Accident · 1 fatalClosedCessna 150 · Ashland, NEDec 20, 1971 · N23217 · Destroyed NTSB MIA72DKT39Accident · No injuriesClosedCessna 140 · Deerfld Beach, FLDec 20, 1971 · N2938N · Substantial damage NTSB FTW72FPG57Accident · Serious injuriesClosedChampion 7GCBC · Parkin, ARDec 20, 1971 · N1851G · Destroyed NTSB CHI72FEA25Accident · No injuriesClosedCessna 172 · Greencastle, INDec 20, 1971 · N46374 · Substantial damage NTSB SEA72AS025Accident · 1 fatalClosedPiper PA-22 · Portland, ORDec 19, 1971 · N3535Z · Destroyed NTSB OAK72DVA39Accident · No injuriesClosedPiper PA-24 · Porterville, CADec 19, 1971 · N6564P · Substantial damage NTSB NYC72FNA27Accident · No injuriesClosedCessna 172 · Plymouth, MADec 19, 1971 · N46601 · Substantial damage NTSB NYC72DKM15Accident · Minor injuriesClosedCessna 182A · Statesville, NCDec 19, 1971 · N5060D · Substantial damage NTSB MKC72FCJ41Accident · Minor injuriesClosedPiper PA-28 · Lincoln, NEDec 19, 1971 · N6710J · Substantial damage NTSB MKC72AK038Accident · 1 fatalClosedErco 415C · Lake Mills, IADec 19, 1971 · N93703 · Destroyed NTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSDec 19, 1971 · N7436M · Destroyed NTSB MIA72DLD23Accident · No injuriesClosedPiper PA-30 · Bartow, FLDec 19, 1971 · N8113Y · Substantial damage NTSB MIA72AM054Accident · 2 fatalClosedLuscombe 8A · Santee, SCDec 19, 1971 · N45961 · Destroyed NTSB LAX72FUA29Accident · No injuriesClosedAerostar 601 · Santa Ana, CADec 19, 1971 · N7494S · Substantial damage NTSB DEN72AD027Accident · 1 fatalClosedAmer Avco AA1A · Tucson, AZDec 19, 1971 · N9249L · Destroyed NTSB ANC72FAG82Accident · No injuriesClosedCessna 180 · Northway, AKDec 19, 1971 · N6538A · Substantial damage NTSB UNK72X0103Accident · No injuriesClosedCessna 310H · Malton, CanadaDec 18, 1971 · N1078Q · Substantial damage NTSB SEA72FYC25Accident · No injuriesClosedCessna 150 · Forest Grove, ORDec 18, 1971 · N7011S · Substantial damage NTSB NYC72DNA23Accident · No injuriesClosedPiper PA-22 · Block Island, RIDec 18, 1971 · N8537C · Substantial damage NTSB MKC72FER34Accident · No injuriesClosedCessna 172E · Walker, MNDec 18, 1971 · N3599S · Substantial damage NTSB LAX72DUG43Accident · No injuriesClosedHughes 269A · Ontario, CADec 18, 1971 · N8846F · Substantial damage NTSB CHI72AC053Accident · 2 fatalClosedPiper PA-30 · Bowlng Green, OHDec 18, 1971 · N8083Y · Destroyed NTSB ANC72DAG85Accident · Minor injuriesClosedCessna 180 · Chevak, AKDec 18, 1971 · N3384D · Substantial damage NTSB ANC72DAG84Accident · No injuriesClosedCessna 120 · Hope, AKDec 18, 1971 · N72233 · Substantial damage NTSB MIA72DLA26Accident · Minor injuriesClosedBell 47D1 · Milton, FLDec 17, 1971 · N3109G · Substantial damage NTSB LAX72FVA37Accident · Serious injuriesClosedBell 47G5 · Mcfarland, CADec 17, 1971 · N8557F · Destroyed NTSB LAX72DUG46Accident · No injuriesClosedChampion 7GCBC · La Verne, CADec 17, 1971 · N7590F · Substantial damage NTSB FTW72DRG43Accident · Minor injuriesClosedCessna 210E · Tresimilio, MexicoDec 17, 1971 · N1801F · Substantial damage NTSB FTW72AF037Accident · No injuriesClosedBeech A99A · Houston, TXDec 17, 1971 · N1923T · Substantial damage NTSB SEA72AS024Accident · Serious injuriesClosedBeech 65-B80 · Mccall, IDDec 16, 1971 · N1028C · Substantial damage NTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSDec 16, 1971 · N1248Q · Substantial damage NTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INDec 16, 1971 · N8641C · Destroyed NTSB NYC72FNE20Accident · No injuriesClosedCessna 182L · Simsbury, CTDec 15, 1971 · N3366R · Destroyed NTSB NYC72AN082Accident · Serious injuriesClosedPiper PA-23 · Haledon, NJDec 15, 1971 · N6685Y · Destroyed NTSB MKC72AK036Accident · No injuriesClosedPiper PA-32 · Topeka, KSDec 15, 1971 · N4105W · Substantial damage NTSB LAX72FUG39Accident · No injuriesClosedBell 47B · La Verne, CADec 15, 1971 · N514SF · Substantial damage NTSB FTW72FRA26Accident · No injuriesClosedLuscomb 8E · Conroe, TXDec 15, 1971 · N1850K · Substantial damage NTSB FTW72DRG42Accident · No injuriesClosedCessna 182 · San Saba, TXDec 15, 1971 · N2169G · Substantial damage NTSB FTW72DRD17Accident · No injuriesClosedCessna A185E · Leeville, LADec 15, 1971 · N5818J · Substantial damage NTSB FTW72DPJ26Accident · No injuriesClosedBoeing A75N1 · Hollis, OKDec 15, 1971 · N50755 · Substantial damage NTSB DEN72FTE49Accident · No injuriesClosedCessna 150 · Littleton, CODec 15, 1971 · N6812F · Substantial damage NTSB DEN72FQD18Accident · No injuriesClosedBell 47G3B1 · Hollomn Afb, NMDec 15, 1971 · N1382X · Substantial damage NTSB CHI72DEI25Accident · No injuriesClosedCessna 206 · Cleveland, OHDec 15, 1971 · N8755Z · Substantial damage