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 DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.NTSB DEN90IA072Incident · No injuriesIncident investigationFinal reportCessna 208A · Wright, WYThe incident was engine failure due to gas producer turbine disc blade failure caused by stress rupture.NTSB DEN90LA026Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Gillette, WYForced landing in unsuitable terrain as a result of an engine crankshaft failure at low level cruise flight.NTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…NTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB DEN89LA153Accident · No injuriesLimited investigationFinal reportStitts SA7D · Evanston, WYImproper compensation by the pilot for wind conditions. Contributing factors were: high density altitude, unfavorable wind, and downdraft.NTSB DEN89LA147Accident · No injuriesLimited investigationFinal reportBeech A24R · Evanston, WYThe pilot became disoriented and delayed in taking remedial action, which resulted on a critically low fuel level. A factor related to the accident was: rough/uneven terrain in the emergency landing area.NTSB DEN89FA146Accident · 1 fatalField investigationFinal reportBeech 35 · Glenrock, WYProper altitude not maintained by the pilot. The weather/night conditions and pilot fatigue were considered to be contributing factors.NTSB DEN89LA122Accident · No injuriesLimited investigationFinal reportCessna 175 · Sheridan, WYBinding (stuck) #4 exhaust valve. High vegetation (hay) and a hidden obstruction (ditch) were contributing factors.NTSB DEN89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Cheyenne, WYFailure of the pilot-in-command to properly recover from a bounced landing.NTSB DEN89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Evanston, WYThe failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.NTSB DEN89LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYImproper planning/decision by the pilot. Factors related to the accident were the high wind and gusts, which he was unable to compensate for.NTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…NTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…NTSB DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…NTSB DEN89LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Riverton, WYThe instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…NTSB DEN89LA006Accident · No injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Rawlins, WYThe pvt plt in command and his atp-rated pax were ferrying the newly-purchased acft from FL to WA. They departed scottsbluff, NE, and were enroute to rock springs, WY, when the pax advised the plt insufficient VFR fuel reserves precluded continuing to rks.…NTSB DEN88FA202Accident · 1 fatalField investigationFinal reportBeech 200 · Jackson, WYThe plt and his two pax had just arrived at the Jackson hole airport (jax) approximately 30 minutes prior to the accident. The plt dropped off his pax and stepped into operations for a short break. He then returned to the acft by himself for a return flt to…NTSB DEN88LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYPlt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was…NTSB DEN88FA193Accident · 2 fatalField investigationFinal reportMooney M20F · Jackson Hole, WYThe pvt plt obtained his instrument rating 14 days prior to the accident. 12 hrs of actual instrument flt time was logged in March of 1987. The remaining instrument flt time was simulated. Visibility in the Jackson Hole area was reduced by smoke. The plt…NTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYNTSB DEN88LA184Accident · No injuriesLimited investigationFinal reportCessna A185F · Medicine Bow, WYThe pvt plt returned to his ranch strip & landed to the ene with a x-wind from the right. Drg the lndg roll, the acft began to go to the right. The plt corrected with left pedal, but subsequently, the acft ground looped to the left & nosed over. An exam of…NTSB DEN88LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Casper, WYDrg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,…NTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…NTSB DEN88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Gillette, WYNTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…NTSB DEN88FA151Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dubois, WYNTSB DEN88LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Cheyenne, WYThe flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…NTSB DEN88LA123Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Encampment, WYThe plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as…NTSB DEN88FA121Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rock Springs, WYShortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The…NTSB DEN88FA114Accident · 2 fatalField investigationFinal reportBeech D-17S · Wheatland, WYThe witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…NTSB DEN88LA092Accident · No injuriesLimited investigationFinal reportCessna 210L · Cheyenne, WYThe CFI was giving a checkout to the private pilot doctor. The CFI flight records showed only one hour in this make/model. The fuel selector was in the right tank position throughout the flight. The pilot reported that the engine quit on one mile short final…NTSB DEN88LA066Accident · No injuriesLimited investigationFinal reportPiper J3C · Cody, WYDuring an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and…NTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…NTSB DEN88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Riverton, WYThe instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an…NTSB DEN88FA128Accident · 2 fatalField investigationFinal reportCessna 177RG · Afton, WYThe acft was not certified nor equipped for flt into icing conditions. The plt elected to depart even though he was advised by the crew of a C-182 that had just lndd to stay below the clouds because of icing. After tkof the acft cleared an 11000 ft mtn range…NTSB DEN87DTI02Accident · No injuriesFinal reportBakeng Deuce · Gillette, WYThe plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &…NTSB DEN87FA237Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Pinedale, WYThe plt and two passengers had flown to Pinedale to fish. The plt stated that he was cruising at an alt of 400 ft AGL and was executing a rt turn at the request of a pax. He stated that he slowed the acft, decreased the collective, and added rt pedal as he…NTSB DEN87DTI01Accident · No injuriesFinal reportCessna A188B · Basin, WYThe plt was taking off on a private, 2300 ft, dirt, ag strip with a load of chemicals. The arpt elev was 4185 ft & the rprtd temp was 74 deg. The plt said the wind was calm when he began his takeoff roll, but about 3/4 of the way down the rwy, the acft…NTSB DEN87LA199Accident · Serious injuriesLimited investigationFinal reportBell 204B · Dubois, WYThe commercial plt was performing external sling loads in support of seismic operations. The plt reported that the engine failed during a load release and the plt executed an autorotation. This resulted in a hard landing in heavy timber on sloping terrain.…NTSB DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.NTSB DEN87FA162Accident · 4 fatalField investigationFinal reportCessna 421C · Cody, WYThe plt & 3 paxs were returning to dallas, TX from a retreat in Montana. The plt filed an IFR flt plan from white sulphur springs, MT, to casper, WY, but did not activate it after departure. The acft was rprtd overdue by family & a search was initiated. The…NTSB DEN87IA145Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Casper, WYBoeing 727 (northwest flt 354) & USAF EC-135 (slum 51) were involved in a nr collision at FL 330. The mishap occurred asflt 354 was ene bnd on J-158 & slum 51 was flying on a radial-distance (r/d) flt pln, flying btn r/d pts south of J-158.as slum 51 apchd…NTSB DEN87LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Upton, WYThe plt reported completing a cross wind landing with strong gusts. While taxiing from landing, the wind lifted the acft from the right and it nosed over. The rwy used was 13, and the FBO reported winds as 210 degrees at 20 knots, gusting to 40 knots.NTSB DEN87FA130Accident · 3 fatalField investigationFinal reportPiper PA-31T-620II · Cody, WYN2336X was on a business flt to Cody, WY. The pilot executed a missed approach on the first attempt of the vor-a approach. A pilot who landed at Cody minutes before the accident said the visibility had decreased to 3/4 of a mi when N2336X made the first…NTSB DEN87LA113Accident · No injuriesLimited investigationFinal reportBeech A24R · Beulah, WYThe acft lost power during a normal climb on a personal trip. The private plt noticed a drop in fuel flow pressure and smelled fuel. The plt then selected boost pump on but the pressure stayed low. The plt elected to make a forced landing and selected a…