# NTSB investigations, 2017: 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 GAA18LA062](https://openairdocs.org/ntsb/GAA18LA062.md): Diamond Aircraft Ind DA 40 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Oct 13, 2017 · N965DS · Substantial damage
  > A coyote strike and the subsequent operation of the airplane, which led to internal composite wing structure damage.
- [NTSB CEN18LA012](https://openairdocs.org/ntsb/CEN18LA012.md): Globe GC 1A · Los Lunas, NM · Accident · 1 fatal · Limited investigation · Final report · Oct 9, 2017 · N90365 · Substantial damage
  > The loss of directional control during takeoff and impact with a steel culvert.
- [NTSB ERA17FA265](https://openairdocs.org/ntsb/ERA17FA265.md): North Wing Freedom · Green Township, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2017 · N2854L · Substantial damage
  > The pilot's improper preflight setup of the aircraft's foldable wing, during which he incorrectly attached a nylon strap loop pull handle, instead of the steel cable shackle at the end of the strap, to its mounting hook. The nylon strap failed in flight,…
- [NTSB ERA17FA222](https://openairdocs.org/ntsb/ERA17FA222.md): Piper PA23 · Chatsworth, GA · Accident · 4 fatal · Field investigation · Final report · Jul 1, 2017 · N44HJ · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…
- [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 CEN17FA231](https://openairdocs.org/ntsb/CEN17FA231.md): Gefa-Flug AS-105-GD · Hartford, WI · Accident · Serious injuries · Field investigation · Final report · Jun 15, 2017 · G-SUNA · Destroyed
  > The overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.
- [NTSB WPR17FA117](https://openairdocs.org/ntsb/WPR17FA117.md): Cessna 180 · Ventura, CA · Accident · 1 fatal · Field investigation · Final report · Jun 1, 2017 · N3683C · Destroyed
  > The pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.
- [NTSB ERA17FA145](https://openairdocs.org/ntsb/ERA17FA145.md): Pipistrel Virus SW · Micanopy, FL · Accident · 1 fatal · Field investigation · Final report · Apr 4, 2017 · N155CL · Destroyed
  > The pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup.
- [NTSB WPR17FA074](https://openairdocs.org/ntsb/WPR17FA074.md): Quicksilver MXL II · Hesperia, CA · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2017 · UNREG · Substantial damage
  > The pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…

## 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 year(c."eventDate") = 2017
  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?year=2017

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