NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 DEN67D0192Accident · No injuriesClosedPiper PA-28 · Etna, WYDec 23, 1966 · N9301J · Substantial damageNTSB DEN67D0182Accident · No injuriesClosedCessna 310 · Rock Springs, WYDec 20, 1966 · N2257F · Substantial damageNTSB DEN67D0154Accident · No injuriesClosedCessna 182 · Rock River, WYOct 11, 1966 · N3579F · Substantial damageNTSB DEN67A0029Accident · No injuriesClosedCessna 310G · Casper, WYOct 10, 1966 · N8900Z · Substantial damageNTSB DEN67F0110Accident · No injuriesClosedCessna 310G · Casper, WYSep 22, 1966 · N8900Z · Substantial damageNTSB DEN67D0111Accident · No injuriesClosedPiper J-3 · Riverton, WYSep 18, 1966 · N88661 · Substantial damageNTSB DEN67F0133Accident · No injuriesClosedCessna 210 · Mcfadden, WYSep 16, 1966 · N3938Y · Substantial damageNTSB DEN67A0021Accident · Serious injuriesClosedBell 47G3B1 · Old Faithful, WYSep 15, 1966 · N73982 · Substantial damageNTSB DEN67F0112Accident · Minor injuriesClosedCessna 172 · Laramie, WYSep 11, 1966 · N7382T · Substantial damageNTSB DEN67F0097Accident · Serious injuriesClosedCessna 150 · Uffalo, WYSep 11, 1966 · N3919U · DestroyedNTSB DEN67F0122Accident · No injuriesClosedPiper PA-24 · New Castle, WYSep 6, 1966 · N5579P · Substantial damageNTSB DEN67F0095Accident · Minor injuriesClosedMooney M20 · Rawlins, WYSep 5, 1966 · N1064B · Substantial damageNTSB DEN67F0094Accident · Serious injuriesClosedSchweizer TG-3A · Casper, WYAug 28, 1966 · N9305H · Substantial damageNTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYAug 28, 1966 · N3642C · Substantial damageNTSB MKC67F0181Accident · No injuriesClosedPiper PA-28 · Worland, WYAug 17, 1966 · N8849J · Substantial damageNTSB DEN67D0082Accident · No injuriesClosedCessna 210 · Evanston, WYAug 15, 1966 · N9544T · Substantial damageNTSB DEN67F0083Accident · No injuriesClosedPiper PA-30 · Rock Springs, WYAug 14, 1966 · N8025Y · Substantial damageNTSB DEN67D0054Accident · No injuriesClosedStinson L-13 · Sheridan, WYAug 5, 1966 · N6500C · Substantial damageNTSB DEN67D0055Accident · No injuriesClosedMooney M20E · Dubois, WYJul 31, 1966 · N2710W · Substantial damageNTSB DEN67D0078Accident · No injuriesClosedBeech A23 · Evanston, WYJul 29, 1966 · N3517R · Substantial damageNTSB DEN67D0070Accident · No injuriesClosedBeech 35-33 · Rock Springs, WYJul 29, 1966 · N9008S · Substantial damageNTSB DEN67F0068Accident · Serious injuriesClosedAeronca 65-TC · Greybull, WYJul 23, 1966 · N27392 · Substantial damageNTSB DEN67A0007Accident · Serious injuriesClosedBell 47G3B1 · Riverton, WYJul 20, 1966 · N1332X · Substantial damageNTSB DEN67F0067Accident · Minor injuriesClosedCessna 150 · Sundance, WYJul 18, 1966 · N6061T · Substantial damageNTSB DEN67D0041Accident · No injuriesClosedPiper PA-18 · Roset, WYJul 13, 1966 · N4720A · Substantial damageNTSB DEN67D0056Accident · Minor injuriesClosedPiper PA-28 · Pine Bluffs, WYJul 7, 1966 · N8814J · 2 aircraft · Substantial damageNTSB DEN67A0002Accident · Minor injuriesClosedHiller UH12E · Greybull, WYJul 7, 1966 · N9754C · Substantial damageNTSB DEN67D0030Accident · No injuriesClosedNavy N3N-3 · Elk Mountain, WYJun 26, 1966 · N45056 · Substantial damageNTSB DEN66A0089Accident · No injuriesClosedBell 47D1 · Hyattville, WYJun 19, 1966 · N74121 · Substantial damageNTSB DEN67A0015Accident · 3 fatalClosedPiper PA-24 · Powder River, WYJun 7, 1966 · N7441P · DestroyedNTSB DEN67D0018Accident · No injuriesClosedBeech S35 · Gillette, WYMay 26, 1966 · N385CA · Substantial damageNTSB DEN66A0084Accident · No injuriesClosedHiller UH-12E · Lonetree, WYMay 21, 1966 · N9754C · Substantial damageNTSB DEN67D0019Accident · No injuriesClosedCessna 175 · Du Bois, WYMay 14, 1966 · N9308B · Substantial damageNTSB DEN66D0307Accident · No injuriesClosedCessna 182 · Big Piney, WYApr 30, 1966 · N5047D · Substantial damageNTSB DEN66D0304Accident · No injuriesClosedInterstate S-1A · Fontenelle, WYApr 26, 1966 · N37307 · Substantial damageNTSB DEN67F0016Accident · Serious injuriesClosedCessna 175 · Alpine, WYApr 23, 1966 · N6584E · Substantial damageNTSB DEN66F0305Accident · Minor injuriesClosedLuscombe 8C · Evanston, WYApr 23, 1966 · N39094 · Substantial damageNTSB DEN67D0017Accident · No injuriesClosedPiper PA-18 · Kaycee, WYApr 19, 1966 · N3931Z · Substantial damageNTSB DEN66F0306Accident · Minor injuriesClosedBeech F35 · Evanston, WYApr 10, 1966 · N5041B · Substantial damageNTSB DEN66A0073Accident · No injuriesClosedHughes 269A · Arvada, WYApr 5, 1966 · N8891F · Substantial damageNTSB DEN66I0066Incident · No injuriesClosedBoeing B-727 · Cheyenne, WYMar 19, 1966 · N7038U · Minor damageNTSB DEN66D0281Accident · No injuriesClosedTaylorcraft BC12-D · Seely, WYMar 6, 1966 · N95051 · Substantial damageNTSB DEN66A0062Accident · No injuriesClosedBoeing B-17G · Cody, WYMar 6, 1966 · N7228C · Substantial damageNTSB DEN66D0274Accident · No injuriesClosedPiper PA-18 · Seely, WYMar 5, 1966 · N7537K · Substantial damageNTSB DEN66D0237Accident · No injuriesClosedChampion 7GCB · Evanston, WYFeb 20, 1966 · N9953Y · Substantial damageNTSB DEN66D0227Accident · No injuriesClosedPiper PA-28 · Gillette, WYFeb 10, 1966 · N7107W · Substantial damageNTSB DEN66D0282Accident · No injuriesClosedPiper J3C · Big Piney, WYFeb 7, 1966 · N98859 · Substantial damageNTSB DEN66F0216Accident · No injuriesClosedBeechcraft 23 · Riverton, WYJan 29, 1966 · N2305L · Substantial damageNTSB DEN66F0213Accident · No injuriesClosedCessna 180 · Rock Springs, WYJan 25, 1966 · N6570A · Substantial damageNTSB DEN66D0205Accident · No injuriesClosedCessna 320 · Green River, WYJan 13, 1966 · N5707X · Substantial damage