NTSB investigations, WY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 SEA92LA210Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Arlington, WYThe pilot in command's failure to touch down at the proper landing point on the road. A factor contributing to the accident was high density altitude.NTSB DEN92FA093Accident · 1 fatalField investigationFinal reportCessna 172M · Evanston, WYLoss of control for undetermined reasons.NTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.NTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.NTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.NTSB DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.NTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.NTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.NTSB SEA92LA138Accident · Minor injuriesLimited investigationFinal reportNavion H · Gillette, WYAn engine power loss due to the collapse of the induction air ducting, inadequate maintenance, and improper approval of the modification.NTSB SEA92LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mckinnon, WYWater in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.NTSB SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.NTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.NTSB SEA92LA044Accident · 2 fatalLimited investigationFinal reportLockheed P2V-7 · Dixon, WYThe pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…NTSB SEA92LA030Accident · Minor injuriesLimited investigationFinal reportArtic S-1B2 · Lysite, WYThe pilot's failure to maintain clearance with terrain. Factors contributing to the accident were rising terrain, downdrafts, and the pilot's inadequate compensation for wind conditions.NTSB SEA92FA222Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Moran, WYThe pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…NTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.NTSB SEA91LA256Accident · No injuriesLimited investigationFinal reportLyons Stueckle Quickie Q-2 · Cheyenne, WYThe premature landing flare by the pilot.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.NTSB SEA91LA221Accident · Minor injuriesLimited investigationFinal reportCessna C-210L · Cheyenne, WYMaintenance personnel did not perform a proper top overhaul. This resulted in engine failure due to the failure of a connecting rod bearing. Factors include the hard landing resulting from the premature landing flare by the pilot.NTSB SEA91FA220Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Arlington, WYThe loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.NTSB SEA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Kemmerer, WYThe pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.NTSB SEA91LA185Accident · No injuriesLimited investigationFinal reportCessna 180 · Cody, WYPilot's failure to maintain proper runway alignment. Factors were diverted attention, and gusty crosswinds.NTSB SEA91FA181Accident · 2 fatalField investigationFinal reportCessna 180J · Newcastle, WYPilot factor in that he did not maintain sufficient flying speed and allowed the aircraft to enter an inadvertent stall/spin. Factors include high density altitude.NTSB SEA91LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Dayton, WYSevere down drafts. Factors to the accident were: terrain clearance was not maintained, and a poor weather evaluation, by the pilot.NTSB SEA91LA154Accident · 1 fatalLimited investigationFinal reportJerrell RV-4 · Yellowstonepark, WYA collapsed induction air duct. Factors include inadequate design by the manufacturer/builder, and a misjudged rate of descent by the pilot.NTSB SEA91LA150Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Riverton, WYThe pilot did not maintain adequate terrain clearance. A factor to the accident was: poor inflight planning/preparation.NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB SEA91LA134Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Rock Springs, WYThe pilot's inadequate preflight planning and decision to attempt flights in unfavorable environmental codnitions. The environmental conditions were factors in the accident.NTSB SEA91LA128Accident · No injuriesLimited investigationFinal reportEnstrom F280C · Baggs, WYExhaust valve failure, resulting in a partial power loss. Contributing factors were low altitude and rough/uneven terrain.NTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.NTSB SEA91LA112Accident · No injuriesLimited investigationFinal reportCessna 172P · Alva, WYThe pilot's overconfidence in his personal ability, overconfidence in the aircraft's ability. Contributing to the accident was the engine failure.NTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB SEA91LA097Accident · 1 fatalLimited investigationFinal reportGrumman AA-1B · Douglas, WYAn inadvertent stall with inadequate terrain clearance. Factors include flight in mountainous terrain at an altitude where remedial action was not possible.NTSB SEA91TA003Accident · No injuriesFinal reportPiper PA-34 · Pinedale, WYThe pilot's failure to attain proper runway alignment during landing. A contributing factor was a snow covered runway.NTSB ANC91FA017Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Evanston, WYThe pilot's premature descent. Contributing to the accident was the pilot's fatigue and poor weather.NTSB SEA91LA012Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Afton, WYAn improper maintenance modification to disable the carburetor heat control by unknown personnel.NTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.NTSB SEA91LA007Accident · No injuriesLimited investigationFinal reportCessna 414A · Jackson, WYThe pilot's inadequate preflight preparation of the aircraft, his failure to remove snow and ice from the aircraft before takeoff, and his delay in attempting to abort the takeoff.NTSB SEA91LA006Accident · No injuriesLimited investigationFinal reportMooney M20F · Casper, WYThe loss of engine power due to fatigue fracture of the number 2 cylinder connecting rod. Factors related to the accident were: rough and uneven terrain at the accident site and the lack of suitable terrain for forced landing.NTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.NTSB SEA90LA178Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk Mountain, WYThe pilot's failure to maintain flying speed while at an altitude that did not provide adequate terrain clearance for a safe stall recovery.NTSB SEA90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32-300RT · Glenrock, WYFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation. Unsuitable terrain was a factor related to the accident.NTSB SEA90LA175Accident · No injuriesLimited investigationFinal reportMooney M-20E · Cheyenne, WYPilot's failure to extend the landing gear prior to landing after having been distracted by traffic. A mitigating factor in this accident was the fact that the gear warning horn did not function.NTSB DEN90FA172Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Meeteetse, WYA main rotor head blade dampener failure. A factor in the accident was the subsequent failure of a blade restraining cable.NTSB SEA90LA152Accident · No injuriesLimited investigationFinal reportBoson Starduster TOO · Pinedale, WYThe loss of engine power due to failure of the ignition coil, and the lack of suitable terrain for a forced landing. Failure of the ignition coil resulting in a total loss of engine power. The lack of suitable terrain was a factor related to the accident.NTSB DEN90LA168Accident · Serious injuriesLimited investigationFinal reportGulfstream G-II · Cheyenne, WYAn unforeseen encounter with clear air turbulence.NTSB SEA90LA147Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Rawlins, WYPilot's improper planning/decision, and his misjudgement of the aircraft's climb capability in conditions of high density altitude and unanticipated atmospheric conditions. The high density altitude and rising terrain were related factors.NTSB SEA90FA146Accident · 3 fatalField investigationFinal reportWheeler Technology FT-210 · Linch, WYFailure of the pilot to maintain control of the aircraft and/or correct the stall/spin.NTSB DEN90LA164Accident · No injuriesLimited investigationFinal reportMooney M20F · Torrington, WYA partial loss of power due to a failed exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.