# NTSB investigations, SD: Approach

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.

Page 1 of 2 · 98 cases

## Latest cases

- [NTSB CEN24LA076](https://openairdocs.org/ntsb/CEN24LA076.md): Piper PA-18A 150 · Vermillion, SD · Accident · No injuries · Class 3 · Limited · Final report · Dec 29, 2023 · N2774P · Substantial damage
  > The pilot’s encounter with carburetor icing during landing final approach which resulted in fuel starvation, a total loss of engine power, and impact with terrain.
- [NTSB CEN20CA086](https://openairdocs.org/ntsb/CEN20CA086.md): Cessna 182 · Huron, SD · Accident · No injuries · Data collection · Final report · Feb 15, 2020 · N2019A · Substantial damage
  > The pilot's failure to maintain adequate airspeed during final approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.
- [NTSB CEN19LA049](https://openairdocs.org/ntsb/CEN19LA049.md): Beech 58 · Sioux Falls, SD · Accident · 2 fatal · Class 2 · Limited · Final report · Dec 25, 2018 · N6745V · Destroyed
  > The pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.
- [NTSB CEN18LA306](https://openairdocs.org/ntsb/CEN18LA306.md): Bell 47G 3B · Custer, SD · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 2, 2018 · N347BH · Substantial damage
  > The pilot’s mismanagement of rotor RPM and subsequent forced landing on uneven terrain which led to a dynamic rollover.
- [NTSB GAA17CA513](https://openairdocs.org/ntsb/GAA17CA513.md): Cessna 172 · Belle Fourche, SD · Accident · Minor injuries · Data collection · Final report · Aug 30, 2017 · N2982U · Substantial damage
  > The flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.
- [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 CEN16LA201](https://openairdocs.org/ntsb/CEN16LA201.md): Cessna 402B · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · May 27, 2016 · N76MD · Substantial damage
  > The failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.
- [NTSB GAA16LA128](https://openairdocs.org/ntsb/GAA16LA128.md): Piper PA24 · Sturgis, SD · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 2016 · N6691P · Substantial damage
  > The pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.
- [NTSB CEN15CA160](https://openairdocs.org/ntsb/CEN15CA160.md): Zenith Acft Stol CH 701 · Marion, SD · Accident · Serious injuries · Data collection · Final report · Feb 27, 2015 · N511QC · Substantial damage
  > The pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.
- [NTSB CEN13LA431](https://openairdocs.org/ntsb/CEN13LA431.md): Schweizer 269C · Gary, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 2013 · N7507A · Substantial damage
  > The failure of the engine connecting rod due to fatigue.
- [NTSB CEN12CA658](https://openairdocs.org/ntsb/CEN12CA658.md): Cessna 175A · Spearfish, SD · Accident · No injuries · Data collection · Final report · Sep 25, 2012 · N6979E · Substantial damage
  > The pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.
- [NTSB CEN12LA580](https://openairdocs.org/ntsb/CEN12LA580.md): Cessna 140 · Spearfish, SD · Accident · No injuries · Limited investigation · Final report · Aug 25, 2012 · N140XX · Substantial damage
  > The partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.
- [NTSB CEN12LA346](https://openairdocs.org/ntsb/CEN12LA346.md): Beech 77 · Clark, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2012 · N18012 · Substantial damage
  > The pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.
- [NTSB CEN10LA430](https://openairdocs.org/ntsb/CEN10LA430.md): Piper PA-28-151 · Spearfish, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2010 · N1158X · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB CHI07LA050](https://openairdocs.org/ntsb/CHI07LA050.md): Beech B-99 · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2006 · N99TH · Substantial damage
  > The pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.
- [NTSB CHI06CA234](https://openairdocs.org/ntsb/CHI06CA234.md): Beech 19A · Yankton, SD · Accident · No injuries · Data collection · Final report · Aug 16, 2006 · N6544T · Substantial damage
  > The dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.
- [NTSB CHI05LA225](https://openairdocs.org/ntsb/CHI05LA225.md): Cessna 210 · Rapid City, SD · Accident · No injuries · Limited investigation · Final report · Aug 10, 2005 · N9408T · Substantial damage
  > The landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…
- [NTSB CHI05LA023](https://openairdocs.org/ntsb/CHI05LA023.md): Taylorcraft BC12-D · Wasta, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 2004 · N39971 · Substantial damage
  > The pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.
- [NTSB CHI04TA193](https://openairdocs.org/ntsb/CHI04TA193.md): PZL-Mielec M-18T · Pine Ridge, SD · Accident · No injuries · Final report · Jul 12, 2004 · N7077N · Substantial damage
  > The propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.
- [NTSB CHI03LA249](https://openairdocs.org/ntsb/CHI03LA249.md): North American AT-6D · Brookings, SD · Accident · No injuries · Limited investigation · Final report · Aug 7, 2003 · N9272K · Substantial damage
  > The inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.
- [NTSB CHI03LA197](https://openairdocs.org/ntsb/CHI03LA197.md): Cessna 175 · Wessington Spri, SD · Accident · No injuries · Limited investigation · Final report · Jul 4, 2003 · N7256M · Destroyed
  > The pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.
- [NTSB CHI01LA082](https://openairdocs.org/ntsb/CHI01LA082.md): Beech 65-B80 · Sioux Falls, SD · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 2001 · N107BA · Substantial damage
  > The pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…
- [NTSB CHI01LA033](https://openairdocs.org/ntsb/CHI01LA033.md): Saab 340-B · Aberdeen, SD · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2000 · N402XJ · Substantial damage
  > the impact with the flock of snow geese.
- [NTSB CHI00FA123](https://openairdocs.org/ntsb/CHI00FA123.md): Cessna 177RG · Watertown, SD · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2000 · N1978Q · Destroyed
  > the pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.
- [NTSB MIA98FA219](https://openairdocs.org/ntsb/MIA98FA219.md): Socata TBM-700 · Spearfish, SD · Accident · 4 fatal · Field investigation · Final report · Aug 4, 1998 · N69BS · Destroyed
  > The pilot's failure to maintain control of the airplane while turning to base leg. Contributing factors were low ceilings, clouds, and the pilot's failure to adhere to both the published approach procedures and the published minimum decent altitude.
- [NTSB CHI98LA018](https://openairdocs.org/ntsb/CHI98LA018.md): Bellanca 7GCBC · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1997 · N88119 · Substantial damage
  > the windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.
- [NTSB CHI96LA285](https://openairdocs.org/ntsb/CHI96LA285.md): Ramesbotham CH701 · N. Sioux City, SD · Accident · No injuries · Limited investigation · Final report · Aug 11, 1996 · N4053G · Substantial damage
  > the pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.
- [NTSB CHI96LA274](https://openairdocs.org/ntsb/CHI96LA274.md): Beech 35 · Yankton, SD · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N3392V · Substantial damage
  > an improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…
- [NTSB CHI96LA229](https://openairdocs.org/ntsb/CHI96LA229.md): Hewitt Cassutt 3M · Vermillion, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1996 · N290E · Substantial damage
  > the failure of the unapproved fuel pump.
- [NTSB CHI92LA236](https://openairdocs.org/ntsb/CHI92LA236.md): Rockwell 112TC · Winner, SD · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1992 · N30MT · Substantial damage
  > Failure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.
- [NTSB CHI92LA114](https://openairdocs.org/ntsb/CHI92LA114.md): Bellanca 7 Gcbc · Quinn, SD · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1992 · N1013E · Substantial damage
  > The pilot's inadequate visual lookout.
- [NTSB CHI91DTK04](https://openairdocs.org/ntsb/CHI91DTK04.md): Boland/Poe Tsunami · Pierre, SD · Accident · 1 fatal · Final report · Sep 25, 1991 · NX39JR · Destroyed
  > A bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…
- [NTSB CHI91LA202](https://openairdocs.org/ntsb/CHI91LA202.md): Piper PA-28-140 · Vermillion, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1991 · N541FL · Substantial damage
  > The pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.
- [NTSB DEN90LA084](https://openairdocs.org/ntsb/DEN90LA084.md): Cessna 172I · Isabel, SD · Accident · No injuries · Limited investigation · Final report · Mar 11, 1990 · N35485 · Substantial damage
  > Pilot's inadequate compensation for the wind conditions.
- [NTSB DEN88LA094](https://openairdocs.org/ntsb/DEN88LA094.md): Agusta A109A · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Apr 9, 1988 · N33SV · Substantial damage
- [NTSB DEN88LA028](https://openairdocs.org/ntsb/DEN88LA028.md): Cessna 150L · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N1380Q · Substantial damage
  > The private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…
- [NTSB DEN88FA016](https://openairdocs.org/ntsb/DEN88FA016.md): Beech A-36 · Mitchell, SD · Accident · 3 fatal · Field investigation · Final report · Oct 26, 1987 · N1257E · Destroyed
  > The acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…
- [NTSB DEN87FA167](https://openairdocs.org/ntsb/DEN87FA167.md): Mooney M20F · Mitchell, SD · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1987 · N6933V · Destroyed
  > This non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.
- [NTSB DEN85FA189](https://openairdocs.org/ntsb/DEN85FA189.md): Cessna 320F · Rapid City, SD · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1985 · N90HC · Destroyed
  > The acft crashed during an attempted VFR go-around. The plt said he didn't recall touching down and he thought he was 'floating.' When the acft began drifting left of rwy centerline, the plt initiated a go-aroung. He said he applied full power and rotated. He…
- [NTSB DEN85FA180](https://openairdocs.org/ntsb/DEN85FA180.md): Hughes 369HS · Keystone, SD · Accident · 4 fatal · Field investigation · Final report · Jul 6, 1985 · N5410W · Destroyed
  > Main rotor hub was overhauled by a repair station that was not authroized by Hughes helicopters for hub overhauls. The main rotor hub and blades separated in-flt 279 hrs after overhaul. The acft crashed in a densily wooded area. Post accident exam of the main…
- [NTSB DEN84LA200](https://openairdocs.org/ntsb/DEN84LA200.md): Piper PA-38-112 · Stratford, SD · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N9389T · Substantial damage
  > Acft touched down short of apch end of rwy and collided with a fence which surrounds the private airstrip boundry. The plt stated too much alt was lost at slow speed on final.
- [NTSB DEN84FA159](https://openairdocs.org/ntsb/DEN84FA159.md): Grumman American AA-1C · Rapid City, SD · Accident · Serious injuries · Field investigation · Final report · May 23, 1984 · N9803U · Substantial damage
  > The acft collided with rolling terrain while on a dual training flt. The CFI stated that the student plt was in the process of doing a simulated engine out forced landing when he raised the nose too high. The CFI and student were discussing the terrain when…
- [NTSB DEN84FA021](https://openairdocs.org/ntsb/DEN84FA021.md): Convair 580 · Sioux Falls, SD · Accident · Serious injuries · Field investigation · Final report · Nov 7, 1983 · N7517U · Minor damage
  > The acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the…
- [NTSB DEN83FTK05](https://openairdocs.org/ntsb/DEN83FTK05.md): Piper PA28-180C · Sturgis Muni., SD · Accident · Serious injuries · Final report · Aug 27, 1983 · N8426W · Destroyed
  > The acft crashed on the approach end to runway 11 during an aborted landing. The plt stated the acft was high so he applied full power and retracted the flaps. He said he retracted the flaps too fast and lost control of the acft. The nose gear was broken off,…
- [NTSB DEN83FTK03](https://openairdocs.org/ntsb/DEN83FTK03.md): Beech V35A · Sioux Falls, SD · Accident · Serious injuries · Final report · Feb 16, 1983 · N8478N · Destroyed
  > During an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…
- [NTSB DEN83FA027](https://openairdocs.org/ntsb/DEN83FA027.md): Cessna P210 · Sioux Falls, SD · Accident · 2 fatal · Field investigation · Final report · Dec 1, 1982 · N4721P · Destroyed
  > At 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy…
- [NTSB DEN83FA001](https://openairdocs.org/ntsb/DEN83FA001.md): Piper PA-28-181 · Wolsey, SD · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1982 · N6553C · Destroyed
  > The pilot had been issued an instrument rating on 8/6/82 and had logged 5.6 hrs since that time. The pilot's instructor believed this would have been his first low approach in actual instrument conditions since he completed his check flight. A witness stated…
- [NTSB DEN82FA034](https://openairdocs.org/ntsb/DEN82FA034.md): Piper PA-23 · Mitchell, SD · Accident · No injuries · Field investigation · Final report · Feb 18, 1982 · N5799Y · Substantial damage
  > As the pilot approached sioux falls he received information that it was below minimums, so he started to divert. As he passed over sioux falls he could see Mitchell, SD, which appeared to be clear, therefore, he elected to land there. It continued to look…
- [NTSB DEN81DTK23](https://openairdocs.org/ntsb/DEN81DTK23.md): Hughes 269C · Wilmot, SD · Accident · Minor injuries · Closed · Sep 10, 1981 · N8954F · Substantial damage
- [NTSB DEN81FTK13](https://openairdocs.org/ntsb/DEN81FTK13.md): Piper PA-28 · Rapid City, SD · Accident · 1 fatal · Closed · Jun 21, 1981 · N4853T · Substantial damage

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=SD&page=2

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

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