NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 DEN66D0196Accident · No injuriesClosedPiper PA-24 · Riverton, WYDec 24, 1965 · N6648P · Substantial damageNTSB DEN66D0191Accident · No injuriesClosedCessna 182 · Frannie, WYNov 12, 1965 · N3494S · Substantial damageNTSB FTW66D0378Accident · No injuriesClosedGrumman G-164 · Sheridan, WYNov 7, 1965 · N471Y · Substantial damageNTSB DEN66D0150Accident · No injuriesClosedPiper PA-20 · Casper, WYOct 28, 1965 · N7663K · Substantial damageNTSB DEN66F0157Accident · No injuriesClosedPiper PA-23 · Cheyenne, WYOct 25, 1965 · N5448Y · Substantial damageNTSB DEN66F0141Accident · No injuriesClosedErcoupe 415C · Cheyenne, WYOct 15, 1965 · N2192H · Substantial damageNTSB DEN66F0125Accident · Minor injuriesClosedCessna 182C · Laramie, WYOct 15, 1965 · N8554T · Substantial damageNTSB DEN66D0126Accident · Minor injuriesClosedBellanca 14-19 · Douglas, WYOct 10, 1965 · N7688B · Substantial damageNTSB DEN66D0145Accident · Serious injuriesClosedBeechcraft A45 · Pinedale, WYOct 8, 1965 · N10140 · Substantial damageNTSB DEN66F0131Accident · No injuriesClosedCessna 172 · Albin, WYOct 7, 1965 · N8058B · Substantial damageNTSB DEN66A0024Accident · Minor injuriesClosedBell 47G3B1 · Jackson, WYSep 29, 1965 · N1136W · Substantial damageNTSB DEN66A0019Accident · No injuriesClosedPiper PA-22 · Cheyenne, WYSep 19, 1965 · N629A · Substantial damageNTSB DEN66D0124Accident · No injuriesClosedCessna 180 · Medicine Bow, WYSep 18, 1965 · N3178D · Substantial damageNTSB DEN66F0105Accident · No injuriesClosedPiper PA-23 · Evanston, WYSep 16, 1965 · N1096P · Substantial damageNTSB DEN66D0106Accident · No injuriesClosedBeechcraft B55 · Big Piney, WYSep 8, 1965 · N8647Q · Substantial damageNTSB DEN66D0098Accident · No injuriesClosedPiper PA-11 · Big Piney, WYSep 4, 1965 · N78838 · Substantial damageNTSB DEN66A0015Accident · 2 fatalClosedChampion 7EC · Cheyenne, WYAug 20, 1965 · N9569S · DestroyedNTSB DEN66D0075Accident · No injuriesClosedPiper PA-18 · Lysite, WYAug 10, 1965 · N3965Z · Substantial damageNTSB DEN66A0006Accident · 3 fatalClosedPiper PA-23 · Douglas, WYAug 9, 1965 · N1272P · DestroyedNTSB DEN66D0091Accident · Minor injuriesClosedCallair A-5 · Lovell, WYAug 2, 1965 · N9958C · Substantial damageNTSB DEN66D0060Accident · No injuriesClosedPiper PA-28 · Saratoga, WYJul 21, 1965 · N7187W · Substantial damageNTSB DEN66D0074Accident · Minor injuriesClosedCessna 185 · Jackson, WYJul 14, 1965 · N1535F · Substantial damageNTSB DEN66A0010Accident · No injuriesClosedHughes 269B · Cody, WYJul 14, 1965 · N9397F · Substantial damageNTSB DEN66F0053Accident · No injuriesClosedForney 415-CD · Cheyenne, WYJul 11, 1965 · N3856H · Substantial damageNTSB DEN66A0004Accident · No injuriesClosedHiller UH-12E · Meeteetse, WYJul 7, 1965 · N5343V · DestroyedNTSB DEN66F0019Accident · No injuriesClosedBeechcraft K-35 · Cheyenne, WYJul 5, 1965 · N6099E · Substantial damageNTSB DEN66D0054Accident · No injuriesClosedPiper PA-18A · Upton, WYJul 5, 1965 · N8238P · Substantial damageNTSB DEN66D0020Accident · No injuriesClosedCessna 195 · Moran, WYJul 1, 1965 · N4455C · DestroyedNTSB DEN65F0115Accident · No injuriesClosedPiper PA-24 · Sheridan, WYJun 20, 1965 · N8324P · Substantial damageNTSB DEN65A0082Accident · 2 fatalClosedChampion 7ECA · Alcova, WYJun 16, 1965 · N11060 · DestroyedNTSB DEN66D0010Accident · No injuriesClosedCessna 182 · Mountain View, WYJun 12, 1965 · N8805S · Substantial damageNTSB DEN65F0097Accident · Minor injuriesClosedCessna 172 · Sundance, WYMay 30, 1965 · N4077F · Substantial damageNTSB DEN65F0090Accident · No injuriesClosedPiper PA-12 · Wheatland, WYMay 25, 1965 · N3231M · Substantial damageNTSB DEN65F0079Accident · No injuriesClosedMooney M20A · Cheyenne, WYMay 24, 1965 · N1063C · Substantial damageNTSB DEN65D0088Accident · No injuriesClosedPiper PA-11 · Pinedale, WYMay 20, 1965 · N78838 · Substantial damageNTSB DEN65F0070Accident · No injuriesClosedSwift GC-1B · Rawlins, WYMay 16, 1965 · N80883 · Substantial damageNTSB DEN65D0086Accident · No injuriesClosedLuscombe 8E · Lovell, WYMay 12, 1965 · N2422K · Substantial damageNTSB DEN65D0078Accident · No injuriesClosedCessna 150B · Wheatland, WYMay 10, 1965 · N1134Y · Substantial damageNTSB DEN65D0089Accident · No injuriesClosedCessna 170 · Douglas, WYMay 9, 1965 · N3475D · Substantial damageNTSB DEN65D0069Accident · No injuriesClosedBeechcraft 95 · Rock Springs, WYMay 5, 1965 · N911Y · Substantial damageNTSB DEN65A0069Accident · 1 fatalClosedCessna 182A · 8s Cheyenne, WYMay 3, 1965 · N9987T · DestroyedNTSB DEN65D0080Accident · Minor injuriesClosedPiper PA-25 · Lebarge, WYApr 27, 1965 · N7375Z · Substantial damageNTSB DEN65D0071Accident · No injuriesClosedStinson 108 · Worland, WYApr 24, 1965 · N97328 · Substantial damageNTSB DEN65D0065Accident · Minor injuriesClosedChampion 7CCM · Alva, WYApr 23, 1965 · N4451E · Substantial damageNTSB DEN65F0059Accident · No injuriesClosedChampion 7BCM · Afton, WYApr 19, 1965 · N81474 · Substantial damageNTSB DEN65D0087Accident · No injuriesClosedCessna 182 · Pine Bluffs, WYApr 11, 1965 · N3187Y · Substantial damageNTSB DEN65F0030Accident · No injuriesClosedMooney M20C · Newcastle, WYMar 22, 1965 · N6430U · Substantial damageNTSB DEN65F0019Accident · No injuriesClosedCessna 180 · Lander, WYFeb 28, 1965 · N1725C · Substantial damageNTSB DEN65A0058Accident · 2 fatalClosedPiper PA-24 · Cheyenne, WYFeb 27, 1965 · CF MGL · DestroyedNTSB DEN65F0011Accident · No injuriesClosedBeechcraft S-35 · Cheyenne, WYFeb 4, 1965 · N5877S · Substantial damage