# NTSB investigations, OK: 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 DFW08CA047](https://openairdocs.org/ntsb/DFW08CA047.md): Cessna 210 · Medford, OK · Accident · No injuries · Data collection · Final report · Dec 21, 2007 · N5957F · Substantial damage
  > The pilot's decision to attempt a night landing without runway lighting. A contributing factor was inoperative runway lights.
- [NTSB FTW02LA044](https://openairdocs.org/ntsb/FTW02LA044.md): Bell 47G · Ardmore, OK · Accident · No injuries · Limited investigation · Final report · Dec 1, 2001 · N5226 · Substantial damage
  > the flight instructor's selection of an unsuitable area for practicing a full touchdown autorotation, which resulted in a nose over. A contributing factor was the soft ground.
- [NTSB DEN99FA086](https://openairdocs.org/ntsb/DEN99FA086.md): PZL-Mielec M-18B · Altus, OK · Accident · 1 fatal · Field investigation · Final report · May 25, 1999 · N8199W · Substantial damage
  > The pilot's disregard of takeoff performance data and his failure to jettison the load. Contributing factors were high density altitude, exceeding the aircraft's maximum allowable gross weight, and the berm.
- [NTSB FTW95LA200](https://openairdocs.org/ntsb/FTW95LA200.md): Beech D55 · Norman, OK · Accident · No injuries · Limited investigation · Final report · May 13, 1995 · N993ES · Substantial damage
  > The pilot's inadvertent retraction of the landing gear, resulting in a gear up landing.
- [NTSB FTW90LA117](https://openairdocs.org/ntsb/FTW90LA117.md): Boeing E75 · Watonga, OK · Accident · No injuries · Limited investigation · Final report · Jun 8, 1990 · N55292 · Substantial damage
  > Pic's failure to use all of the available runway. A factor was the high density altitude.
- [NTSB FTW88LA140](https://openairdocs.org/ntsb/FTW88LA140.md): Piper PA-28R · Oklahoma City, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1988 · N2970M · Substantial damage
  > The air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…
- [NTSB FTW86LA042](https://openairdocs.org/ntsb/FTW86LA042.md): Cessna 172N · Marietta, OK · Accident · No injuries · Limited investigation · Final report · Mar 15, 1986 · N7576G · Substantial damage
  > During takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…
- [NTSB FTW82DA398](https://openairdocs.org/ntsb/FTW82DA398.md): Piper PA-28-140 · Kansas, OK · Accident · No injuries · Final report · Sep 28, 1982 · N1755J · Substantial damage
  > Aircraft collided with a hole in a pasture after a precautionary landing due to low fuel state brought on by head winds.

## 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" = 'OK' 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=OK

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