# NTSB investigations: Piper PA-28-181, 2009

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 CEN10LA054](https://openairdocs.org/ntsb/CEN10LA054.md): Piper PA-28-181 · Mineola, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2009 · N3148Q · Substantial damage
  > A loss of engine power due to fuel exhaustion and the pilot's inadequate preflight planning.
- [NTSB WPR09CA410](https://openairdocs.org/ntsb/WPR09CA410.md): Piper PA28 · Glendale, AZ · Accident · No injuries · Data collection · Final report · Aug 21, 2009 · N424PA · Substantial damage
  > The student pilot's failure to maintain directional control during the landing roll.
- [NTSB WPR09CA406](https://openairdocs.org/ntsb/WPR09CA406.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Data collection · Final report · Aug 19, 2009 · N4177L · Substantial damage
  > The student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.
- [NTSB WPR09CA363](https://openairdocs.org/ntsb/WPR09CA363.md): Piper PA-28-181 · Metaline Falls, WA · Accident · No injuries · Data collection · Final report · Jul 23, 2009 · N2903A · Substantial damage
  > The pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.
- [NTSB ERA09CA322](https://openairdocs.org/ntsb/ERA09CA322.md): Piper PA-28-181 · Caldwell, NJ · Accident · No injuries · Data collection · Final report · May 31, 2009 · N811SA · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during landing. Contributing to the accident was the pilot’s failure to ensure that he could operate the rudder pedals without interference.
- [NTSB ERA09LA296](https://openairdocs.org/ntsb/ERA09LA296.md): Piper PA-28 · Dingman, PA · Accident · No injuries · Limited investigation · Final report · May 18, 2009 · N4130W · Substantial damage
  > A total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.
- [NTSB CEN09WA248](https://openairdocs.org/ntsb/CEN09WA248.md): Piper PA-28-181 · Steep, United Kingdom · Accident · 2 fatal · Foreign investigation · Apr 10, 2009 · N2405Y · Destroyed
- [NTSB WPR09LA164](https://openairdocs.org/ntsb/WPR09LA164.md): Piper PA-28-181 · Firebaugh, CA · Accident · No injuries · Limited investigation · Final report · Mar 24, 2009 · N1857H · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning and monitoring.

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

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

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