NTSB investigations, WY
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, newest first
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 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.
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 c."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN03LA153Accident · Minor injuriesLimited investigationFinal reportSharp Corben Baby Ace D · Wamsutter, WYA loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing.NTSB DEN03LA098Accident · Minor injuriesLimited investigationFinal reportHelio H800 · Cody, WYthe pilot's improper preflight planning and his failure to maintain aircraft control when returning to the airport. Factors contributing to the accident were the oil leak, the attempted precautionary landing, and the downdraft.NTSB DEN03LA092Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cheyenne, WYthe pilot's failure to maintain aircraft control. A contributing to the accident was the sudden tailwind encountered.NTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.NTSB DEN03LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Afton, WYthe pilot's failure to achieve an adequate climb rate, resulting in an inflight collision with the sign. Contributing factors were the pilot's improper mixture leaning procedure, the high density altitude, his failure to abort the takeoff in a timely manner,…NTSB DEN03LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kemmerer, WYthe pilot's failure to maintain directional control and his inadequate compensation for wind during the landing roll which resulted in a ground loop/swerve and impact with terrain. Contributing factors include the wind gust and the ditch.NTSB DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.NTSB DEN03FA040Accident · 1 fatalField investigationFinal reportBeech V35B · Rock Springs, WYthe pilot's failure to maintain adequate airspeed, resulting in a stall. Factors contributing to the accident were the icing conditions, low altitude, and the high gusting winds.NTSB DEN03FA030Accident · 1 fatalField investigationFinal reportSilvius Rans S-12XL · Laramie, WYthe pilot's failure to maintain aircraft control, resulting in an inadvertent stall/mush. Contributing factors include the pilot's use of an over-the-counter antihistamine, and the pilot's inadequate in-flight decision to fly at low altitude.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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.NTSB 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.NTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.NTSB 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.NTSB DEN02LA048Accident · No injuriesLimited investigationFinal reportHelio H-391B · Cheyenne, WYthe pilot's failure to maintain directional control.NTSB 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.NTSB DEN02LA032Accident · No injuriesLimited investigationFinal reportBoeing E75 · Cheyenne, WYthe pilot's excessive use of the brakes, which resulted in a nose over.NTSB 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.NTSB 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.NTSB 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.NTSB DEN02TA011Accident · No injuriesFinal reportCessna 206 · Casper, WYfailure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.NTSB DEN02LA006Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Casper, WYThe pilot's failure to maintain clearance from another parked airplane while taxiing. Contributing factors were the night light conditions, and the pilot's fatigue from a long day.NTSB DEN01LA156Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kemmerer, WYthe loss of tail rotor effectiveness while air taxiing. Contributing factors were the high winds and gusts, and the pilot's limited experience in aircraft make/model.NTSB DEN01LA154Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Kemmerer, WYloss of tail rotor effectiveness while hovering. A contributing factor was the wind gust.NTSB DEN01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Rock Springs, WYthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…NTSB DEN01LA145Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B-2 · Cody, WYthe pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.NTSB DEN01LA144Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kemmerer, WYfuel exhaustion due to the pilot's failure to refuel the aircraft, which resulted in a loss of engine power. A contributing factor was the unsuitable steep terrain on which to make a forced landing.NTSB DEN01LA142Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Rock Springs, WYthe right main tire blowing out in flight, which resulted in a loss of directional control during landing.NTSB DEN01FA135Accident · 1 fatalField investigationFinal reportBeech V-35A · Lusk, WYthe pilot's inadequate visual lookout, which resulted in an inadvertent collision with transmission wires.NTSB DEN01TA134Accident · No injuriesFinal reportBell 205A-1 · Jackson, WYthe Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.NTSB DEN01LA125Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Cody, WYthe failure of the turbine assembly due to an over temperature condition. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.NTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…NTSB DEN01LA067Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Buffalo, WYfailure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.NTSB DEN01LA060Accident · No injuriesLimited investigationFinal reportBell 407 · Jackson, WYThe pilot's failure to maintain adequate lateral and vertical clearance during landing. Factors were the clouds and snow-covered high terrain.NTSB DEN01LA057Accident · No injuriesLimited investigationFinal reportEurocopter France AS-350-B2 · Powder River, WYThe pilot's failure to maintain aircraft control during aircraft shut down procedures. Contributing factors were: the snow and ice covered field and the confined landing areas unsuitable obstacle clearance.NTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.NTSB DEN01FA030Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-700 · Jackson, WYThe pilot's failure to follow IFR approach procedures and perform a missed approach when the runway was not in sight below approach minimums. Contributing factors were the copilot's failure to follow current ILS approach procedures and use the correct…NTSB DEN01FA028Accident · 2 fatalField investigationFinal reportCessna 172 · Lusk, WYthe pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…NTSB DEN01LA002Accident · Serious injuriesLimited investigationFinal reportHughes 369FF · Baggs, WYimpact with terrain following a total loss of engine power due to fatigue failure of the turbine-to-compressor coupling. A contributing factor was the unsuitable terrain for a forced landing.NTSB DEN00LA176Accident · No injuriesLimited investigationFinal reportBell 206B · Rawlins, WYThe company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.NTSB DEN00LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sheridan, WYThe pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.NTSB DEN00LA166Accident · No injuriesLimited investigationFinal reportCessna 340A · Big Piney, WYCollision with animals during the takeoff roll.NTSB DEN00LA165Accident · Serious injuriesLimited investigationFinal reportGulfstream G-IV · Sheridan, WYthe pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.