# NTSB investigations: Piper PA-32RT-300, OH

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 ERA23LA306](https://openairdocs.org/ntsb/ERA23LA306.md): Piper PA-32RT-300 · Mount Gilead, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 21, 2023 · N9519C · Substantial damage
  > The pilot’s improper fuel management by not switching fuel tanks in flight, resulting in fuel starvation to the engine and a total loss of engine power.
- [NTSB IAD99LA029](https://openairdocs.org/ntsb/IAD99LA029.md): Piper PA-32RT-300 · Medina, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 7, 1999 · N31975 · Destroyed
  > Was the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.
- [NTSB CHI84LA120](https://openairdocs.org/ntsb/CHI84LA120.md): Piper PA-32RT-300 · Lima, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1984 · N30026 · Substantial damage
  > Heavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…
- [NTSB CHI81FEK09](https://openairdocs.org/ntsb/CHI81FEK09.md): Piper PA32RT · Columbus, OH · Accident · No injuries · Closed · Dec 31, 1980 · N36126 · Destroyed
- [NTSB CHI79FEK14](https://openairdocs.org/ntsb/CHI79FEK14.md): Piper PA32RT · St Clairsville, OH · Accident · No injuries · Closed · May 28, 1979 · N36126 · Substantial damage
- [NTSB CHI79FEK08](https://openairdocs.org/ntsb/CHI79FEK08.md): Piper PA32RT · Sidney, OH · Accident · No injuries · Closed · Mar 16, 1979 · N31996 · Substantial damage

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

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

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