# Fatal NTSB investigations: Piper PA-34-200T: Loss of control in flight

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 ERA19LA012](https://openairdocs.org/ntsb/ERA19LA012.md): Piper PA34 · Westhampton Beach, NY · Accident · 3 fatal · Limited investigation · Final report · Oct 13, 2018 · N593MS · Destroyed
  > The instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…
- [NTSB ERA18FA148](https://openairdocs.org/ntsb/ERA18FA148.md): Piper PA34 · Bennington, VT · Accident · 1 fatal · Field investigation · Final report · May 20, 2018 · N1101X · Destroyed
  > The pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.
- [NTSB CEN15FA087](https://openairdocs.org/ntsb/CEN15FA087.md): Piper PA-34-200T · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2014 · N38884 · Destroyed
  > The pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.
- [NTSB ERA13FA253](https://openairdocs.org/ntsb/ERA13FA253.md): Piper PA-34-200T · Johnstown, NY · Accident · 3 fatal · Field investigation · Final report · May 24, 2013 · N31743 · Destroyed
  > The pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.

## 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."highestInjuryLevel" = 'Fatal'
  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')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/240/sequence?fatal=1&model=7103406

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
