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

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 ANC05LA068](https://openairdocs.org/ntsb/ANC05LA068.md): Piper PA-31-350 · Utopia, AK · Accident · No injuries · Limited investigation · Final report · Dec 15, 2004 · N792FC · Substantial damage
  > The pilot's misjudged distance/speed while on final approach to land, which resulted in an overrun during the landing roll. Factors associated with the accident are the pilot's inadequate weather evaluation, and a gusty tailwind.
- [NTSB NYC05FA028](https://openairdocs.org/ntsb/NYC05FA028.md): Piper PA-31-350 · Vandalia, OH · Accident · 1 fatal · Field investigation · Final report · Dec 7, 2004 · N54316 · Destroyed
  > The pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.
- [NTSB DFW05FA020](https://openairdocs.org/ntsb/DFW05FA020.md): Piper PA-31-350 · San Antonio, TX · Accident · 5 fatal · Field investigation · Final report · Nov 14, 2004 · N40731 · Destroyed
  > The pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.
- [NTSB MIA05LA011](https://openairdocs.org/ntsb/MIA05LA011.md): Piper PA-31-350 · Pompano Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2004 · N61518 · Destroyed
  > The pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…
- [NTSB ANC04LA117](https://openairdocs.org/ntsb/ANC04LA117.md): Piper PA-31-350 · Telida, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 2004 · N41185 · Substantial damage
  > A failure of the pilot-in-command to extend the landing gear, which resulted in a gear-up landing and structural damage to the airplane.
- [NTSB FTW04LA238](https://openairdocs.org/ntsb/FTW04LA238.md): Piper PA-31-350 · Sweeny, TX · Accident · No injuries · Limited investigation · Final report · Sep 14, 2004 · N555MC · Substantial damage
  > The fracture failure of the left engine crankshaft for undetermined reasons.
- [NTSB IAD04FA030](https://openairdocs.org/ntsb/IAD04FA030.md): Piper PA-31-350 · Ticonderoga, NY · Accident · 2 fatal · Field investigation · Final report · Jul 10, 2004 · N45032 · Destroyed
  > Reason for occurrence undetermined.
- [NTSB ANC04LA059](https://openairdocs.org/ntsb/ANC04LA059.md): Piper PA-31-350 · Goodnews, AK · Accident · No injuries · Limited investigation · Final report · May 23, 2004 · N4105D · Substantial damage
  > The pilot's inadequate weather evaluation which resulted in an in-flight encounter with severe turbulence, and his exceedence of the design stress limits resulting in overstress of the wings. A factor contributing to the accident was the presence of…
- [NTSB ANC04LA018](https://openairdocs.org/ntsb/ANC04LA018.md): Piper PA-31-350 · Koyukuk, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 2004 · N45008 · Substantial damage
  > The pilot's continued flight into adverse weather conditions, and his failure to maintain clearance from terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog and whiteout weather conditions.

## 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") = 2004
  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=2004

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