# NTSB investigations, UT: Maneuvering

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 6 · 276 cases

## Latest cases

- [NTSB ANC26FA079](https://openairdocs.org/ntsb/ANC26FA079.md): Helicopter Transport Services CH-54A · Cove Fort, UT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N793HT · Destroyed
  > On August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…
- [NTSB WPR26LA180](https://openairdocs.org/ntsb/WPR26LA180.md): Cessna 172 · Marysvale, UT · Accident · Serious injuries · Class 4 · Limited · Final report · May 10, 2026 · N6643A · Destroyed
  > The pilot's failure to maintain clearance from trees while maneuvering in mountainous terrain prior to encountering a downdraft.
- [NTSB WPR26LA174](https://openairdocs.org/ntsb/WPR26LA174.md): American Champion 7GCBC · Big Water, UT · Accident · Minor injuries · Class 4 · Limited · Final report · May 1, 2026 · N400KB · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and exceedance of the airplanes critical angle of attack while maneuvering at a low altitude, which resulted in a subsequent stall and impact with trees during stall recovery.
- [NTSB WPR26LA104](https://openairdocs.org/ntsb/WPR26LA104.md): Aerosport Ikarus C42E · Wendover, UT · Accident · No injuries · Class 4 · Limited · Final report · Feb 16, 2026 · N420MS · Substantial damage
  > The pilot’s mismanagement of engine power during a maximum performance, 180° climbing left turn at a low altitude that resulted in impact with terrain.
- [NTSB WPR25LA278](https://openairdocs.org/ntsb/WPR25LA278.md): Diamond Aircraft Ind DA 40 · Rocky Ridge, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 12, 2025 · N8VT · Substantial damage
  > The flight instructor’s inadequate supervision and delayed remedial action during an unusual attitude recovery, which resulted in a descent into terrain.
- [NTSB WPR25LA056](https://openairdocs.org/ntsb/WPR25LA056.md): Piper PA-12 · Marysvale, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 5, 2024 · N1706B · Substantial damage
  > The pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.
- [NTSB WPR24FA313](https://openairdocs.org/ntsb/WPR24FA313.md): Cirrus Design SR22 · Provo, UT · Accident · 2 fatal · Class 3 · Field · Final report · Sep 27, 2024 · N831AZ · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.
- [NTSB WPR24FA083](https://openairdocs.org/ntsb/WPR24FA083.md): Hawker Beechcraft Hawker 900XP · Westwater, UT · Accident · 2 fatal · Class 2 · Field · Final report · Feb 7, 2024 · N900VA · Destroyed
  > The flight crew’s decision to conduct a post-maintenance stall test in an area of icing conditions, which resulted in wing contamination that significantly decreased the airplane’s critical angle of attack. Also causal was the airplane manufacturer’s lack of…
- [NTSB WPR24FA035](https://openairdocs.org/ntsb/WPR24FA035.md): Cessna 172G · Provo, UT · Accident · 2 fatal · Class 3 · Field · Final report · Nov 14, 2023 · N3971L · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…
- [NTSB WPR23LA126](https://openairdocs.org/ntsb/WPR23LA126.md): Trendak Taurus · Strawberry Reservoir, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 11, 2023 · N553AT · Substantial damage
  > The pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.
- [NTSB WPR23LA103](https://openairdocs.org/ntsb/WPR23LA103.md): Piper PA-12 · Porterville, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 4, 2023 · N3969B · Substantial damage
  > The pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.
- [NTSB WPR23LA053](https://openairdocs.org/ntsb/WPR23LA053.md): Aviat A-1C-180 · Morgan, UT · Accident · No injuries · Class 4 · Limited · Final report · Dec 3, 2022 · N60WY · Substantial damage
  > The pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.
- [NTSB WPR22LA261](https://openairdocs.org/ntsb/WPR22LA261.md): Aerospatiale SA342J · Escalante, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 18, 2022 · N342WF · Substantial damage
  > The pilot's failure to control the helicopter’s descent rate during landing, which resulted in collision with terrain.
- [NTSB WPR22FA227](https://openairdocs.org/ntsb/WPR22FA227.md): Cessna 152 · Mendon, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jun 24, 2022 · N934JH · Substantial damage
  > The flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.
- [NTSB WPR22LA157](https://openairdocs.org/ntsb/WPR22LA157.md): Robinson Helicopter R44 II · Salt Lake City, UT · Accident · No injuries · Class 4 · Limited · Final report · Apr 16, 2022 · N3297Q · Substantial damage
  > The student pilot’s failure to maintain lateral control and terrain clearance while hovering, and the flight instructor’s delayed remedial action which resulted in a dynamic rollover.
- [NTSB WPR22LA117](https://openairdocs.org/ntsb/WPR22LA117.md): Six Chuter Legend · Toquerville, UT · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 2, 2022 · N290TQ · Destroyed
  > The pilot’s improper throttle input which resulted in a loss of engine power and subsequent impact with terrain.
- [NTSB WPR21FA321](https://openairdocs.org/ntsb/WPR21FA321.md): Cessna 182H · Bountiful, UT · Accident · 3 fatal · Class 3 · Field · Final report · Aug 16, 2021 · N8477S · Destroyed
  > The decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…
- [NTSB WPR21FA243](https://openairdocs.org/ntsb/WPR21FA243.md): Feraca Edward M Searey LSX · Logan, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jun 27, 2021 · N62EF · Substantial damage
  > The pilot’s loss of airplane control while maneuvering at a low altitude, which resulted in a collision with a house.
- [NTSB WPR21LA202](https://openairdocs.org/ntsb/WPR21LA202.md): Goodsell Lynn A Classic 4 · Richmond, UT · Accident · No injuries · Class 4 · Limited · Final report · May 18, 2021 · N549Z · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.
- [NTSB WPR20LA258](https://openairdocs.org/ntsb/WPR20LA258.md): Cessna T210 · Hanna, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 7, 2020 · N761RG · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed after a partial loss of power for undetermined reasons, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall from which the pilot could not recover.
- [NTSB WPR20LA239](https://openairdocs.org/ntsb/WPR20LA239.md): Vans RV7 · Henefer, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 26, 2020 · N514BS · Substantial damage
  > The total loss of engine power due to the separation of the idler gear shaft bolts as a result of improper installation, which allowed for the idler gear to become disengaged.
- [NTSB WPR19FA250](https://openairdocs.org/ntsb/WPR19FA250.md): Cessna 210 · Henefer, UT · Accident · 2 fatal · Class 3 · Field · Final report · Sep 4, 2019 · N94262 · Substantial damage
  > The pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.
- [NTSB WPR19FA183](https://openairdocs.org/ntsb/WPR19FA183.md): Schempp Hirth Arcus · Ephraim, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jul 1, 2019 · N215MM · Destroyed
  > The pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.
- [NTSB WPR19FA182](https://openairdocs.org/ntsb/WPR19FA182.md): Cub Crafters CCK-1865 · Moab, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jun 30, 2019 · N66DN · Substantial damage
  > The pilots failure to maintain clearance from terrain while maneuvering at a low altitude in mountainous terrain.
- [NTSB WPR18FA186](https://openairdocs.org/ntsb/WPR18FA186.md): Cessna 320 · Eagle Mountain, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jun 28, 2018 · N320MF · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.
- [NTSB WPR18LA177](https://openairdocs.org/ntsb/WPR18LA177.md): Schempp Hirth Flugzeugbau Arcus M · Richfield, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 21, 2018 · N16DN · Destroyed
  > An inflight loss of control and subsequent inflight breakup for reasons that could not be determined based on the available information.
- [NTSB WPR18LA136](https://openairdocs.org/ntsb/WPR18LA136.md): Cessna 182F · Boulder, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 28, 2018 · N3377U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined due to the available evidence.
- [NTSB GAA18CA127](https://openairdocs.org/ntsb/GAA18CA127.md): Hughes 369 · Heber City, UT · Accident · No injuries · Data collection · Final report · Feb 12, 2018 · N338HW · Substantial damage
  > The pilot’s failure to maintain clearance from an elk while maneuvering at a low altitude.
- [NTSB WPR18FA063](https://openairdocs.org/ntsb/WPR18FA063.md): Cessna 172M · Ogden, UT · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2017 · N4395R · Substantial damage
  > The pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.
- [NTSB GAA18CA073](https://openairdocs.org/ntsb/GAA18CA073.md): Brock Steiner Sport Copter Vortex · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N395SC · Substantial damage
  > The pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.
- [NTSB WPR17FA149](https://openairdocs.org/ntsb/WPR17FA149.md): Aviat A · Herriman, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2017 · N211AM · Destroyed
  > The flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…
- [NTSB GAA17CA117](https://openairdocs.org/ntsb/GAA17CA117.md): Air Tractor AT 802 · Vernon, UT · Accident · No injuries · Data collection · Final report · Jan 17, 2017 · N20361 · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain.
- [NTSB GAA16CA488](https://openairdocs.org/ntsb/GAA16CA488.md): Robinson Helicopter R44 II · Cedar City, UT · Accident · No injuries · Data collection · Final report · Sep 14, 2016 · N46HF · Substantial damage
  > The flight instructor’s delayed remedial action while providing hover instruction in gusting wind conditions, which resulted in dynamic roll-over.
- [NTSB WPR16LA165](https://openairdocs.org/ntsb/WPR16LA165.md): Robinson Helicopter R44 II · Gunnison, UT · Accident · No injuries · Limited investigation · Final report · Aug 12, 2016 · N247DB · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR16FA144](https://openairdocs.org/ntsb/WPR16FA144.md): Diamond Aircraft Ind DA40 F · Logan, UT · Accident · 1 fatal · Field investigation · Final report · Jul 18, 2016 · N419FP · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering in turbulence and gusty wind conditions, which resulted in an aerodynamic stall/spin.
- [NTSB GAA16CA358](https://openairdocs.org/ntsb/GAA16CA358.md): Cessna 172 · Bountiful, UT · Accident · No injuries · Data collection · Final report · Jul 1, 2016 · N52071 · Substantial damage
  > The pilot's decision to fly into a canyon without sufficient room to reverse course if necessary, which resulted in an emergency landing, loss of directional control, collision with terrain, and a post-crash fire.
- [NTSB WPR16LA129](https://openairdocs.org/ntsb/WPR16LA129.md): Burkes BR-1 · Brigham City, UT · Accident · No injuries · Class 3 · Limited · Final report · Jun 22, 2016 · N677DB · Substantial damage
  > A loss of engine power as a result of a failure of the primary and backup ignition system.
- [NTSB WPR16FA036](https://openairdocs.org/ntsb/WPR16FA036.md): Barnett Allen S RV7 · Hurricane, UT · Accident · 2 fatal · Class 3 · Field · Final report · Dec 10, 2015 · N307AB · Substantial damage
  > The pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.
- [NTSB GAA16CA027](https://openairdocs.org/ntsb/GAA16CA027.md): Cessna A188A · Elberta, UT · Accident · No injuries · Data collection · Final report · Oct 24, 2015 · N4401Q · Substantial damage
  > The pilot's failure to compensate for wind while maneuvering at a low altitude, resulting in a collision with terrain and a postcrash fire.
- [NTSB WPR16FA002](https://openairdocs.org/ntsb/WPR16FA002.md): Cessna 152 · Cedar City, UT · Accident · 2 fatal · Field investigation · Final report · Oct 5, 2015 · N6449M · Destroyed
  > The failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.
- [NTSB GAA15CA258](https://openairdocs.org/ntsb/GAA15CA258.md): Airbus AS350 · Draper, UT · Accident · No injuries · Data collection · Final report · Sep 9, 2015 · N253HP · Substantial damage
  > The ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.
- [NTSB WPR15LA232](https://openairdocs.org/ntsb/WPR15LA232.md): Schleicher ASW 20B · Logan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2015 · N20YZ · Substantial damage
  > The pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.
- [NTSB GAA15LA131](https://openairdocs.org/ntsb/GAA15LA131.md): Robinson Helicopter R22 Beta · Escalante, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2015 · N441MM · Substantial damage
  > The pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…
- [NTSB WPR15LA185](https://openairdocs.org/ntsb/WPR15LA185.md): Cessna 182A · Moab, UT · Accident · No injuries · Limited investigation · Final report · Jun 14, 2015 · N5143D · Substantial damage
  > The pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR15LA170](https://openairdocs.org/ntsb/WPR15LA170.md): Duenas Pulsar III · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · May 29, 2015 · N747N · Substantial damage
  > An elevated oil temperature and subsequent total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR15CA063](https://openairdocs.org/ntsb/WPR15CA063.md): Eurocopter AS 350 B2 Ecureuil · Bicknell, UT · Accident · No injuries · Data collection · Final report · Dec 16, 2014 · N352SL · Substantial damage
  > The pilot's failure to prevent the helicopter from settling with power while maneuvering at a low altitude, which resulted in a loss of control and subsequent hard landing.
- [NTSB WPR15FA051](https://openairdocs.org/ntsb/WPR15FA051.md): Robinson Helicopter R44 · Bountiful, UT · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2014 · N3234U · Substantial damage
  > The pilot/mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and a subsequent loss of control.
- [NTSB WPR14CA347](https://openairdocs.org/ntsb/WPR14CA347.md): Eipper Formance Mxii · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Aug 16, 2014 · N1624Z · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB WPR14FA183](https://openairdocs.org/ntsb/WPR14FA183.md): Cessna 150 - F · Santa Clara, UT · Accident · 2 fatal · Field investigation · Final report · May 7, 2014 · N8236F · Substantial damage
  > The flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude.
- [NTSB WPR14GA176](https://openairdocs.org/ntsb/WPR14GA176.md): Hughes OH 6 · Bullfrog, UT · Accident · Serious injuries · Final report · Apr 29, 2014 · N37929 · Substantial damage
  > A loss of engine power while the helicopter was hovering for reasons that could not be determined because postaccident examination of the engine and rotor drive system revealed no evidence of a mechanical malfunction or failure that would have precluded…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=UT&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" = 'UT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.
