# NTSB investigations, SD: Standing

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 CHI01LA253](https://openairdocs.org/ntsb/CHI01LA253.md): Cessna 150M · Rapid City, SD · Accident · No injuries · Limited investigation · Final report · Jul 26, 2001 · N714GF · Substantial damage
  > The student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.
- [NTSB CHI00LA295](https://openairdocs.org/ntsb/CHI00LA295.md): Aerostar S-81A · Custer, SD · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 2000 · N9174Z · Minor damage
  > The ground crew's failure to maintain control of the balloon until all passengers were disembarked. A factor related to the accident was the gust of wind.
- [NTSB CHI96LA241](https://openairdocs.org/ntsb/CHI96LA241.md): Cessna 150 · Parker, SD · Accident · No injuries · Limited investigation · Final report · Jul 12, 1996 · N50104 · Destroyed
  > engine compartment fire from accumulated fuel in the carburetor, and failure of the pilot to follow the emergency checklist procedure.
- [NTSB CHI93IA060](https://openairdocs.org/ntsb/CHI93IA060.md): Beech B90 · Sioux Falls, SD · Incident · No injuries · Incident investigation · Final report · Dec 29, 1992 · N31SV · Minor damage
  > The pilot-in-command's inadequate preflight.
- [NTSB DEN88LA183](https://openairdocs.org/ntsb/DEN88LA183.md): Piper PA-22-108 · Hoven, SD · Accident · No injuries · Limited investigation · Final report · Aug 14, 1988 · N5301Z · Substantial damage
  > The private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…
- [NTSB DEN85LA083](https://openairdocs.org/ntsb/DEN85LA083.md): Piper PA-28-140 · Hot Springs, SD · Accident · No injuries · Limited investigation · Final report · Feb 16, 1985 · N4513R · Substantial damage
  > Plt said he performed a 'hasty' preflight. During engine pre-start the plt inadvertently left the throttle open. The engine srated and the acft taxied across the ramp and hit a fence post before the plt could regain control of the acft.
- [NTSB DEN84LA033](https://openairdocs.org/ntsb/DEN84LA033.md): Cessna 172 · Yankton, SD · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1983 · N52419 · No damage
  > The plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…
- [NTSB DEN82DTK07](https://openairdocs.org/ntsb/DEN82DTK07.md): Raven RX-7 · Phillip, SD · Accident · Serious injuries · Final report · Aug 22, 1982 · N4010S · Minor damage
  > After the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…
- [NTSB MKC66D0524](https://openairdocs.org/ntsb/MKC66D0524.md): Cessna 172 · Yankton, SD · Accident · No injuries · Closed · Mar 31, 1966 · N5600A · Substantial damage
- [NTSB MKC66D0234](https://openairdocs.org/ntsb/MKC66D0234.md): Cessna 172D · Lak Preston, SD · Accident · Serious injuries · Closed · Aug 11, 1965 · N8585X · Substantial damage
- [NTSB UNK64X3229](https://openairdocs.org/ntsb/UNK64X3229.md): Piper J3C · Hot Springs, SD · Accident · No injuries · Closed · Aug 5, 1964 · N3477N · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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