# NTSB investigations, 2009, SD

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 CEN09CA608](https://openairdocs.org/ntsb/CEN09CA608.md): Piper J3C-65 · Spearfish, SD · Accident · No injuries · Data collection · Final report · Sep 29, 2009 · N3260N · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll.
- [NTSB CEN09LA523](https://openairdocs.org/ntsb/CEN09LA523.md): From Here To There PDQ RV-8 · Tea, SD · Accident · 2 fatal · Limited investigation · Final report · Aug 16, 2009 · N98AW · Substantial damage
  > The pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.
- [NTSB CEN09CA519](https://openairdocs.org/ntsb/CEN09CA519.md): Cessna 182A · Watertown, SD · Accident · No injuries · Data collection · Final report · Jul 31, 2009 · N2131G · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of a fuel tank leak. Contributing to the accident was the reported malfunction of the fuel gauge.
- [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.
- [NTSB CEN09CA616](https://openairdocs.org/ntsb/CEN09CA616.md): Piper PA-36-285 · Clark, SD · Accident · No injuries · Data collection · Final report · Jun 12, 2009 · N57625 · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from a levy.
- [NTSB CEN09CA305](https://openairdocs.org/ntsb/CEN09CA305.md): Flight Design CT2K · Mitchell, SD · Accident · No injuries · Data collection · Final report · May 13, 2009 · N433CT · Substantial damage
  > The pilot's inadequate compensation for the gusting winds during landing.
- [NTSB CEN09LA206](https://openairdocs.org/ntsb/CEN09LA206.md): Cessna 402B · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Mar 10, 2009 · N402BP · Substantial damage
  > The pilot's continued flight into adverse weather and icing conditions, and his failure to maintain aircraft control resulting in a hard landing. Contributing to the accident was the accumulation of airframe ice and the strong, gusting crosswinds.
- [NTSB CEN09CA194](https://openairdocs.org/ntsb/CEN09CA194.md): Air Tractor AT-502B · Harrold, SD · Accident · Minor injuries · Data collection · Final report · Mar 6, 2009 · N648LA · Substantial damage
  > The pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.

## 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 year(c."eventDate") = 2009
  AND c."eventStateOrRegion" = 'SD' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=SD&year=2009

---
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.