# NTSB investigations, UT: Recent experience

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.

## Latest cases

- [NTSB WPR23LA194](https://openairdocs.org/ntsb/WPR23LA194.md): Cubcrafters CCX-2300 · Spanish Fork, UT · Accident · No injuries · Class 4 · Limited · Final report · May 21, 2023 · N668LD · Substantial damage
  > The pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.
- [NTSB GAA17CA073](https://openairdocs.org/ntsb/GAA17CA073.md): Carter Richard L Buddy Baby Lakes · Hurricane, UT · Accident · No injuries · Data collection · Final report · Nov 10, 2016 · N1028Q · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB LAX08TA116](https://openairdocs.org/ntsb/LAX08TA116.md): Hughes TH-55 · Logan, UT · Accident · No injuries · Final report · Apr 18, 2008 · N6358Z · Substantial damage
  > The pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.

## The whole list in SQL

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

```sql
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02031035'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02031035/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
