NTSB investigations, 1973, WY

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1973, 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\") = 1973
    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 DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYDec 15, 1973 · N19583 · DestroyedNTSB DEN74FTC22Accident · Minor injuriesClosedPiper PA-28 · Casper, WYDec 1, 1973 · N4944L · Substantial damageNTSB DEN74AD028Accident · 3 fatalClosedCessna 182 · Cokeville, WYNov 29, 1973 · N9338G · DestroyedNTSB DEN74DTC21Accident · No injuriesClosedMaule M4220C · Gillette, WYNov 26, 1973 · N2080U · Substantial damageNTSB DEN74DTC20Accident · No injuriesClosedPiper PA-25 · Upton, WYNov 16, 1973 · N6393Z · Substantial damageNTSB DEN74AD018Accident · 2 fatalClosedPiper PA-18 · Lusk, WYOct 28, 1973 · N8579C · DestroyedNTSB DEN74FTC18Accident · No injuriesClosedPiper PA-20 · Cheyenne, WYOct 19, 1973 · N7657K · Substantial damageNTSB DEN74DTC19Accident · No injuriesClosedPiper PA-28 · Rock Springs, WYOct 19, 1973 · N9359W · Substantial damageNTSB DEN74AD016Accident · 2 fatalClosedBellanca 14-193 · Arlington, WYOct 10, 1973 · N1273R · DestroyedNTSB DEN74FTC15Accident · No injuriesClosedBeech 65-A90 · Casper, WYOct 4, 1973 · N100HM · Substantial damageNTSB DEN74DTC17Accident · No injuriesClosedPiper PA-24 · Wheatland, WYSep 28, 1973 · N9412P · Substantial damageNTSB DEN74DTC13Accident · No injuriesClosedPiper PA-18 · Wheatland, WYSep 16, 1973 · N4332Z · DestroyedNTSB DEN74FTC12Accident · No injuriesClosedCessna 310 · Cokeville, WYAug 31, 1973 · N6732T · Substantial damageNTSB DEN74FTC11Accident · Minor injuriesClosedCessna 411 · Farson, WYAug 26, 1973 · N100MM · Substantial damageNTSB DEN74AD011Accident · 1 fatalClosedCessna 195 · Worland, WYAug 25, 1973 · N4332N · DestroyedNTSB DEN74DTC10Accident · Minor injuriesClosedPiper PA-18 · Rocky Point, WYAug 16, 1973 · N7101K · Substantial damageNTSB DEN74DTC09Accident · No injuriesClosedPiper PA-28 · Laramie, WYAug 16, 1973 · N95477 · Substantial damageNTSB DEN74FTC14Accident · No injuriesClosedCessna 310P · Rock Springs, WYAug 14, 1973 · N6732T · Substantial damageNTSB DEN74DTC08Accident · No injuriesClosedCessna 210 · Greybull, WYAug 12, 1973 · N22054 · Substantial damageNTSB DEN74DTC07Incident · No injuriesClosedTaylorcraft DC12D · Evanston, WYAug 11, 1973 · N39243 · Minor damageNTSB DEN74FTC06Accident · Serious injuriesClosedPiper PA-32 · Savery, WYAug 3, 1973 · N4035W · DestroyedNTSB DEN74AD005Accident · 1 fatalClosedPiper PA-18 · Sheridan, WYAug 1, 1973 · N3571P · DestroyedNTSB DEN74FTC05Accident · Minor injuriesClosedAeronca 7BCM · Rock Springs, WYJul 29, 1973 · N2043A · Substantial damageNTSB DEN74DTC04Accident · No injuriesClosedChampion 7GCBC · Colony, WYJul 23, 1973 · N5130T · Substantial damageNTSB DEN74FTC02Accident · No injuriesClosedBeech D18S · Encampment, WYJul 1, 1973 · N6560D · Substantial damageNTSB DEN74DTC01Accident · Minor injuriesClosedCessna T210 · Pinedale, WYJul 1, 1973 · N6935R · DestroyedNTSB DEN73FTC29Accident · Serious injuriesClosedSnow S2C · Sheridan, WYJun 14, 1973 · N1641S · DestroyedNTSB DEN74DTC03Accident · No injuriesClosedPiper PA-18 · Lovell, WYJun 13, 1973 · N3099Z · Substantial damageNTSB DEN73FTC27Accident · No injuriesClosedCessna 180 · Kemmerer, WYJun 12, 1973 · N3657C · Substantial damageNTSB DEN73FTC28Accident · No injuriesClosedHughes 269A · Baggs, WYJun 11, 1973 · N8859F · DestroyedNTSB DEN73AD053Accident · 1 fatalClosedBerkshire C-70 · Burns, WYJun 10, 1973 · N10QT · DestroyedNTSB DEN73DTC26Accident · No injuriesClosedHelio H-395 · Jackson, WYMay 25, 1973 · N4198D · Substantial damageNTSB DEN73DTC25Accident · No injuriesClosedCessna T210J · Riverton, WYMay 9, 1973 · N2280R · Substantial damageNTSB DEN73DTC24Accident · No injuriesClosedBellanca 7GCBC · Rock River, WYApr 27, 1973 · N222WY · Substantial damageNTSB DEN73DTC23Accident · No injuriesClosedPiper PA-18 · Buffalo, WYApr 22, 1973 · N1449A · Substantial damageNTSB DEN73AD046Accident · 3 fatalClosedPiper PA-24 · Laramie, WYApr 8, 1973 · N8323P · DestroyedNTSB DEN73AD045Accident · 2 fatalClosedCessna 210 · Farson, WYMar 31, 1973 · N9545T · DestroyedNTSB DEN73FTC21Accident · Minor injuriesClosedPiper PA-18A · Bosler, WYMar 18, 1973 · N1385C · DestroyedNTSB DEN73DTC22Accident · No injuriesClosedCessna 180A · Glendo, WYMar 18, 1973 · N5220D · Substantial damageNTSB DEN73DTC20Accident · No injuriesClosedPiper PA-28R · Laramie, WYMar 15, 1973 · N2064T · Substantial damageNTSB DEN73FTC19Accident · No injuriesClosedHughes 269A · Hanna, WYFeb 22, 1973 · N8859F · Substantial damageNTSB DEN73AD038Accident · 4 fatalClosedMooney M20F · Saratoga, WYFeb 11, 1973 · N9352V · DestroyedNTSB DEN73FTC18Accident · Minor injuriesClosedPiper PA-28 · Cheyenne, WYJan 28, 1973 · N7240F · Substantial damageNTSB DEN73DTC17Accident · No injuriesClosedCessna 180 · Gillette, WYJan 21, 1973 · N3178D · Substantial damageNTSB DEN73DTC16Accident · No injuriesClosedMooney M20F · Sheridan, WYJan 2, 1973 · N9777M · Substantial damage