# NTSB investigations, WY: On ground/water encounter with terrain/water

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 DEN03LA148](https://openairdocs.org/ntsb/DEN03LA148.md): Cessna 150H · Moran, WY · Accident · No injuries · Limited investigation · Final report · Sep 1, 2003 · N23108 · Substantial damage
  > the pilot's selection of an unsuitable takeoff area which resulted in an encounter with the gopher hole during the touch-and-go. Factors contributing to the accident were the gopher hole, the abrupt pull up, the low airspeed, the inadvertent stall mush, the…
- [NTSB DEN02LA024](https://openairdocs.org/ntsb/DEN02LA024.md): Aviat A-1A · Afton, WY · Accident · No injuries · Limited investigation · Final report · Feb 11, 2002 · N29HU · Substantial damage
  > The pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.
- [NTSB DEN99LA017](https://openairdocs.org/ntsb/DEN99LA017.md): Cessna 182A · Bedford, WY · Accident · No injuries · Limited investigation · Final report · Nov 1, 1998 · N6352B · Substantial damage
  > The pilot's failure to identify a soft area on his newly constructed airstrip, which subsequently caused his airplane to nose over.
- [NTSB SEA95LA180](https://openairdocs.org/ntsb/SEA95LA180.md): Mooney M20A · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Aug 11, 1995 · N8378E · Substantial damage
  > The pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…
- [NTSB SEA91LA187](https://openairdocs.org/ntsb/SEA91LA187.md): Beech A-36 · Kemmerer, WY · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1991 · N4394A · Substantial damage
  > The pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.
- [NTSB DEN88LA154](https://openairdocs.org/ntsb/DEN88LA154.md): Piper PA-18 · Cody, WY · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N6083A · Substantial damage
  > During landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…
- [NTSB DEN83LA207](https://openairdocs.org/ntsb/DEN83LA207.md): Cessna 210E · Powell, WY · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N2339F · Substantial damage
  > According to the pilot he made an approach to a dirt road beside a feed lot and overshot the intended touchdown point. He was relectant to make a go around because there was a high hill close ahead. He tried to stop the acft on the road remaining but the road…

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

This list as a web page: https://openairdocs.org/ntsb?occurrence=320&state=WY

---
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.