Skip to content

NTSB investigations, 1980

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") = 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 FTW81DQD10Accident · No injuriesClosedBeech C35 · Carlsbad, NMDec 4, 1980 · N2033D · Substantial damage NTSB CHI81FEE10Accident · Minor injuriesClosedBeech C24R · West Chicago, ILDec 4, 1980 · N37329 · Substantial damage NTSB ATL81FKG04Accident · Minor injuriesClosedAeronca 7CCM · Douglasville, GADec 4, 1980 · N2558B · Substantial damage NTSB ATL81DID03Accident · Minor injuriesClosedTaylorcraft BC12-D · Scottsville, VADec 4, 1980 · N22N · Substantial damage NTSB SEA81FA013Accident · 1 fatalClosedCessna 210 · Royal City, WADec 3, 1980 · N6508X · Destroyed NTSB NYC81IA015Incident · Minor injuriesClosedNord 262A12 · Groton, CTDec 3, 1980 · N26217 · Minor damage NTSB MIA81DLD16Accident · No injuriesClosedBeech C23 · St.Petersburg, FLDec 3, 1980 · N6015F · Substantial damage NTSB LAX81FUM06Accident · No injuriesClosedCessna 150 · Leucadia, CADec 3, 1980 · N6505G · Substantial damage NTSB FTW81FRA09Accident · Serious injuriesClosedBede BD-5 · Tomball, TXDec 3, 1980 · N52BM · Destroyed NTSB ATL81IA023Incident · No injuriesClosedDouglas DC-8 · Atlanta, GADec 3, 1980 · N864FT · Minor damage NTSB ATL80DLT01Accident · No injuriesClosedVolksplane 2 · Ripley, MSDec 3, 1980 · N37922 · Substantial damage NTSB NYC81DNA04Accident · No injuriesClosedBell 206B · Warwick, RIDec 2, 1980 · N2775F · Substantial damage NTSB MIA81DLD15Accident · No injuriesClosedPiper PA-23 · Cassia, FLDec 2, 1980 · N5172Y · Substantial damage NTSB MIA81DLD14Accident · No injuriesClosedCessna 182Q · Winter Haven, FLDec 2, 1980 · N735EZ · Substantial damage NTSB LAX81DUJ20Accident · Minor injuriesClosedCessna 172N · Tucson, AZDec 2, 1980 · N738YA · Substantial damage NTSB FTW81DA014Accident · 1 fatalClosedBell 206B3 · Cameron, LADec 2, 1980 · N5003Q · Destroyed NTSB ATL81FA024Accident · 2 fatalClosedPiper PA-30 · Sunbright, TNDec 2, 1980 · N99EJ · Destroyed NTSB ATL81FA022Accident · 3 fatalClosedSwearigen SA26AT · Albany, KYDec 2, 1980 · N177MF · Destroyed NTSB ATL81FA021Accident · 4 fatalClosedCessna T210N · Tazewell, TNDec 2, 1980 · N4846C · Destroyed NTSB NYC81FHJ02Accident · No injuriesClosedBeech C23 · Farmingdale, NYDec 1, 1980 · N9745L · Substantial damage NTSB MIA81FA021Accident · 3 fatalClosedCessna 182 · Oak Hill, FLDec 1, 1980 · N5178D · Destroyed NTSB MIA81DLD13Accident · No injuriesClosedCessna 152 · Titusville, FLDec 1, 1980 · N48122 · Substantial damage NTSB MIA81DLA05Accident · No injuriesClosedCessna 152 · Gainsville, FLDec 1, 1980 · N67843 · Substantial damage NTSB LAX81DVG07Accident · No injuriesClosedBellanca 7ECA · Red Bluff, CADec 1, 1980 · N5067C · Substantial damage NTSB FTW81FRG10Accident · No injuriesClosedPiper PA-23 · Corpus Christi, TXDec 1, 1980 · N6536A · Substantial damage NTSB FTW81DRD09Accident · No injuriesClosedGrum-Amer AA-1A · Clinton, LADec 1, 1980 · N9314L · Substantial damage NTSB ATL81IA020Incident · No injuriesClosedBoeing 737 · Richmond, VADec 1, 1980 · N740N · Minor damage NTSB SEA81DYK01Accident · No injuriesClosedPiper PA-32R · Adel, ORNov 30, 1980 · N1260H · Substantial damage NTSB LAX81FUQ04Accident · 1 fatalClosedBakeng Double · Rosamond, CANov 30, 1980 · N71DD · Destroyed NTSB LAX81FUJ12Accident · Minor injuriesClosedBell 47D-1 · Horseshoe Lk, AZNov 30, 1980 · N8272E · Substantial damage NTSB LAX81FA020Accident · 2 fatalClosedCessna 320C · Marysville, WANov 30, 1980 · N9RT · Destroyed NTSB LAX81DVA17Accident · No injuriesClosedErco 415-C · Strathmore, CANov 30, 1980 · N99785 · Substantial damage NTSB FTW81FRG08Accident · Serious injuriesClosedMitsubishi MU-2J · Port Aransas, TXNov 30, 1980 · N44MR · Destroyed NTSB FTW81FPM03Accident · No injuriesClosedCessna R172K · Lenapah, OKNov 30, 1980 · N758BN · Substantial damage NTSB FTW81DPJ07Accident · No injuriesClosedCessna 150 · Beaver, OKNov 30, 1980 · N7723E · Substantial damage NTSB DEN81FTE07Accident · Minor injuriesClosedSchweizer SG5-2 · Boulder, CONov 30, 1980 · N5826V · Substantial damage NTSB CHI81FEG02Accident · No injuriesClosedCessna 172 · Springfield, OHNov 30, 1980 · N6049R · Substantial damage NTSB CHI81FA008Accident · 1 fatalClosedPiper PA-24 · Annawan, ILNov 30, 1980 · N8077P · Destroyed NTSB CHI81DEV06Accident · No injuriesClosedCessna 172 · Urbana, ILNov 30, 1980 · N6665G · Substantial damage NTSB ATL81FLQ06Accident · Minor injuriesClosedCessna 182 · Hazard, KYNov 30, 1980 · N2879R · Substantial damage NTSB ATL81FLG07Accident · No injuriesClosedCessna 150H · Greer, SCNov 30, 1980 · N7075S · Substantial damage NTSB ATL81FIJ01Accident · Serious injuriesClosedCessna 180 · Morgantown, WVNov 30, 1980 · N96L · Substantial damage NTSB ATL81FA019Accident · 5 fatalClosedPiper PA-32 · Hilton Head, SCNov 30, 1980 · N3242W · 2 aircraft · Destroyed NTSB SEA81FYA06Accident · Serious injuriesClosedCessna 150F · Caldwell, IDNov 29, 1980 · N3576L · Destroyed NTSB NYC81FNA06Accident · No injuriesClosedSonerai II · East Greenwich, RINov 29, 1980 · N24JW · Substantial damage NTSB MKC81FA009Accident · 1 fatalClosedCessna 305A · Denison, IANov 29, 1980 · N5262G · Destroyed NTSB MKC81DCD03Accident · No injuriesClosedCessna 180 · Knoxville, IANov 29, 1980 · N9712B · Substantial damage NTSB MIA81FLA04Accident · No injuriesClosedRobertson T210M · Gainesville, FLNov 29, 1980 · N1877M · Substantial damage NTSB LAX81FUA02Accident · Minor injuriesClosedGrumman AA-5B · Torrance, CANov 29, 1980 · N74494 · Destroyed NTSB FTW81FPG07Accident · 1 fatalClosedBensen B8M · Sherrill, ARNov 29, 1980 · N3790K · Destroyed