# NTSB investigations: Piper PA-28R-201T, 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 FTW98LA112](https://openairdocs.org/ntsb/FTW98LA112.md): Piper PA-28R-201T · Lone Grove, OK · Accident · Serious injuries · Limited investigation · Final report · Jan 29, 1998 · N43763 · Substantial damage
  > The total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced…
- [NTSB FTW94FA208](https://openairdocs.org/ntsb/FTW94FA208.md): Piper PA-28R-201T · Southard, OK · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1994 · N9766K · Destroyed
  > The pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.
- [NTSB FTW88FA164](https://openairdocs.org/ntsb/FTW88FA164.md): Piper PA-28R-201T · Okmulgee, OK · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1988 · N47806 · Destroyed
  > Non-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…
- [NTSB FTW82FPJ11](https://openairdocs.org/ntsb/FTW82FPJ11.md): Piper PA-28R-201T · Watonga, OK · Accident · No injuries · Final report · Jan 14, 1982 · N47442 · Substantial damage
  > The pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…
- [NTSB FTW81FPJ26](https://openairdocs.org/ntsb/FTW81FPJ26.md): Piper PA-28R · Carnegie, OK · Accident · Serious injuries · Closed · May 24, 1981 · N777VS · 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 ('7102813'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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