# Fatal NTSB investigations: Piper PA 31P 350

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 BFO95FA064](https://openairdocs.org/ntsb/BFO95FA064.md): Piper PA-31P-350 · Cedar Bluff, VA · Accident · 3 fatal · Field investigation · Final report · Jun 15, 1995 · N922DC · Destroyed
  > the pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.
- [NTSB LAX89FA025](https://openairdocs.org/ntsb/LAX89FA025.md): Piper PA31P-350 · Redlands, CA · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1988 · N79HW · Destroyed
  > The pilot's inadvertent selection of an inappropriate altitude for the attempted night special VFR circle to land maneuver. Contributing to the accident was the dark night, restricted visibilities and lack of ground reference lights. Also contributing to the…
- [NTSB FTW86FA031](https://openairdocs.org/ntsb/FTW86FA031.md): Piper PA-31P-350 · Norco, LA · Accident · 2 fatal · Field investigation · Final report · Jan 5, 1986 · N9253Y · Destroyed
  > The plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…

## 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 ('7103111'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7103111

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