# NTSB investigations, UT: Undershoot

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 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 DEN90LA133](https://openairdocs.org/ntsb/DEN90LA133.md): Piper Aerostar 601P · Brigham City, UT · Accident · No injuries · Limited investigation · Final report · Jun 13, 1990 · N3637F · Substantial damage
  > The pilot's failure to attain the proper touchdown point.
- [NTSB DEN88LA136](https://openairdocs.org/ntsb/DEN88LA136.md): Piper PA-28-160 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1988 · N5113W · Substantial damage
  > The low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…
- [NTSB DEN85LA197](https://openairdocs.org/ntsb/DEN85LA197.md): Piper PA-28 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N2203D · Substantial damage
  > The student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.
- [NTSB DEN85LA047](https://openairdocs.org/ntsb/DEN85LA047.md): Piper PA-22-135 · Taylor, UT · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N3648A · Substantial damage
  > Acft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely.
- [NTSB DEN82DA032](https://openairdocs.org/ntsb/DEN82DA032.md): Cessna 210 · Blanding, UT · Accident · Minor injuries · Final report · Feb 17, 1982 · N4814K · Substantial damage
  > The pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=390&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.
