NTSB investigations, 1980, UT

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

19632026
NTSB investigations, 1980, UT per year, 1963–2026: 2,267 cases
19631
196454
196554
196665
196752
196844
196945
197039
197127
197239
197344
197433
197538
197657
197742
197842
197941
198052
198158
198241
198345
198453
198541
198632
198737
198828
198940
199032
199131
199226
199336
199431
199524
199627
199736
199835
199929
200049
200133
200239
200340
200434
200525
200632
200744
200842
200937
201035
201131
201226
201320
201425
201525
201618
201727
201826
201929
202021
202123
202228
202335
202427
202522
202623

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\" = 'UT' 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 DEN81FTM11Accident · No injuriesClosedPiper PA-28R · Ogden, UTDec 24, 1980 · N29021 · Substantial damageNTSB DEN81FA012Accident · 1 fatalClosedBeech 76 · Morgan, UTNov 23, 1980 · N6048Y · DestroyedNTSB DEN81FTM04Accident · Serious injuriesClosedPiper PA-28 · Woodland, UTNov 21, 1980 · N8021F · Substantial damageNTSB DEN81FTM02Accident · Minor injuriesClosedEnstrom 280C · Salt Lake City, UTNov 16, 1980 · N51780 · Substantial damageNTSB DEN81FA009Accident · No injuriesClosedHiller Acft 12E · Blanding, UTNov 5, 1980 · N57972 · Substantial damageNTSB DEN81DTM03Accident · No injuriesClosedMitsubishi MU2-35 · Provo, UTNov 2, 1980 · N18WP · Substantial damageNTSB DEN8UDA004Accident · No injuriesClosedCessna TU206G · Moab, UTOct 8, 1980 · N756HD · Substantial damageNTSB DEN81FA003Accident · Serious injuriesClosedAerosatle SA315B · Panguitch, UTOct 5, 1980 · N47312 · Substantial damageNTSB DEN80FTM01Accident · No injuriesClosedCessna 172N · West Jordan, UTOct 2, 1980 · N734UD · Substantial damageNTSB DEN80FTM41Accident · Serious injuriesClosedCessna 172 · Heber, UTSep 25, 1980 · N8076E · Substantial damageNTSB DEN80FTM40Accident · No injuriesClosedPiper PA-28 · Kamas, UTSep 24, 1980 · N54445 · Substantial damageNTSB DEN80FTM39Accident · No injuriesClosedWeatherly 201 · Delta, UTSep 5, 1980 · N9198W · No damageNTSB DEN80FA060Accident · 1 fatalClosedBell UH-1B · Provo, UTSep 2, 1980 · N99478 · Substantial damageNTSB DEN80FTM38Accident · Minor injuriesClosedCessna 210 · Parowan, UTSep 1, 1980 · N1683X · Substantial damageNTSB DEN80FTM37Accident · Serious injuriesClosedGrum-Amer AA-5B · Heber City, UTAug 17, 1980 · N28823 · Substantial damageNTSB DEN80DTM36Accident · Serious injuriesClosedHiller Acft UH-12D · Coalville, UTAug 8, 1980 · N31332 · Substantial damageNTSB DEN80FTM35Accident · No injuriesClosedBeech A-36 · America Fork, UTAug 2, 1980 · N1097W · Substantial damageNTSB DEN80FTM34Accident · Serious injuriesClosedPiper PA-28 · Callao, UTAug 1, 1980 · N8800N · Substantial damageNTSB DEN80FTM33Accident · Serious injuriesClosedCourt Sport A · Richfield, UTJul 29, 1980 · N747R · DestroyedNTSB DEN80FTM32Accident · No injuriesClosedPiper PA-28 · Strawberry Vly, UTJul 29, 1980 · N1819T · Substantial damageNTSB DEN80FTM31Accident · No injuriesClosedCessna 182 · Hanksville, UTJul 19, 1980 · N8859X · Substantial damageNTSB DEN80FTM30Accident · Minor injuriesClosedCessna TU206F · Bountiful, UTJul 7, 1980 · N25CF · Substantial damageNTSB DEN80FTM29Accident · No injuriesClosedPiper PA-38 · Provo, UTJul 3, 1980 · N2453A · Substantial damageNTSB DEN80FTM28Accident · No injuriesClosedCessna T337D · Ouray, UTJul 3, 1980 · N85876 · Substantial damageNTSB DEN80FTM27Accident · No injuriesClosedCessna 190 · St George, UTJun 28, 1980 · N4318N · Substantial damageNTSB DEN80FTM26Accident · 1 fatalClosedSkybolt Steen · Brigham City, UTJun 21, 1980 · N6260 · Substantial damageNTSB DEN80FTM25Accident · No injuriesClosedPiper PA-28 · Cedar City, UTJun 20, 1980 · N47445 · Substantial damageNTSB DEN80DTM24Accident · No injuriesClosedCessna 188 · Vernal, UTJun 18, 1980 · N9055R · Substantial damageNTSB DEN80DTM23Accident · Minor injuriesClosedCessna 206T · Moab, UTJun 14, 1980 · N4590U · Substantial damageNTSB DEN80FA037Accident · 1 fatalClosedGlobe GC-1B · Spanish Fork, UTJun 7, 1980 · N211M · DestroyedNTSB DEN80DTM22Accident · No injuriesClosedPiper PA-18 · Santaquin, UTMay 31, 1980 · N6798A · Substantial damageNTSB DEN80FTM21Accident · No injuriesClosedPiper PA-28 · Nephi, UTMay 26, 1980 · N2138J · Substantial damageNTSB DEN80FTM19Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTMay 24, 1980 · N1582J · Substantial damageNTSB DEN80FA034Accident · 1 fatalClosedHughes 500 · Vernal, UTMay 18, 1980 · N58245 · Substantial damageNTSB DEN80DTM20Accident · No injuriesClosedCessna 172N · Tooele, UTMay 14, 1980 · N739ZB · Substantial damageNTSB DEN80DTM18Accident · Minor injuriesClosedCessna 182Q · Richfield, UTMay 12, 1980 · N735DE · Substantial damageNTSB DEN80FA032Accident · No injuriesClosedBell 206B · Brighton, UTMay 9, 1980 · N1074Z · Substantial damageNTSB DEN80FTM17Accident · Minor injuriesClosedGrum-Amer AA-1B · Bullfrog Basin, UTMay 4, 1980 · N9961L · Substantial damageNTSB DEN80FTM16Accident · No injuriesClosedBell 47G3B1 · Vernal, UTApr 30, 1980 · N687PH · Substantial damageNTSB DEN80FTM15Accident · No injuriesClosedPiper PA-28 · Wendover, UTApr 26, 1980 · N4605R · Substantial damageNTSB DEN80DTM14Accident · No injuriesClosedCessna 182 · Provo, UTApr 19, 1980 · N94527 · Substantial damageNTSB DEN80FTM13Accident · No injuriesClosedCessna 180 · Roosevelt, UTApr 18, 1980 · N5063E · Substantial damageNTSB DEN80DTM12Accident · No injuriesClosedCessna 182 · Cedar City, UTApr 11, 1980 · N3916D · Substantial damageNTSB DEN80DTM11Accident · No injuriesClosedBeech A36 · Huntington, UTMar 28, 1980 · N3675T · Substantial damageNTSB DEN80AA026Accident · Minor injuriesClosedPiper PA-31 · Moab, UTFeb 29, 1980 · N3540T · Substantial damageNTSB DEN80DTM10Accident · No injuriesClosedBell 47G3B1 · Heber, UTFeb 20, 1980 · N64711 · Substantial damageNTSB DEN80FA024Accident · 1 fatalClosedMooney M20C · Scipio, UTFeb 6, 1980 · N6489U · DestroyedNTSB DEN80DTM09Accident · No injuriesClosedCessna 172N · Heber, UTFeb 4, 1980 · N6190D · Substantial damageNTSB DEN80FA021Accident · 2 fatalClosedMooney M20F · Grantsville, UTJan 27, 1980 · N6439Q · DestroyedNTSB DEN80FA020Accident · 3 fatalClosedBeech H35 · Copperton, UTJan 24, 1980 · N7935D · Destroyed