# Final NTSB investigations: Frames (main fuselage)

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 WPR22FA169](https://openairdocs.org/ntsb/WPR22FA169.md): Bearhawk LSA · Kalispell, MT · Accident · 2 fatal · Class 3 · Field · Final report · Apr 30, 2022 · N1908A · Substantial damage
  > An excessive pitch control input for undetermined reasons while the airplane was operating above maneuvering speed, which led to a structural failure of the right wing during cruise flight. Contributing to the accident was the poor construction quality of the…
- [NTSB ANC19LA024](https://openairdocs.org/ntsb/ANC19LA024.md): Aeronca 7DC · Nome Creek, AK · Accident · No injuries · Class 3 · Limited · Final report · Jun 12, 2019 · N83391 · Substantial damage
  > The failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…
- [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…
- [NTSB WPR13LA404](https://openairdocs.org/ntsb/WPR13LA404.md): Bell 47G5 · King City, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 2013 · N7836S · Substantial damage
  > The failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…
- [NTSB ERA13IA114](https://openairdocs.org/ntsb/ERA13IA114.md): Cessna 560XL · Debary, FL · Incident · No injuries · Incident investigation · Final report · Jan 13, 2013 · N662QS · No damage
  > An accumulation of debris in the airplane’s bilge drain holes that prevented accumulated moisture from properly draining; the accumulated moisture subsequently froze around the elevator control components, which resulted in the flight control stiffness.…
- [NTSB ANC11CA063](https://openairdocs.org/ntsb/ANC11CA063.md): Piper PA-12 · Gulkana, AK · Accident · No injuries · Data collection · Final report · Jul 10, 2011 · N2318M · Substantial damage
  > The pilot's inadequate recovery from a bounced landing.
- [NTSB WPR10CA475](https://openairdocs.org/ntsb/WPR10CA475.md): Cessna 172S · Santa Maria, CA · Accident · No injuries · Data collection · Final report · Jul 25, 2010 · N172CY · Substantial damage
  > The pilot's inadequate flare which resulted in a bounce and hard landing.
- [NTSB ANC10LA012](https://openairdocs.org/ntsb/ANC10LA012.md): Piper PA-12 · Gulkana, AK · Accident · No injuries · Limited investigation · Final report · Jan 14, 2010 · N3233M · Substantial damage
  > The pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035311'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01035311/cases?status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
