# NTSB investigations: Piper PA-32R-300, MI

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 CEN19LA066](https://openairdocs.org/ntsb/CEN19LA066.md): Piper PA-32R-300 · Adrian, MI · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 2019 · N8892E · Substantial damage
  > The airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.
- [NTSB CEN15FA342](https://openairdocs.org/ntsb/CEN15FA342.md): Piper PA 32R-300 · Harbor Springs, MI · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2015 · N43829 · Substantial damage
  > The pilot's failure to maintain clearance from the trees during the approach in dark, night conditions, which resulted in controlled flight into trees and terrain.
- [NTSB CHI87LA217](https://openairdocs.org/ntsb/CHI87LA217.md): Piper PA-32R-300 · Hillsdale, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1987 · N8799E · Destroyed
  > Tkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…
- [NTSB CHI84LA039](https://openairdocs.org/ntsb/CHI84LA039.md): Piper PA-32R-300 · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Oct 6, 1983 · N47519 · Substantial damage
  > The acft was struck by a truck as it taxied on the ramp after landing. The fire department reported the truck left a 25 ft skid mark as it came out from an area of parked acft and struck N47519.
- [NTSB CHI81FEC07](https://openairdocs.org/ntsb/CHI81FEC07.md): Piper PA-32R · Belleville, MI · Accident · No injuries · Closed · Dec 20, 1980 · N5421F · Substantial damage
- [NTSB CHI80FEC22](https://openairdocs.org/ntsb/CHI80FEC22.md): Piper PA-32R · Troy, MI · Accident · Serious injuries · Closed · Jul 10, 1980 · N7113F · 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" = 'MI' 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 ('7103213'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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