# 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 WPR10FA440](https://openairdocs.org/ntsb/WPR10FA440.md): Hiller UH 12E · Kamiah, ID · Accident · 3 fatal · Field investigation · Final report · Aug 31, 2010 · N67264 · Substantial damage
  > In-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…
- [NTSB WPR09FA116](https://openairdocs.org/ntsb/WPR09FA116.md): Piper PA-24-260 · Hagerman, ID · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2009 · N8810P · Destroyed
  > The student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…
- [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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '337' 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/337/sequence?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.