# NTSB investigations: Piper PA-31-310: Airframe/component/system failure/malfunction

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 MIA93LA152](https://openairdocs.org/ntsb/MIA93LA152.md): Piper PA-31 · Atlantic Ocean (Atlantic Ocean) · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1993 · N36L · Destroyed
  > Total loss of engine power from both engines due to fuel exhaustion after the pilot became lost/disoriented. Contributing to the accident was the delay by the pilot-in-command to execute the emergency procedure by resetting the alternators and voltage…
- [NTSB CHI93LA145](https://openairdocs.org/ntsb/CHI93LA145.md): Piper PA-31-310 · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · Apr 22, 1993 · N654N · Substantial damage
  > failure of the landing gear actuator cable.
- [NTSB DEN91FA065](https://openairdocs.org/ntsb/DEN91FA065.md): Piper PA-31B-310 · Bennett, CO · Accident · 1 fatal · Field investigation · Final report · May 1, 1991 · N7407L · Destroyed
  > In-flight separation of the left engine cowl assembly that was not properly latched, and failure of the pilot to maintain minimum control speed, which resulted in his loss of aircraft control. Factors related to the accident were: an inadequate preflight…
- [NTSB CHI86LA228](https://openairdocs.org/ntsb/CHI86LA228.md): Piper PA-31-310 · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N707HB · Substantial damage
  > At the end of an uneventful flight the pilot lowered the landing gear and noted three gear down indicator lights. Upon landing rollout the nose gear collapsed. An inspection following the accident revealed that a hydraulic leak was present near the hydraulic…
- [NTSB ATL83FA003](https://openairdocs.org/ntsb/ATL83FA003.md): Piper PA-31-310 · Dyersburg, TN · Accident · Minor injuries · Field investigation · Final report · Oct 4, 1982 · N1ET · Substantial damage
  > At 30 mi north of the destination, the inboard side of the right eng cowl popped loose & began vibrating severely, the plt was concerned that the cowling would break loose & strike the vert of horiz stabilizer so he feathered the r eng. Atthis point, the arpt…
- [NTSB DCA82AA009](https://openairdocs.org/ntsb/DCA82AA009.md): Piper PA-31 · Ithaca, NY · Accident · 2 fatal · Final report · Jan 5, 1982 · N546BA · Destroyed
  > The acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103102')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103102&occurrence=130

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