NTSB investigations, 1980, WY

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.

Cases per year

19642026
NTSB investigations, 1980, WY per year, 1964–2026: 1,568 cases
196447
196552
196650
196755
196847
196953
197042
197134
197238
197345
197437
197542
197638
197748
197845
197934
198043
198140
198247
198344
198432
198520
198631
198716
198822
198914
199018
199121
199218
199324
199424
199515
199616
199712
199821
199921
200020
200117
200216
200319
200416
200517
200613
200713
200818
20094
20109
201126
201218
201315
201411
201514
201610
201711
201813
201911
20209
20215
202213
20236
202416
20259
202613

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\" = 'WY' 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 DEN81FTC07Accident · No injuriesClosedCessna 182 · Worland, WYDec 31, 1980 · N4838D · Substantial damageNTSB DEN81FA013Accident · 1 fatalClosedPiper PA-24 · Teton Village, WYDec 25, 1980 · N5873P · DestroyedNTSB DEN81FTC06Accident · No injuriesClosedCessna 150K · Wright, WYDec 22, 1980 · N6458G · Substantial damageNTSB DEN81FTC05Accident · No injuriesClosedCessna 172 · Rock Springs, WYNov 22, 1980 · N51873 · Substantial damageNTSB DEN81FTC04Accident · Minor injuriesClosedCessna 150M · Casper, WYOct 25, 1980 · N345JF · DestroyedNTSB DEN81FTC03Accident · No injuriesClosedPiper PA-20 · Cody, WYOct 24, 1980 · N8536C · Substantial damageNTSB DEN81FTC02Accident · No injuriesClosedDehavilland DH82A · Evanston, WYOct 21, 1980 · N3744M · Substantial damageNTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYOct 17, 1980 · N6395U · Substantial damageNTSB DEN80FAMS1Accident · 2 fatalClosedMooney M20F · Buffalo, WYOct 17, 1980 · N9182V · DestroyedNTSB DEN81FA006Accident · 1 fatalClosedCessna 182K · Rock Springs, WYOct 15, 1980 · N2463Q · Substantial damageNTSB MKC81FA003Accident · 2 fatalClosedCessna 182H · Newcastle, WYOct 6, 1980 · N3460S · DestroyedNTSB DEN81FTC01Accident · No injuriesClosedCessna 170 · Wright, WYOct 4, 1980 · N3830V · Substantial damageNTSB DEN80DTC31Accident · Minor injuriesClosedCessna 182-TR · Sundance, WYSep 17, 1980 · N756WV · Substantial damageNTSB MKC80FA054Accident · 4 fatalClosedBeech V35 · Jackson, WYSep 8, 1980 · N21MD · DestroyedNTSB DEN80FTC30Accident · Serious injuriesClosedCessna 210K · Jackson, WYSep 8, 1980 · N824M · DestroyedNTSB DEN80FTC29Accident · Serious injuriesClosedCessna 120 · Afton, WYAug 29, 1980 · N3032N · Substantial damageNTSB DEN80FA054Accident · 1 fatalClosedPiper PA-24R · Jackson, WYAug 17, 1980 · N4560J · Substantial damageNTSB DEN80FTC27Accident · No injuriesClosedCessna 310Q · Evanston, WYAug 16, 1980 · N69834 · Substantial damageNTSB DEN80DTC28Accident · No injuriesClosedHiller UH-12E · Greybull, WYAug 8, 1980 · N5389V · Substantial damageNTSB DEN80FTC25Accident · No injuriesClosedPiper PA-28R · Encampment, WYAug 5, 1980 · N7494J · Substantial damageNTSB DEN80FTC20Accident · No injuriesClosedHughes 269C · Edgerton, WYAug 3, 1980 · N7412F · Substantial damageNTSB DEN80FA052Accident · 2 fatalClosedAerospatial SA315 · Meeteetse, WYAug 1, 1980 · N47294 · DestroyedNTSB DEN80DTC26Accident · No injuriesClosedPiper PA-18 · Lysite, WYAug 1, 1980 · N82669 · Substantial damageNTSB DEN80FTC22Accident · Serious injuriesClosedAerospatle 315B · Afton, WYJul 17, 1980 · N3602C · Substantial damageNTSB DEN80FTC23Accident · No injuriesClosedPiper PA-25 · Aladdin, WYJul 15, 1980 · N4771Y · Substantial damageNTSB DEN80DTC24Accident · No injuriesClosedAerospatle SA315B · Pinedale, WYJul 12, 1980 · N223RM · Substantial damageNTSB DEN80FTC21Accident · No injuriesClosedPiper PA-16 · Rock Springs, WYJul 5, 1980 · N5331H · Substantial damageNTSB DEN80FTC19Accident · Minor injuriesClosedCessna 152 · Sheridan, WYJun 22, 1980 · N67417 · Substantial damageNTSB DEN80FTC18Accident · Minor injuriesClosedCessna 210L · Mountain View, WYJun 13, 1980 · N2280S · Substantial damageNTSB DEN80FA038Accident · No injuriesClosedAlouette SA315B · Jackson, WYJun 11, 1980 · N10067 · Substantial damageNTSB DEN80FTC17Accident · No injuriesClosedPiper PA-18 · Cheyenne, WYMay 23, 1980 · N6083A · Substantial damageNTSB DEN80FA036Accident · 1 fatalClosedCessna TR182 · Wheatland, WYMay 23, 1980 · N738GG · DestroyedNTSB DEN80FTC16Accident · 2 fatalClosedCessna R172K · Cheyenne, WYMay 21, 1980 · N758LA · DestroyedNTSB DEN80FA033Accident · No injuriesClosedBeech 58 · Casper, WYMay 16, 1980 · N25734 · Substantial damageNTSB DEN80FTC14Accident · No injuriesClosedPiper PA-18 · Hulett, WYMay 6, 1980 · N8254C · Substantial damageNTSB DEN80FTC13Accident · Minor injuriesClosedCessna TU206G · Farson, WYApr 24, 1980 · N756PT · Substantial damageNTSB DEN80FTC12Accident · Minor injuriesClosedHughes 369D · Chugwater, WYApr 9, 1980 · N49667 · DestroyedNTSB DEN80DTC10Accident · No injuriesClosedSwearingen SA26T · Jackson, WYFeb 29, 1980 · N30SG · Substantial damageNTSB DEN80DTC08Accident · No injuriesClosedLuscombe 8E · Cheyenne, WYFeb 27, 1980 · N28490 · Substantial damageNTSB DEN80FTC09Accident · No injuriesClosedCessna 172N · Rock Springs, WYFeb 25, 1980 · N5216E · Substantial damageNTSB DEN80FTC07Accident · No injuriesClosedCessna 152 · Lander, WYFeb 16, 1980 · N24272 · Substantial damageNTSB DEN80DTC06Accident · No injuriesClosedCessna 172N · Kemmerer, WYFeb 12, 1980 · N739KU · Substantial damageNTSB DEN80FTC05Accident · No injuriesClosedHiller Acft UH-12D · Mckennon, WYFeb 8, 1980 · N31331 · Substantial damage