# NTSB investigations: Main frame (on wing)

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 ERA24LA185](https://openairdocs.org/ntsb/ERA24LA185.md): Bailey-Moyes Dragonfly · Groveland, FL · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 19, 2024 · UNREG · Substantial damage
  > The pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.
- [NTSB WPR19MA177](https://openairdocs.org/ntsb/WPR19MA177.md): Beech 65-A90 · Mokuleia, HI · Accident · 11 fatal · Class 2 · Major · Final report · Jun 22, 2019 · N256TA · Destroyed
  > The pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…
- [NTSB WPR18LA121](https://openairdocs.org/ntsb/WPR18LA121.md): Airborne Windsports PTY XT-912-L · Peoria, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 15, 2018 · N107PW · Substantial damage
  > An inflight loss of control due to failure of the weight-shift-control aircraft's wing assembly.
- [NTSB DCA16CA197](https://openairdocs.org/ntsb/DCA16CA197.md): Facebook UK Aquila · Yuma, AZ · Accident · No injuries · Data collection · Final report · Jun 28, 2016 · N565AQ · Substantial damage
  > a structural failure of the wing as a result of exceeding the airspeed envelope due to wind gusts which were beyond the capabilities of the autopilot. Contributing to the accident was an insufficient amount of drag to track the glideslope in the presence of…
- [NTSB ERA16FA089](https://openairdocs.org/ntsb/ERA16FA089.md): Caughran Terry Flightstar II · Wake, VA · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2016 · N82652 · Substantial damage
  > Failure of the left wing in flight due to compression loading from wing loads combined with preexisting damage.
- [NTSB CEN14LA419](https://openairdocs.org/ntsb/CEN14LA419.md): Evolution Trikes Revo · South Haven, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 11, 2014 · N214EV · Substantial damage
  > The noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.
- [NTSB CEN12FA196](https://openairdocs.org/ntsb/CEN12FA196.md): Beech 35 · Glencoe, MN · Accident · 3 fatal · Field investigation · Final report · Mar 21, 2012 · N3871N · Substantial damage
  > The non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.
- [NTSB ERA11FA036](https://openairdocs.org/ntsb/ERA11FA036.md): Beech B36TC · Rienzi, MS · Accident · 2 fatal · Field investigation · Final report · Oct 26, 2010 · N8045Y · Substantial damage
  > The pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035710'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01035710/cases

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