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 CHI72AC045Accident · No injuriesClosedBoeing 727 · Milwaukee, WINov 17, 1971 · N7077U · Substantial damage NTSB OAK72DVM15Accident · No injuriesClosedLuscombe 8A · Palo Alto, CANov 16, 1971 · N1439K · Substantial damage NTSB NYC72AN067Accident · 1 fatalClosedBay Avn. Superv · Keene, NHNov 16, 1971 · N430MD · Destroyed NTSB MKC72FCA16Accident · No injuriesClosedN.American SNJ-4 · Chesterfield, MONov 16, 1971 · N1395N · Substantial damage NTSB MIA72RKT28Accident · Minor injuriesClosedPiper PA-23 · Nassau, Burkina FasoNov 16, 1971 · N2226P · Substantial damage NTSB MIA72DKJ33Accident · No injuriesClosedPiper PA-32 · Montgomery, ALNov 16, 1971 · N8660N · Substantial damage NTSB LAX72DUQ45Accident · No injuriesClosedPiper PA-22 · Lancaster, CANov 16, 1971 · N2241A · Substantial damage NTSB LAX72AL035Accident · 2 fatalClosedCessna 150C · Tonopah, AZNov 16, 1971 · N7802Z · Destroyed NTSB LAX72AL034Accident · 4 fatalClosedPiper PA-28 · Bonita, CANov 16, 1971 · N5721U · 2 aircraft · Destroyed NTSB FTW72DPG55Accident · No injuriesClosedCessna 177 · Carlisle, ARNov 16, 1971 · N29380 · Substantial damage NTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNov 16, 1971 · N7018S · Substantial damage NTSB ANC72AA021Accident · No injuriesClosedCessna 180H · Gulkana, AKNov 16, 1971 · N2757X · Substantial damage NTSB OAK72DVM14Accident · No injuriesClosedBeech C35 · Palo Alto, CANov 15, 1971 · N5836C · Substantial damage NTSB MIA72FKG53Accident · No injuriesClosedPitts Spcl SC-1 · Douglasville, GANov 15, 1971 · N6119 · Substantial damage NTSB SEA72FYG20Accident · No injuriesClosedCessna 172K · Spokane, WANov 14, 1971 · N84034 · Substantial damage NTSB OAKM2FVD28Accident · No injuriesClosedBeech 99 · Oakland, CANov 14, 1971 · N931GP · Substantial damage NTSB OAK72FVA34Accident · No injuriesClosedCessna 210J · Columbia, CANov 14, 1971 · N350TM · Substantial damage NTSB NYC72FNE16Accident · No injuriesClosedCessna 172D · Deep River, CTNov 14, 1971 · N8537X · Substantial damage NTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNov 14, 1971 · N2204C · Substantial damage NTSB MKC72FCD44Accident · No injuriesClosedPiper PA-28 · Newton, IANov 14, 1971 · N6649J · Substantial damage NTSB MKC72DCJ37Accident · No injuriesClosedWaco UKC · Columbus, NENov 14, 1971 · N14086 · Substantial damage NTSB MKC72DCD45Accident · No injuriesClosedPiper PA-32 · Ida Grove, IANov 14, 1971 · N4063R · Substantial damage NTSB MIA72FKG55Accident · Minor injuriesClosedPiper PA-22 · Wrens, GANov 14, 1971 · N884A · Substantial damage NTSB MIA72AM043Accident · No injuriesClosedTed Smith 600 · Hilton Head Is, SCNov 14, 1971 · N7414S · Substantial damage NTSB FTW72FRJ13Accident · No injuriesClosedPiper PA-30 · Winnsboro, TXNov 14, 1971 · N8806Y · Substantial damage NTSB FTW72FRA21Accident · Minor injuriesClosedGlobe GC-1B · Lamarque, TXNov 14, 1971 · N80891 · Substantial damage NTSB FTW72DQG23Accident · No injuriesClosedCessna 401A · Amarillo, TXNov 14, 1971 · N6238Q · Substantial damage NTSB FTW72DQG22Accident · No injuriesClosedMooney M20F · Kermit, TXNov 14, 1971 · N432AF · Substantial damage NTSB FTW72DPJ24Accident · No injuriesClosedGrumman TBM-3U · Cushing, OKNov 14, 1971 · N108Q · Substantial damage NTSB CHI72FLQ20Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYNov 14, 1971 · N7254F · Substantial damage NTSB ANC72FAG75Accident · No injuriesClosedCessna 207 · Anchorage, AKNov 14, 1971 · N1590U · Destroyed NTSB SEA72DYC23Accident · No injuriesClosedCessna 175 · Condon, ORNov 13, 1971 · N7095M · Substantial damage NTSB SEA72DYC22Accident · No injuriesClosedBeech A-23A · Troutdale, ORNov 13, 1971 · N3692Q · Substantial damage NTSB NYC72FNA20Accident · 1 fatalClosedPiper J3C-65 · Haverhill, MANov 13, 1971 · N3406K · Destroyed NTSB NYC72FLJ16Accident · No injuriesClosedCessna 150L · Macon, NCNov 13, 1971 · N6559G · Substantial damage NTSB NYC72FHA25Accident · No injuriesClosedAero Comdr 500-S · Allentown, PANov 13, 1971 · N5031E · Substantial damage NTSB NYC72AN086Accident · Serious injuriesClosedBoeing 707 · Honolulu, HINov 13, 1971 · N8760 · No damage NTSB MKC72FER26Accident · 1 fatalClosedKnutson B8M · St.Paul, MNNov 13, 1971 · N34DK · Destroyed NTSB MKC72DER27Accident · No injuriesClosedAeronca L-16 · Lakeville, MNNov 13, 1971 · N6040V · Substantial damage NTSB MIA72FKJ31Accident · No injuriesClosedBeech 65-A80 · Birmingham, ALNov 13, 1971 · N277Q · Substantial damage NTSB LAX72FUQ41Accident · No injuriesClosedHawker Fury Mark 2 · Mojave, CANov 13, 1971 · N878M · Destroyed NTSB LAX72FUG33Accident · Serious injuriesClosedCessna 182M · Mentone, CANov 13, 1971 · N71169 · Destroyed NTSB LAX72DUJ56Accident · No injuriesClosedPiper PA-28 · Tucson, AZNov 13, 1971 · N8598N · Substantial damage NTSB LAX72DUJ55Accident · Minor injuriesClosedBeech B35 · Phoenix, AZNov 13, 1971 · N5078C · Substantial damage NTSB LAX72AL033Accident · 4 fatalClosedPiper PA-28 · Solvang, CANov 13, 1971 · N3626R · Destroyed NTSB FTW72DRA24Accident · No injuriesClosedBeech K35 · Matamoros, MexicoNov 13, 1971 · N6060E · Substantial damage NTSB DEN72DTE43Accident · No injuriesClosedCessna 150G · Broomfield, CONov 13, 1971 · N3484J · Substantial damage NTSB CHI72DEE45Accident · No injuriesClosedMooney M20B · Rockford, ILNov 13, 1971 · N74578 · Substantial damage NTSB ANC72FAA21Accident · No injuriesClosedCessna 170B · Livengood, AKNov 13, 1971 · N2313D · Substantial damage NTSB NYC72FFJ23Accident · No injuriesClosedBeech 35-A33 · Baldwinsville, NYNov 12, 1971 · N9365Y · Destroyed