# NTSB investigations, UT: 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 11 · 544 cases

## Latest cases

- [NTSB WPR26LA285](https://openairdocs.org/ntsb/WPR26LA285.md): Cessna 172 · Layton, UT · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 31, 2026 · N9650V · Substantial damage
  > On July 30, 2026, at 2356 mountain daylight time, a Cessna 172M airplane, N9650V, was substantially damaged when it was involved in an accident near Layton, Utah. The flight instructor was seriously injured, and the private pilot sustained minor injuries. The…
- [NTSB WPR26LA235](https://openairdocs.org/ntsb/WPR26LA235.md): Diamond Aircraft Ind DA20-C1 · Nephi, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 25, 2026 · N643DC · Substantial damage
  > On June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title…
- [NTSB WPR26FA232](https://openairdocs.org/ntsb/WPR26FA232.md): Cessna 172 · Willard, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N387AF · Destroyed
  > On June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB WPR26LA132](https://openairdocs.org/ntsb/WPR26LA132.md): Piper PA-28-140 · West Valley City, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N7328J · Substantial damage
  > On March 21, 2026, about 1610 mountain daylight time, a Piper PA-28-140, N7328J, was substantially damaged when it was involved in an accident near West Valley City, Utah. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…
- [NTSB DCA26LA012](https://openairdocs.org/ntsb/DCA26LA012.md): Boeing 737 · Moab, UT · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 16, 2025 · N17327 · Substantial damage
  > On October 16, 2025, at 0643 mountain daylight time (MDT), United Airlines (UAL) flight 1093, a Boeing 737-8, N17327, was involved in a midair collision with an object while in cruise flight near Moab, Utah. Although the captain sustained minor injuries, none…
- [NTSB WPR26LA012](https://openairdocs.org/ntsb/WPR26LA012.md): Piper PA24 · Vineyard, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 8, 2025 · N7946P · Substantial damage
  > On October 7, 2025, about 1825 mountain daylight time, a Piper PA24 airplane, N7946P, was substantially damaged in an accident near Vineyard, Utah. The pilot and pilot-rated passenger were not injured. The flight was conducted under Title 14 Code of Federal…
- [NTSB WPR25FA269](https://openairdocs.org/ntsb/WPR25FA269.md): Piper PA-28R-200 · Alta, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N1147X · Substantial damage
  > On August 31, 2025, about 1720, mountain daylight time a Piper PA28-200R, N1147X, was substantially damaged when it was involved in an accident near Alta, Utah. The pilot was seriously injured, and the passenger sustained fatal injuries. The airplane was…
- [NTSB WPR25FA232](https://openairdocs.org/ntsb/WPR25FA232.md): Schleicher ASW27-18 · Morgan, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N929JK · Destroyed
  > On August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…
- [NTSB WPR25LA096](https://openairdocs.org/ntsb/WPR25LA096.md): Cessna 150J · Minersville, UT · Accident · No injuries · Class 3 · Limited · Final report · Feb 16, 2025 · N151GW · Substantial damage
  > The failure of the propeller blade due to fatigue that originated from an impact pit sustained at an unknown time. Contributing to the accident was the failure of unknown maintenance personnel to detect and repair the impact pit before painting the propeller,…
- [NTSB WPR25FA090](https://openairdocs.org/ntsb/WPR25FA090.md): Beech B24R · Skull Valley, UT · Accident · No injuries · Class 3 · Field · Final report · Feb 10, 2025 · N9324S · Substantial damage
  > The flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were multiple distractions that diverted the flight instructor’s attention from the proper monitoring and…
- [NTSB WPR24LA216](https://openairdocs.org/ntsb/WPR24LA216.md): Alexander Schleicher ASH 31 MI · Parowan, UT · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 24, 2024 · N517PB · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain?flight.
- [NTSB WPR24LA211](https://openairdocs.org/ntsb/WPR24LA211.md): Beech 58P · Escalante, UT · Accident · No injuries · Class 3 · Limited · Final report · Jun 19, 2024 · N9NS · Substantial damage
  > The failure of the windshield for undetermined reasons.
- [NTSB WPR24LA178](https://openairdocs.org/ntsb/WPR24LA178.md): Piper PA-28-180 · Nephi, UT · Accident · Minor injuries · Class 4 · Limited · Final report · May 31, 2024 · N7838W · Substantial damage
  > The pilot’s incorrect movement of the fuel selector valve to an off or restricted position, which resulted in fuel starvation and a loss of engine power.
- [NTSB WPR24LA064](https://openairdocs.org/ntsb/WPR24LA064.md): Diamond Aircraft Ind DA 40 · Spanish Fork, UT · Accident · No injuries · Class 3 · Limited · Final report · Dec 21, 2023 · N453DS · Substantial damage
  > Maintenance personnel’s improper installation of the left magneto, which resulted in oil starvation to the engine and a subsequent total loss of engine power.
- [NTSB WPR24FA024](https://openairdocs.org/ntsb/WPR24FA024.md): Cessna T206H · Orangeville, UT · Accident · 1 fatal · Class 3 · Field · Final report · Oct 27, 2023 · N915DV · Substantial damage
  > The pilot's controlled flight into mountainous terrain for reasons that could not be determined.
- [NTSB WPR24FA010](https://openairdocs.org/ntsb/WPR24FA010.md): Robert L Thurmond RV8 · Centerville, UT · Accident · 1 fatal · Class 3 · Field · Final report · Oct 10, 2023 · N75RT · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…
- [NTSB WPR23LA324](https://openairdocs.org/ntsb/WPR23LA324.md): Diamond DA20 · Fairfield, UT · Accident · No injuries · Class 4 · Limited · Final report · Aug 23, 2023 · N989PA · Substantial damage
  > The flight pilots improper fuel management, which resulted a total loss of engine power, and impact with terrain during an off-airport landing. Contributing to the accident was the flight instructor’s failure to follow the airplane checklist.
- [NTSB WPR23LA308](https://openairdocs.org/ntsb/WPR23LA308.md): Piper PA-28-180 · Ritchfield, UT · Accident · No injuries · Class 4 · Limited · Final report · Aug 8, 2023 · N8823J · Substantial damage
  > The pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.
- [NTSB WPR23LA149](https://openairdocs.org/ntsb/WPR23LA149.md): Stevens Kelly C RV-7 · Morgan, UT · Accident · No injuries · Class 3 · Limited · Final report · Apr 9, 2023 · N17NK · Substantial damage
  > The pilot/builder improperly torqued the propeller attachment bolts while reinstalling the propeller, which resulted in the fatigue failure of the bolts and the separation of the propeller assembly.
- [NTSB WPR23LA099](https://openairdocs.org/ntsb/WPR23LA099.md): Beech C23 · Rich County, UT · Accident · No injuries · Class 4 · Limited · Final report · Jan 25, 2023 · N23FD · Substantial damage
  > The pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.
- [NTSB WPR23FA083](https://openairdocs.org/ntsb/WPR23FA083.md): Piper PA-34-220T · New Harmony, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jan 4, 2023 · N814WT · Destroyed
  > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.
- [NTSB WPR22FA164](https://openairdocs.org/ntsb/WPR22FA164.md): Diamond Aircraft Ind DA 40 · Cedar City, UT · Accident · 4 fatal · Class 3 · Field · Final report · Apr 24, 2022 · N321PF · Destroyed
  > The pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.
- [NTSB WPR22LA127](https://openairdocs.org/ntsb/WPR22LA127.md): Piper PA-32R-300 · St. George, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 24, 2022 · N111NW · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB WPR22LA080](https://openairdocs.org/ntsb/WPR22LA080.md): Walter Tachiki Tachiki 750 Cruzer · Spanish Fork, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 14, 2022 · N145WT · Substantial damage
  > A partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…
- [NTSB WPR22LA046](https://openairdocs.org/ntsb/WPR22LA046.md): Vans RV10 · Hurricane, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 22, 2021 · N54CT · Substantial damage
  > The total loss of engine power due to a loose fuel line at the fuel servo outlet port.
- [NTSB WPR21LA325](https://openairdocs.org/ntsb/WPR21LA325.md): Stout Garry V Europa - Trigear · Hanksville, UT · Accident · No injuries · Class 3 · Limited · Final report · Aug 16, 2021 · N133AC · Substantial damage
  > The pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…
- [NTSB WPR21LA290](https://openairdocs.org/ntsb/WPR21LA290.md): Burkhart Grob G 103 Twin II · Levan, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 25, 2021 · N4446Y · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight which resulted in an off-airport landing and a collision with a fence.
- [NTSB WPR21FA231](https://openairdocs.org/ntsb/WPR21FA231.md): Piper PA-28-140 · Rush Valley, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jun 18, 2021 · N6323R · Substantial damage
  > The pilot’s misidentification of a mountain pass at night, which resulted in controlled flight into terrain. Contributing to the accident were the pilot’s overconfidence based on her previous aviation experience and fatigue due to both the time of the flight…
- [NTSB WPR21FA211](https://openairdocs.org/ntsb/WPR21FA211.md): Textron 172S · Eden, UT · Accident · 2 fatal · Class 3 · Field · Final report · May 29, 2021 · N1727T · Destroyed
  > The flight instructor’s improper aeronautical decision-making, which led to an encounter with a downdraft at a low altitude in mountainous terrain and resulted in the instructor’s loss of airplane control and an impact with terrain.
- [NTSB WPR20LA249](https://openairdocs.org/ntsb/WPR20LA249.md): North American Navion · Cedar City, UT · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 2, 2020 · N225HJ · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s improper fuel planning and failure to see and avoid the communications tower support guy wire.
- [NTSB WPR20LA203](https://openairdocs.org/ntsb/WPR20LA203.md): Cessna 172 · Alpine, UT · Accident · 4 fatal · Class 3 · Limited · Final report · Jul 3, 2020 · N6929H · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle-of-attack while maneuvering in a canyon, which resulted in a loss of airplane control.
- [NTSB WPR20LA029](https://openairdocs.org/ntsb/WPR20LA029.md): Agusta A109 · Salt Lake City, UT · Accident · No injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N271HC · Substantial damage
  > The flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.
- [NTSB WPR20LA012](https://openairdocs.org/ntsb/WPR20LA012.md): Czech Sport Sportcruiser · Holden, UT · Accident · No injuries · Class 3 · Limited · Final report · Oct 23, 2019 · N204BF · Substantial damage
  > The fatigue failure of the No. 2 cylinder intake valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power. Contributing to the severity of the damage was the improper deployment of the ballistic…
- [NTSB WPR19LA192](https://openairdocs.org/ntsb/WPR19LA192.md): Judd Challenger II · Draper, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 19, 2019 · N77YD · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR19FA154](https://openairdocs.org/ntsb/WPR19FA154.md): Cirrus SR22 · Grover, UT · Accident · 2 fatal · Class 2 · Field · Final report · May 24, 2019 · N809SR · Destroyed
  > The pilot's encounter with moderate to severe icing conditions during cruise flight, which resulted in structural icing and a subsequent loss of control. Contributing to the accident was the pilot’s decision to continue a flight route through known moderate…
- [NTSB WPR19FA148](https://openairdocs.org/ntsb/WPR19FA148.md): Robinson R44 · Alpine, UT · Accident · 2 fatal · Class 3 · Field · Final report · May 17, 2019 · N744TW · Substantial damage
  > The noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…
- [NTSB WPR19LA010](https://openairdocs.org/ntsb/WPR19LA010.md): Piper PA46 · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2018 · N413LL · Substantial damage
  > The mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.
- [NTSB WPR18LA199](https://openairdocs.org/ntsb/WPR18LA199.md): Cub Crafters CC19 · Hyrum, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2018 · N70DD · Substantial damage
  > The pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…
- [NTSB GAA18CA377](https://openairdocs.org/ntsb/GAA18CA377.md): Jonker Sailplanes JS1-C · Panguitch, UT · Accident · No injuries · Data collection · Final report · Jun 24, 2018 · N963CG · Substantial damage
  > The pilot’s inability to maintain altitude and his delayed decision to deploy the powered-glider’s engine, which necessitated an off-airport landing.
- [NTSB WPR18LA102](https://openairdocs.org/ntsb/WPR18LA102.md): Macdonald Craig MAC CUB · Ogden, UT · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2018 · N669WH · Substantial damage
  > The pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.
- [NTSB WPR18FA095](https://openairdocs.org/ntsb/WPR18FA095.md): Piper PA32R · Monticello, UT · Accident · 4 fatal · Field investigation · Final report · Feb 22, 2018 · C-GYGY · Destroyed
  > The noninstrument-rated pilot's continued flight into a region of deteriorating ceiling and visibility conditions, which resulted in controlled flight into terrain event.
- [NTSB GAA17CA468](https://openairdocs.org/ntsb/GAA17CA468.md): Cessna 170 · Moab, UT · Accident · Serious injuries · Data collection · Final report · Aug 4, 2017 · N1214D · Substantial damage
  > The pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.
- [NTSB GAA17CA371](https://openairdocs.org/ntsb/GAA17CA371.md): Aero Commander Callair A 9 · Morgan, UT · Accident · No injuries · Data collection · Final report · Jun 24, 2017 · N7662V · Substantial damage
  > The pilot’s failure to see and avoid transmission wires.
- [NTSB WPR17FA065](https://openairdocs.org/ntsb/WPR17FA065.md): Cessna 172 · Panguitch, UT · Accident · 3 fatal · Field investigation · Final report · Feb 26, 2017 · N3712F · Substantial damage
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.
- [NTSB GAA17CA088](https://openairdocs.org/ntsb/GAA17CA088.md): Diamond Aircraft Ind DA-20 · Payson, UT · Accident · No injuries · Data collection · Final report · Dec 2, 2016 · N992CT · Substantial damage
  > The student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.
- [NTSB WPR16LA155](https://openairdocs.org/ntsb/WPR16LA155.md): Beech C 99 · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Aug 2, 2016 · N234AV · Substantial damage
  > An in-flight collision with power lines.
- [NTSB WPR16LA114](https://openairdocs.org/ntsb/WPR16LA114.md): Michael Burton Calidus · Fruitland, UT · Accident · Serious injuries · Limited investigation · Final report · May 20, 2016 · N50NE · Substantial damage
  > The pilot's improper judgment in conducting a flight in a gyroplane over mountainous terrain near its demonstrated maximum operating altitude and his subsequent failure to maintain adequate clearance with terrain during cruise flight in turbulent weather…
- [NTSB WPR16FA054](https://openairdocs.org/ntsb/WPR16FA054.md): Cessna 525 · Cedar Fort, UT · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2016 · N711BX · Destroyed
  > The pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…
- [NTSB DCA15CA145](https://openairdocs.org/ntsb/DCA15CA145.md): Boeing 737 832 · Salt Lake City, UT · Accident · Serious injuries · Data collection · Final report · Jun 30, 2015 · N396DA · No damage
  > inadvertent contact by beverage cart during cabin service.
- [NTSB GAA15CA029](https://openairdocs.org/ntsb/GAA15CA029.md): Kerr John A Kitfox Classic IV · Logan, UT · Accident · No injuries · Data collection · Final report · Mar 28, 2015 · N195KF · Substantial damage
  > The pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, and a loss of engine power en route.

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

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