# NTSB investigations, SD: Enroute

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 4 · 190 cases

## Latest cases

- [NTSB CEN27LA011](https://openairdocs.org/ntsb/CEN27LA011.md): Flight Design Ctls · Yankton, SD · Accident · Minor injuries · Class 4 · Limited · Investigation open · Oct 9, 2026 · N792CT · Substantial damage
- [NTSB CEN26LA332](https://openairdocs.org/ntsb/CEN26LA332.md): Piper PA18 · Karinen, SD · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 17, 2026 · N3879Z · Substantial damage
  > On September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…
- [NTSB CEN25LA368](https://openairdocs.org/ntsb/CEN25LA368.md): Beech 35-C33 · Brookings, SD · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 6, 2025 · N1310A · Destroyed
  > On September 6, 2025, about 0859 central daylight time, a Beech 35-C33 airplane, N1310A, was destroyed when it was involved in an accident near Brookings, South Dakota. The pilot and two passengers sustained minor injuries. The airplane was operated as a…
- [NTSB CEN24LA341](https://openairdocs.org/ntsb/CEN24LA341.md): Taylorcraft BC12-D · Trojan, SD · Accident · No injuries · Class 3 · Limited · Final report · Sep 7, 2024 · N95078 · Substantial damage
  > The partial loss of engine power due to a loose magneto and subsequent impact with terrain.
- [NTSB CEN24FA295](https://openairdocs.org/ntsb/CEN24FA295.md): Piper PA-28-180 · Irene, SD · Accident · 1 fatal · Class 3 · Field · Final report · Jul 31, 2024 · N903US · Destroyed
  > The pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.
- [NTSB CEN22FA433](https://openairdocs.org/ntsb/CEN22FA433.md): Airgyro AG915 · Yankton, SD · Accident · 1 fatal · Class 3 · Field · Final report · Sep 27, 2022 · N499AG · Destroyed
  > A loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.
- [NTSB CEN22LA313](https://openairdocs.org/ntsb/CEN22LA313.md): Piper PA-24-260 · Rapid City, SD · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2022 · N478WT · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the airplane was unavailable for examination.
- [NTSB CEN21LA316](https://openairdocs.org/ntsb/CEN21LA316.md): Cessna 172F · Eagle Butte, SD · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2021 · N5340R · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 6 connecting rod.
- [NTSB CEN19FA307](https://openairdocs.org/ntsb/CEN19FA307.md): Cessna 140 · Lakeview, SD · Accident · 2 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N73000 · Substantial damage
  > The student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…
- [NTSB CEN19FA021](https://openairdocs.org/ntsb/CEN19FA021.md): Cessna 210 · Bradley, SD · Accident · 1 fatal · Field investigation · Final report · Nov 2, 2018 · N81KD · Destroyed
  > The non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB CEN18LA146](https://openairdocs.org/ntsb/CEN18LA146.md): Cessna T303 · Pine Ridge, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2018 · N9746C · Substantial damage
  > The airplane’s inadvertent encounter with severe icing conditions during descent, which resulted in structural icing, the pilot’s inability to maintain altitude, and an emergency landing. Contributing to the accident was an incomplete preflight weather…
- [NTSB CEN17LA265](https://openairdocs.org/ntsb/CEN17LA265.md): Cubcrafters CC11-160 · Milesville, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2017 · N111JW · Substantial damage
  > Fuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…
- [NTSB CEN17IA094](https://openairdocs.org/ntsb/CEN17IA094.md): Eurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SD · Incident · No injuries · Class 2 · Incident · Final report · Jan 27, 2017 · N911MK · Minor damage
  > The gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…
- [NTSB DCA16IA215](https://openairdocs.org/ntsb/DCA16IA215.md): Airbus A320 232 · Wood, SD · Incident · Minor injuries · Incident investigation · Final report · Aug 12, 2016 · N632JB · Minor damage
  > an inadvertent encounter with convective turbulence while in cruise flight.
- [NTSB CEN16LA275](https://openairdocs.org/ntsb/CEN16LA275.md): Meyers 200 · Huron, SD · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 20, 2016 · N229RS · Substantial damage
  > The partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.
- [NTSB CEN15CA006](https://openairdocs.org/ntsb/CEN15CA006.md): Piper PA 31-350 · Glenham, SD · Accident · Minor injuries · Data collection · Final report · Oct 7, 2014 · N300VF · Substantial damage
  > The pilot's improper fuel management, which resulted in losses of power on both engines due to fuel exhaustion.
- [NTSB CEN14FA224](https://openairdocs.org/ntsb/CEN14FA224.md): Piper PA 32R-300 · Highmore, SD · Accident · 4 fatal · Field investigation · Final report · Apr 28, 2014 · N8700E · Destroyed
  > The pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…
- [NTSB CEN13LA367](https://openairdocs.org/ntsb/CEN13LA367.md): Piper PA-28-140 · De Smet, SD · Accident · No injuries · Limited investigation · Final report · Jun 21, 2013 · N589FL · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examinations of the airplane and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN13LA220](https://openairdocs.org/ntsb/CEN13LA220.md): Walker Phil RV-6A · Spearfish, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 2013 · N525PW · Substantial damage
  > The coil-distributor wire loosening in flight, which rendered the ignition system inoperative and subsequently caused the loss of engine power.
- [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 CEN12LA242](https://openairdocs.org/ntsb/CEN12LA242.md): Bell 407 · Aberdeen, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2012 · N509MT · Substantial damage
  > The fatigue failure of two turbine engine blades due to vibration.
- [NTSB CEN12LA175](https://openairdocs.org/ntsb/CEN12LA175.md): Piper PA-28-161 · Rapid City, SD · Accident · No injuries · Limited investigation · Final report · Feb 24, 2012 · N20GG · Substantial damage
  > The loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.
- [NTSB CEN12FA001](https://openairdocs.org/ntsb/CEN12FA001.md): Robinson Helicopter R66 · Philip, SD · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2011 · N266CY · Destroyed
  > The in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.
- [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 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 CHI08CA246](https://openairdocs.org/ntsb/CHI08CA246.md): Air Tractor AT-802A · Turton, SD · Accident · No injuries · Data collection · Final report · Aug 10, 2008 · N9078G · Substantial damage
  > The failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.
- [NTSB CHI08CA235](https://openairdocs.org/ntsb/CHI08CA235.md): Cessna 150L · Watertown, SD · Accident · Minor injuries · Data collection · Final report · Aug 4, 2008 · N16235 · Substantial damage
  > The pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.
- [NTSB CHI06FA264](https://openairdocs.org/ntsb/CHI06FA264.md): Beech BE-95-B55 · N. Sioux City, SD · Accident · 1 fatal · Field investigation · Final report · Sep 22, 2006 · N4JV · Substantial damage
  > The pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.
- [NTSB CHI06LA078](https://openairdocs.org/ntsb/CHI06LA078.md): Cirrus Design SR22 · Wagner, SD · Accident · No injuries · Limited investigation · Final report · Feb 6, 2006 · N751CD · Substantial damage
  > The pilot not maintaining airplane control and the inadvertent stall encountered during the climb. A factor was the instrument meteorological conditions.
- [NTSB CHI06CA002](https://openairdocs.org/ntsb/CHI06CA002.md): Creed RV-4 · Mitchell, SD · Accident · No injuries · Data collection · Final report · Oct 6, 2005 · N149KC · Substantial damage
  > The mechanic's improper installation of the air filter assembly which resulted in foreign debris inside the carburetor. A factor associated with the accident was the rough terrain on which the airplane was landed.
- [NTSB CHI04CA091](https://openairdocs.org/ntsb/CHI04CA091.md): Cessna C-180 · Aberdeen, SD · Accident · No injuries · Data collection · Final report · Mar 28, 2004 · N2916C · Substantial damage
  > The pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…
- [NTSB CHI03LA299](https://openairdocs.org/ntsb/CHI03LA299.md): Piper J3C-65 · South Shore, SD · Accident · No injuries · Limited investigation · Final report · Sep 4, 2003 · N38435 · Substantial damage
  > A loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.
- [NTSB CHI03IA300](https://openairdocs.org/ntsb/CHI03IA300.md): Cessna 650 · Rapid City, SD · Incident · No injuries · Incident investigation · Final report · Aug 29, 2003 · N651EJ · No damage
  > The in-flight failure of the right wing aileron cable during cruise.
- [NTSB CHI03FA141](https://openairdocs.org/ntsb/CHI03FA141.md): Cessna 182Q · Gettysburg, SD · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2003 · N630SW · Destroyed
  > The pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.
- [NTSB CHI03LA133](https://openairdocs.org/ntsb/CHI03LA133.md): Air & Space 18A · South Shore, SD · Accident · 1 fatal · Limited investigation · Final report · May 19, 2003 · N6155S · Destroyed
  > The pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.
- [NTSB CHI02FA288](https://openairdocs.org/ntsb/CHI02FA288.md): Bell 206L-1 · Doland, SD · Accident · 4 fatal · Field investigation · Final report · Sep 10, 2002 · N400SL · Destroyed
  > Pilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…
- [NTSB CHI01FA113](https://openairdocs.org/ntsb/CHI01FA113.md): Beech 95-B55 · Norris, SD · Accident · 3 fatal · Field investigation · Final report · Feb 19, 2001 · N9927S · Destroyed
  > The pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.
- [NTSB CHI01LA086](https://openairdocs.org/ntsb/CHI01LA086.md): Cessna 310Q · Mitchell, SD · Accident · No injuries · Limited investigation · Final report · Feb 7, 2001 · N10ET · Substantial damage
  > The pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.
- [NTSB CHI01LA053](https://openairdocs.org/ntsb/CHI01LA053.md): Cessna 150M · New Underwood, SD · Accident · No injuries · Limited investigation · Final report · Dec 26, 2000 · N63067 · Substantial damage
  > The pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.
- [NTSB CHI00FA265](https://openairdocs.org/ntsb/CHI00FA265.md): Cessna 340A · Mission, SD · Accident · 3 fatal · Field investigation · Final report · Aug 23, 2000 · N34DD · Destroyed
  > the aircraft control not maintained by the pilot. A contributing factor was pilot fatigue.
- [NTSB DCA00MA005](https://openairdocs.org/ntsb/DCA00MA005.md): Learjet 35 · Aberdeen, SD · Accident · 6 fatal · Class 1 · Major · Final report · Oct 25, 1999 · N47BA · Destroyed
  > Incapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.
- [NTSB CHI99LA355](https://openairdocs.org/ntsb/CHI99LA355.md): Piper PA-28-181 · Hermosa, SD · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1999 · N3889F · Substantial damage
  > the pilot's improper fuel management, improper in-flight decision and the precautionary landing. Factors relating to this accident were the pilot's inadequate preflight planning and the fence post.
- [NTSB CHI99FA089](https://openairdocs.org/ntsb/CHI99FA089.md): Piper PA-18-150 · Belle Fourche, SD · Accident · 2 fatal · Field investigation · Final report · Feb 6, 1999 · N8075D · Destroyed
  > inadequate preflight planning/preparation, refueling not performed, and aircraft control not maintained by the pilot. The inadvertent stall by the pilot was an additional cause. Fuel exhaustion was a contributing factor.
- [NTSB CHI98LA307](https://openairdocs.org/ntsb/CHI98LA307.md): Cessna 150L · Philip, SD · Accident · No injuries · Limited investigation · Final report · Aug 9, 1998 · N5413Q · Substantial damage
  > the fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.
- [NTSB CHI98LA235](https://openairdocs.org/ntsb/CHI98LA235.md): Piper PA-22-108 · Spearfish, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1998 · N5181Z · Substantial damage
  > the pilots improper preflight planning, which failed to detect the fuel selector positioned on the left fuel tank, which had insufficient fuel, resulting in fuel starvation, and the loss of engine power.
- [NTSB CHI98LA120](https://openairdocs.org/ntsb/CHI98LA120.md): Rodgers Raven · Brandt, SD · Accident · 2 fatal · Limited investigation · Final report · Apr 11, 1998 · N17JR · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to this accident was the pilot's lack of experience in the airplane.
- [NTSB CHI98LA109](https://openairdocs.org/ntsb/CHI98LA109.md): Cessna 180 · Whitewood, SD · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1998 · N9140C · Substantial damage
  > failure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…
- [NTSB CHI98LA104](https://openairdocs.org/ntsb/CHI98LA104.md): Mooney M20C · White River, SD · Accident · No injuries · Limited investigation · Final report · Mar 10, 1998 · N6235U · Substantial damage
  > the pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.
- [NTSB CHI97FAMS3](https://openairdocs.org/ntsb/CHI97FAMS3.md): Grumman American AA-5 · Lower Brule, SD · Accident · 1 fatal · Missing aircraft · Final report · Aug 10, 1997 · N7148L · Destroyed
  > undetermined due to the accident airplane not being available for examination.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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