# NTSB investigations, SC: Wing structure

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 ERA22LA116](https://openairdocs.org/ntsb/ERA22LA116.md): Dehavilland DHC-2 · Gilbert, SC · Accident · No injuries · Class 4 · Limited · Final report · Feb 5, 2022 · N1454Z · Substantial damage
  > The pilot’s improper flap setting, which resulted in a collision with trees during a takeoff attempt from a short grass field.
- [NTSB ERA20CA243](https://openairdocs.org/ntsb/ERA20CA243.md): Piper PA28 · Greenwood, SC · Accident · No injuries · Class 4 · Data collection · Final report · Jun 7, 2020 · N6958J · Substantial damage
  > The pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.
- [NTSB ERA16FA001](https://openairdocs.org/ntsb/ERA16FA001.md): Piper PA32R · Westminster, SC · Accident · 4 fatal · Field investigation · Final report · Oct 2, 2015 · N782TM · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB ERA13LA061](https://openairdocs.org/ntsb/ERA13LA061.md): Cessna 550 · Greenwood, SC · Accident · No injuries · Limited investigation · Final report · Nov 17, 2012 · N6763L · Substantial damage
  > Collision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.
- [NTSB ERA11LA415](https://openairdocs.org/ntsb/ERA11LA415.md): Polaris Polar Star · Dewees Island, SC · Accident · 2 fatal · Limited investigation · Final report · Jul 20, 2011 · UNREG · Substantial damage
  > The non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…

## 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" = 'SC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010357'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010357/cases?state=SC

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