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 FTW72DQG24Accident · No injuriesClosedPiper PA-28 · Follett, TXDec 4, 1971 · N4658R · Substantial damage NTSB CHI72FLQ22Accident · No injuriesClosedHughes 269B · Louisville, KYDec 4, 1971 · N9470F · Substantial damage NTSB CHI72FET11Accident · Serious injuriesClosedCessna 175 · Auburn, INDec 4, 1971 · N7627M · Substantial damage NTSB CHI72DEI22Accident · No injuriesClosedCessna 150 · Chagrin Fals, OHDec 4, 1971 · N6967S · Substantial damage NTSB ANC72AA030Accident · 1 fatalClosedCessna 180 · Anchorage, AKDec 4, 1971 · N7692A · Destroyed NTSB OAK72FVG29Accident · No injuriesClosedMeyers 200-D · Sacramento, CADec 3, 1971 · N2903T · Substantial damage NTSB NYC72FKM14Accident · No injuriesClosedCessna 421A · Charlotte, NCDec 3, 1971 · N2224Q · Substantial damage NTSB NYC72FHM20Accident · No injuriesClosedMooney M20C · Newburgh, NYDec 3, 1971 · N9262M · Minor damage NTSB MIA72AM051Accident · No injuriesClosedHughes 269C · Hallandale, FLDec 3, 1971 · N9621F · Substantial damage NTSB FTW72FPG56Accident · Serious injuriesClosedCessna 150E · Hot Springs, ARDec 3, 1971 · N4020U · Destroyed NTSB UNK72X0101Accident · Minor injuriesClosedLake LA-4 · Seoul, KSDec 2, 1971 · N7612L · Destroyed NTSB OAK72DJA10Accident · No injuriesClosedBoeing E75N1 · Maui, HIDec 2, 1971 · N4752V · Substantial damage NTSB OAK72DJA09Accident · 1 fatalClosedCessna 150G · Honokaa, HIDec 2, 1971 · N3904J · Destroyed NTSB MKC72AK033Accident · 1 fatalClosedAero Comdr 100 · Albert Lea, MNDec 2, 1971 · N4176X · Destroyed NTSB NYC72FKM13Accident · No injuriesClosedBeech 60 · Charlotte, NCDec 1, 1971 · N7080D · Substantial damage NTSB NYC72FHM19Accident · No injuriesClosedCessna 172 · Wallkill, NYDec 1, 1971 · N8834Z · Substantial damage NTSB NYC72DFA26Accident · No injuriesClosedCessna 172 · Athens, NYDec 1, 1971 · N216NY · Substantial damage NTSB MKC72FER29Accident · Minor injuriesClosedCessna 182M · Belview, MNDec 1, 1971 · N91834 · Substantial damage NTSB MKC72AK032Accident · 2 fatalClosedPiper PA-28 · Rutledge, MODec 1, 1971 · N3393R · 2 aircraft · Substantial damage NTSB LAX72FUA26Accident · No injuriesClosedCessna 150H · Santa Ana, CADec 1, 1971 · N50273 · Substantial damage NTSB NYC72AN072Accident · No injuriesClosedBeech A35 · Clayton, NCNov 30, 1971 · N71C · Substantial damage NTSB MIA72FKT33Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLNov 30, 1971 · N2279P · Substantial damage NTSB MIA72FKG59Accident · No injuriesClosedAeronca 7AC · Hampton, GANov 30, 1971 · N83644 · Substantial damage NTSB LAX72AL040Accident · 2 fatalClosedPiper PA-28 · Caliente, CANov 30, 1971 · N8899W · Destroyed NTSB LAX72AL036Accident · 1 fatalClosedPiper PA-28 · Lebec, CANov 30, 1971 · N5929U · Destroyed NTSB FTW72FPM16Accident · No injuriesClosedLuscombe 8A · Cleveland, OKNov 30, 1971 · N1561K · Substantial damage NTSB CHI72FEE46Accident · No injuriesClosedCessna 150L · Libertyville, ILNov 30, 1971 · N6835G · Substantial damage NTSB NYC72FID17Accident · Minor injuriesClosedBeech H18 · Charlottsville, VANov 29, 1971 · N717Z · Destroyed NTSB NYC72DFA25Accident · No injuriesClosedCessna 140 · Mayfield, NYNov 29, 1971 · N1736U · Substantial damage NTSB MIA72FKT32Accident · Serious injuriesClosedAeronca 7AC · Belle Glade, FLNov 29, 1971 · N82473 · Destroyed NTSB ANC72DAG78Accident · No injuriesClosedChampion 7ECA · Anchorage, AKNov 29, 1971 · N9009L · Substantial damage NTSB NYC72FNC19Accident · Minor injuriesClosedErco 415-CD · Pownal, MENov 28, 1971 · N3777H · Substantial damage NTSB NYC72FLJ18Accident · 1 fatalClosedPiper PA-28 · Angier, NCNov 28, 1971 · N7854N · Substantial damage NTSB NYC72FHM18Accident · No injuriesClosedBeech A23A · New Paltz, NYNov 28, 1971 · N3696Q · Substantial damage NTSB NYC72AN073Accident · 5 fatalClosedPiper PA-32 · Adams, MANov 28, 1971 · N550XX · Destroyed NTSB NYC72AN071Accident · 4 fatalClosedPiper PA-28 · Berlin, NYNov 28, 1971 · N6644J · Destroyed NTSB NYC72AN070Accident · 3 fatalClosedCessna 170B · Fallston, PANov 28, 1971 · N2535D · 2 aircraft · Destroyed NTSB MIA72FKQ26Accident · No injuriesClosedCessna 175 · Duck Hill, MSNov 28, 1971 · N9259B · Substantial damage NTSB MIA72FKG56Accident · No injuriesClosedBellanca 14-19 · Cairo, GANov 28, 1971 · N7655B · Substantial damage NTSB MIA72DLT10Accident · No injuriesClosedCessna 177 · Brownsville, TNNov 28, 1971 · N3248T · Substantial damage NTSB MIA72DLD27Accident · No injuriesClosedCessna 150J · Osteen, FLNov 28, 1971 · N50830 · Destroyed NTSB MIA72DKJ35Accident · No injuriesClosedMooney M20C · Jasper, ALNov 28, 1971 · N9078V · Substantial damage NTSB FTW72DRG39Accident · No injuriesClosedPiper PA-32 · Estacion Coah, MexicoNov 28, 1971 · N3435W · Substantial damage NTSB FTW72DQD17Accident · No injuriesClosedCessna 172L · Hermosillo, MexicoNov 28, 1971 · N7624G · Substantial damage NTSB FTW72AF030Accident · 7 fatalClosedPiper PA-32 · Wells, TXNov 28, 1971 · N8973N · Destroyed NTSB DEN72DTE47Accident · No injuriesClosedCessna 172B · Erie, CONov 28, 1971 · N7909X · Substantial damage NTSB SEA72AS021Accident · 2 fatalClosedMooney M20C · Broadus, MTNov 27, 1971 · N6436U · Destroyed NTSB MIA72DLG17Accident · No injuriesClosedPiper PA-28 · Greer, SCNov 27, 1971 · N98095 · Substantial damage NTSB MIA72DLD28Accident · No injuriesClosedCessna 150 · Orlando, FLNov 27, 1971 · N22750 · Substantial damage NTSB LAX72FUA28Accident · No injuriesClosedCessna 177 · Long Beach, CANov 27, 1971 · N29343 · Substantial damage