NTSB investigations, 1981, WY

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, 1981, 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\") = 1981
    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 DEN82FA009Accident · No injuriesClosedAerospatial SA316B · Cokeville, WYNov 20, 1981 · N4261E · Substantial damageNTSB DEN82FA006Accident · 2 fatalClosedMitsubishi MU-2B · Saratoga, WYNov 5, 1981 · N53AD · DestroyedNTSB DEN82FTC01Accident · No injuriesClosedPiper PA-28 · Powell, WYOct 23, 1981 · N8972C · Substantial damageNTSB DEN81FTC28Accident · No injuriesClosedPiper PA-18 · 25m S Gillette, WYSep 28, 1981 · N57555 · Substantial damageNTSB DEN81FTC25Accident · Minor injuriesClosedBeech H18S · Gillette, WYSep 27, 1981 · N919X · Substantial damageNTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYSep 19, 1981 · N4941P · Substantial damageNTSB DEN81FTC26Accident · Minor injuriesClosedHughes 369D · Cokeville, WYSep 16, 1981 · N1106G · Substantial damageNTSB DEN81AA064Accident · 5 fatalClosedMitsubishi MU-2B · Riverton, WYSep 6, 1981 · N3ED · DestroyedNTSB DEN81FA062Accident · Minor injuriesClosedHughes 369D · Afton, WYAug 27, 1981 · N58256 · Substantial damageNTSB DEN81FTC24Accident · Minor injuriesClosedCessna 177RG · Cheyenne, WYAug 23, 1981 · N1980Q · Substantial damageNTSB DEN81FA061Accident · 3 fatalClosedPiper PA-28 · 40 Mi S Casper, WYAug 23, 1981 · N8415N · DestroyedNTSB DEN81FA060Accident · 1 fatalClosedCessna T207 · Casper, WYAug 21, 1981 · N17464 · DestroyedNTSB DEN81FA059Accident · Serious injuriesClosedBell 206-B3 · Alpine, WYAug 20, 1981 · N39088 · DestroyedNTSB DEN81DTC23Accident · No injuriesClosedPiper PA-12 · Cody, WYAug 19, 1981 · N3622M · Substantial damageNTSB DEN81FA057Accident · 1 fatalClosedAerospatial 316B · Alpine, WYAug 12, 1981 · N607RA · Substantial damageNTSB DEN81DTC22Accident · No injuriesClosedPiper PA-28 · Ft Bridger, WYAug 2, 1981 · N7283W · Substantial damageNTSB DEN81FTC21Accident · Serious injuriesClosedPiper PA-28 · Rawlins, WYJul 24, 1981 · N4617J · Substantial damageNTSB DEN81FTC20Accident · Minor injuriesClosedPiper PA-28 · Sundance, WYJul 11, 1981 · N33533 · Substantial damageNTSB DEN81FA051Accident · 2 fatalClosedPiper PA-16 · Ten Sleep, WYJul 11, 1981 · N6852K · DestroyedNTSB DEN81FTC19Accident · No injuriesClosedCessna 180 · Thayne, WYJun 26, 1981 · N966K · Substantial damageNTSB DEN81FTC17Accident · Minor injuriesClosedCessna TR182 · Cheyenne, WYJun 7, 1981 · N756VW · Substantial damageNTSB DEN81FTC18Accident · Minor injuriesClosedAerospatle SA315B · Meeteetse, WYJun 6, 1981 · N223RM · Substantial damageNTSB DEN81FTC16Accident · No injuriesClosedN American P-51D · Casper, WYJun 6, 1981 · N5471V · Substantial damageNTSB DEN81FA035Accident · 1 fatalClosedBell 206B · Evanston, WYMay 18, 1981 · N39101 · Substantial damageNTSB DEN81FTC15Accident · No injuriesClosedCessna 152 · Gillette, WYMay 8, 1981 · N6560H · Substantial damageNTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYMay 7, 1981 · N6842R · DestroyedNTSB DEN81FA031Accident · 1 fatalClosedCessna 152 · Cowley, WYMay 4, 1981 · N757YH · DestroyedNTSB DEN81FA030Accident · 1 fatalClosedPiper PA-32 · Gillette, WYMay 4, 1981 · N8999N · Substantial damageNTSB DEN81FTC14Accident · No injuriesClosedDehavilland DHC-1 · Rawlins, WYApr 30, 1981 · N48262 · Substantial damageNTSB DEN81FTC13Accident · No injuriesClosedCessna 172XP · Moorcroft, WYApr 26, 1981 · N1254V · Substantial damageNTSB DEN81FTC12Accident · No injuriesClosedPiper PA-18 · Ft Bridger, WYApr 9, 1981 · N6881B · Substantial damageNTSB DEN81FA026Accident · 2 fatalClosedPiper PA-28 · Rock Springs, WYMar 29, 1981 · N44900 · DestroyedNTSB DEN81FA022Accident · No injuriesClosedBell 206A · Evanston, WYMar 16, 1981 · N7881S · Substantial damageNTSB DEN81FTC11Accident · Minor injuriesClosedCessna 140 · Wapiti, WYMar 14, 1981 · N72917 · Substantial damageNTSB DEN81FA020Accident · 1 fatalClosedCessna 206G · Cokeville, WYMar 7, 1981 · N735RM · DestroyedNTSB DEN81FTC09Accident · No injuriesClosedCessna 182 · Moran Juction, WYFeb 17, 1981 · N5871B · Substantial damageNTSB DEN81DTC10Accident · No injuriesClosedCessna 170B · Buffalo, WYFeb 14, 1981 · N1896C · Substantial damageNTSB DEN81FTC08Accident · No injuriesClosedBell 206B · Kenmerer, WYFeb 10, 1981 · N6238N · Substantial damageNTSB DEN81FA015Accident · 1 fatalClosedCessna 310C · Encampment, WYJan 4, 1981 · N6726T · DestroyedNTSB DEN81FA014Accident · 6 fatalClosedCessna T310R · Moose, WYJan 4, 1981 · N4880A · Destroyed