# NTSB investigations, SD: On ground/water collision with object

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 CHI04LA204](https://openairdocs.org/ntsb/CHI04LA204.md): Aerostar S53H · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Jul 8, 2004 · N5001J · Substantial damage
  > The pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.
- [NTSB CHI97LA109](https://openairdocs.org/ntsb/CHI97LA109.md): Cessna 421C · Pierre, SD · Accident · No injuries · Limited investigation · Final report · Apr 21, 1997 · N283PT · Substantial damage
  > the pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.
- [NTSB CHI97LA108](https://openairdocs.org/ntsb/CHI97LA108.md): Aerostar RXS-8 · Sioux Falls, SD · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1997 · N71493 · No damage
  > the ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.
- [NTSB DEN85FA002](https://openairdocs.org/ntsb/DEN85FA002.md): Hamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SD · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1984 · N127MW · Destroyed
  > The hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…
- [NTSB DEN84LA233](https://openairdocs.org/ntsb/DEN84LA233.md): Cessna A188B · Stratford, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N9108R · Substantial damage
  > Plt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…
- [NTSB DCA84AA012](https://openairdocs.org/ntsb/DCA84AA012.md): Douglas DC-9-31 · Sioux Falls, SD · Accident · 1 fatal · Final report · Dec 20, 1983 · N994Z · Substantial damage
  > During landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…

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

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