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 FTW72DQG25Accident · No injuriesClosedCessna 210 · Denver City, TXNov 27, 1971 · N1446 · Substantial damage NTSB CHI72FEE47Accident · No injuriesClosedPiper PA-12 · Elgin, ILNov 27, 1971 · N3847M · Substantial damage NTSB ANC72DAG80Accident · No injuriesClosedCessna 180 · Tyonek, AKNov 27, 1971 · N93330 · Substantial damage NTSB ANC72DAG77Accident · No injuriesClosedPiper J5A · Anchorage, AKNov 27, 1971 · N35408 · Substantial damage NTSB OAK72DVD30Accident · No injuriesClosedCessna 337 · Hayward, CANov 26, 1971 · N6214F · Destroyed NTSB NYC72FHA27Accident · No injuriesClosedPiper PA-28 · Quakertown, PANov 26, 1971 · N471FL · Substantial damage NTSB MKC72AK031Accident · 4 fatalClosedBeech H35 · Bland, MONov 26, 1971 · N5520D · Destroyed NTSB MIA72IM049Incident · Minor injuriesClosedDouglas DC-10 · Miami, FLNov 26, 1971 · N60NA · No damage NTSB MIA72FKG57Accident · Serious injuriesClosedPiper J3C-65 · Cedartown, GANov 26, 1971 · N3586N · Substantial damage NTSB LAX72FUG36Accident · Minor injuriesClosedN.American P-51D · Chino, CANov 26, 1971 · N3333E · 2 aircraft · Substantial damage NTSB CHI72FEG24Accident · No injuriesClosedPiper PA-23 · Lebanon, OHNov 26, 1971 · N4175P · Substantial damage NTSB CHI72FEA23Accident · Minor injuriesClosedCessna 150 · Pittsboro, INNov 26, 1971 · N5988G · Substantial damage NTSB ANC72AA027Accident · No injuriesClosedCessna 185 · Skwentna, AKNov 26, 1971 · N70022 · Substantial damage NTSB SEA72AS022Accident · 6 fatalClosedBeech C35 · Astoria, ORNov 25, 1971 · N1944D · Destroyed NTSB NYC72FHD23Accident · No injuriesClosedCessna 177 · Sewell, NJNov 25, 1971 · N3258T · Substantial damage NTSB NYC72DID18Accident · No injuriesClosedCessna 172K · Reedville, VANov 25, 1971 · N7211G · Substantial damage NTSB MKC72FTK11Accident · Serious injuriesClosedBeech S35 · Pierre, SDNov 25, 1971 · N198Q · Substantial damage NTSB MKC72FCA17Accident · No injuriesClosedCessna 172K · Fenton, MONov 25, 1971 · N7041G · Substantial damage NTSB MIA72FLD26Accident · No injuriesClosedCessna 172 · Tampa, FLNov 25, 1971 · N6485B · Substantial damage NTSB MIA72DKJ34Accident · No injuriesClosedCessna 150G · Owens X-Rds, ALNov 25, 1971 · N3124J · Substantial damage NTSB CHI72FEM40Accident · No injuriesClosedTaylorcraft BC12-D · Williamsburg, MINov 25, 1971 · N95943 · Substantial damage NTSB CHI72FEK07Accident · No injuriesClosedPiper PA-28R · Columbus, OHNov 25, 1971 · N7441J · Substantial damage NTSB CHI72AC047Accident · 1 fatalClosedBeech A23 · Missing AircraftNov 25, 1971 · N3500R · Destroyed NTSB NYC72FIJ33Accident · Minor injuriesClosedCessna 140 · Summersville, WVNov 24, 1971 · N76540 · Destroyed NTSB NYC72FHD22Accident · Minor injuriesClosedMooney M20F · Vineland, NJNov 24, 1971 · N9652M · Substantial damage NTSB MKC72AK030Accident · 4 fatalClosedBeech E35 · Garden City, KSNov 24, 1971 · N3202C · Destroyed NTSB LAX72AL039Accident · 1 fatalClosedCessna 182A · Big Bear, CANov 24, 1971 · N3715D · Destroyed NTSB FTW72FPJ23Accident · No injuriesClosedBeech A23-24 · Crescent, OKNov 24, 1971 · N5979S · Substantial damage NTSB FTW72DRA29Accident · No injuriesClosedCessna 182 · Kountze, TXNov 24, 1971 · N71038 · Substantial damage NTSB FTW72DPD23Accident · No injuriesClosedCessna 182 · Weatherford, TXNov 24, 1971 · N3260S · Substantial damage NTSB DEN72FQA25Accident · No injuriesClosedLuscombe 8A · Albuquerque, NMNov 24, 1971 · N23060 · Substantial damage NTSB DEN72AD025Accident · No injuriesClosedBeech 99A · Greeley, CONov 24, 1971 · N21FW · Substantial damage NTSB CHI72FEI23Accident · No injuriesClosedHelio Acft H-295 · Medina, OHNov 24, 1971 · N6469V · Substantial damage NTSB CHI72DLQ23Accident · No injuriesClosedMitsubishi MU-2F · Bardstown, KYNov 24, 1971 · N180MA · Substantial damage NTSB CHI72DEP26Accident · No injuriesClosedLuscombe 8A · Wilmot, WINov 24, 1971 · N45676 · Substantial damage NTSB ANC72DAG79Accident · No injuriesClosedStinson 108-2 · Kodiak, AKNov 24, 1971 · N9510K · Substantial damage NTSB ANC72AA023Accident · No injuriesClosedPiper PA-28 · Iliamna, AKNov 24, 1971 · N7311W · Substantial damage NTSB NYC72FHM17Accident · No injuriesClosedPiper PA-28 · Belmar, NJNov 23, 1971 · N2171T · Substantial damage NTSB NYC72FGT06Accident · No injuriesClosedCessna 195 · Hershey, PANov 23, 1971 · N4338N · Substantial damage NTSB NYC72DNC17Accident · Minor injuriesClosedBeech A23A · West Dover, VTNov 23, 1971 · N7903L · Substantial damage NTSB MKC72DCJ38Accident · Minor injuriesClosedChampion 7GCBC · Hershey, NENov 23, 1971 · N1802G · Substantial damage NTSB MIA72FKW08Accident · Minor injuriesClosedPiper PA-23 · Maloneyville, TNNov 23, 1971 · N3498P · Destroyed NTSB MIA72DKJ32Accident · No injuriesClosedPiper PA-28 · Auburn, ALNov 23, 1971 · N5957W · Substantial damage NTSB LAX72FUG35Accident · Minor injuriesClosedCessna 205 · El Mirage, CANov 23, 1971 · N8460Z · Substantial damage NTSB LAX72AL038Accident · 1 fatalClosedPiper PA-22 · Chloride, AZNov 23, 1971 · N2565P · Destroyed NTSB CHI72FLQ21Accident · No injuriesClosedPiper PA-22 · Albany, KYNov 23, 1971 · N4440A · Substantial damage NTSB CHI72FEK09Accident · No injuriesClosedCessna 150F · Zanesville, OHNov 23, 1971 · N6561F · Substantial damage NTSB CHI72FEC19Accident · No injuriesClosedBeech M35 · Owosso, MINov 23, 1971 · N9751R · Substantial damage NTSB ANC72AA026Accident · 4 fatalClosedCessna 175 · Willits, CANov 23, 1971 · N7055M · Destroyed NTSB OAK72FVW19Accident · No injuriesClosedAero Comdr 100 · Mercury, NVNov 22, 1971 · N3697X · Substantial damage