# NTSB investigations: Piper PA-28R-200, AR

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 CEN15LA270](https://openairdocs.org/ntsb/CEN15LA270.md): Piper PA28-200 · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Jun 10, 2015 · N872CS · Substantial damage
  > Maintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.
- [NTSB MKC86LA135](https://openairdocs.org/ntsb/MKC86LA135.md): Piper PA-28R-200 · Mammoth Spring, AR · Accident · No injuries · Limited investigation · Final report · Jun 26, 1986 · N44767 · Substantial damage
  > The pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…
- [NTSB FTW81DPG08](https://openairdocs.org/ntsb/FTW81DPG08.md): Piper PA-28R · Mountain Home, AR · Accident · No injuries · Closed · Nov 28, 1980 · N43496 · Substantial damage
- [NTSB FTW80DA119](https://openairdocs.org/ntsb/FTW80DA119.md): Piper PA-28R · Mountain View, AR · Accident · No injuries · Closed · Sep 20, 1980 · N32820 · Substantial damage
- [NTSB FTW78DPG55](https://openairdocs.org/ntsb/FTW78DPG55.md): Piper PA-28R · Dermott, AR · Accident · No injuries · Closed · Jul 2, 1978 · N8539C · Substantial damage
- [NTSB FTW77DPG45](https://openairdocs.org/ntsb/FTW77DPG45.md): Piper PA-28R · Manila, AR · Accident · No injuries · Closed · Jun 10, 1977 · N5057S · Substantial damage
- [NTSB FTW77DPG10](https://openairdocs.org/ntsb/FTW77DPG10.md): Piper PA-28R · Dermott, AR · Accident · No injuries · Closed · Nov 30, 1976 · N55830 · Substantial damage
- [NTSB FTW73FPG39](https://openairdocs.org/ntsb/FTW73FPG39.md): Piper PA-28R · Black Fork, AR · Accident · Serious injuries · Closed · Mar 1, 1973 · N4974T · 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" = 'AR' 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=AR

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