# Final NTSB investigations, IA: 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 CEN24LA011](https://openairdocs.org/ntsb/CEN24LA011.md): Cirrus SR22 · Red Oak, IA · Accident · No injuries · Class 3 · Limited · Final report · Oct 15, 2023 · N6JA · Substantial damage
  > The fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.
- [NTSB ENG23LA030](https://openairdocs.org/ntsb/ENG23LA030.md): Gulfstream Aerospace G-IV · Sioux City, IA · Incident · No injuries · Class 3 · Limited · Final report · Jun 17, 2023 · N926TT · Minor damage
  > A No. 2 (right) engine failure due to a spinner fairing separation and subsequent impact with the fan blades that resulted in a midspan fracture of one fan blade. The spinner fairing separated as a result of a fatigue crack that originated from the heat…
- [NTSB CEN21LA138](https://openairdocs.org/ntsb/CEN21LA138.md): Cessna 182F · Millville, IA · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 24, 2021 · N3209U · Substantial damage
  > The inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.
- [NTSB WPR19FA022](https://openairdocs.org/ntsb/WPR19FA022.md): Piper PA28 · Guthrie Center, IA · Accident · 4 fatal · Class 2 · Field · Final report · Nov 9, 2018 · N91770 · Substantial damage
  > Pilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.
- [NTSB CEN16LA032](https://openairdocs.org/ntsb/CEN16LA032.md): Cessna 177RG · Red Oak, IA · Accident · No injuries · Limited investigation · Final report · Oct 8, 2015 · N1542H · Substantial damage
  > The improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.
- [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.
- [NTSB CEN09LA403](https://openairdocs.org/ntsb/CEN09LA403.md): Ayres S2R-G6 · Ainsworth, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 2009 · N60015 · Substantial damage
  > A component failure of the fuel control unit, which resulted in a loss of engine power.

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

This list as a web page: https://openairdocs.org/ntsb-events/340/cases?state=IA&status=final

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