# NTSB investigations, SD: Incorrect action selection

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 CEN19LA092](https://openairdocs.org/ntsb/CEN19LA092.md): Bell 407 · Union Center, SD · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 2019 · N450AM · Substantial damage
  > The ambulance driver’s failure to see the helicopter’s rotating main rotor blades in dark night conditions, which resulted in the ambulance’s inadvertent collision with the helicopter. Contributing to the accident was the ambulance driver's failure to follow…
- [NTSB CEN17CA294](https://openairdocs.org/ntsb/CEN17CA294.md): Air Tractor AT 502B · Harrold, SD · Accident · Minor injuries · Data collection · Final report · Jul 26, 2017 · N421CA · Substantial damage
  > The pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.
- [NTSB CEN10LA429](https://openairdocs.org/ntsb/CEN10LA429.md): Warth Dennis J Classic Sport S-18 · Tea, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2010 · N216TB · Substantial damage
  > A loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.

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

This list as a web page: https://openairdocs.org/ntsb-findings/02041010/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.
