# NTSB investigations, UT: Initial climb

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 5 · 228 cases

## Latest cases

- [NTSB WPR26FA294](https://openairdocs.org/ntsb/WPR26FA294.md): Textron 172S · Provo, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N1842E · Substantial damage
  > On August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction…
- [NTSB WPR25LA027](https://openairdocs.org/ntsb/WPR25LA027.md): Cirrus Design SR20 · St. George, UT · Accident · No injuries · Class 3 · Limited · Final report · Oct 28, 2024 · N27WF · Destroyed
  > A partial loss of power for reasons that could not be determined due to postimpact fire damage.
- [NTSB WPR24FA227](https://openairdocs.org/ntsb/WPR24FA227.md): Fantasy Air Sro Allegro 2007 · Eureka, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jul 7, 2024 · N969RC · Substantial damage
  > The pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.
- [NTSB WPR24LA161](https://openairdocs.org/ntsb/WPR24LA161.md): Aerospatiale SA315B · Hildale, UT · Accident · Minor injuries · Class 3 · Limited · Final report · May 27, 2024 · N57948 · Substantial damage
  > Maintenance personnel’s failure to properly secure the EGT thermocouples, which resulted in catastrophic overtemperature of the engine and a total loss of engine power.
- [NTSB WPR24LA127](https://openairdocs.org/ntsb/WPR24LA127.md): Schleicher Alexander ASH 26 E · Heber, UT · Accident · No injuries · Class 3 · Limited · Final report · Apr 21, 2024 · N644CC · Substantial damage
  > Reduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.
- [NTSB WPR24FA002](https://openairdocs.org/ntsb/WPR24FA002.md): Piper PA-28-140 · Moab, UT · Accident · 4 fatal · Class 3 · Field · Final report · Oct 2, 2023 · N7153R · Substantial damage
  > The pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.
- [NTSB WPR23LA343](https://openairdocs.org/ntsb/WPR23LA343.md): Boeing A75N1(PT17) · Monticello, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 13, 2023 · N10KP · Substantial damage
  > A partial loss of engine power for reasons that could not be determined.
- [NTSB WPR23FA323](https://openairdocs.org/ntsb/WPR23FA323.md): Hensler Howard Cassutt · West Jordan, UT · Accident · 1 fatal · Class 3 · Field · Final report · Aug 23, 2023 · N6291N · Substantial damage
  > A loss of control during the initial climb for reasons that could not be determined.
- [NTSB WPR23LA203](https://openairdocs.org/ntsb/WPR23LA203.md): Piper PA-28-181 · West Jordan, UT · Accident · No injuries · Class 3 · Limited · Final report · May 29, 2023 · N456Y · Substantial damage
  > Loss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.
- [NTSB WPR23LA204](https://openairdocs.org/ntsb/WPR23LA204.md): Cessna 175A · Enterprise, UT · Accident · No injuries · Class 4 · Limited · Final report · May 28, 2023 · N5089 · Substantial damage
  > The pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.
- [NTSB WPR22LA342](https://openairdocs.org/ntsb/WPR22LA342.md): Cessna 152 · Salt Lake City, UT · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2022 · N48918 · Substantial damage
  > The airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.
- [NTSB WPR22LA211](https://openairdocs.org/ntsb/WPR22LA211.md): Rans S21 · Fairfield, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 9, 2022 · N46JH · Substantial damage
  > The owner’s (pilot) failure to properly torque a fuel filter b-nut fitting, which likely introduced air into the fuel system and resulted in a loss of engine power. Contributing to the loss of power was a missing restricted bypass line and a header tank vent…
- [NTSB WPR21LA319](https://openairdocs.org/ntsb/WPR21LA319.md): Piper PA-28-140 · Panguitch, UT · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2021 · N1651J · Substantial damage
  > The airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…
- [NTSB WPR21LA078](https://openairdocs.org/ntsb/WPR21LA078.md): Cessna P210N · Moab, UT · Accident · No injuries · Class 3 · Limited · Final report · Jan 2, 2021 · N833RT · Substantial damage
  > The pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.
- [NTSB WPR21LA070](https://openairdocs.org/ntsb/WPR21LA070.md): SilverLight AR-1 · Heber City, UT · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 16, 2020 · N261MD · Substantial damage
  > The pilot’s failure to follow the procedures for takeoff in the Pilot Operating Handbook, which resulted in a loss of control and collision with the terrain. Contributing to the accident was the pilot’s failure to receive additional training in the gyroplane.
- [NTSB WPR21LA068](https://openairdocs.org/ntsb/WPR21LA068.md): Cirrus Design SR22 · Ogden, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 10, 2020 · N577CP · Substantial damage
  > The partial loss of engine power for reasons that cannot be determined due to lack of available evidence.
- [NTSB WPR20LA238](https://openairdocs.org/ntsb/WPR20LA238.md): Piper PA32R · West Jordan, UT · Accident · 5 fatal · Class 3 · Limited · Final report · Jul 25, 2020 · N7677C · Substantial damage
  > The pilot's failure to maintain the airplane’s speed during takeoff near the airplane’s maximum gross weight in high-density altitude conditions, which resulted in the exceedance of the airplane's critical angle of attack and led to an aerodynamic stall, loss…
- [NTSB WPR20LA116](https://openairdocs.org/ntsb/WPR20LA116.md): TL Ultralight Sro Stingsport · Hurricane, UT · Accident · No injuries · Class 3 · Limited · Final report · Mar 28, 2020 · N7997N · Substantial damage
  > A total loss of engine power due to the failure of the ignition system as a result of foreign object damage.
- [NTSB WPR20LA001](https://openairdocs.org/ntsb/WPR20LA001.md): Buckeye Breeze · Moore, UT · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 5, 2019 · N582UT · Substantial damage
  > The pilot’s improper preflight inspection and detection of a pinch point in the steering line, which resulted in a loss of control in flight and impact with terrain.
- [NTSB WPR17LA202](https://openairdocs.org/ntsb/WPR17LA202.md): Beech A24R · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 2017 · N9798L · Substantial damage
  > The airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.
- [NTSB WPR17LA187](https://openairdocs.org/ntsb/WPR17LA187.md): Cessna 310I · Salt Lake City, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 24, 2017 · N8170M · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR17LA183](https://openairdocs.org/ntsb/WPR17LA183.md): Piper PA 28R-200 · West Jordan, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 11, 2017 · N33732 · Substantial damage
  > The pilot's failure to account for operation at high density altitude at or near the airplane’s maximum gross weight, which led to degraded engine performance and prevented the airplane from achieving an adequate airspeed for a positive rate of climb,…
- [NTSB WPR17FA035](https://openairdocs.org/ntsb/WPR17FA035.md): Quest Kodiak 100 · Moab, UT · Accident · 1 fatal · Field investigation · Final report · Dec 12, 2016 · N772RT · Destroyed
  > The pilot's loss of control shortly after takeoff due to spatial disorientation.
- [NTSB GAA15CA157](https://openairdocs.org/ntsb/GAA15CA157.md): Balloon Works FIREFLY8 - 24 · Provo, UT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2015 · N7148P · 2 aircraft · Substantial damage
  > **This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…
- [NTSB WPR15CA059](https://openairdocs.org/ntsb/WPR15CA059.md): Cessna 182T · Wendover, UT · Accident · Serious injuries · Data collection · Final report · Dec 12, 2014 · N961GW · Substantial damage
  > The pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.
- [NTSB WPR14LA336](https://openairdocs.org/ntsb/WPR14LA336.md): Piper PA 32R-300 · West Jordan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2014 · N4646F · Destroyed
  > A partial loss of engine power during initial climb for reasons that could not be determined due to the severity of the damage to the engine.
- [NTSB WPR14LA118](https://openairdocs.org/ntsb/WPR14LA118.md): Cessna P210N · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Feb 23, 2014 · N18DP · Substantial damage
  > Fuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.
- [NTSB WPR14CA066](https://openairdocs.org/ntsb/WPR14CA066.md): Mcdonnell Douglas Helicopter 369E · Monticello, UT · Accident · No injuries · Data collection · Final report · Dec 6, 2013 · N2066W · Substantial damage
  > The passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.
- [NTSB WPR13FA041](https://openairdocs.org/ntsb/WPR13FA041.md): American AA-1 · Morgan, UT · Accident · 1 fatal · Field investigation · Final report · Nov 15, 2012 · N5642L · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in frost remaining on the airplane's surfaces and led to its inability to produce enough lift to clear rising terrain.
- [NTSB WPR12FA230](https://openairdocs.org/ntsb/WPR12FA230.md): Cessna 172S · St. George, UT · Accident · 4 fatal · Field investigation · Final report · May 26, 2012 · N953SP · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…
- [NTSB WPR12FA001](https://openairdocs.org/ntsb/WPR12FA001.md): Vaughn Pulsar · West Jordan, UT · Accident · 2 fatal · Field investigation · Final report · Oct 4, 2011 · N91BV · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…
- [NTSB WPR11LA180](https://openairdocs.org/ntsb/WPR11LA180.md): William Wright Avid Flyer · Cedar City, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 2011 · N613HH · Substantial damage
  > A loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal a specific anomaly that would have precluded normal operation.
- [NTSB WPR11LA013](https://openairdocs.org/ntsb/WPR11LA013.md): Beech C24 · Blanding, UT · Accident · No injuries · Limited investigation · Final report · Oct 10, 2010 · N5063M · Substantial damage
  > The pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.
- [NTSB WPR10LA310](https://openairdocs.org/ntsb/WPR10LA310.md): Rice KR-2 · Richfield, UT · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2010 · N44729 · Substantial damage
  > A loss of engine power during initial climb due to a carburetor malfunction.
- [NTSB WPR10LA292](https://openairdocs.org/ntsb/WPR10LA292.md): Air Creation GTE · Springville, UT · Accident · 1 fatal · Limited investigation · Final report · Jun 14, 2010 · N227EH · Substantial damage
  > The pilot's inadequate preflight planning and his failure to maintain clearance from obstacles during takeoff. Contributing to the accident was the pilot's lack of experience.
- [NTSB WPR10LA302](https://openairdocs.org/ntsb/WPR10LA302.md): Piper PA-28-140 · Richfield, UT · Accident · No injuries · Limited investigation · Final report · Jun 4, 2010 · N3922K · Substantial damage
  > The pilot’s decision to operate the unairworthy airplane with suspected performance deficiencies in a high density altitude and the subsequent partial loss of engine power due to low compression.
- [NTSB WPR10LA210](https://openairdocs.org/ntsb/WPR10LA210.md): Piper PA-44-180 · Tooele, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2010 · N331GP · Substantial damage
  > The complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…
- [NTSB WPR09LA417](https://openairdocs.org/ntsb/WPR09LA417.md): Piper PA28R · Wendover, UT · Accident · No injuries · Limited investigation · Final report · Aug 27, 2009 · N4837T · Substantial damage
  > The failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…
- [NTSB WPR09CA303](https://openairdocs.org/ntsb/WPR09CA303.md): Cessna A188B · Ogden, UT · Accident · No injuries · Data collection · Final report · Jun 20, 2009 · N731GE · Substantial damage
  > A partial loss of engine power due to the number one cylinder air induction tube becoming disconnected for undetermined reasons.
- [NTSB WPR09LA268](https://openairdocs.org/ntsb/WPR09LA268.md): Maule M-5-210C · Ogden, UT · Accident · Serious injuries · Limited investigation · Final report · May 28, 2009 · N315X · Substantial damage
  > A loss of engine power during takeoff for undetermined reasons.
- [NTSB WPR09LA016](https://openairdocs.org/ntsb/WPR09LA016.md): Heisler Lancair Legacy · Parowan, UT · Accident · 1 fatal · Limited investigation · Final report · Oct 18, 2008 · N151HT · Substantial damage
  > The pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.
- [NTSB LAX08MA277](https://openairdocs.org/ntsb/LAX08MA277.md): Beech A100 · Moab, UT · Accident · 10 fatal · Major investigation · Final report · Aug 22, 2008 · N601PC · Substantial damage
  > The pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.
- [NTSB LAX08GA239](https://openairdocs.org/ntsb/LAX08GA239.md): Beech A200 · Salt Lake CIty, UT · Accident · No injuries · Final report · Jul 21, 2008 · N11 · Substantial damage
  > The failure of the landing gear motor (worn components) resulting in the partial collapse of the landing gear during landing. Contributing to the accident was the flight crew not following emergency checklist procedures to attempt a manual gear extension.
- [NTSB LAX08LA179](https://openairdocs.org/ntsb/LAX08LA179.md): Cessna 172S · Beaver, UT · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 2008 · N233GW · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.
- [NTSB SEA08LA090](https://openairdocs.org/ntsb/SEA08LA090.md): Diamond Aircraft Industries DA 20-C1 · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Mar 9, 2008 · N765DC · Substantial damage
  > The fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.
- [NTSB LAX08CA013](https://openairdocs.org/ntsb/LAX08CA013.md): Poser DM 582 Buckeye · Hurricane, UT · Accident · No injuries · Data collection · Final report · Oct 16, 2007 · N785CP · Substantial damage
  > The pilot's inadequate compensation for the existing wind conditions and subsequent failure to maintain aircraft control.
- [NTSB LAX07CA201](https://openairdocs.org/ntsb/LAX07CA201.md): Cessna 172K · Newcastle, UT · Accident · No injuries · Data collection · Final report · Jul 2, 2007 · N84888 · Substantial damage
  > The pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.
- [NTSB LAX07CA165](https://openairdocs.org/ntsb/LAX07CA165.md): Piper PA-28-140 · Moab, UT · Accident · Minor injuries · Data collection · Final report · May 12, 2007 · N8598N · Substantial damage
  > The pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.
- [NTSB SEA06CA072](https://openairdocs.org/ntsb/SEA06CA072.md): Robinson R22 Beta · Tooele, UT · Accident · Minor injuries · Data collection · Final report · Apr 8, 2006 · N921U · Substantial damage
  > The pilot's failure to maintain control of the helicopter during the takeoff initial climb, which resulted in an in-flight collision with the ground. A contributing factor was the gusty wind condition.
- [NTSB DEN05LA133](https://openairdocs.org/ntsb/DEN05LA133.md): Piper PA-28R-180 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2005 · N9069E · Destroyed
  > the flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.