# NTSB investigations: Piper PA-28R-200: Oil

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 WPR23LA094](https://openairdocs.org/ntsb/WPR23LA094.md): Piper PA28R · Carlsbad, CA · Accident · No injuries · Class 3 · Limited · Final report · Jan 19, 2023 · N57355 · Substantial damage
  > A failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.
- [NTSB CEN19LA132](https://openairdocs.org/ntsb/CEN19LA132.md): Piper PA28R · Prairieville, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 3, 2019 · N41AT · Minor damage
  > Installation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…
- [NTSB WPR15LA141](https://openairdocs.org/ntsb/WPR15LA141.md): Piper PA 28R-200 · Santa Maria, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 2015 · N5469T · Substantial damage
  > The engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…
- [NTSB CEN15LA157](https://openairdocs.org/ntsb/CEN15LA157.md): Piper PA 28R-200 · Frankenmuth, MI · Accident · No injuries · Limited investigation · Final report · Feb 27, 2015 · N2837R · Substantial damage
  > The failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01071020')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01071020/cases?model=7102811

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
