NTSB investigations, 2002, 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, 2002, 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\") = 2002
    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 DEN03FA002Accident · 1 fatalField investigationFinal reportCessna T210M · Laramie, WYthe pilot's improper inflight planning/decision, and his failure to maintain terrain clearance while attempting a low altitude maneuver. Contributing factors were the mountainous terrain, the airplane’s low altitude, and the pilot's lack of total instrument…Oct 1, 2002 · N210HC · DestroyedNTSB DEN02FA105Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Rock Springs, WYthe flight crew of the Beech and the pilot of the Piper's failure to attain proper clearance from the other during their respective landings. Factors contributing to the accident were the crew's and the pilot of the other airplane's inadequate visual lookout…Sep 15, 2002 · N8822P · 2 aircraft · Substantial damageNTSB DEN02GA097Accident · 1 fatalFinal reportArctic S-1B2 · Meeteetse, WYthe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the intentional low pass/slow flight maneuver.Aug 16, 2002 · N71AT · DestroyedNTSB DEN02FA080Accident · 2 fatalField investigationFinal reportCessna 177B · Crowheart, WYthe pilot's failure to maintain clearance of the high mountain terrain. Contributing factors were the high mountain terrain, and the high density altitude weather condition.Jul 27, 2002 · N34859 · DestroyedNTSB DEN02LA075Accident · Serious injuriesLimited investigationFinal reportAmerican General AA5B · Worland, WYthe pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.Jul 13, 2002 · N28717 · DestroyedNTSB DEN02LA071Accident · No injuriesLimited investigationFinal reportCessna T206H · Jackson, WYthe engine failure for undetermined reasons and the pilot's failure to maintain aircraft control during the forced landing attempt. A factor contributing to the accident was the inadvertent stall.Jul 6, 2002 · N2453V · Substantial damageNTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.Jul 1, 2002 · N33515 · DestroyedNTSB DEN02LA051Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Medicine Bow, WYthe unsuitable terrain encountered during the emergency autorotation, following a partial loss of engine power. Factors contributing to this accident were fuel contamination (water), the low altitude, the high winds, and the tailwind.Jun 10, 2002 · N5694Z · Substantial damageNTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.Jun 7, 2002 · N8735A · Substantial damageNTSB DEN02LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Rock Springs, WYthe pilot's failure to maintain aircraft control during initial takeoff climb. A contributing factor was the gusty crosswind.May 30, 2002 · N4559C · Substantial damageNTSB DEN02LA048Accident · No injuriesLimited investigationFinal reportHelio H-391B · Cheyenne, WYthe pilot's failure to maintain directional control.May 24, 2002 · N25BA · Substantial damageNTSB DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.May 17, 2002 · N1211D · DestroyedNTSB DEN02LA032Accident · No injuriesLimited investigationFinal reportBoeing E75 · Cheyenne, WYthe pilot's excessive use of the brakes, which resulted in a nose over.Apr 21, 2002 · N68463 · Substantial damageNTSB DEN02TA037Accident · No injuriesFinal reportDouglas/Basler DC-3C · Casper, WYThe copilot's inadvertent retraction of the landing gear. A contributing factor was the use of inappropriate medication by the copilot.Apr 5, 2002 · N115Z · Substantial damageNTSB DEN02LA027Accident · No injuriesLimited investigationFinal reportKnight BD-4 · Kemmerer, WYThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a snowbank. A contributing factor was the high crosswind.Feb 20, 2002 · N84RL · Substantial damageNTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.Feb 11, 2002 · N29HU · Substantial damage