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 LAX82AA259Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · Morton, WYWhile flying in good wx over central Wyoming, the captain noted a gentle wave motion that caused the autothrottles to react. Therefore, he disengaged the autothrottles and autopilot. The acft had lost 250 ft drg the wave motion, so the captain turned on the…NTSB DEN82DA130Accident · Serious injuriesFinal reportAerospatiale SA316B · Meeteetse, WYPrior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was…NTSB DEN82DA126Accident · No injuriesFinal reportAerospatiale SA 315B · Big Piney, WYThe pilot stated that he felt a shudder while he was taking off with a long line attached. He began a descent, and when the helicopter was about 5 ft above the ground, the long line caught a tree. Subsequently, the helicopter pitched nose down and the rotor…NTSB DEN82DA125Accident · Minor injuriesFinal reportErcoupe 415-C · Wamsutter, WYThe pilot became sick during the flight and elected to land on a highway. He took spacing behind a truck, but the truck slowed down, so he continued the landing beside the highway. After lowering the nosewheel, it hit a ditch and collapsed, and the aircraft…NTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.NTSB DEN82DA105Accident · No injuriesFinal reportPiper PA-20 · Near Rawlins, WYThe pilot stated that he had landed on a blacktop road, but opted to takeoff on a gravel road because of the proximity of reflector posts to the wings. He stepped off the road and estimated that he had about 800 ft for takeoff. The density altitude was about…NTSB DEN82FTC05Accident · Minor injuriesFinal reportBell 47G-3B · Douglas, WYThe pilot reported that he made a normal approach to the landing site near his loading dock. When he touched down, the helicopter as on a slope, so he picked the craft back up to a hover. Reportedly, he was moving the helicopter about 4 ft forward to a more…NTSB DEN82IA103Incident · No injuriesIncident investigationFinal reportGrumman G-159C · Gillette, WYThe acft was on a scheduled, domestic, pax flt. The coplt was the company's chief plt and was flyng the acft from the left seat. He was under supervision of the pilot-in-command (PIC) who was in the rt seat. Drg arrival, the crew elected to make a…NTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…NTSB DEN82DA092Accident · No injuriesFinal reportCessna 180D · Gillette, WYThe aircraft swerved off the runway to the left 1500 feet from the approach end and the right main gear collapsed. Examination revealed three of five "brake anti-rattle clips" were missing from each brake assembly, allowing the brake disk to wabble.…NTSB DEN82IA090Incident · No injuriesIncident investigationFinal reportGulfstream American G-159C · Gillette, WYDuring arrival, a thunderstorm was located about 6 mi southeast of the airport and another was about 8 to 10 mi northwest. Reportedly, the wind was variable from 090 to 180 deg at 10, gusting 25 KTS. While landing on a 75 ft wide runway, the aircraft began to…NTSB DEN82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Medicine Bow, WYDuring takeoff from a muddy field with a density altitude of 7253 feet the aircraft failed to clear a boundary fence. The passengers stated the stall warning sounded steadily from takeoff until impact with the ground. After the collision with the fence the…NTSB DEN82DA078Accident · No injuriesFinal reportCessna 182M · Lovell, WYAfter landing on a dirt road to talk to a sheep herder, the aircraft was taxied off the road. A gust of wind picked the tail of the aircraft up and turned the aircraft over. The pilot reported winds were from 135 degees at 20 knots gusting to 30 knots.NTSB DEN82FA075Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Wheatland, WYThe acft struck a tree approximately 1/2 mi from the approach end of rwy 08. No fuel was on board the acft. The gear were down & the flaps were in the 10 deg position.NTSB DEN82DA076Accident · No injuriesFinal reportFunk B75L · Laramie, WYAccording to the pilot, when the aircraft was in a mountain pass about 10 mi from the departure point, it was caught by a downdraft. Reportedly, he was forced to land on a dirt trail. During the landing, the aircraft was substantially damaged.NTSB DEN82DA072Accident · No injuriesFinal reportEnstrom 280-C · Granger, WYThe aircraft's engine backfired and quit during takeoff. The pilot cleared a fence and during the forced landing the gear collapsed. No engine malfunction or failure could be found.NTSB DEN82FTC03Accident · Serious injuriesFinal reportAerospatiale SA315B · Big Piney, WYThe acft was engaged in seismic activity supplying explosives by long line. The eng failed at about 400-500 ft AGL. The load was released & an open field was selected. At about 150 ft AGL the plt was unable to maintain rotor RPM & the acft impacted the ground…NTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…NTSB DEN82DA068Accident · No injuriesFinal reportCessna 182A · 20mn Of Jackson, WYThe pilot reported that he became involved in a deteriorating weather condition while maneuvering in a mountainous area. He attempted to return to the departure airport, but the weather conditions (snowshowers) became worse. He elected to make a precautionary…NTSB DEN82DA045Accident · Minor injuriesFinal reportCessna 180J · Casper, WYAfter arriving, the pilot landed on runway 07 in variable wind conditions with gusts to 20 knots. After touchdown, he encountered a crosswind gust, became airborne, and ballooned about 3 ft. he added a slight amount of power to control the aircraft and make a…NTSB DEN82FTC02Accident · Minor injuriesFinal reportCessna 210M · Cheyenne, WYThe pilot initiated his takeoff on runway 12 from an intersection with runway 16. From this intersection, there was 2175 ft or runway remaining. During the takeoff, the aircraft struck the roof of a garage about 360 ft from the departure end of the runway.…NTSB DEN82DA041Accident · No injuriesFinal reportBellanca 7GCBC · Thermopolis, WYDuring a landing in a hay meadow the pilot touched down long, due to a tailwind, and turned uphill to avoid hitting a fence and ditch. The aircraft ground looped breaking the right wheel strut.NTSB DEN82DA028Accident · Serious injuriesFinal reportPiper PA-32 · Rock Springs, WYThe aircraft departed vernal,ut at 1810 MST after refueling. During the VFR flight the pilot reported to Rock Springs fss that he was 20 miles south and was given current weather and runway in use. No other transmissions were received. The aircraft struck a…NTSB DEN82DA025Accident · No injuriesFinal reportCessna 172 · Near Gillete, WYThe purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid…NTSB DEN82DA022Accident · No injuriesFinal reportBell/Textron 206 L-1 · 36 Sw Laramie, WYAfter a precautionary landing on a road due to snow, wind and reduced visibility the pilot tookoff when he decided conditions had improved. Shortly after takeoff the visibility worsened and during the execution of a 180 degree turn the pilot stated the engine…NTSB DEN82DA021Accident · No injuriesFinal reportHughes 269C · Bondurant, WYThe pilot stated that he became disoriented in a white out condition due to blowing snow during a landing attempt. He then lowered the collective to stop the blowing snow and the left side of the helicopter broke through the crust of a four foot thick snow…NTSB DEN82FA017Accident · 4 fatalField investigationFinal reportCessna 210N · Riverton, WYThe acft impacted a hill immediately after taking off. The wreckage was located 8,000 ft beyond the departure end of rwy 28 & 1,800 ft left of the rwy centerline extended. The accident site was approximately 55 ft above the airport elevation. Witnesses…NTSB DEN82DA015Accident · No injuriesFinal reportBeech 35 · Jackson, WYThe temperature was approximately a minus 15 degrees fahrenheit. The pilot reported the engine was preheated for 30 minutes and that everything was in the green before takeoff. Shortly after takeoff, the engine began to overspeed. The pilot throttled back and…NTSB DEN82FA009Accident · No injuriesClosedAerospatial SA316B · Cokeville, WYNTSB DEN82FA006Accident · 2 fatalClosedMitsubishi MU-2B · Saratoga, WYNTSB DEN82FTC01Accident · No injuriesClosedPiper PA-28 · Powell, WYNTSB DEN81FTC28Accident · No injuriesClosedPiper PA-18 · 25m S Gillette, WYNTSB DEN81FTC25Accident · Minor injuriesClosedBeech H18S · Gillette, WYNTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYNTSB DEN81FTC26Accident · Minor injuriesClosedHughes 369D · Cokeville, WYNTSB DEN81AA064Accident · 5 fatalClosedMitsubishi MU-2B · Riverton, WYNTSB DEN81FA062Accident · Minor injuriesClosedHughes 369D · Afton, WYNTSB DEN81FTC24Accident · Minor injuriesClosedCessna 177RG · Cheyenne, WYNTSB DEN81FA061Accident · 3 fatalClosedPiper PA-28 · 40 Mi S Casper, WYNTSB DEN81FA060Accident · 1 fatalClosedCessna T207 · Casper, WYNTSB DEN81FA059Accident · Serious injuriesClosedBell 206-B3 · Alpine, WYNTSB DEN81DTC23Accident · No injuriesClosedPiper PA-12 · Cody, WYNTSB DEN81FA057Accident · 1 fatalClosedAerospatial 316B · Alpine, WYNTSB DEN81DTC22Accident · No injuriesClosedPiper PA-28 · Ft Bridger, WYNTSB DEN81FTC21Accident · Serious injuriesClosedPiper PA-28 · Rawlins, WYNTSB DEN81FTC20Accident · Minor injuriesClosedPiper PA-28 · Sundance, WYNTSB DEN81FA051Accident · 2 fatalClosedPiper PA-16 · Ten Sleep, WYNTSB DEN81FTC19Accident · No injuriesClosedCessna 180 · Thayne, WYNTSB DEN81FTC17Accident · Minor injuriesClosedCessna TR182 · Cheyenne, WYNTSB DEN81FTC18Accident · Minor injuriesClosedAerospatle SA315B · Meeteetse, WY