# NTSB investigations: Continental E225 series: Aircraft structural failure

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 ERA11FA431](https://openairdocs.org/ntsb/ERA11FA431.md): Beech G35 · Byron, GA · Accident · 1 fatal · Field investigation · Final report · Jul 31, 2011 · N156RP · Substantial damage
  > The pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.
- [NTSB WPR11LA172](https://openairdocs.org/ntsb/WPR11LA172.md): Beech G35 · Whidbey Island, WA · Accident · No injuries · Limited investigation · Final report · Mar 19, 2011 · N4211D · Substantial damage
  > The pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…
- [NTSB WPR09FA391](https://openairdocs.org/ntsb/WPR09FA391.md): Navion Navion A · Adrian, OR · Accident · 3 fatal · Field investigation · Final report · Aug 7, 2009 · N4898K · Substantial damage
  > The pilot’s failure to maintain aircraft control while in cruise flight due to spatial disorientation, which resulted in an exceedence of the design stress limits of the aircraft and led to an in-flight structural failure.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17015')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '337'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/337/cases?engine=17015

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