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 SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB SEA95FA012Accident · 2 fatalField investigationFinal reportUnited Consultant UC-1 · Pinedale, WYAircraft control was not maintained. Factors to the accident were: rough water and downdrafts.NTSB SEA95FA011Accident · 4 fatalField investigationFinal reportCessna 310R · Rawlins, WYThe pilot-in-command's not maintaining clearance with terrain. Factors contributing to the accident were high terrain, dark night conditions, and the pilot-in-command's not obtaining/ maintaining the proper climb rate.NTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.NTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.NTSB SEA94LA210Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-109B · Rock Springs, WYAircraft control was not maintained. Factors to the accident were: high density altitude and wind gusts.NTSB SEA94LA187Accident · No injuriesLimited investigationFinal reportBeech P-35 · Laramie, WYLoss of engine power for undetermined reasons. Factors include fence posts struck during rollout at the emergency landing site.NTSB SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.NTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.NTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.NTSB SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB SEA94LA089Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Gillette, WYProcedures/directives were not followed and partial failure of the landing gear selector switch. A factor to the accident was an inoperative gear warning system.NTSB SEA94LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Evanston, WYThe pilot's inadequate compensation for wind conditions. Factors include gusty crosswind, and the pilot's lack of total experience.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.NTSB SEA94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cheyenne, WYThe pilot's improper use of the carburetor heat. A factor to the accident was carburetor icing conditions.NTSB SEA94LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Cheyenne, WYThe pilot's poor in flight decision. Factors include high winds, gusts, and the pilot's lack of total experience operating in high wind conditions.NTSB SEA94LA025Accident · No injuriesLimited investigationFinal reportCessna T210F · Sheridan, WYThe pilot did not obtain proper assistance after landing in high wing conditions. Factors contributing to the accident were the strong, gusty wind conditions.NTSB SEA94LA005Accident · No injuriesLimited investigationFinal reportCessna T182RG · Casper, WYInadequate maintenance and inspection of the hydraulic line resulting in a loss of hydraulic pressure.NTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.NTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.NTSB SEA93FA187Accident · 3 fatalField investigationFinal reportCessna 180 · Cheyenne, WYImproper in-flight planning/decison by the pilot, which resulted in exceeding the design stress limits of the aircraft after encountering adverse weather. The weather conditions were related factors.NTSB SEA93T#A03Accident · No injuriesClass 3Final reportBell 206L-1 · Crowheart, WYNTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.NTSB SEA93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Arlington, WYFuel contamination, directives not followed by the pilot in command, and his premature flare.NTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.NTSB SEA93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31ATC · Jackson Hole, WYThe pilot's selection of an empty fuel tank, and fuel starvation. Factors include rough/uneven terrain.NTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.NTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB SEA93LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Afton, WYA loss of engine power for an undetermined reason(s).NTSB SEA93LA107Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Cody, WYThe failure of the pilot to maintain directional control while hovering. Factors relating to the accident were the improper decision by the pilot, improper touchdown point selection, high density altitude, and wind gusts.NTSB SEA93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Casper, WYFuel exhaustion, and the pilot in command's poor inflight decision. Factors include an inadequate preflight by the pilot in command.NTSB SEA93FA088Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-35 · Casper, WYFailure of the pilot to maintain proper altitude during the night IFR approach in instrument meteorological conditions (IMC).NTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.NTSB SEA93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Riverton, WYThe pilot did not perform an abort of the takeoff after observing a partial loss of power. Factors include improper use of the mixture control.NTSB SEA93LA055Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Medicine Bow, WYFailure of the #7 cylinder rocker arm. Factors contributing to the accident were unsuitable terrain and dark night conditions.NTSB SEA93IA050Incident · No injuriesIncident investigationFinal reportBeech 1900C · Riverton, WYThe pilot's disorientation. Factors include snow, fog, snow covered terrain, and a drainage ditch.NTSB SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB SEA93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Moran Junction, WYThe pilot in command's attempting flight into known adverse weather conditions and his subsequent inability to maintain altitude. Factors contributing to the accident were icing conditions and trees.NTSB SEA93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Evanston, WYThe pilot's disregard of hazardous weather advisory, resulting in flt into forecast icing conditions in an acft not equipped or certified for the flt, and the improper inflt planning by pilot during the VFR approach that resulted in impact with terrain short…NTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.NTSB SEA92LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Smoot, WYThe pilot in command's delayed go-around. Factors contributing to the accident were the pilot in command's selection of unsuitable terrain and trees.