# NTSB investigations, ID: 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 WPR21LA324](https://openairdocs.org/ntsb/WPR21LA324.md): Cessna 172 · Athol, ID · Accident · No injuries · Class 4 · Limited · Final report · Aug 7, 2021 · N4110L · Substantial damage
  > The failure of the windshield during spin recovery for reasons that were not determined.
- [NTSB WPR17FA128](https://openairdocs.org/ntsb/WPR17FA128.md): Prescot E. Wilkie RV-3 · Payette, ID · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2017 · N177TT · Destroyed
  > The in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.
- [NTSB WPR11LA459](https://openairdocs.org/ntsb/WPR11LA459.md): Mcarthur Steen Skybolt · Greenleaf, ID · Accident · No injuries · Limited investigation · Final report · Sep 19, 2011 · N77VW · Substantial damage
  > Structural failure of the upper left wing during aerobatic flight.
- [NTSB LAX08LA083](https://openairdocs.org/ntsb/LAX08LA083.md): Gulfstream-Schweizer G-164B · Genesee, ID · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 2008 · N8148K · Substantial damage
  > The in-flight failure of the rudder attachment point due to severe corrosion, which made directional control of the airplane not possible during 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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE 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?state=ID

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