# NTSB investigations, SD: Use of equip/system

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 CEN16CA364](https://openairdocs.org/ntsb/CEN16CA364.md): Beech V35B · Sioux Falls, SD · Accident · No injuries · Data collection · Final report · Aug 30, 2016 · N23583 · Substantial damage
  > The pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate preflight by the pilot and flight instructor, and the flight instructor's…
- [NTSB CEN10CA305](https://openairdocs.org/ntsb/CEN10CA305.md): Cessna 337 · Custer, SD · Accident · No injuries · Data collection · Final report · Jun 5, 2010 · N2267X · Substantial damage
  > A partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.
- [NTSB CEN09LA388](https://openairdocs.org/ntsb/CEN09LA388.md): Beech B100 · Rapid City, SD · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2009 · N4490M · No damage
  > The flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.

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

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