Skip to content

NTSB investigations, 1971

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 OAK72FVA35Accident · Serious injuriesClosedHargis JT · Madera, CANov 22, 1971 · N3804 · Substantial damage NTSB NYC72AN069Accident · 1 fatalClosedAero Comdr 560-A · East Greenwich, RINov 22, 1971 · N87K · Substantial damage NTSB MKC72FCQ36Accident · Minor injuriesClosedBeech 35 · Junction Cty, KSNov 22, 1971 · N735JS · Substantial damage NTSB MKC72FCG34Accident · 1 fatalClosedPiper PA-22 · Lansing, KSNov 22, 1971 · N1792P · Substantial damage NTSB LAX72FUG37Accident · No injuriesClosedCessna 150 · El Monte, CANov 22, 1971 · N4035J · Substantial damage NTSB FTW72AF029Accident · 1 fatalClosedBeech J35 · Jacksboro, TXNov 22, 1971 · N8321D · Destroyed NTSB NYC72FHM16Accident · No injuriesClosedCessna 182K · Spring Valley, NYNov 21, 1971 · N2586Q · Substantial damage NTSB NYC72FHD21Accident · No injuriesClosedCessna 182J · Williamstown, NJNov 21, 1971 · N2733F · Substantial damage NTSB NYC72FHA26Accident · No injuriesClosedSchweizer SGS126 · Kutztown, PANov 21, 1971 · N1136S · Substantial damage NTSB NYC72DHM15Accident · No injuriesClosedCessna 150 · Teterboro, NJNov 21, 1971 · N23072 · Substantial damage NTSB MKC72FER30Accident · Serious injuriesClosedPiper PA-18 · Gilman, MNNov 21, 1971 · N4316Z · Substantial damage NTSB MIA72FKT30Accident · No injuriesClosedGlobe GC-1B · Sanibel Isld, FLNov 21, 1971 · N80990 · Substantial damage NTSB MIA72DKG48Accident · No injuriesClosedSchweizer 2-33A · Sylvania, GANov 21, 1971 · N7537 · Substantial damage NTSB MIA72AM048Accident · No injuriesClosedBeech 99A · Ft.Lauderdale, FLNov 21, 1971 · N860SA · Substantial damage NTSB MIA72AM047Accident · 1 fatalClosedCessna 182E · Heflin, ALNov 21, 1971 · N2946Y · Destroyed NTSB FTW72FRA22Accident · No injuriesClosedCessna 177 · Lake Jackson, TXNov 21, 1971 · N29418 · Substantial damage NTSB FTW72DPD22Accident · No injuriesClosedCessna 120 · Weatherford, TXNov 21, 1971 · N72384 · Substantial damage NTSB DEN72FQA26Accident · No injuriesClosedCessna 150F · Cedar Crest, NMNov 21, 1971 · N8182F · Substantial damage NTSB DEN72DTE45Accident · Minor injuriesClosedPiper PA-22 · Pagosa Sprgs, CONov 21, 1971 · N6127D · Substantial damage NTSB ANC72AA022Accident · 4 fatalClosedCessna 170B · Kotzebue, AKNov 21, 1971 · N3455D · Destroyed NTSB SEA72FYC24Accident · Minor injuriesClosedPiper PA-20 · Washougal, ORNov 20, 1971 · N7630K · Destroyed NTSB OAK72FJA08Accident · Serious injuriesClosedHiller Acft 1100 · Kaanapali, HINov 20, 1971 · N578FH · Destroyed NTSB OAK72DVA47Accident · No injuriesClosedErco 415-C · Merced, CANov 20, 1971 · N2601H · Substantial damage NTSB NYC72FLJ17Accident · No injuriesClosedCessna 150 · Jacksonville, NCNov 20, 1971 · N6440G · Substantial damage NTSB NYC72DNA21Accident · No injuriesClosedPiper PA-28 · Edgartown, MANov 20, 1971 · N3488K · Substantial damage NTSB LAX72FUA24Accident · No injuriesClosedCessna 150H · Hntngtn Bch, CANov 20, 1971 · N50441 · Substantial damage NTSB LAX72DUJ58Accident · Minor injuriesClosedPiper J3C-65 · Pearce, AZNov 20, 1971 · N70524 · Destroyed NTSB LAX72AL037Accident · 1 fatalClosedGlobe GC-1B · Palos Vrdes, CANov 20, 1971 · N250B · Destroyed NTSB FTW72FRA25Accident · No injuriesClosedMooney M20A · Houston, TXNov 20, 1971 · N8379E · Substantial damage NTSB FTW72AF028Accident · 1 fatalClosedCessna 150K · Plano, TXNov 20, 1971 · N1031M · Destroyed NTSB EU172DYZ02Accident · No injuriesClosedAero Comdr 680-V · Aminabad, IranNov 20, 1971 · N2655 · Substantial damage NTSB DEN72DTE44Accident · Minor injuriesClosedCessna 172 · Fountain, CONov 20, 1971 · N4339Q · Substantial damage NTSB CHI72DEV18Accident · No injuriesClosedPiper PA-16 · Lawrenceville, ILNov 20, 1971 · N5899H · Substantial damage NTSB ANC72AA024Accident · 1 fatalClosedChampion 7GCBC · Prescott, AZNov 20, 1971 · N9002L · Destroyed NTSB NYC72AN068Accident · 1 fatalClosedPiper PA-28 · Craryville, NYNov 19, 1971 · N5594U · Destroyed NTSB FTW72FQG21Accident · Serious injuriesClosedCessna 172K · Old Glory, TXNov 19, 1971 · N7305G · Substantial damage NTSB OAK72AP016Accident · 2 fatalClosedPiper PA-22 · Bodega Bay, CANov 18, 1971 · N2503P · Destroyed NTSB MKC72DTK10Accident · No injuriesClosedBeech S35 · Ipswich, SDNov 18, 1971 · N8657Q · Substantial damage NTSB MIA72AM046Accident · No injuriesClosedCessna 150K · Opa Locka, FLNov 18, 1971 · N5922G · 2 aircraft · Substantial damage NTSB FTW72DRJ15Accident · Minor injuriesClosedCessna 172K · Jonesville, LANov 18, 1971 · N84612 · Destroyed NTSB CHI72FEK08Accident · No injuriesClosedCessna 172A · Columbus, OHNov 18, 1971 · N7841T · Substantial damage NTSB CHI72DEI21Accident · No injuriesClosedCessna 150 · Fremont, OHNov 18, 1971 · N6457S · Substantial damage NTSB CHI72AC046Accident · 4 fatalClosedCessna 320E · No.Madison, OHNov 18, 1971 · N3414Q · Destroyed NTSB ANC72FAG76Accident · No injuriesClosedPiper PA-28 · Naknek, AKNov 18, 1971 · N257W · Substantial damage NTSB SEA72AS020Accident · 4 fatalClosedPiper PA-23 · Grants Pass, ORNov 17, 1971 · N1156P · Destroyed NTSB OAK72FVW18Accident · Serious injuriesClosedCessna 172B · Las Vegas, NVNov 17, 1971 · N7697X · Substantial damage NTSB MKC72DCD47Accident · No injuriesClosedPiper PA-32 · Dubuque, IANov 17, 1971 · N4139W · Substantial damage NTSB MIA72AM045Accident · 4 fatalClosedPiper PA-31 · Iuka, MSNov 17, 1971 · N780JM · Destroyed NTSB MIA72AM044Accident · No injuriesClosedLockheed 749A · No.Atlantic Ocean (Atlantic Ocean)Nov 17, 1971 · N6021C · Substantial damage NTSB LAX72FUG34Accident · No injuriesClosedCessna 182 · Chriaco Smt, CANov 17, 1971 · N92380 · Substantial damage