# NTSB investigations, 2011, IA: Loss of engine power (partial)

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 CEN11CA532](https://openairdocs.org/ntsb/CEN11CA532.md): Alon A-2A · Rolfe, IA · Accident · No injuries · Data collection · Final report · Jul 31, 2011 · N5647F · Substantial damage
  > The pilot's decision to execute a precautionary landing to unsuitable terrain.
- [NTSB CEN11LA539](https://openairdocs.org/ntsb/CEN11LA539.md): Hurley Richard A Cavalier SA102.5 · Salem, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 2011 · N115RH · Substantial damage
  > The partial loss of engine power due to the formation of carburetor ice.
- [NTSB CEN11FA436](https://openairdocs.org/ntsb/CEN11FA436.md): Ray Aerial Spraying 773 Racer · Ottumwa, IA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2011 · N773RY · Destroyed
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airplane’s engine and ignition system did not reveal any anomalies that would have precluded normal operation, and extensive postaccident fire damage…
- [NTSB CEN11LA367](https://openairdocs.org/ntsb/CEN11LA367.md): Jones Cozy Mark IV · Sioux City, IA · Accident · Minor injuries · Limited investigation · Final report · May 30, 2011 · N204TJ · Substantial damage
  > The pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.

## 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") = 2011
  AND c."eventStateOrRegion" = 'IA' 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" = '342' 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/342/sequence?state=IA&year=2011

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