NTSB investigations, WY
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DEN00TA160Accident · Minor injuriesFinal reportBell 212 · Jackson, WYLoss of control for undetermined reasons.NTSB DEN00LA157Accident · Serious injuriesLimited investigationFinal reportPhelps Rans S-12 Airaile · Buffalo, WYthe lack of suitable terrain for the forced landing. Contributing factors were the power failure due to a failed rod bearing, and down draft weather condition.NTSB DEN00LA156Accident · No injuriesLimited investigationFinal reportCessna 180K · Douglas, WYThe pilot's failure to maintain control of the aircraft during landing roll. Factors were high winds and crosswinds.NTSB DEN00FA141Accident · 1 fatalField investigationFinal reportMooney M20K · Cheyenne, WYthe airplane's in-flight collision with hilly terrain for undetermined reasons.NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.NTSB DEN00LA079Accident · 1 fatalLimited investigationFinal reportGreen GTX-SE-FI · Gillette, WYThe pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.NTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.NTSB DEN00LA057Accident · No injuriesLimited investigationFinal reportLearjet 60 · Jackson, WYThe pilot not following the airplane manufacturer's recommended landing procedures for a contaminated runway by landing with a tailwind. Factors were the pilot's inadvertent deactivation of the anti-skid protection, the ice contaminated runway, and the snow…NTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.NTSB DEN00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Rock Springs, WYA forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…NTSB DEN00LA036Accident · No injuriesLimited investigationFinal reportBeech B200 · Jackson, WYThe pilot misreading the visual approach lighting system, resulting in his failure to maintain proper alignment with the runway and his selection of an improper touchdown point. Factors were the low ceiling weather conditions and the snow covered runway.NTSB DEN00LA026Accident · No injuriesLimited investigationFinal reportCessna 421C · Gillette, WYThe collision with a deer on the runway during a night landing. A factor was the dark night.NTSB DEN00FA021Accident · 2 fatalField investigationFinal reportPiper PA-18-125 · Afton, WYFailure of the pilot to remove frost from the wings prior to takeoff, causing an inadvertent stall/spin on initial climbout. Factors included exceeding the aircraft's certificated gross weight, and fog conditions.NTSB DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.NTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.NTSB DEN99LA147Accident · No injuriesLimited investigationFinal reportCessna 180H · Gillette, WYThe pilot's inadvertent ground loop during landing roll.NTSB DEN99LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Casper, WYThe pilot's selection of a wrong runway for landing and his failure to maintain directional control.NTSB DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.NTSB DEN99LA130Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Centennial, WYThe pilot's failure to consult the airplane performance charts and allowing the airplane to exceed its climb performance. Factors were high density altitude conditions and a downdraft.NTSB DEN99LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Big Piney, WYThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A related factor was the gusty crosswind.NTSB DEN99FA109Accident · 1 fatalField investigationFinal reportBoeing Stearman A75 · Carpenter, WYPilot incapacitation for unknown reasons.NTSB DEN99LA096Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cheyenne, WYThe pilot's inadequate flight planning, and lack of suitable terrain for the forced landing. Factor's were the pilot's inadequate aircraft preflight, and the subsequent engine power loss due to fuel exhaustion.NTSB DEN99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Parkman, WYThe pilot's inadequate in-flight planning by exceeding the helicopter's performance climb capability. Factors were the downdraft encountered during initial climb following takeoff, and the high density altitude.NTSB DEN99LA089Accident · Minor injuriesLimited investigationFinal reportDehaan Challenger II · Douglas, WYThe pilot's failure to maintain directional control of the aircraft by not adequately correcting for torque/p-factor during initial climb following takeoff.NTSB DEN99LA084Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Baggs, WYThe pilot not maintaining the main rotor's RPM. Factor's were the high density altitude, and the mountainous/hilly terrain.NTSB DEN99FA075Accident · 2 fatalField investigationFinal reportPiper PA-11 · Lander, WYThe pilot inadvertently stalling the airplane. Factors were his abrupt maneuvering of the airplane to avoid a powerline, and his attention being diverted.NTSB DEN99LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burlington, WYThe pilots' inadequate preflight planning for take off in that he failed to consider the takeoff surface not being a paved surface. A factor was loose material on the roadway used for take off.NTSB DEN99LA061Accident · No injuriesLimited investigationFinal reportMooney M20K · Medicine Bow, WYA fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.NTSB DEN99LA056Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Evanston, WYA total loss of engine power for undetermined reasons.NTSB DEN99LA040Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Baggs, WYA hard landing resulting from rotor rpm decay. Factors were the improper replacement of the turbine by company maintenance personnel resulting in the PC line nut becoming loose, and the pilot operating outside the normal height/velocity curve.NTSB DEN99LA036Accident · No injuriesLimited investigationFinal reportCessna 208B · Cody, WYThe pilot's inability to maintain aircraft control due to unfavorable winds conditions.NTSB DEN99LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Bedford, WYThe pilot's failure to identify a soft area on his newly constructed airstrip, which subsequently caused his airplane to nose over.NTSB DEN99FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Buffalo, WYThe non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.NTSB DEN99LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Jackson Hole, WYThe pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.NTSB FTW98LA391Accident · No injuriesLimited investigationFinal reportCessna 180F · Douglas, WYA collision with a deer during take-off.NTSB FTW98LA374Accident · No injuriesLimited investigationFinal reportBeech B36TC · Pinedale, WYThe pilot not following his Pilot Operating checklist procedures. A factor was the aborted landing which interfered with the pilot's normal traffic pattern habit.NTSB FTW98FA354Accident · 1 fatalField investigationFinal reportMooney M20J · Centennial, WYThe pilot's disregard of information provided in weather briefs, and his flight into known adverse weather in mountainous terrain which resulted in an in-flight collision with a mountain. Factors were rain and low ceiling/visibility.NTSB FTW98LA336Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Cody, WYThe pilot's failure to maintain visual lookout while taxiing the aircraft.NTSB FTW98LA334Accident · Minor injuriesLimited investigationFinal reportCessna 500 · Rawlins, WYThe captain's use of improper airplane performance data, resulting in inadequate takeoff capability. Factors were his decision to abort the takeoff above V1, the separation of the drag chute, a wet runway, a tailwind, and collision with objects that included…NTSB FTW98LA332Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rock Springs, WYThe pilot's failure to maintain directional control, and an inadvertent ground loop/swerve.NTSB FTW98LA309Accident · Serious injuriesLimited investigationFinal reportOverton Mustang M-II · Hillsdale, WYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance from obstacles. Factors were an intentional low altitude flight maneuver, wires, and low light conditions.NTSB FTW98LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20-160 · Kemmerer, WYThe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. A factor was the pilot's lack of experience in a conventional landing gear type of airplane.NTSB FTW98LA288Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYThe pilot's improper in-flight planning and decision making by selecting an inadequate landing area for an emergency landing when a suitable landing area was available. Factors were fuel exhaustion, inaccurate preflight planning, and lack of recent experience.NTSB FTW98LA270Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Douglas, WYThe pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.NTSB FTW98LA254Accident · No injuriesLimited investigationFinal reportCessna 172A · Ten Sleep, WYThe student pilot's failure to select a proper touchdown point. A factor was his lack of recent experience conducting solo flight operations.NTSB FTW98LA201Accident · No injuriesLimited investigationFinal reportCessna 320D · Greybull, WYStress overload failure of the bellcrank assembly of the left landing gear.NTSB FTW98LA200Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Jackson, WYthe pilot's misjudgment of distance and speed, while approaching to land; his failure to attain a proper touchdown point for landing; and his failure to go around, while there was sufficient runway remaining. A related factor was the uneven terrain, which was…NTSB FTW98LA176Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Riverton, WYcontinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude from terrain, while manuevering to reverse direction. Related factors were: the adverse weather conditions, mountainous terrain, and…