# NTSB investigations, SD: Sys/Comp malf/fail (non-power)

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 CEN18LA164](https://openairdocs.org/ntsb/CEN18LA164.md): Beech 1900C · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Apr 30, 2018 · N172GA · Substantial damage
  > Failure of the right main landing gear drag brace bolt for reasons that could not be determined based on the available information.
- [NTSB CEN12LA557](https://openairdocs.org/ntsb/CEN12LA557.md): Bell 47G-2 · Flandreau, SD · Accident · No injuries · Limited investigation · Final report · Aug 14, 2012 · N444EH · Substantial damage
  > A malfunction of the helicopter’s throttle system, which resulted in a loss of engine power during cruise flight.
- [NTSB CEN12LA283](https://openairdocs.org/ntsb/CEN12LA283.md): Beech 58 · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Apr 24, 2012 · N8121R · Substantial damage
  > The failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.
- [NTSB CEN09CA026](https://openairdocs.org/ntsb/CEN09CA026.md): Holland Rotorway 162F · Rutland, SD · Accident · Minor injuries · Data collection · Final report · Oct 10, 2008 · N162NJ · Substantial damage
  > The loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.
- [NTSB CHI08CA245](https://openairdocs.org/ntsb/CHI08CA245.md): Air Tractor 301 · Herreid, SD · Accident · No injuries · Data collection · Final report · Aug 5, 2008 · N3161A · Substantial damage
  > Failure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.
- [NTSB CHI08CA111](https://openairdocs.org/ntsb/CHI08CA111.md): Veldhuizen Highlander · Onida, SD · Accident · No injuries · Data collection · Final report · Apr 18, 2008 · N8888V · Substantial damage
  > The separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' 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/330/sequence?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.