# NTSB investigations, SD: Dragged wing,rotor,pod,float or tail/skid

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 CHI91DTK02](https://openairdocs.org/ntsb/CHI91DTK02.md): Cessna 188/B · Hecla, SD · Accident · No injuries · Final report · Jul 13, 1991 · N9399G · Substantial damage
  > The failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.
- [NTSB DEN84LA217](https://openairdocs.org/ntsb/DEN84LA217.md): Weatherly 201 · Watertown, SD · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N86686 · Destroyed
  > The spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan 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" = 'SD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 160)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=160&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.