# NTSB investigations: Piper PA-32R-301T, AL

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 ERA10LA110](https://openairdocs.org/ntsb/ERA10LA110.md): Piper PA-32R-301T · Auburn, AL · Accident · No injuries · Limited investigation · Final report · Jan 6, 2010 · N8448Y · Substantial damage
  > The pilot's loss of directional control after landing, which resulted in a runway excursion.
- [NTSB ATL03FA114](https://openairdocs.org/ntsb/ATL03FA114.md): Piper PA-32R-301T · Scottsboro, AL · Accident · 2 fatal · Field investigation · Final report · Jun 19, 2003 · N270LM · Substantial damage
  > The pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.
- [NTSB ATL84FA111](https://openairdocs.org/ntsb/ATL84FA111.md): Piper PA-32RT-301T · Goodway, AL · Accident · 2 fatal · Field investigation · Final report · Mar 3, 1984 · N8427A · Destroyed
  > Plt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…

## 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" = 'AL' 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 ('7103220', '7103221'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103220&state=AL

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