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 OAK72FVM20Accident · 1 fatalClosedN.American SNJ-5B · Gonzales, CADec 14, 1971 · N3437G · Destroyed NTSB OAK72AP018Accident · 1 fatalClosedCessna 182M · Reno, NVDec 14, 1971 · N71592 · Destroyed NTSB MIA72DKA08Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRDec 14, 1971 · N5991W · Substantial damage NTSB FTW72DRG46Accident · No injuriesClosedCessna 182G · Bertram, TXDec 14, 1971 · N3214S · Substantial damage 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 MKC72FCJ40Accident · Minor injuriesClosedPiper PA-28R · Scribner, NEDec 13, 1971 · N4981J · Substantial damage NTSB MKC72AK035Accident · 2 fatalClosedPiper PA-28 · Success, MODec 13, 1971 · N2185T · Destroyed NTSB MIA72FLG18Accident · No injuriesClosedPiper PA-24 · Florence, SCDec 13, 1971 · N8552P · Substantial damage NTSB MIA72FLD31Accident · No injuriesClosedPiper J3L-65 · Avon Park, FLDec 13, 1971 · N30842 · Substantial damage NTSB FTW72AF036Accident · 1 fatalClosedCessna 310 · San Antonio, TXDec 13, 1971 · N5203A · Destroyed NTSB OAK72DVG30Accident · No injuriesClosedCessna 182 · Tulelake, CADec 12, 1971 · N2396G · Substantial damage NTSB NYC72FNE18Accident · Serious injuriesClosedCessna 150J · Goshen, MADec 12, 1971 · N61180 · Substantial damage NTSB NYC72FNE17Accident · No injuriesClosedCommonwlth 185 · Middlebury, CTDec 12, 1971 · N92914 · Substantial damage NTSB NYC72FIA09Accident · 2 fatalClosedLake LA-4A · Laplata, MDDec 12, 1971 · N1001L · Destroyed NTSB NYC72DNC18Accident · No injuriesClosedCessna 150F · Plymouth, NHDec 12, 1971 · N8683G · Substantial damage NTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damage NTSB NYC72AN079Accident · Serious injuriesClosedBoeing 707 · Kingston, NYDec 12, 1971 · N781TW · No damage NTSB NYC72AN078Accident · 4 fatalClosedChampion 7KCAB · Erwinna, PADec 12, 1971 · N5197X · 2 aircraft · Destroyed NTSB MKC72FCJ39Accident · No injuriesClosedPiper PA-24 · Scribner, NEDec 12, 1971 · N5095P · Substantial damage NTSB MIA72AM052Accident · 1 fatalClosedSchweizer SGS233 · Williamson, GADec 12, 1971 · N1201S · Substantial damage NTSB LAX72DUG41Accident · No injuriesClosedCessna 150 · Apple Vally, CADec 12, 1971 · N8182S · Substantial damage NTSB LAX72AL071Accident · Minor injuriesClosedGrumman G-21 · Long Beach, CADec 12, 1971 · N11CS · Substantial damage NTSB FTW72FPM15Accident · No injuriesClosedCessna 172K · Jenks, OKDec 12, 1971 · N84691 · Substantial damage NTSB FTW72AF035Accident · 2 fatalClosedPiper J3C-65 · Marlow, OKDec 12, 1971 · N6382H · Destroyed NTSB DEN72DQD19Accident · No injuriesClosedChampion 7EC · Montoya, NMDec 12, 1971 · N4307C · Substantial damage NTSB CHI72AC051Accident · 2 fatalClosedCessna 320D · Springfield, ILDec 12, 1971 · N777K · Destroyed NTSB SEA72DYG21Accident · Minor injuriesClosedBeech 23 · Pullman, WADec 11, 1971 · N7608R · Substantial damage NTSB OAK72FVW20Accident · Minor injuriesClosedHughes 269C · Las Vegas, NVDec 11, 1971 · N9636F · Substantial damage NTSB NYC72FGM25Accident · No injuriesClosedMooney M20C · Monroeville, PADec 11, 1971 · N78921 · Substantial damage NTSB NYC72FGM24Accident · No injuriesClosedCessna 182K · Sharon, PADec 11, 1971 · N2742Q · Substantial damage NTSB NYC72AN077Accident · 1 fatalClosedCessna 172 · Buckhannon, WVDec 11, 1971 · N2501Y · Destroyed NTSB MIA72FKG60Accident · 1 fatalClosedFly Baby Swords · Winder, GADec 11, 1971 · N2011 · Destroyed NTSB MIA72DKJ38Accident · No injuriesClosedPiper PA-32 · Atlantic Ocean (Atlantic Ocean)Dec 11, 1971 · N8965N · Destroyed NTSB LAX72DUJ60Accident · No injuriesClosedMooney M20E · Keam Canyon, AZDec 11, 1971 · N6697R · Substantial damage NTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKDec 11, 1971 · N7025F · Destroyed NTSB FTW72AF034Accident · 1 fatalClosedPiper PA-28 · Piedmont, OKDec 11, 1971 · N5461S · Destroyed NTSB CHI72FEP24Accident · No injuriesClosedMitsubishi MU2B20 · East Troy, WIDec 11, 1971 · N304L · Substantial damage NTSB CHI72FEG26Accident · No injuriesClosedBeech A23A · Harrison, OHDec 11, 1971 · N3602Q · Substantial damage NTSB CHI72FEG25Accident · No injuriesClosedPiper PA-22 · S Lebanon, OHDec 11, 1971 · N1773P · Substantial damage NTSB CHI72FEE48Accident · No injuriesClosedNavion B · Harvard, ILDec 11, 1971 · N5327K · Substantial damage NTSB CHI72DEA24Accident · No injuriesClosedCessna 172 · Martinsville, INDec 11, 1971 · N7613G · Substantial damage NTSB ANC72AA029Accident · No injuriesClosedCessna 180 · Iliamna, AKDec 11, 1971 · N2773X · Substantial damage 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 NYC72FHM23Accident · Serious injuriesClosedAero Comdr 500S · Morristown, NJDec 10, 1971 · N9128N · Destroyed NTSB NYC72FHM22Accident · No injuriesClosedCessna 150 · Linden, NJDec 10, 1971 · N61274 · Substantial damage NTSB NYC72FGM23Accident · No injuriesClosedCessna 172L · West Mifflin, PADec 10, 1971 · N2853Q · Substantial damage NTSB MKC72DTG14Accident · No injuriesClosedPiper J-3 · Colgan, NDDec 10, 1971 · N24705 · Substantial damage