# NTSB investigations: Piper PA-28-235, OK

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 GAA18CA082](https://openairdocs.org/ntsb/GAA18CA082.md): Piper PA28 · Pocasset, OK · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N8856W · Substantial damage
  > The pilot’s improper approach path, which resulted in the airplane landing short of the runway.
- [NTSB CEN12FA101](https://openairdocs.org/ntsb/CEN12FA101.md): Piper PA-28-235D · Chickasha, OK · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2011 · N999RR · Substantial damage
  > The non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…
- [NTSB FTW96LA358](https://openairdocs.org/ntsb/FTW96LA358.md): Piper PA-28-235 · Tulsa, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1996 · N8565W · Substantial damage
  > low fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.
- [NTSB FTW95LA135](https://openairdocs.org/ntsb/FTW95LA135.md): Piper PA-28-235 · Hobart, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1995 · N8514W · Substantial damage
  > The pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.
- [NTSB FTW82DA106](https://openairdocs.org/ntsb/FTW82DA106.md): Piper PA-28-235 · Tulsa, OK · Accident · Minor injuries · Final report · Mar 26, 1982 · N8904W · Substantial damage
  > The aircraft experienced a partial power loss during takeoff at an altitude of about 150 AGL. The pilot turned left with the intention of landing on a perpendicular taxiway. During the turn the aircraft developed a high sink-rate and struck the taxiway in a…
- [NTSB FTW81FPM13](https://openairdocs.org/ntsb/FTW81FPM13.md): Piper PA-28 · Tulsa, OK · Accident · Minor injuries · Closed · Jun 20, 1981 · N8510W · Substantial damage
- [NTSB FTW81FPJ09](https://openairdocs.org/ntsb/FTW81FPJ09.md): Piper PA-28 · Enid, OK · Accident · No injuries · Closed · Jan 8, 1981 · N38558 · Substantial damage
- [NTSB FTW79FPJ12](https://openairdocs.org/ntsb/FTW79FPJ12.md): Piper PA-28 · Purcell, OK · Accident · 1 fatal · Closed · Apr 26, 1979 · N8530W · Destroyed
- [NTSB FTW73DPJ05](https://openairdocs.org/ntsb/FTW73DPJ05.md): Piper PA-28 · Yukon, OK · Accident · No injuries · Closed · Sep 23, 1972 · N9349W · Substantial damage
- [NTSB FTW66F0615](https://openairdocs.org/ntsb/FTW66F0615.md): Piper PA-28 · Stilwell, OK · Accident · No injuries · Closed · Apr 14, 1966 · N8965W · Substantial damage
- [NTSB UNK64X3773](https://openairdocs.org/ntsb/UNK64X3773.md): Piper PA28 · Kingston, OK · Accident · No injuries · Closed · Sep 4, 1964 · N8702W · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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