# NTSB investigations: Piper PA-32R-301T: Powerplant sys/comp malf/fail

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 ERA24FA050](https://openairdocs.org/ntsb/ERA24FA050.md): Piper PA32R · Attalla, AL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 27, 2023 · N4187Q · Destroyed
  > The undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…
- [NTSB CEN17LA226](https://openairdocs.org/ntsb/CEN17LA226.md): Piper PA 32R-301T · Dalhart, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2017 · N782SW · Substantial damage
  > The failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.
- [NTSB ERA12LA524](https://openairdocs.org/ntsb/ERA12LA524.md): Piper PA-32R-301T · Riverview, FL · Accident · No injuries · Limited investigation · Final report · Aug 23, 2012 · N362DM · Substantial damage
  > Damage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.
- [NTSB WPR10LA128](https://openairdocs.org/ntsb/WPR10LA128.md): Piper PA-32R-301T · Dolan Springs, AZ · Accident · No injuries · Limited investigation · Final report · Feb 4, 2010 · N1060X · Substantial damage
  > The fuel flow divider inlet line nut coming loose during cruise flight, resulting in a fuel leak and in-flight fire. The root cause of the loose B-nut fitting could not be determined. Contributing to the accident was the pilot's decision to fly the airplane…

## 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 ('7103220', '7103221')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/340/sequence?model=7103220

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