# NTSB investigations, UT: On ground/water encounter with weather

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 FTW98LA214](https://openairdocs.org/ntsb/FTW98LA214.md): Stinson 108-1 · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · May 10, 1998 · N8178K · Destroyed
  > The pilot's inadequate compensation for winds while taxing. A factor was gusty, high wind conditions.
- [NTSB DEN86LA111](https://openairdocs.org/ntsb/DEN86LA111.md): Cessna 170B · St George, UT · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N2436D · Substantial damage
  > The plt stated the acft encountered a crosswind and ground looped during the landing touchdown.
- [NTSB DEN84LA277](https://openairdocs.org/ntsb/DEN84LA277.md): Cessna 180 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N926OC · Substantial damage
  > According to the plt, at midfield during the landing roll a gust of wind from the west caught the right wing. The acft ground looped collapsing the left main landing gear and damaging the left wing. While the nearest wx observation facility reported wind from…
- [NTSB DEN83LA182](https://openairdocs.org/ntsb/DEN83LA182.md): Helio Courier H-295 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 4, 1983 · N6484V · Substantial damage
  > Before starting his takeoff, the plt waited for other acft in the pattern to make touch-and-go landings. Immediately before & during his attempted takeoff, the plt saw 2 national guard helicopters hovering over a sod area, west of rwy 34. Reportedly, the 1st…

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

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