# NTSB investigations: Piper PA-31-350, 2020

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 ERA20LA331](https://openairdocs.org/ntsb/ERA20LA331.md): Piper PA31 · Fort Lauderdale, FL · Accident · No injuries · Class 3 · Limited · Final report · Sep 19, 2020 · N257SH · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s decision to continue to the destination following the loss of engine power to the first engine.
- [NTSB ANC20CA044](https://openairdocs.org/ntsb/ANC20CA044.md): Piper PA31 · Buckland, AK · Accident · No injuries · Data collection · Final report · Apr 18, 2020 · N88TG · Substantial damage
  > The pilot's failure to extend the landing gear before landing due to distraction by the condition of the runway and his failure to use the Before Landing checklist.
- [NTSB ANC20LA013](https://openairdocs.org/ntsb/ANC20LA013.md): Piper PA31 · Fairbanks, AK · Accident · No injuries · Class 3 · Limited · Final report · Jan 12, 2020 · N4112K · Substantial damage
  > The improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…

## 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 year(c."eventDate") = 2020
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103110', '7103125'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103110&year=2020

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