# NTSB investigations: Piper PA-32R-301T: Off-field or emergency landing

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 CEN20LA384](https://openairdocs.org/ntsb/CEN20LA384.md): Piper PA32R · Bonham, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 7, 2020 · N3576X · Substantial damage
  > The loss of engine power due to a disconnected fuel injector line that was not properly tightened during recent maintenance.
- [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 CEN15LA206](https://openairdocs.org/ntsb/CEN15LA206.md): Piper PA 32R-301T · Stephenville, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2015 · N9284 · Substantial damage
  > The partial loss of engine power after takeoff for undetermined reasons, which necessitated a forced landing, during which the airplane impacted trees and a power line.
- [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.

## 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" = '440' 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/440/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.
