# NTSB investigations: Piper PA-34-200T, 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 ERA13CA357](https://openairdocs.org/ntsb/ERA13CA357.md): Piper PA-34-200T · West Mifflin, PA · Accident · No injuries · Data collection · Final report · Aug 4, 2013 · N75131 · Substantial damage
  > The pilot's improper landing flare, which resulted in a hard landing.
- [NTSB NYC02LA007](https://openairdocs.org/ntsb/NYC02LA007.md): Piper PA-34-200T · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Oct 10, 2001 · N91284 · Substantial damage
  > The collapse of the right main landing gear for undetermined reasons.
- [NTSB NYC97FA013](https://openairdocs.org/ntsb/NYC97FA013.md): Piper PA-34-200T · Lehman Township, PA · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1996 · N5671V · Destroyed
  > The failure of the forward fuselage nose assembly for an undetermined reason, which resulted in an in-flight breakup of the airplane.
- [NTSB NYC92LA176](https://openairdocs.org/ntsb/NYC92LA176.md): Piper PA-34-200T · Coatesville, PA · Accident · No injuries · Limited investigation · Final report · Aug 24, 1992 · N37DD · Substantial damage
  > The pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.
- [NTSB NYC84FA135](https://openairdocs.org/ntsb/NYC84FA135.md): Piper PA-34-200T · Johnstown, PA · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1984 · N33569 · Destroyed
  > The acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light…
- [NTSB NYC79FA034](https://openairdocs.org/ntsb/NYC79FA034.md): Piper PA-34 · Philadelphia, PA · Accident · 2 fatal · Closed · Apr 3, 1979 · N6211J · 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" = '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 ('7103406'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103406&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.
