# NTSB investigations: Piper PA-30, 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 CEN10FA070](https://openairdocs.org/ntsb/CEN10FA070.md): Piper PA-30 · Port Mansfield, TX · Accident · 2 fatal · Field investigation · Final report · Dec 11, 2009 · N7781Y · Destroyed
  > The pilot’s failure to maintain clearance with the water while on approach (VFR) to land.
- [NTSB ERA10FA088](https://openairdocs.org/ntsb/ERA10FA088.md): Piper PA-30 · Raneille, WV · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2009 · N8923Y · Substantial damage
  > The pilot's improper decision to attempt visual flight into deteriorating night weather conditions, and his subsequent controlled flight into terrain.
- [NTSB WPR09LA372](https://openairdocs.org/ntsb/WPR09LA372.md): Piper PA-30 · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Jul 22, 2009 · N7504Y · Substantial damage
  > A tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.
- [NTSB WPR09LA324](https://openairdocs.org/ntsb/WPR09LA324.md): Piper PA-30 · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2009 · N7657Y · Substantial damage
  > The pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.
- [NTSB ERA09WA291](https://openairdocs.org/ntsb/ERA09WA291.md): Piper PA-30 · Port Sudan, Sudan · Accident · 2 fatal · Foreign investigation · May 10, 2009 · N502TC · Destroyed
  > On May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…
- [NTSB ERA09CA277](https://openairdocs.org/ntsb/ERA09CA277.md): Piper PA-30 · Great Barrington, MA · Accident · No injuries · Data collection · Final report · Apr 30, 2009 · N8034Y · Substantial damage
  > The pilot's improper decision to land with a tailwind.
- [NTSB ERA09LA209](https://openairdocs.org/ntsb/ERA09LA209.md): Piper PA-30 · Lumberton, MS · Accident · No injuries · Limited investigation · Final report · Mar 8, 2009 · N8560Y · Substantial damage
  > Collapse of the landing gear due to worn left main landing gear components.
- [NTSB ERA09LA158](https://openairdocs.org/ntsb/ERA09LA158.md): Piper PA-30 · Lakeville, NY · Accident · No injuries · Limited investigation · Final report · Feb 8, 2009 · N10JR · Substantial damage
  > The pilot's failure to maintain aircraft control following a loss of engine power on the left engine for undetermined reasons.

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

This list as a web page: https://openairdocs.org/ntsb?model=7103002&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.