# NTSB investigations, 2009, AZ: Powerplant sys/comp malf/fail

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 WPR09LA196](https://openairdocs.org/ntsb/WPR09LA196.md): Cessna 152 · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2009 · N6285M · Substantial damage
  > A loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.
- [NTSB WPR09LA153](https://openairdocs.org/ntsb/WPR09LA153.md): Howes RV-6 · Paulden, AZ · Accident · 1 fatal · Limited investigation · Final report · Mar 19, 2009 · N6383W · Substantial damage
  > A total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…
- [NTSB WPR09IA140](https://openairdocs.org/ntsb/WPR09IA140.md): Eurocopter AS 350 B2 · Peach Springs, AZ · Incident · No injuries · Incident investigation · Final report · Mar 3, 2009 · N197AE · Minor damage
  > A loss of engine power due to the failure of the number three engine bearing as a result of oil starvation due to coked oil obstructing the oil passages.

## 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."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/340/sequence?state=AZ&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
