NTSB investigations, 1980, ID

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

Cases per year

19642026
NTSB investigations, 1980, ID per year, 1964–2026: 2,504 cases
196470
196549
196662
196764
196865
196947
197054
197157
197241
197348
197463
197556
197663
197748
197843
197956
198044
198140
198247
198341
198441
198546
198650
198725
198829
198922
199030
199130
199237
199326
199439
199535
199633
199731
199841
199946
200034
200124
200248
200352
200440
200538
200630
200740
200834
200937
201037
201133
201240
201332
201430
201527
201622
201731
201828
201933
202024
202139
202227
202329
202435
202522
202619

Latest cases

Query with SQL
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
    AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
  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.

NTSB SEA81FA011Accident · 2 fatalClosedPiper PA-12 · Rexburg, IDDec 12, 1980 · N78709 · DestroyedNTSB SEA81FYA06Accident · Serious injuriesClosedCessna 150F · Caldwell, IDNov 29, 1980 · N3576L · DestroyedNTSB SEA81FA008Accident · 6 fatalClosedBeech A60 · Driggs, IDNov 27, 1980 · N17JC · DestroyedNTSB SEA81FA006Accident · No injuriesClosedPiper PA32RT · Oakley, IDNov 20, 1980 · N21842 · Substantial damageNTSB SEA81FA005Accident · 2 fatalClosedCessna U206F · Bonners Ferry, IDNov 18, 1980 · N333MH · DestroyedNTSB SEA81DYA05Accident · No injuriesClosedCessna 182P · Blackfoot, IDNov 14, 1980 · N58818 · DestroyedNTSB SEA81FYA04Accident · Serious injuriesClosedCessna 182A · Blackfoot, IDNov 1, 1980 · N4952D · DestroyedNTSB SEA81DYA03Accident · No injuriesClosedBellanca 7KCAB · Council, IDOct 28, 1980 · N41811 · Substantial damageNTSB SEA81FA003Accident · 1 fatalClosedCessna 172 · Craigmont, IDOct 26, 1980 · N9109B · DestroyedNTSB SEA81FYP03Accident · Minor injuriesClosedCessna TU206G · Salmon, IDOct 18, 1980 · N345SS · Substantial damageNTSB SEA81DYA02Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDOct 6, 1980 · N15442 · Substantial damageNTSB SEA81IA001Incident · No injuriesClosedPiper PA-28 · Elk City, IDOct 5, 1980 · N21170 · Minor damageNTSB SEA81DYA01Accident · No injuriesClosedCessna 182 · Picabo, IDOct 3, 1980 · N6797M · Substantial damageNTSB SEA80FYA25Accident · Serious injuriesClosedBreezy RLU-1F · Jerome, IDSep 14, 1980 · N1PY · DestroyedNTSB SEA80FYP37Accident · Serious injuriesClosedGrum-Amer AA-1B · Coeur D'Alene, IDSep 4, 1980 · N1367R · Substantial damageNTSB SEA80DYA23Accident · No injuriesClosedBeech C24R · Soda Springs, IDAug 29, 1980 · N6021P · Substantial damageNTSB SEA80DYP35Accident · No injuriesClosedCessna 180 · Coeur D'Alene, IDAug 24, 1980 · N2487C · Substantial damageNTSB SEA80DYP32Accident · No injuriesClosedAeronca 7FC · Grangeville, IDAug 15, 1980 · N7547E · Substantial damageNTSB SEA80FA043Accident · 2 fatalClosedPiper J4E · Mountain Home, IDAug 11, 1980 · N37989 · DestroyedNTSB SEA80FA042Accident · 2 fatalClosedCessna T207 · Salmon, IDAug 11, 1980 · N91115 · DestroyedNTSB SEA80DYA21Accident · No injuriesClosedCessna 150 · Horseshoe Bend, IDAug 9, 1980 · N11617 · Substantial damageNTSB SEA80FA039Accident · 1 fatalClosedAero Comdr 500B · Salmon, IDAug 5, 1980 · N184Z · DestroyedNTSB SEA80DYA24Accident · No injuriesClosedPiper J3C-65 · Blackfoot, IDAug 2, 1980 · N98484 · Substantial damageNTSB SEA80DYP31Accident · No injuriesClosedCessna 182 · Elk City, IDAug 1, 1980 · N8466M · Substantial damageNTSB SEA80DYA20Accident · No injuriesClosedWeatherly 201B · Mountain Home, IDJul 26, 1980 · N1293W · Substantial damageNTSB SEA80FYA19Accident · 1 fatalClosedCallair A-9 · Homedale, IDJul 6, 1980 · N8270H · DestroyedNTSB SEA80DYA18Accident · Minor injuriesClosedCessna 172 · Donnelly, IDJul 6, 1980 · N6388E · Substantial damageNTSB SEA80DYA17Accident · Minor injuriesClosedCessna 182 · Mccall, IDJun 28, 1980 · N71856 · DestroyedNTSB SEA80DYP25Accident · Minor injuriesClosedCessna R172K · Mullen, IDJun 26, 1980 · N758KG · DestroyedNTSB SEA80FA035Accident · 3 fatalClosedPiper PA-28 · Couer D'Alene, IDJun 22, 1980 · N2204F · DestroyedNTSB SEA80DYA16Accident · Minor injuriesClosedCessna T188C · Fairfield, IDJun 19, 1980 · N2903J · Substantial damageNTSB SEA80FYA15Accident · Minor injuriesClosedBell 206A · Boise, IDJun 7, 1980 · N7068J · Substantial damageNTSB SEA80FYA14Accident · No injuriesClosedPiper PA-25 · Burley, IDJun 5, 1980 · N6486Z · Substantial damageNTSB SEA80DYA13Accident · Minor injuriesClosedCessna T188C · American Falls, IDMay 22, 1980 · N91964 · Substantial damageNTSB SEA80FA025Accident · 3 fatalClosedDouglas DC-3C · Athol, IDApr 11, 1980 · N64490 · DestroyedNTSB SEA80FA024Accident · 1 fatalClosedCessna T210L · Pocatello, IDApr 6, 1980 · N260DW · DestroyedNTSB SEA80DYP16Accident · Minor injuriesClosedCessna 172 · Orofino, IDMar 31, 1980 · C-GMEJ · Substantial damageNTSB SEA80FYA11Accident · Serious injuriesClosedCassutt 3M · Boise, IDMar 16, 1980 · N11XR · DestroyedNTSB SEA80DYA10Accident · No injuriesClosedCessna 185D · Challis, IDMar 8, 1980 · N5895T · Substantial damageNTSB SEA80DYA09Accident · No injuriesClosedCessna 152 · Blackfoot, IDMar 1, 1980 · N24755 · Substantial damageNTSB SEA80DYA08Accident · No injuriesClosedCessna 170B · Mccall, IDFeb 12, 1980 · N2713D · Substantial damageNTSB SEA80DYP12Accident · No injuriesClosedPiper PA-38 · Sandpoint, IDJan 31, 1980 · N24563 · Substantial damageNTSB SEA80FYA06Accident · Serious injuriesClosedCessna 210E · Burley, IDJan 23, 1980 · N2352F · Substantial damageNTSB SEA80FA016Accident · 4 fatalClosedCessna 182Q · Murphy, IDJan 17, 1980 · N94839 · Destroyed