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 DEN06CA092Accident · No injuriesData collectionFinal reportFlaglor High Tow · Jackson, WYthe loss of engine power due to low cylinder compression and fouled spark plugs. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.NTSB DEN06CA088Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Cokeville, WYthe pilot's failure to maintain directional control resulting in a ground loop. Contributing factors included the high winds and crosswind.NTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.NTSB DEN06CA074Accident · No injuriesData collectionFinal reportCessna 182Q · Fort Bridger, WYthe pilot's failure to maintain aircraft control during the landing flare and touchdown. Contributing to the accident was the high, gusty crosswinds.NTSB DEN06CA073Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cody, WYthe pilot's failure to maintain clearance with a parked vehicle during the approach to land on a dirt road. Contributing factors were the pilot's improper decision to land near an unsuitable landing area, and the parked vehicle.NTSB DEN06IA042Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Casper, WYloss of directional control for undetermined reasons. A factor contributing to the incident was the runway maker light.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB DEN06LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Rock Springs, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.NTSB DEN06LA005Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kaycee, WYthe pilot's improper decision to attempt a go-around and the pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was the hard landing.NTSB DEN06FA001Accident · 2 fatalField investigationFinal reportBeechcraft V35B · Barnum, WYthe pilot's improper in-flight planning and decision to continue flight into forecasted icing conditions and the pilot's inability to maintain aircraft control due to wing contamination in the form of ice. Contributing factors included the weather conditions…NTSB DEN05LA143Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Torrington, WYfailure of the #7 connecting rod, causing engine seizure. A contributing factor was the berm.NTSB DEN05LA142Accident · Serious injuriesLimited investigationFinal reportShea Vans RV6A · Glendo, WYfailure of the nose gear during the landing roll.NTSB DEN05LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Rock Springs, WYthe pilot's failure to maintain control of the helicopter during the attempted autorotation after he experienced an engine overspeed that occurred for reasons undetermined.NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.NTSB DEN05CA135Accident · Minor injuriesData collectionFinal reportAviat A-1B · Sheridan, WYpilot's failure to maintain aircraft control during the aborted landing. A contributing factor was the pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.NTSB DEN05FA125Accident · 2 fatalField investigationFinal reportCessna 177B · Centennial, WYthe pilot's improper in-flight planning/decision, in that he failed to maintain a steady state climb rate to a safe altitude and continued flight towards visible weather that obstructed his chosen route of flight, and his failure to maintain terrain…NTSB DEN05CA116Accident · No injuriesData collectionFinal reportCessna 210E · Saratoga, WYthe pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…NTSB DEN05FA100Accident · 1 fatalField investigationFinal reportCGS Hawk Two Place Arrow · Jackson, WYThe loss of airplane pitch control resulting from the pilot/owner's improper reinstallation of the rear locking collar on the elevator control torque tube, which allowed the torque tube to move rearward during flight and loosen the elevator control cable…NTSB DEN05LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Rock Springs, WYthe pilot's improper flare and recovery from a bounced landing.NTSB DEN05LA059Accident · 1 fatalLimited investigationFinal reportBourgeois-Avid Flyer MK IV · Kaycee, WYthe pilot's failure to maintain airspeed which resulted in a stall.NTSB DEN05LA057Accident · No injuriesLimited investigationFinal reportCessna P210N · Lander, WYthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05FA051Accident · 3 fatalField investigationFinal reportBeech BE-90 · Rawlins, WYThe pilot's inadvertent flight into adverse weather [severe icing] conditions, resulting in an aerodynamic stall impact with rising, mountainous terrain during approach. A factor contributing to the accident was the pilot's inadequate planning for the…NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.NTSB DEN04LA140Accident · No injuriesLimited investigationFinal reportBeech B-60 · Casper, WYthe missing nose gear assembly bolt, spacer and nut resulting in a gear collapse due to improper maintenance procedures. Contributing to the accident was the collision with the storm drain.NTSB DEN04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Gillette, WYimproper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN04LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Atlantic City, WYthe pilot's inability to maintain aircraft control, improper in-flight planning and decision making, and failure to compensate for wind conditions, resulting in collision with terrain. Contributing factors were the intentional low-level maneuver, and the wind…NTSB DEN04IA126Incident · No injuriesIncident investigationFinal reportCessna 750 · Jackson, WYthe failure of the right main landing gear trailing link due to fatigue cracking initiated by an undetected manufacturing defect. A contributing factor was the improper plating process by unknown manufacture personnel.NTSB DEN04CA125Accident · Minor injuriesData collectionFinal reportMaule M-6-235 · Dubois, WYthe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.NTSB DEN04CA117Accident · Minor injuriesData collectionFinal reportMooney M20K · Jackson Hole, WYthe pilot's failure to maintain aircraft control resulting in a stall/mush. Contributing factors include the windshear, the crosswind and the runway light.NTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…NTSB DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB DEN04CA099Accident · No injuriesData collectionFinal reportCessna 172N · Laramie, WYfuel exhaustion due to the pilot's improper inflight decision not to stop and refuel. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB DEN04FA078Accident · 1 fatalField investigationFinal reportAir Borne Windsports Pty. Edge Wing X · Carter, WYThe non-certificated pilot's failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident include the non-certificated pilot's improper judgment and the his lack of experience.NTSB DEN04FA074Accident · 2 fatalField investigationFinal reportPiper PA-30 · Evanston, WYthe pilot's failure to maintain terrain clearance. Contributing factors include snow, low ceiling, icing conditions, and the dark night.NTSB DEN04FA079Accident · 3 fatalField investigationFinal reportMooney M20K · Pinedale, WYThe pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.NTSB DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.NTSB DEN04FA043Accident · 1 fatalField investigationFinal reportCessna T206H · Walcott, WYThe pilot not following proper IFR procedures for tracking a VOR radial while on an IFR flight plan in IMC conditions, and not maintaining clearance with terrain during cruise flight. Contributing factors were the mountain, and the cloudy weather condition.NTSB DEN04LA020Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA227BC · Rawlins, WYthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the pilot's improper in-flight planning/decision, the icy, snow covered runway and the snow bank.NTSB DEN04MA015Accident · 1 fatalMajor investigationFinal reportCessna 208B · Cody, WYthe pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.NTSB DEN04LA008Accident · No injuriesLimited investigationFinal reportCessna 182R · Lysite, WYthe pilot's fuel mismanagement resulting in the loss of engine power and the subsequent forced landing. A contributing factor was the lack of suitable terrain for a forced landing and the nose over.NTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.NTSB DEN03LA148Accident · No injuriesLimited investigationFinal reportCessna 150H · Moran, WYthe pilot's selection of an unsuitable takeoff area which resulted in an encounter with the gopher hole during the touch-and-go. Factors contributing to the accident were the gopher hole, the abrupt pull up, the low airspeed, the inadvertent stall mush, the…NTSB DEN03LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Laramie, WYA partial loss of engine power for undetermined reasons. Contributing factors were the high density altitude, trees, mountainous terrain, and unsuitable terrain on which to make a forced landing.NTSB DEN03LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Crowheart, WYThe pilot's inadequate preflight planning (attempting to exceed aircraft's published certificated performance), the pilot not obtaining sufficient altitude to clear the terrain (not possible), and the pilot's inadequate in flight planning/decision making.…NTSB DEN03FA138Accident · 1 fatalField investigationFinal reportWright Hughes 1-B · Yellowstone Nat, WYThe in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.NTSB DEN03FA125Accident · 2 fatalField investigationFinal reportCASA 2.111 · Cheyenne, WYA loss of engine power for reasons undetermined, and the pilot's failure to maintain aircraft control. Contributing factors were the unsuitable terrain on which to make a forced landing, low airspeed, the fence, automobile, and the school bus wash barn.NTSB DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.