# NTSB investigations, UT: Use of equip/info, general

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 WPR14LA346](https://openairdocs.org/ntsb/WPR14LA346.md): Boeing 737 7H4 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 14, 2014 · N758SW · Substantial damage
  > The disconnection of baggage carts that subsequently collided with the parked airplane following the tug driving over a dip in the roadway.
- [NTSB WPR12CA351](https://openairdocs.org/ntsb/WPR12CA351.md): Robinson R22 · Monticello, UT · Accident · Minor injuries · Data collection · Final report · Aug 11, 2012 · N7135J · Substantial damage
  > The pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…
- [NTSB WPR12GA243](https://openairdocs.org/ntsb/WPR12GA243.md): Lockheed P2V-7 · Modena, UT · Accident · 2 fatal · Final report · Jun 3, 2012 · N14447 · Substantial damage
  > The flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…
- [NTSB WPR11LA056](https://openairdocs.org/ntsb/WPR11LA056.md): Bell 407 · Riverdale, UT · Accident · No injuries · Limited investigation · Final report · Nov 22, 2010 · N408UH · Substantial damage
  > The pilot's failure to maintain clearance from a highway marker sign while maneuvering.

## 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", '02063000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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