# NTSB investigations, WY: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 8 · 365 cases

## Latest cases

- [NTSB WPR26LA209](https://openairdocs.org/ntsb/WPR26LA209.md): Cirrus Design SR22T · Casper, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2026 · N324WY · Substantial damage
  > On June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA083](https://openairdocs.org/ntsb/WPR26LA083.md): Robinson R44 · Parkman, WY · Accident · No injuries · Class 4 · Limited · Final report · Jan 19, 2026 · N996NR · 2 aircraft · Substantial damage
  > The pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.
- [NTSB WPR26LA048](https://openairdocs.org/ntsb/WPR26LA048.md): Aviat A1 · Evanston, WY · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 4, 2025 · N96WJ · Substantial damage
  > The airplane’s encounter with downdrafts in mountainous terrain, which resulted in a collision with terrain. Contributing to the accident was the pilot’s decision to continue the flight through mountainous terrain in marginal weather conditions.
- [NTSB ANC25LA116](https://openairdocs.org/ntsb/ANC25LA116.md): Socata TBM 700 · Alpine, WY · Accident · No injuries · Class 4 · Limited · Final report · Sep 28, 2025 · N101NX · Substantial damage
  > The pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off airport landing.
- [NTSB ANC25FA098](https://openairdocs.org/ntsb/ANC25FA098.md): Piper PA-28-180 · Wolf, WY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 1, 2025 · N8307W · Substantial damage
  > On September 1, 2025 about 1612 mountain daylight time, a Piper PA-28-180 airplane, N8307W, was substantially damaged when it was involved in an accident near Wolf, Wyoming. The pilot and one passenger were seriously injured; one passenger was fatally…
- [NTSB DCA25LA276](https://openairdocs.org/ntsb/DCA25LA276.md): Airbus A330 · Creston, WY · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 30, 2025 · N422DZ · Minor damage
  > On July 30, 2025, at 1723 mountain daylight time, Delta Air Lines flight 56, an Airbus A330-941, encountered severe turbulence while in cruise flight at an altitude of 37,000 ft near Creston, Wyoming. After determining that injuries had occurred, the flight…
- [NTSB WPR25FA079](https://openairdocs.org/ntsb/WPR25FA079.md): Piper PA-24-250 · Rock Springs, WY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 14, 2025 · N6502P
  > On January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB WPR24FA291](https://openairdocs.org/ntsb/WPR24FA291.md): American Champion 8GCBC · Meeteetse, WY · Accident · 1 fatal · Class 3 · Field · Final report · Sep 1, 2024 · N23BD · Destroyed
  > The pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.
- [NTSB WPR23LA283](https://openairdocs.org/ntsb/WPR23LA283.md): Beech C35 · Rock Springs, WY · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 20, 2023 · N620D · Substantial damage
  > Maintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.
- [NTSB WPR23FA188](https://openairdocs.org/ntsb/WPR23FA188.md): Cessna T182T · Albany, WY · Accident · 2 fatal · Class 3 · Field · Final report · May 14, 2023 · N665B · Destroyed
  > The pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…
- [NTSB WPR23FA137](https://openairdocs.org/ntsb/WPR23FA137.md): Cessna 182S · Alcova, WY · Accident · 1 fatal · Class 3 · Field · Final report · Mar 21, 2023 · N314FR · Substantial damage
  > The airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.
- [NTSB WPR23LA016](https://openairdocs.org/ntsb/WPR23LA016.md): Quickie Q2 · Laramie, WY · Accident · No injuries · Class 3 · Limited · Final report · Oct 14, 2022 · C-GDHK · Substantial damage
  > The partial loss of engine power due to the seizure of the No. 1 cylinder exhaust valve in the valve guide.
- [NTSB WPR22LA352](https://openairdocs.org/ntsb/WPR22LA352.md): Jacquneaux Glen R CGS Hawk · Lander, WY · Accident · No injuries · Class 3 · Limited · Final report · Sep 15, 2022 · N5148G · Substantial damage
  > A reported severe airframe vibration and subsequent forced landing for reasons that could not be determined because the wreckage was not made available for examination.
- [NTSB WPR22LA334](https://openairdocs.org/ntsb/WPR22LA334.md): Buxbaum Mark Edward Long EZ · Medicine Bow, WY · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 5, 2022 · N444MR · Substantial damage
  > A partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.
- [NTSB WPR22LA253](https://openairdocs.org/ntsb/WPR22LA253.md): Cessna P210N · Buffalo, WY · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 14, 2022 · N731BJ · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into localized instrument meteorological conditions, which resulted in an encounter with convective turbulence and a subsequent loss of control and in-flight breakup.
- [NTSB WPR21LA108](https://openairdocs.org/ntsb/WPR21LA108.md): Abbett Gerry Lancair Evolution · Saratoga, WY · Accident · No injuries · Class 3 · Limited · Final report · Feb 8, 2021 · N7569A · Substantial damage
  > A windshield failure during cruise flight due to stress concentrations in the bond area as a result of improper assembly of the windshield.
- [NTSB WPR20CA262](https://openairdocs.org/ntsb/WPR20CA262.md): Head AX8 88 · Jackson, WY · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 3, 2020 · N45303 · Minor damage
  > The balloon pilot’s inability to maintain altitude during un-forecasted weather, which resulted in a hard landing.
- [NTSB CEN19FA305](https://openairdocs.org/ntsb/CEN19FA305.md): Champion 7GCBC · Carpenter, WY · Accident · 1 fatal · Class 3 · Field · Final report · Sep 7, 2019 · N5502S · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.
- [NTSB WPR19LA088](https://openairdocs.org/ntsb/WPR19LA088.md): Lancair IV · Laramie, WY · Accident · No injuries · Class 3 · Limited · Final report · Feb 10, 2019 · N549CJ · Substantial damage
  > An environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.
- [NTSB CEN18LA373](https://openairdocs.org/ntsb/CEN18LA373.md): Cessna T310 · Laramie, WY · Accident · No injuries · Class 4 · Limited · Final report · Sep 6, 2018 · N376J · Substantial damage
  > The pilot’s failure to properly adjust the fuel/air mixtures, which resulted in a partial loss of engine power to both engines due to fuel starvation and a subsequent forced landing to a field.
- [NTSB CEN18LA225](https://openairdocs.org/ntsb/CEN18LA225.md): Rockwell International 112TC · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jun 14, 2018 · N4954W · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA18CA330](https://openairdocs.org/ntsb/GAA18CA330.md): Sorensen Danny S BF9 2 · Evanston, WY · Accident · No injuries · Data collection · Final report · May 31, 2018 · N81973 · Substantial damage
  > The pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustion
- [NTSB CEN17LA356](https://openairdocs.org/ntsb/CEN17LA356.md): Cessna R182 · Worland, WY · Accident · No injuries · Limited investigation · Final report · Sep 12, 2017 · N1835R · Substantial damage
  > The pilot's decision to operate an airplane with unreliable fuel gauges and the worn fuel cap seal that allowed fuel to siphon from the left wing fuel tank, which ultimately resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN15LA407](https://openairdocs.org/ntsb/CEN15LA407.md): Alon A2 · Laramie, WY · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 2015 · N6359V · Substantial damage
  > The pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…
- [NTSB CEN15FA307](https://openairdocs.org/ntsb/CEN15FA307.md): Cessna T310R · Cody, WY · Accident · 4 fatal · Field investigation · Final report · Jul 18, 2015 · N72TP · Destroyed
  > The pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.
- [NTSB WPR14FA188](https://openairdocs.org/ntsb/WPR14FA188.md): Mooney M20C · Cody, WY · Accident · 2 fatal · Field investigation · Final report · May 6, 2014 · N6704U · Substantial damage
  > The non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.
- [NTSB WPR14LA240](https://openairdocs.org/ntsb/WPR14LA240.md): Cessna T207A · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · May 5, 2014 · N323JC · Substantial damage
  > Maintenance personnel’s application of insufficient torque to the engine cylinder through bolts during replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 main bearing, the bearing shifting, and a catastrophic engine failure.
- [NTSB DCA14LA060](https://openairdocs.org/ntsb/DCA14LA060.md): Boeing 737 · Kaycee, WY · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 2014 · N23708 · No damage
  > an encounter with severe mountain wave turbulence during cruise flight.
- [NTSB WPR13CA381](https://openairdocs.org/ntsb/WPR13CA381.md): Cessna 172E · Meeteetse, WY · Accident · Minor injuries · Data collection · Final report · Aug 20, 2013 · N516MA · Substantial damage
  > The student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of situational awareness.
- [NTSB WPR13FA138](https://openairdocs.org/ntsb/WPR13FA138.md): Cessna 172M · Saratoga, WY · Accident · 1 fatal · Field investigation · Final report · Mar 3, 2013 · N5129R · Substantial damage
  > The pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…
- [NTSB WPR13FA053](https://openairdocs.org/ntsb/WPR13FA053.md): Cessna 182D · Bondurant, WY · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2012 · N61LN · Destroyed
  > The noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.
- [NTSB WPR13IA059](https://openairdocs.org/ntsb/WPR13IA059.md): Bell 407 · Riverton, WY · Incident · No injuries · Incident investigation · Final report · Nov 15, 2012 · N7160V · Minor damage
  > The pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.
- [NTSB WPR13FA008](https://openairdocs.org/ntsb/WPR13FA008.md): Piper PA-32R-301T · Laramie Peak, WY · Accident · 4 fatal · Field investigation · Final report · Oct 9, 2012 · N110UM · Destroyed
  > The noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.
- [NTSB WPR12LA392](https://openairdocs.org/ntsb/WPR12LA392.md): Cessna 210 · Kemmerer, WY · Accident · No injuries · Limited investigation · Final report · Aug 30, 2012 · N7321E · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.
- [NTSB WPR12LA341](https://openairdocs.org/ntsb/WPR12LA341.md): Fairchild Hiller FH-1100 · Cody, WY · Accident · No injuries · Limited investigation · Final report · Jul 31, 2012 · N5038F · Substantial damage
  > The failure of a tail rotor driveshaft coupling due to fatigue.
- [NTSB WPR12LA309](https://openairdocs.org/ntsb/WPR12LA309.md): Beech A36 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Jun 22, 2012 · N4972M · Substantial damage
  > The total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…
- [NTSB WPR12LA256](https://openairdocs.org/ntsb/WPR12LA256.md): Ayres S2R-G6 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Jun 11, 2012 · N70WY · Substantial damage
  > An engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR12LA161](https://openairdocs.org/ntsb/WPR12LA161.md): Piper PA-28-181 · Casper, WY · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 2012 · N30997 · Substantial damage
  > A total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…
- [NTSB WPR11FA381](https://openairdocs.org/ntsb/WPR11FA381.md): Beech A36 · Lander, WY · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2011 · N324AT · Destroyed
  > The pilot’s failure to maintain clearance from mountainous terrain.
- [NTSB WPR11CA399](https://openairdocs.org/ntsb/WPR11CA399.md): Richmond Jim R CCK-1865 · Dubois, WY · Accident · No injuries · Data collection · Final report · Aug 12, 2011 · N56WY · Substantial damage
  > The pilot's failure to maintain clearance from a wire during cruise flight.
- [NTSB WPR11CA327](https://openairdocs.org/ntsb/WPR11CA327.md): Cessna 150J · Wheatland, WY · Accident · Minor injuries · Data collection · Final report · Jul 13, 2011 · N60060 · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to continue flight with known equipment deficiencies.
- [NTSB WPR11LA233](https://openairdocs.org/ntsb/WPR11LA233.md): Palmer RV6A · Cody, WY · Accident · Serious injuries · Limited investigation · Final report · May 21, 2011 · N52VC · Substantial damage
  > The pilot’s failure to maintain sufficient altitude to avoid rising terrain. Contributing to the accident was the pilot’s visual illusion and disorientation due to the flat light conditions.
- [NTSB WPR11FA228](https://openairdocs.org/ntsb/WPR11FA228.md): Bellanca 17-30A · Rock Springs, WY · Accident · 2 fatal · Field investigation · Final report · May 18, 2011 · N93577 · Substantial damage
  > The pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.
- [NTSB WPR11FA188](https://openairdocs.org/ntsb/WPR11FA188.md): Aviat A-1C-180 · Laramie, WY · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2011 · N28WY · Substantial damage
  > The pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.
- [NTSB WPR11FA082](https://openairdocs.org/ntsb/WPR11FA082.md): Aero Commander 114B · Lander, WY · Accident · 3 fatal · Field investigation · Final report · Dec 22, 2010 · N799RS · Substantial damage
  > The non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…
- [NTSB WPR11LA038](https://openairdocs.org/ntsb/WPR11LA038.md): Cessna T210N · Baggs, WY · Accident · No injuries · Limited investigation · Final report · Nov 6, 2010 · N6179Y · Substantial damage
  > The failure of a connecting rod cap retaining bolt during cruise flight, which resulted in a loss of engine power.
- [NTSB WPR11FA032](https://openairdocs.org/ntsb/WPR11FA032.md): Mooney M20J · Lander, WY · Accident · 4 fatal · Field investigation · Final report · Oct 25, 2010 · N201HF · Substantial damage
  > The pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…
- [NTSB WPR09CA348](https://openairdocs.org/ntsb/WPR09CA348.md): Cessna 172M · Thermopolis, WY · Accident · Serious injuries · Data collection · Final report · Jul 16, 2009 · N5461Q · Substantial damage
  > The instructor pilot's failure to ensure that his dual student maintained clearance from the terrain during a dark night visual flight rules descent.
- [NTSB WPR09CA193](https://openairdocs.org/ntsb/WPR09CA193.md): Piper PA-28-140 · Dubois, WY · Accident · Minor injuries · Data collection · Final report · Apr 13, 2009 · N945RH · Substantial damage
  > The pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.
- [NTSB WPR09CA051](https://openairdocs.org/ntsb/WPR09CA051.md): Beech B60 · Rock River, WY · Accident · No injuries · Data collection · Final report · Nov 29, 2008 · N6693A · Substantial damage
  > The pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=WY&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=WY

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.