# NTSB investigations, 2009, CA: 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 WPR10FA056](https://openairdocs.org/ntsb/WPR10FA056.md): Beech A36 · San Gabriel, CA · Accident · 1 fatal · Field investigation · Final report · Nov 15, 2009 · N17803 · Substantial damage
  > Failure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.
- [NTSB WPR09LA373](https://openairdocs.org/ntsb/WPR09LA373.md): Grumman G164 · Riverdale, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2009 · N8741H · Substantial damage
  > The partial loss of engine power due to the failure of the engine's supercharger-blower.
- [NTSB WPR09LA145](https://openairdocs.org/ntsb/WPR09LA145.md): Cessna 172R · Oceanside, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2009 · N2478B · Substantial damage
  > A total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.
- [NTSB WPR09GA119](https://openairdocs.org/ntsb/WPR09GA119.md): Mcdonnell Douglas Helicopter 600 · San Clemente, CA · Accident · Serious injuries · Final report · Feb 20, 2009 · N608BP · Substantial damage
  > Failure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.
- [NTSB WPR09CA114](https://openairdocs.org/ntsb/WPR09CA114.md): Schweizer G-164B · Buttonwillow, CA · Accident · No injuries · Data collection · Final report · Feb 12, 2009 · N3626T · Substantial damage
  > A loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.

## 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" = 'CA' 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=CA&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.
