# NTSB investigations, 2015, SD: Attempted remediation/recovery

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 GAA15CA251](https://openairdocs.org/ntsb/GAA15CA251.md): Air Tractor AT 402A · Fort Pierre, SD · Accident · Minor injuries · Data collection · Final report · Sep 4, 2015 · N321DA · Substantial damage
  > The pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.
- [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.

## 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") = 2015
  AND c."eventStateOrRegion" = 'SD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' 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/060/sequence?state=SD&year=2015

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