# NTSB investigations, UT: Approach

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 · 221 cases

## Latest cases

- [NTSB WPR26LA211](https://openairdocs.org/ntsb/WPR26LA211.md): Piper PA-44-180T · St. George, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 7, 2026 · N8390K · Substantial damage
  > On June 7, 2026, about 1012 mountain standard time, a Piper PA-44-180T, N8390K, was substantially damaged when it was involved in an accident near St. George, Utah. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26LA079](https://openairdocs.org/ntsb/WPR26LA079.md): Kubicek Factory S R O BB26M · La Verkin, UT · Accident · No injuries · Class 4 · Limited · Final report · Jan 10, 2026 · N90MN · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines after an aborted landing attempt.
- [NTSB WPR24LA254](https://openairdocs.org/ntsb/WPR24LA254.md): Piper PA-34-220T · Roy, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 24, 2024 · N134MG · Substantial damage
  > The flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.
- [NTSB WPR24LA296](https://openairdocs.org/ntsb/WPR24LA296.md): Cessna 182C · Vernal, UT · Accident · No injuries · Class 3 · Limited · Final report · May 22, 2024 · N8580T · Substantial damage
  > The pilot’s improper in-flight fuel management and delay in configuring the fuel selector for landing as recommended by the manufacturer, which resulted in fuel starvation and a total loss of engine power during the final approach to land.
- [NTSB WPR24LA088](https://openairdocs.org/ntsb/WPR24LA088.md): Piper PA-32R-301T · Spanish Fork, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 10, 2024 · N989SR · Substantial damage
  > The pilot's failure to ensure proper placement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR23LA278](https://openairdocs.org/ntsb/WPR23LA278.md): Aerospatiale AS-355E Twin Star · Farmington, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 19, 2023 · N102UM · Substantial damage
  > The premature failure of one of the No. 2 engine compressor bleed valve, which resulted in a partial loss of power to that engine.
- [NTSB WPR22LA358](https://openairdocs.org/ntsb/WPR22LA358.md): Piper PA-28RT-201 · South Jordan, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 23, 2022 · N2919U · Substantial damage
  > The pilot’s inability to see and avoid a bird while landing in dark night conditions.
- [NTSB WPR21LA335](https://openairdocs.org/ntsb/WPR21LA335.md): Cessna 560XL · Salt Lake City, UT · Accident · No injuries · Class 4 · Limited · Final report · Sep 3, 2021 · N827JS · Substantial damage
  > The airplane’s impact with birds during approach.
- [NTSB WPR21LA320](https://openairdocs.org/ntsb/WPR21LA320.md): Robinson Helicopter R22 Beta · West Jordan, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 14, 2021 · N226WM · Substantial damage
  > The pilot receiving instruction’s improper application of forward cyclic in a low rotor rpm condition and the instructor’s delayed remediation, which resulted in an impact with terrain.
- [NTSB WPR21LA176](https://openairdocs.org/ntsb/WPR21LA176.md): Vans RV4 · Oljato-Monument Valley, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 15, 2021 · N345DL · Substantial damage
  > The pilot’s failure to maintain airplane control while compensating for a downdraft during landing, which resulted in the airplane touching down short of the runway on soft terrain and nosing over.
- [NTSB WPR20LA196](https://openairdocs.org/ntsb/WPR20LA196.md): Kostrazewa Andre Sonex Light Sport · Centerville, UT · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 25, 2020 · N620AK · Destroyed
  > The pilot flying’s exceedance of the airplane’s critical angle of attack during an attempted forced landing, which resulted in an aerodynamic stall and impact with terrain. The reason for the attempted forced landing could not be determined.
- [NTSB WPR20CA158](https://openairdocs.org/ntsb/WPR20CA158.md): Cessna P210 · Heber City, UT · Accident · No injuries · Class 4 · Data collection · Final report · May 31, 2020 · N5404W · Substantial damage
  > The pilots failure to switch the fuel pump to the 'OFF' position during landing, resulting in a loss of engine power and subsequent collision with a fence during landing. Contributing to the accident was a modified before landing checklist which omitted the…
- [NTSB WPR20FA065](https://openairdocs.org/ntsb/WPR20FA065.md): Cessna T310 · Roy, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jan 15, 2020 · N5805M · Substantial damage
  > The pilot’s inadequate preflight fuel planning and fuel management, which resulted in a total loss of power to the left engine due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the…
- [NTSB WPR19LA065](https://openairdocs.org/ntsb/WPR19LA065.md): Piper PA28 · Salt Lake City, UT · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2019 · N1697J · Substantial damage
  > A partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.
- [NTSB WPR18TA212](https://openairdocs.org/ntsb/WPR18TA212.md): ICP Savannah · Fairfield, UT · Accident · Minor injuries · Final report · Aug 5, 2018 · N951RA · Substantial damage
  > The pilot's failure to maintain airplane control after encountering a downdraft on approach to the runway.
- [NTSB WPR17LA157](https://openairdocs.org/ntsb/WPR17LA157.md): Cirrus Design SR22 · Ogden, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2017 · N754AP · Substantial damage
  > The failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.
- [NTSB GAA17CA327](https://openairdocs.org/ntsb/GAA17CA327.md): Cessna 172 · Tooele, UT · Accident · No injuries · Data collection · Final report · Jun 6, 2017 · N741TW · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB GAA17CA207](https://openairdocs.org/ntsb/GAA17CA207.md): Cessna 550 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Mar 24, 2017 · N551BC · Substantial damage
  > An in-flight collision with a goose during approach.
- [NTSB WPR15CA040](https://openairdocs.org/ntsb/WPR15CA040.md): Aerospatiale AS350BA · Panguitch, UT · Accident · Minor injuries · Data collection · Final report · Nov 13, 2014 · N425U · Substantial damage
  > The flight instructor's delayed reaction in taking control of the helicopter during a student pilot's loss of control while landing.
- [NTSB WPR14LA263](https://openairdocs.org/ntsb/WPR14LA263.md): Knell ASC Spirit · Lehi, UT · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 2014 · N127JK · Substantial damage
  > The pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.
- [NTSB WPR13CA170](https://openairdocs.org/ntsb/WPR13CA170.md): Diamond DA 20-C1 · Provo, UT · Accident · No injuries · Data collection · Final report · Mar 28, 2013 · N986CT · Substantial damage
  > The student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.
- [NTSB WPR12FA378](https://openairdocs.org/ntsb/WPR12FA378.md): Aircraft Mfg & Development CH 2000 · Nephi, UT · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2012 · N651AM · Substantial damage
  > The pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.
- [NTSB WPR12LA214](https://openairdocs.org/ntsb/WPR12LA214.md): Marley Kolb Firestar II · Cedar Fort, UT · Accident · Serious injuries · Limited investigation · Final report · May 17, 2012 · N9173T · Substantial damage
  > The pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.
- [NTSB WPR11FA450](https://openairdocs.org/ntsb/WPR11FA450.md): Cone James A RV-6A · West Jordan, UT · Accident · 1 fatal · Field investigation · Final report · Sep 15, 2011 · N641JC · Substantial damage
  > The pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.
- [NTSB WPR11LA315](https://openairdocs.org/ntsb/WPR11LA315.md): Beech V35B · Oljato, UT · Accident · No injuries · Limited investigation · Final report · Jul 7, 2011 · N1735W · Substantial damage
  > The pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.
- [NTSB WPR11FA242](https://openairdocs.org/ntsb/WPR11FA242.md): Cessna 172R · Wendover, UT · Accident · 4 fatal · Field investigation · Final report · Jun 1, 2011 · N475ER · Substantial damage
  > The pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…
- [NTSB WPR11CA189](https://openairdocs.org/ntsb/WPR11CA189.md): Robinson Helicopter R22 Beta · Salt Lake City, UT · Accident · Minor injuries · Data collection · Final report · Apr 6, 2011 · N268SH · Substantial damage
  > The student pilot's inadvertent action of pulling out the engine's mixture control lever to idle cutoff that resulted in a complete loss of engine power.
- [NTSB WPR11FA073](https://openairdocs.org/ntsb/WPR11FA073.md): Cessna T210M · Ogden, UT · Accident · Serious injuries · Field investigation · Final report · Dec 6, 2010 · N77CF · Substantial damage
  > The pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…
- [NTSB WPR10LA395](https://openairdocs.org/ntsb/WPR10LA395.md): Embraer EMB-145XR · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 10, 2010 · N14105 · Substantial damage
  > An in-flight collision with a bird while on the downwind leg of the traffic pattern during a visual approach.
- [NTSB WPR10CA355](https://openairdocs.org/ntsb/WPR10CA355.md): Leonard Trudy Kitfox III · Monument Valley, UT · Accident · No injuries · Data collection · Final report · Jul 17, 2010 · N888TL · Substantial damage
  > The pilot's inadequate compensation for the wind effects and failure to maintain directional control during an attempted go-around from a landing.
- [NTSB WPR10LA202](https://openairdocs.org/ntsb/WPR10LA202.md): Costruzioni AeronauticheTecnam P2002 Sierra · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Apr 10, 2010 · N797TS · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB WPR10CA146](https://openairdocs.org/ntsb/WPR10CA146.md): Diamond Aircraft Ind DA 20-C1 · Delta, UT · Accident · No injuries · Data collection · Final report · Feb 23, 2010 · N894CT · Substantial damage
  > The student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…
- [NTSB WPR10CA084](https://openairdocs.org/ntsb/WPR10CA084.md): Golden Circle Tierra I · Jensen, UT · Accident · No injuries · Data collection · Final report · Oct 24, 2009 · N440KC · Substantial damage
  > A loss of engine power, as reported by the pilot, for undetermined reasons.
- [NTSB WPR10LA034](https://openairdocs.org/ntsb/WPR10LA034.md): Aero Commander 690 · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Oct 21, 2009 · N690TR · Substantial damage
  > The failure of the landing gear accumulator/regulator and the installation of the improper priority valve, which precluded the landing gear from extending and locking into place.
- [NTSB WPR09CA469](https://openairdocs.org/ntsb/WPR09CA469.md): Cessna 182 · Parowan, UT · Accident · No injuries · Data collection · Final report · Sep 26, 2009 · N1040D · Substantial damage
  > The pilot's improper flare and recovery from a bounced landing.
- [NTSB LAX08CA138](https://openairdocs.org/ntsb/LAX08CA138.md): Schweizer 300C · Ogden, UT · Accident · Serious injuries · Data collection · Final report · Jun 2, 2008 · N1510A · Substantial damage
  > The pilot under instruction's encounter with a settling with power condition, and the flight instructor's failure to maintain adequate rotor rpm during the subsequent go-around. Also causal was the instructor pilot's delayed remedial action during the…
- [NTSB SEA07LA276](https://openairdocs.org/ntsb/SEA07LA276.md): Werner Vari-Eze · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Sep 2, 2007 · N547DB · Substantial damage
  > The loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the wind shear conditions encountered during the forced landing attempt.
- [NTSB SEA07LA250](https://openairdocs.org/ntsb/SEA07LA250.md): Schweizer SGS 2-33 · Morgan, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 2007 · N5731S · Substantial damage
  > The pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.
- [NTSB SEA07FA240](https://openairdocs.org/ntsb/SEA07FA240.md): Flight Design Ctsw · St. George, UT · Accident · Serious injuries · Field investigation · Final report · Aug 26, 2007 · N775CT · Substantial damage
  > The loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB LAX07LA257](https://openairdocs.org/ntsb/LAX07LA257.md): Schempp-Hirth Standard Cirrus · Heber, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 2007 · N62305 · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.
- [NTSB SEA07LA177](https://openairdocs.org/ntsb/SEA07LA177.md): Mooney M20C · Price, UT · Accident · 2 fatal · Limited investigation · Final report · Jun 23, 2007 · N6713N · Substantial damage
  > The pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…
- [NTSB SEA07CA128](https://openairdocs.org/ntsb/SEA07CA128.md): Forney F-1 · Morgan, UT · Accident · No injuries · Data collection · Final report · May 18, 2007 · N3007G · Substantial damage
  > The pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.
- [NTSB SEA06CA173](https://openairdocs.org/ntsb/SEA06CA173.md): Cessna 182RG · Fairfield, UT · Accident · No injuries · Data collection · Final report · Aug 30, 2006 · N5464N · Substantial damage
  > The failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…
- [NTSB SEA06FA116](https://openairdocs.org/ntsb/SEA06FA116.md): Lciv Lancair IV-P Propjet · Provo, UT · Accident · 3 fatal · Field investigation · Final report · Jun 9, 2006 · N95CE · Destroyed
  > The pilot's failure to maintain altitude/clearance during a VFR approach, which resulted in an in-flight collision with water. Contributing factors were the dark night light conditions and the low clouds.
- [NTSB SEA06CA017](https://openairdocs.org/ntsb/SEA06CA017.md): Cessna T210M · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Nov 16, 2005 · N6029N · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.
- [NTSB DEN05LA106](https://openairdocs.org/ntsb/DEN05LA106.md): Clarke YAK 3UR 2000 · Heber City, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2005 · N134US · Substantial damage
  > loss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…
- [NTSB DEN05LA019](https://openairdocs.org/ntsb/DEN05LA019.md): Piper PA-24-250 · Ogden, UT · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 2004 · N7852P · Substantial damage
  > the loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.
- [NTSB DEN04LA142](https://openairdocs.org/ntsb/DEN04LA142.md): Robinson R22 · Spanish Fork, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 2004 · N777UH · Substantial damage
  > the instructor's premature flare, resulting in a hard landing, and his failure to align the helicopter with the direction of travel, resulting in a rollover.Contributing factors were the low rotor RPM and inadequate airspeed. The reason for the loss of engine…
- [NTSB DEN03LA085](https://openairdocs.org/ntsb/DEN03LA085.md): Robinson R22 Beta · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · May 24, 2003 · N7176S · Substantial damage
  > The loss of power for undetermined reasons. Also causal was the student's failure to maintain aircraft control and the instructor's inadequate supervision. The instructor's delayed remedial action as a contributing factor.
- [NTSB DEN03FA068](https://openairdocs.org/ntsb/DEN03FA068.md): Cessna 310D · Provo, UT · Accident · 3 fatal · Field investigation · Final report · Apr 17, 2003 · N6861T · Destroyed
  > failure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…

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

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