# NTSB investigations: Piper PA-24-250, 2003

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 NYC04LA086](https://openairdocs.org/ntsb/NYC04LA086.md): Piper PA-24-250 · Kutztown, PA · Accident · No injuries · Limited investigation · Final report · Nov 25, 2003 · N5406P · Substantial damage
  > The pilot's inadvertent retraction of the landing gear on the ground.
- [NTSB ATL04LA024](https://openairdocs.org/ntsb/ATL04LA024.md): Piper PA-24-250 · Troy, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 2003 · N5920P · Substantial damage
  > The certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.
- [NTSB CHI03LA315](https://openairdocs.org/ntsb/CHI03LA315.md): Piper PA-24-250 · Chanute, KS · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2003 · N122CC · Substantial damage
  > The pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…
- [NTSB LAX03LA190](https://openairdocs.org/ntsb/LAX03LA190.md): Piper PA-24-250 · Fallon, NV · Accident · No injuries · Limited investigation · Final report · Jun 10, 2003 · N5058P · Substantial damage
  > The pilot's inadequate preflight and his mismanagement of the fuel supply by his failure to switch fuel tanks.
- [NTSB DEN03LA049](https://openairdocs.org/ntsb/DEN03LA049.md): Piper PA-24-250 · Belen, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 2003 · N6960P · Substantial damage
  > the pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…
- [NTSB ATL03FA041](https://openairdocs.org/ntsb/ATL03FA041.md): Piper PA-24-250 · Florence, SC · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2003 · N5587P · Destroyed
  > The pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.

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

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

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