# NTSB investigations, SD: Wire

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 GAA19CA502](https://openairdocs.org/ntsb/GAA19CA502.md): Air Tractor AT502 · Onida, SD · Accident · No injuries · Data collection · Final report · Aug 16, 2019 · N500KA · Substantial damage
  > The pilot's failure to maintain clearance from power wires during agricultural application operations.
- [NTSB GAA15CA196](https://openairdocs.org/ntsb/GAA15CA196.md): Robinson Helicopter R44 II · Forest City, SD · Accident · No injuries · Data collection · Final report · Jul 2, 2015 · N824DK · Substantial damage
  > The pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.
- [NTSB CEN15CA160](https://openairdocs.org/ntsb/CEN15CA160.md): Zenith Acft Stol CH 701 · Marion, SD · Accident · Serious injuries · Data collection · Final report · Feb 27, 2015 · N511QC · Substantial damage
  > The pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.
- [NTSB CEN12CA313](https://openairdocs.org/ntsb/CEN12CA313.md): Ayres S2R-R1340 · Clear Lake, SD · Accident · Serious injuries · Data collection · Final report · May 23, 2012 · N30951 · Substantial damage
  > The pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.
- [NTSB CEN09CA194](https://openairdocs.org/ntsb/CEN09CA194.md): Air Tractor AT-502B · Harrold, SD · Accident · Minor injuries · Data collection · Final report · Mar 6, 2009 · N648LA · Substantial damage
  > The pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.

## 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" = 'SD' 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", '03022032'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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