NTSB investigations, 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, 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 WPR13LA230Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB WPR13FA138Accident · 1 fatalField investigationFinal reportCessna 172M · Saratoga, WYThe pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…NTSB WPR13LA132Accident · No injuriesLimited investigationFinal reportCessna T310R · Casper, WYThe separation of the right main gear bracket assembly from its wing attachment fitting due to lack of lubrication of the torque tube bearing.NTSB WPR13CA114Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Worland, WYThe pilot's failure to maintain directional control during landing.NTSB WPR13LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rock Springs, WYThe pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism.NTSB WPR13CA067Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Rawlins, WYThe pilot's failure to maintain main rotor rpm during takeoff, which resulted in a hard landing and subsequent rollover.NTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB WPR13IA059Incident · No injuriesIncident investigationFinal reportBell 407 · Riverton, WYThe pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.NTSB WPR13CA040Accident · No injuriesData collectionFinal reportSpackman Avid Flyer · Casper, WYThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR13FA008Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Laramie Peak, WYThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.NTSB WPR12LA392Accident · No injuriesLimited investigationFinal reportCessna 210 · Kemmerer, WYThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.NTSB WPR12LA341Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Cody, WYThe failure of a tail rotor driveshaft coupling due to fatigue.NTSB WPR12CA319Accident · No injuriesData collectionFinal reportDornier DO 27 B5 · Jackson Hole, WYThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear.NTSB WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.NTSB WPR12LA309Accident · No injuriesLimited investigationFinal reportBeech A36 · Rock Springs, WYThe total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…NTSB WPR12LA256Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Riverton, WYAn engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB WPR12LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Casper, WYA total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…NTSB WPR12LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Rawlins, WYThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR12GA106Accident · 1 fatalFinal reportBell 407 · Moran Junction, WYThe pilot’s failure to maintain yaw control while hovering at high density altitude, which resulted in a loss of tail rotor effectiveness.NTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB WPR12LA065Accident · Minor injuriesLimited investigationFinal reportBell 407 · Rock Springs, WYThe unauthorized operation of the helicopter by a non-certificated and unqualified individual who failed to maintain helicopter control.NTSB WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.NTSB WPR12LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Cheyenne, WYThe flight crew’s failure to properly latch the cabin door before takeoff.NTSB WPR11CA468Accident · No injuriesData collectionFinal reportBeech 36 · Riverton, WYThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB WPR11CA467Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Douglas, WYThe pilot's failure to maintain yaw control of the helicopter while hover taxiing in gusty wind conditions.NTSB WPR11LA463Accident · No injuriesLimited investigationFinal reportCessna 177 · Rock Springs, WYThe pilot did not lean the fuel mixture prior to takeoff, which resulted in the engine's inability to attain sufficient power due to the rich mixture, and his inadequate preflight planning.NTSB WPR11LA434Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Saratoga, WYA loss of engine power during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB WPR11LA388Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Pine Bluffs, WYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR11CA387Accident · Serious injuriesData collectionFinal reportP&M GT450 · Teton Village, WYThe pilot's failure to maintain an adequate airspeed, which resulted in a stall mush to ground impact.NTSB WPR11FA381Accident · 2 fatalField investigationFinal reportBeech A36 · Lander, WYThe pilot’s failure to maintain clearance from mountainous terrain.NTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.NTSB WPR11LA389Accident · No injuriesLimited investigationFinal reportGlasair Sportsman · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.NTSB WPR11CA353Accident · No injuriesData collectionFinal reportSloan Roger D Vans RV7A · Sheridan, WYThe pilot's failure to maintain aircraft control during takeoff due to cockpit distractions.NTSB WPR11LA346Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Torrington, WYThe carburetor’s failure to meet its operating limits at the low range, which resulted in a loss of engine power when the pilot reduced power for landing.NTSB WPR11CA327Accident · Minor injuriesData collectionFinal reportCessna 150J · Wheatland, WYThe pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to continue flight with known equipment deficiencies.NTSB WPR11CA299Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Casper, WYAn in-flight collision with a bird at low altitude.NTSB WPR11LA280Accident · No injuriesLimited investigationFinal reportInhofe/ Davis Vans RV-8 · Sheridan, WYThe pilot's inadequate directional control during the landing roll.NTSB WPR11LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Pine Bluffs, WYA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA233Accident · Serious injuriesLimited investigationFinal reportPalmer RV6A · Cody, WYThe pilot’s failure to maintain sufficient altitude to avoid rising terrain. Contributing to the accident was the pilot’s visual illusion and disorientation due to the flat light conditions.NTSB WPR11FA228Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Rock Springs, WYThe pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.NTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB WPR11FA188Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Laramie, WYThe pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.NTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.