NTSB investigations, WY
58 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 6 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 DEN08CA019Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Wheatland, WYThe pilot's improper decision to execute an off-airport landing on a dirt road. A contributing factor was the soft terrain.NTSB DEN05FA125Accident · 2 fatalField investigationFinal reportCessna 177B · Centennial, WYthe pilot's improper in-flight planning/decision, in that he failed to maintain a steady state climb rate to a safe altitude and continued flight towards visible weather that obstructed his chosen route of flight, and his failure to maintain terrain…NTSB DEN04FA043Accident · 1 fatalField investigationFinal reportCessna T206H · Walcott, WYThe pilot not following proper IFR procedures for tracking a VOR radial while on an IFR flight plan in IMC conditions, and not maintaining clearance with terrain during cruise flight. Contributing factors were the mountain, and the cloudy weather condition.NTSB DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.NTSB DEN03FA002Accident · 1 fatalField investigationFinal reportCessna T210M · Laramie, WYthe pilot's improper inflight planning/decision, and his failure to maintain terrain clearance while attempting a low altitude maneuver. Contributing factors were the mountainous terrain, the airplane’s low altitude, and the pilot's lack of total instrument…NTSB DEN02FA080Accident · 2 fatalField investigationFinal reportCessna 177B · Crowheart, WYthe pilot's failure to maintain clearance of the high mountain terrain. Contributing factors were the high mountain terrain, and the high density altitude weather condition.NTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.NTSB DEN02LA027Accident · No injuriesLimited investigationFinal reportKnight BD-4 · Kemmerer, WYThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a snowbank. A contributing factor was the high crosswind.NTSB DEN01LA060Accident · No injuriesLimited investigationFinal reportBell 407 · Jackson, WYThe pilot's failure to maintain adequate lateral and vertical clearance during landing. Factors were the clouds and snow-covered high terrain.NTSB DEN00LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sheridan, WYThe pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.NTSB DEN00FA141Accident · 1 fatalField investigationFinal reportMooney M20K · Cheyenne, WYthe airplane's in-flight collision with hilly terrain for undetermined reasons.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 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 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 FTW98LA270Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Douglas, WYThe pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.NTSB FTW98LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Laramie, WYThe pilot's improper flare and subsequent improper go-around in that he failed to use compensating elevator control, and his loss of directional control.NTSB FTW97LA337Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Saratoga, WYThe pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.NTSB SEA97LA125Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Rawlins, WYThe pilot's failure to maintain clearance from the terrain during the initial climb after a night takeoff. Factors include a dark night and rising terrain off the departure end of the runway.NTSB SEA96LA081Accident · Minor injuriesLimited investigationFinal reportForth Acro 2 · Rock Springs, WYthe pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.NTSB SEA95FA136Accident · 1 fatalField investigationFinal reportAlon Aircoupe A-2 · Cody, WYThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course. A factor was the downdrafts encountered in the mountainous terrain.NTSB SEA95LA109Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Rawlins, WYThe pilot's failure to maintain a proper climb rate. Factors contributing to the accident were the high density altitude and the rising terrain.NTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.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 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 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 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 SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.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 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 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.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 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 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 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 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 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 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 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 DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.NTSB DEN86MA241Accident · 7 fatalMajor investigationFinal reportCessna 441 · Lander, WYOn 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.…NTSB DEN86FA223Accident · 1 fatalField investigationFinal reportCessna 172 · Ten Sleep, WYThe plt became lost/disoriented and inadvertently entered the narrow canyon in a mountain pass. He attempted to land on a public highway at 7,500 feet MSL when it became apparent the acft would not climb fast enough to clear rapidly rising terrain and that it…NTSB DEN86FA216Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lander, WYThe flt departed Lander, Wyoming, arpt in high density altitude conditions and in an over gross weight condition. The acft was observed flying low over rising terrain until it impacted the ground. The acft was destroyed in a post accident fire and two pax was…NTSB DEN86FA163Accident · 1 fatalField investigationFinal reportBeech C90A · Jackson, WYThe plt departed olathe, KS, en route to Jackson, WY. The plt radioed the denver efas and reported his position as 56 miles northwest of casper, WY. There was no further radio communication with N114CM. The plt's wife stated after the accident that the plt…NTSB DEN86FA149Accident · Serious injuriesField investigationFinal reportAmerican AA-1 Yankee · Cheyenne, WYDuring takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…NTSB DEN85FA225Accident · Serious injuriesField investigationFinal reportCessna 182J · Torrington, WYThe plt had a limitation on her certificate that prohibited flight at night. The flt was conducted at night and while enroute the plt diverted to the Torrington arpt. The rwy is equipped with plt activated lgts. A witness stated that the acft circled several…NTSB DEN85LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYThe student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's…NTSB DEN84LA176Accident · No injuriesLimited investigationFinal reportCessna 150M · Afton, WYThe plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt…NTSB DEN84LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Alpine, WYThe plt stated on takeoff at an alt of 10 ft AGL a loss of power occurred. During the forced landing the left skid contacted either the pad or an object on the pad and the acft rolled over to the left. The plt stated that white out condition occurred during…NTSB DEN84FA108Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Saratoga, WYDuring a night x-country after a 16 hour day the airline captain flying his own acft home collided with a mountain at the 10000 ft level. The weather was VMC but the winds aloft were strong and would have blown the acft towardthe mountain had no wind…