# NTSB investigations: Piper PA-30, ID

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 WPR13FA281](https://openairdocs.org/ntsb/WPR13FA281.md): Piper PA-30 · Idaho Falls, ID · Accident · 2 fatal · Field investigation · Final report · Jun 22, 2013 · N830SS · Substantial damage
  > A loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.
- [NTSB LAX07LA108](https://openairdocs.org/ntsb/LAX07LA108.md): Piper PA-30 · Paris, ID · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 2007 · N7169Y · Substantial damage
  > a loss of power in the right engine for undetermined reasons.
- [NTSB SEA01FA175](https://openairdocs.org/ntsb/SEA01FA175.md): Piper PA-30 · McCall, ID · Accident · 1 fatal · Field investigation · Final report · Sep 29, 2001 · N954S · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a loss of power on the left engine, resulting in loss of aircraft control. Factors included a loss of power on the left engine for undetermined reasons, and the pilot's failure to properly configure…
- [NTSB SEA95LA142](https://openairdocs.org/ntsb/SEA95LA142.md): Piper PA-30 · Island Park, ID · Accident · No injuries · Limited investigation · Final report · Jul 6, 1995 · N7487Y · Substantial damage
  > The pilot's inadequate compensation for wind conditions. A factor to the accident was wind gusts.

## 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  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&state=ID

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