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

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 BFO94LA113](https://openairdocs.org/ntsb/BFO94LA113.md): Piper PA-32R-300 · Seven Springs, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1994 · N40051 · Substantial damage
  > The pilot's failure to attain adequate airspeed and his premature liftoff which resulted in a stall mush and collision with trees.
- [NTSB BFO94LA070](https://openairdocs.org/ntsb/BFO94LA070.md): Piper PA-32R-300 · Bedford, PA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1994 · N4445X · Substantial damage
  > The pilot's failure to maintain the proper descent rate which resulted in an undershoot of the runway.
- [NTSB NYC90LA032](https://openairdocs.org/ntsb/NYC90LA032.md): Piper PA-32R-300 · Johnstown, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 1989 · N1028Q · Substantial damage
  > Failure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…
- [NTSB NYC83LA073](https://openairdocs.org/ntsb/NYC83LA073.md): Piper PA-32R-300 · Quakertown, PA · Accident · No injuries · Limited investigation · Final report · Feb 28, 1983 · N38389 · Substantial damage
  > The acft touched down about 1 ft short of the rwy. The left gear & wing was damaged.
- [NTSB NYC79FGM48](https://openairdocs.org/ntsb/NYC79FGM48.md): Piper PA-32 · Erie, PA · Accident · No injuries · Closed · Sep 24, 1979 · N6838J · 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" = 'PA' 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=PA

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