OpenAirDocs.org

NTSB investigations, WY

135 cases where the phase of flight was Approach.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 500)
  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.

NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.Jan 29, 2026 · N59SE · Substantial damageNTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.Jun 30, 2025 · N124GH · Substantial damageNTSB WPR24LA205Accident · Minor injuriesClass 3 · LimitedFinal reportReplica PA-12 Replica · Douglas, WYA loss of power due to fuel exhaustion as a result of the pilot’s failure to calibrate the fuel flow indicator.Jun 22, 2024 · N406Z · Substantial damageNTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…May 30, 2022 · N44508 · DestroyedNTSB WPR20LA110Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Pinedale, WYA loss of airplane control during approach for reasons that could not be determined based on available evidence.Mar 16, 2020 · N4837Z · Substantial damageNTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.Feb 18, 2018 · N700VX · DestroyedNTSB GAA17CA518Accident · No injuriesData collectionFinal reportCroft Robert C Kitfox Super Sport · Afton, WYThe pilot’s failure to maintain bank control during an attempted go-around.Sep 2, 2017 · N429NC · Substantial damageNTSB WPR13FA405Accident · 2 fatalField investigationFinal reportKamtz RV-7A · Jackson Hole, WYA loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Also causal was the pilot’s failure to adequately compensate for the…Sep 11, 2013 · N820RV · Substantial damageNTSB WPR13LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rock Springs, WYThe pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism.Jan 18, 2013 · N49DS · Substantial damageNTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.Sep 21, 2012 · N423RA · DestroyedNTSB WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.Nov 18, 2011 · N357 · Substantial damageNTSB WPR11LA346Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Torrington, WYThe carburetor’s failure to meet its operating limits at the low range, which resulted in a loss of engine power when the pilot reduced power for landing.Jul 25, 2011 · N4911K · Substantial damageNTSB LAX08CA189Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot's failure to attain and maintain an adequate airspeed during a go around, that resulted in a stall/mush. Contributing to the accident was the tailwind condition.Jun 24, 2008 · N877CM · Substantial damageNTSB DEN08LA027Accident · Serious injuriesLimited investigationFinal reportAgusta A119 · Cody, WYA loss of engine power while on approach for undetermined reasons. Contributing to this accident was the high density altitude.Nov 6, 2007 · C-GNSR · Substantial damageNTSB DEN07LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Basin, WYThe carburetor icing causing a partial loss of engine power, and the pilot's failure to maintain aircraft control leading to the inadvertent stall. A factor contributing to the accident was the conditions conducive for carburetor icing.Jul 25, 2007 · N88247 · Substantial damageNTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.May 30, 2006 · N16JD · Substantial damageNTSB DEN06LA005Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kaycee, WYthe pilot's improper decision to attempt a go-around and the pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was the hard landing.Oct 21, 2005 · N6QR · Substantial damageNTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.Aug 27, 2005 · N91245 · Substantial damageNTSB DEN05FA100Accident · 1 fatalField investigationFinal reportCGS Hawk Two Place Arrow · Jackson, WYThe loss of airplane pitch control resulting from the pilot/owner's improper reinstallation of the rear locking collar on the elevator control torque tube, which allowed the torque tube to move rearward during flight and loosen the elevator control cable…Jun 27, 2005 · UNREG · DestroyedNTSB DEN05FA051Accident · 3 fatalField investigationFinal reportBeech BE-90 · Rawlins, WYThe pilot's inadvertent flight into adverse weather [severe icing] conditions, resulting in an aerodynamic stall impact with rising, mountainous terrain during approach. A factor contributing to the accident was the pilot's inadequate planning for the…Jan 12, 2005 · N41WE · DestroyedNTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…Jul 3, 2004 · N2KD · Substantial damageNTSB DEN04FA074Accident · 2 fatalField investigationFinal reportPiper PA-30 · Evanston, WYthe pilot's failure to maintain terrain clearance. Contributing factors include snow, low ceiling, icing conditions, and the dark night.May 24, 2004 · N7460Y · DestroyedNTSB DEN04MA015Accident · 1 fatalMajor investigationFinal reportCessna 208B · Cody, WYthe pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.Oct 29, 2003 · N791FE · Substantial damageNTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.Sep 7, 2003 · N6384B · Substantial damageNTSB DEN03FA125Accident · 2 fatalField investigationFinal reportCASA 2.111 · Cheyenne, WYA loss of engine power for reasons undetermined, and the pilot's failure to maintain aircraft control. Contributing factors were the unsuitable terrain on which to make a forced landing, low airspeed, the fence, automobile, and the school bus wash barn.Jul 10, 2003 · N72615 · DestroyedNTSB DEN03FA040Accident · 1 fatalField investigationFinal reportBeech V35B · Rock Springs, WYthe pilot's failure to maintain adequate airspeed, resulting in a stall. Factors contributing to the accident were the icing conditions, low altitude, and the high gusting winds.Jan 30, 2003 · N935V · DestroyedNTSB DEN02LA071Accident · No injuriesLimited investigationFinal reportCessna T206H · Jackson, WYthe engine failure for undetermined reasons and the pilot's failure to maintain aircraft control during the forced landing attempt. A factor contributing to the accident was the inadvertent stall.Jul 6, 2002 · N2453V · Substantial damageNTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.Feb 7, 2001 · N59CF · Substantial damageNTSB SEA97LA021Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Laramie, WYVFR flight by the pilot into instrument meteorological conditions (IMC), his misjudged speed/distance on final approach for landing, and his failure to attain the proper touchdown point during the landing. Factors relating to the accident include snow, low…Oct 25, 1996 · N5664Y · Substantial damageNTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.Jul 25, 1995 · N9492T · Substantial damageNTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.Jul 17, 1995 · N3165B · Substantial damageNTSB SEA95FA101Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cheyenne, WYfailure of the pilot to maintain sufficient altitude/clearance from rising terrain. Factors relating to the accident were: low light conditions at dusk, low ceilings with thunderstorms in the area, and continued flight by the pilot into adverse weather…May 17, 1995 · N2883D · DestroyedNTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.Jan 19, 1995 · N5603S · Substantial damageNTSB 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.May 28, 1994 · N2582G · DestroyedNTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.Aug 18, 1993 · N2125S · Substantial damageNTSB 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.Jun 30, 1993 · N127WZ · Substantial damageNTSB 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.Apr 6, 1993 · N5541P · Substantial damageNTSB 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).Apr 6, 1993 · N96JP · DestroyedNTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.Jul 29, 1992 · N303VK · Substantial damageNTSB SEA91LA112Accident · No injuriesLimited investigationFinal reportCessna 172P · Alva, WYThe pilot's overconfidence in his personal ability, overconfidence in the aircraft's ability. Contributing to the accident was the engine failure.May 21, 1991 · N172GA · Substantial damageNTSB 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.Dec 18, 1990 · N4082H · DestroyedNTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.Oct 28, 1990 · N4981C · Substantial damageNTSB 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.Mar 1, 1989 · N11009 · Substantial damageNTSB DEN88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Gillette, WYJul 15, 1988 · N5903B · Substantial damageNTSB 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…May 28, 1988 · N1038M · DestroyedNTSB 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…Apr 5, 1988 · N910DS · Substantial damageNTSB 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…Dec 26, 1987 · N211T · Substantial damageNTSB 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…May 20, 1987 · N2336X · DestroyedNTSB DEN87FA017Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Cheyenne, WYThe plt and his two pax were on a VFR x-country to scottsbluff, NE, when IMC was encountered near grand junction, CO. The plt then called ATC and obtained an IFR clearance. The plt elected to land at Cheyenne, WY. Wx was reported to be 500 overcast, 1/4 mi…Nov 7, 1986 · N8216V · Substantial damageNTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…Sep 27, 1985 · N5322U · No damage