# NTSB investigations: Piper PA-28R-200, 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 CEN12CA671](https://openairdocs.org/ntsb/CEN12CA671.md): Piper PA-28R-200 · Goldsby, OK · Accident · No injuries · Data collection · Final report · Aug 29, 2012 · N7602C · Substantial damage
  > The commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.
- [NTSB FTW97FA100](https://openairdocs.org/ntsb/FTW97FA100.md): Piper PA-28-200 · Lone Wolf, OK · Accident · 3 fatal · Field investigation · Final report · Feb 3, 1997 · N33322 · Destroyed
  > the pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…
- [NTSB FTW95LA070](https://openairdocs.org/ntsb/FTW95LA070.md): Piper PA-28R-200 · Oklahoma City, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1994 · N2874R · Substantial damage
  > The loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.
- [NTSB FTW89LA098](https://openairdocs.org/ntsb/FTW89LA098.md): Piper PA-28R-200 · Edmond, OK · Accident · No injuries · Limited investigation · Final report · May 24, 1989 · N3940X · Substantial damage
  > Improper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.
- [NTSB FTW86LA157](https://openairdocs.org/ntsb/FTW86LA157.md): Piper PA-28R-200 · Afton, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1986 · N214PR · Substantial damage
  > The pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness.
- [NTSB FTW83FA406](https://openairdocs.org/ntsb/FTW83FA406.md): Piper PA 28R-200 · Copan, OK · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1983 · N1292T · Destroyed
  > The acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…
- [NTSB FTW81FPM18](https://openairdocs.org/ntsb/FTW81FPM18.md): Piper PA-28R · Jay, OK · Accident · No injuries · Closed · Aug 6, 1981 · N4509X · Substantial damage
- [NTSB FTW81FPM06](https://openairdocs.org/ntsb/FTW81FPM06.md): Piper PA-28 · Atoka, OK · Accident · No injuries · Closed · Jan 4, 1981 · N8824E · Substantial damage
- [NTSB FTW79FPM15](https://openairdocs.org/ntsb/FTW79FPM15.md): Piper PA-28R · Tulsa, OK · Accident · No injuries · Closed · Sep 27, 1979 · N1073X · Substantial damage
- [NTSB FTW77FA073](https://openairdocs.org/ntsb/FTW77FA073.md): Piper PA-28R · Hugo, OK · Accident · 3 fatal · Closed · Aug 28, 1977 · N33862 · Destroyed
- [NTSB FTW76DPD61](https://openairdocs.org/ntsb/FTW76DPD61.md): Piper PA-28R · Idabel, OK · Accident · No injuries · Closed · Sep 30, 1976 · N1986T · Substantial damage
- [NTSB FTW76AF070](https://openairdocs.org/ntsb/FTW76AF070.md): Piper PA-28R · Boswell, OK · Accident · 1 fatal · Closed · Mar 11, 1976 · N33767 · Destroyed
- [NTSB FTW71FPJ40](https://openairdocs.org/ntsb/FTW71FPJ40.md): Piper J3C · Lindsay, OK · Accident · 1 fatal · Closed · Apr 21, 1971 · N42682 · Destroyed

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

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