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 MKC72DCD48Accident · No injuriesClosedPiper PA-20 · Woodbine, IADec 10, 1971 · N7044K · Substantial damage NTSB MIA72FLD30Accident · Serious injuriesClosedPiper PA-22 · New Smrna, FLDec 10, 1971 · N5195Z · Destroyed NTSB LAX72FUG40Accident · No injuriesClosedRearwin 185 · Chino, CADec 10, 1971 · N92902 · Substantial damage NTSB ANC72AA028Accident · No injuriesClosedPilatus PC-6H2 · Nunapitchuk, AKDec 10, 1971 · N3602R · Substantial damage NTSB MIA72DLD32Accident · No injuriesClosedPiper PA-28 · Kissimmee, FLDec 9, 1971 · N8012N · Substantial damage NTSB FTW72AF033Accident · 7 fatalClosedBeech 65-80 · Okla.City, OKDec 9, 1971 · N252Q · Destroyed NTSB CHI72DEI24Accident · No injuriesClosedCessna 172H · Painesville, OHDec 9, 1971 · N2872L · Substantial damage NTSB MKC72AK034Accident · No injuriesClosedBeech Volpar · Grand Island, NEDec 8, 1971 · N113S · Substantial damage NTSB MIA72FLA25Accident · No injuriesClosedCessna 337A · Mcintosh, FLDec 8, 1971 · N6357F · Substantial damage NTSB MIA72FLA22Accident · Serious injuriesClosedCessna 150L · Jacksonville, FLDec 8, 1971 · N6877G · Destroyed NTSB FTW72FRA23Incident · No injuriesClosedLockheed 1329 · Houston, TXDec 8, 1971 · N110G · No damage NTSB FTW72AF032Accident · 2 fatalClosedMooney M21 · Encino, TXDec 8, 1971 · N5603Q · Destroyed NTSB CHI72AC050Accident · 1 fatalClosedHughes 269C · Clarkston, MIDec 8, 1971 · N9652F · Destroyed NTSB OAK72FJA11Accident · 1 fatalClosedPiper PA-28 · Hilo, HIDec 7, 1971 · N774FC · Destroyed NTSB MKC72FER31Accident · No injuriesClosedCessna 421 · Crystal, MNDec 7, 1971 · N4018L · Substantial damage NTSB MKC72FCA18Accident · Serious injuriesClosedPiper PA-30 · Scott City, MODec 7, 1971 · N8040Y · Destroyed NTSB MIA72DKT34Accident · No injuriesClosedCessna 150 · W Palm Beach, FLDec 7, 1971 · N6031G · Substantial damage NTSB MIA72AM053Accident · 2 fatalClosedPiper PA-24 · Lamont, FLDec 7, 1971 · N7867P · Destroyed NTSB FTW72DPD24Accident · No injuriesClosedCessna 140A · Meridian, TXDec 7, 1971 · N1156D · Substantial damage NTSB CHI72AC049Accident · 2 fatalClosedCessna 175A · New Lebanon, OHDec 7, 1971 · N6820E · Destroyed NTSB OAK72FVA36Accident · No injuriesClosedCessna 172 · Layton, CADec 5, 1971 · N78286 · Substantial damage NTSB NYC72FNC20Accident · No injuriesClosedCessna 150 · Claremont, NHDec 5, 1971 · N6270G · Substantial damage NTSB NYC72FNC16Accident · No injuriesClosedPiper J3C-65 · East Dixfield, MEDec 5, 1971 · N98462 · Substantial damage NTSB NYC72DGM26Accident · No injuriesClosedCessna 172 · Somerset, PADec 5, 1971 · N8285L · Substantial damage NTSB MKC72DER32Accident · No injuriesClosedCessna 150G · Lesueur, MNDec 5, 1971 · N2434J · Substantial damage NTSB MIA72FKA07Accident · No injuriesClosedCessna 150 · St Thomas, VIDec 5, 1971 · N3532 · Substantial damage NTSB LAX72DUJ59Accident · No injuriesClosedCessna 172 · Bllhead Cty, AZDec 5, 1971 · N6497E · Substantial damage NTSB LAX72DUG38Accident · No injuriesClosedCessna 150 · Chino, CADec 5, 1971 · N5927J · Substantial damage NTSB FTW72AF031Accident · 3 fatalClosedAero Comdr 680T · New Orleans, LADec 5, 1971 · N78D · Destroyed NTSB CHI72FEP23Accident · Minor injuriesClosedPiper PA-32 · Waukesha, WIDec 5, 1971 · N3449W · Destroyed NTSB CHI72AC048Accident · 1 fatalClosedCessna 172H · Granton, WIDec 5, 1971 · N3288L · Destroyed NTSB ANC72DAG81Accident · No injuriesClosedMaule M-4 · Skwentna, AKDec 5, 1971 · N2028U · Substantial damage NTSB SEA72FYA21Accident · Minor injuriesClosedPiper J4A · Boise, IDDec 4, 1971 · N23199 · Destroyed NTSB OAK72DVM17Accident · No injuriesClosedBeech 35 · San Jose, CADec 4, 1971 · N3009V · 2 aircraft · Substantial damage NTSB OAK72DVM16Accident · No injuriesClosedPiper PA-28 · Salinas, CADec 4, 1971 · N8176W · Substantial damage NTSB OAK72AP017Accident · 1 fatalClosedTaylorcraft DC-65 · Mariposa, CADec 4, 1971 · N47545 · Destroyed NTSB NYC72IN075Incident · No injuriesClosedDouglas DC-10 · Dulles Int Apt, DCDec 4, 1971 · N1805U · Minor damage NTSB NYC72FNA22Accident · No injuriesClosedBeech J35 · Bedford, MADec 4, 1971 · N636Q · Substantial damage NTSB NYC72FHM21Accident · No injuriesClosedPiper PA-28 · Redhook, NYDec 4, 1971 · N5675W · Substantial damage NTSB NYC72DIG15Accident · No injuriesClosedCessna 140 · Ocean City, MDDec 4, 1971 · N72619 · Substantial damage NTSB NYC72AN076Accident · 5 fatalClosedPiper PA-23 · Burnsville, NCDec 4, 1971 · N4063P · Destroyed NTSB NYC72AN074Accident · 2 fatalClosedCessna 206 · Raleigh, NCDec 4, 1971 · N2110F · 2 aircraft · Destroyed NTSB MKC73DCD19Accident · No injuriesClosedAeronca 7AC · Decorah, IADec 4, 1971 · N85286 · Substantial damage NTSB MKC72DTK12Accident · No injuriesClosedMooney M20A · Harrington, SDDec 4, 1971 · N8360E · Substantial damage NTSB MIA72FLA21Accident · Serious injuriesClosedCessna 172F · Gainesville, FLDec 4, 1971 · N8721U · Substantial damage NTSB MIA72FKG58Accident · Minor injuriesClosedPiper PA-22 · Lafayette, GADec 4, 1971 · N5961D · Substantial damage NTSB MIA72DLA20Accident · No injuriesClosedPiper PA-24 · Gainesville, FLDec 4, 1971 · CF-MNP · Substantial damage NTSB LAX72DUJ62Accident · No injuriesClosedCessna 150F · Litchfld Pk, AZDec 4, 1971 · N8355G · Substantial damage NTSB FTW72FRG38Accident · Serious injuriesClosedTed Smith 600 · Victoria, TXDec 4, 1971 · N7497S · Destroyed NTSB FTW72DRJ16Accident · No injuriesClosedCessna 170B · Tallulah, LADec 4, 1971 · N3165B · Substantial damage