Skip to content

NTSB investigations, 1980

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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") = 1980 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\") = 1980
  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") = 1980
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 SEA81FYM12Accident · Serious injuriesClosedCessna 172N · Yacolt, WADec 25, 1980 · N738FS · Substantial damage NTSB NYC81FGM09Accident · No injuriesClosedHiller Acft FH1100 · Somerset, PADec 25, 1980 · N5042F · Substantial damage NTSB LAX81FUG06Accident · No injuriesClosedHiller Acft UH-12B · Rialto, CADec 25, 1980 · N94731 · Substantial damage NTSB FTW81DPA04Accident · No injuriesClosedBellanca 17-31A · Paris, TXDec 25, 1980 · N14717 · Substantial damage NTSB DEN81FA013Accident · 1 fatalClosedPiper PA-24 · Teton Village, WYDec 25, 1980 · N5873P · Destroyed NTSB LAX81FA026Accident · 3 fatalClosedMooney M20K · Battle Mt, NVDec 24, 1980 · N231NX · Destroyed NTSB LAX81DUQ09Accident · No injuriesClosedCessna 150 · San Fernando, AZDec 24, 1980 · N5620E · Substantial damage NTSB DEN81FTM11Accident · No injuriesClosedPiper PA-28R · Ogden, UTDec 24, 1980 · N29021 · Substantial damage NTSB CHI81FEM04Accident · No injuriesClosedCessna 172N · Pellston, MIDec 24, 1980 · N4800J · Substantial damage NTSB CHI81FEE15Accident · No injuriesClosedCessna 170B · Roscoe, ILDec 24, 1980 · N4362B · Substantial damage NTSB CHI81FEE12Accident · No injuriesClosedPiper PA-31 · Chicago, ILDec 24, 1980 · N851CG · Substantial damage NTSB ATL81FA030Accident · 6 fatalClosedCessna 172M · Aberdeen, MSDec 24, 1980 · N64222 · Destroyed NTSB ATL81DID09Accident · Minor injuriesClosedCessna 150 · Woolwine, VADec 24, 1980 · N6559G · Substantial damage NTSB MKC81DCD04Accident · No injuriesClosedCessna 180J · Thompson, IADec 23, 1980 · N7510K · Substantial damage NTSB DEN81FTE14Accident · Minor injuriesClosedCessna 177 · Brighton, CODec 23, 1980 · N2871X · Substantial damage NTSB DEN81FA011Accident · 2 fatalClosedCessna 310K · Boulder, CODec 23, 1980 · N7058L · Substantial damage NTSB CHI81FEK07Accident · 1 fatalClosedSorrel SNS-2 · Columbus Grove, OHDec 23, 1980 · N55959 · Destroyed NTSB MIA81FA029Accident · 2 fatalClosedCessna 172N · Venice, FLDec 22, 1980 · N5093G · Destroyed NTSB MIA81FA028Accident · Serious injuriesClosedDouglas DC3A · Miami, FLDec 22, 1980 · N3XW · Substantial damage NTSB DEN81FTC06Accident · No injuriesClosedCessna 150K · Wright, WYDec 22, 1980 · N6458G · Substantial damage NTSB CHI81FEI08Accident · No injuriesClosedCessna 182 · Ravenna, OHDec 22, 1980 · N4688K · Substantial damage NTSB ATL81FID08Accident · No injuriesClosedCessna 421 · Norfolk, VADec 22, 1980 · N3932C · 2 aircraft · Substantial damage NTSB ATL81DID07Accident · Serious injuriesClosedCessna 150L · Ruckersville, VADec 22, 1980 · N1240Q · Substantial damage NTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WADec 21, 1980 · N114PH · Destroyed NTSB MIA81FA027Accident · 2 fatalClosedErco 415-C · Lakeland, FLDec 21, 1980 · N2106H · 2 aircraft · Substantial damage NTSB LAX81FA025Accident · 1 fatalClosedCessna 172M · Sierraville, CADec 21, 1980 · N1330U · Destroyed NTSB FTW81FRG13Accident · No injuriesClosedCessna 172N · Laredo, TXDec 21, 1980 · N4903F · Substantial damage NTSB FTW81FA019Accident · 1 fatalClosedPiper PA-22 · Oklahoma City, OKDec 21, 1980 · N2524P · Destroyed NTSB FTW81DQD12Accident · No injuriesClosedBellanca 17-30A · El Paso, TXDec 21, 1980 · N4087B · Substantial damage NTSB CHI81FEK08Accident · No injuriesClosedRaven RX-7 · Dublin, OHDec 21, 1980 · N5711K · Substantial damage NTSB NYC81FNE07Accident · No injuriesClosedPiper PA-28 · Westfield, MADec 20, 1980 · N4232F · Substantial damage NTSB MIA81DKT13Accident · No injuriesClosedCessna 206 · Miami, FLDec 20, 1980 · N184 · Destroyed NTSB LAX81FA024Accident · Minor injuriesClosedRobinson R-22 · Malibu, CADec 20, 1980 · CG-POD · Destroyed NTSB LAX81FA023Accident · 1 fatalClosedCitabria 7KCAB · Truckee, CADec 20, 1980 · N9144L · Destroyed NTSB LAX81DXQ06Accident · Minor injuriesClosedPiper PA-24 · Stateline, NVDec 20, 1980 · N8431P · Substantial damage NTSB CHI81FEK11Accident · No injuriesClosedCessna 414A · Paulding, OHDec 20, 1980 · N21CL · Substantial damage NTSB CHI81FEC07Accident · No injuriesClosedPiper PA-32R · Belleville, MIDec 20, 1980 · N5421F · Substantial damage NTSB ANC81DAD02Accident · No injuriesClosedCessna 180 · St. John'S Hbr, AKDec 20, 1980 · N42464 · Substantial damage NTSB LAX81FUJ16Accident · Minor injuriesClosedWaco BSO · Scottsdale, AZDec 19, 1980 · N8543 · Substantial damage NTSB LAX81DUJ17Accident · No injuriesClosedPiper PA-38 · Wickenburg, AZDec 19, 1980 · N2595D · Substantial damage NTSB FTW81FA018Accident · 3 fatalClosedAero Cmdr 1121 · Many, LADec 19, 1980 · N29LB · Destroyed NTSB MKC81FCQ06Accident · No injuriesClosedPiper PA-28 · Wellington, KSDec 18, 1980 · N6847J · Substantial damage NTSB LAX81FVW05Accident · No injuriesClosedCessna 172N · Las Vegas, NVDec 18, 1980 · N5473D · Substantial damage NTSB LAX81FAMS1Accident · 1 fatalClosedCessna 152 · Missing AircraftDec 18, 1980 · N757RB · Destroyed NTSB FTW81FPD07Accident · Serious injuriesClosedCessna 152 · Thurber, TXDec 18, 1980 · N49124 · Destroyed NTSB FTW81DQA11Accident · No injuriesClosedBeech 18S · Aztec, NMDec 18, 1980 · N924W · Substantial damage NTSB DEN81FTE13Accident · Minor injuriesClosedBeech 60 · Denver, CODec 18, 1980 · N301JD · Substantial damage NTSB DEN81DTG05Accident · No injuriesClosedCessna 172 · Oakes, NDDec 18, 1980 · N5692A · Substantial damage NTSB ATL81DA068Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDDec 18, 1980 · N4495X · Substantial damage NTSB ANC81FA010Accident · Serious injuriesClosedCessna 207 · Pilot Station, AKDec 18, 1980 · N7318U · No damage