# NTSB investigations, SD: Initial climb

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 3 · 140 cases

## Latest cases

- [NTSB CEN26LA296](https://openairdocs.org/ntsb/CEN26LA296.md): Para-Ski VX · Westport, SD · Accident · 1 fatal · Class 3 · Limited · Preliminary report · Aug 20, 2026 · C-IFBY · Substantial damage
  > On August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…
- [NTSB CEN25LA288](https://openairdocs.org/ntsb/CEN25LA288.md): Piper PA-28RT-201T · Brookings, SD · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 26, 2025 · N8423H · Substantial damage
  > On July 26, 2025, at 1840 central daylight time, a Piper PA-28RT-201T airplane, N8423H, was substantially damaged when it was involved in an accident near Brookings, South Dakota. The airline transport pilot and passenger were uninjured. The airplane was…
- [NTSB CEN25FA248](https://openairdocs.org/ntsb/CEN25FA248.md): Piper PA-25 · Hot Springs, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N8186K · Substantial damage
  > On July 12, 2025, about 1322 mountain daylight time, a Piper PA-25, N8186K, was substantially damaged when it was involved in an accident near Hot Springs, South Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN24LA121](https://openairdocs.org/ntsb/CEN24LA121.md): Piper PA-28-181 · Watertown, SD · Accident · No injuries · Class 3 · Limited · Final report · Feb 25, 2024 · N38696 · Substantial damage
  > The stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing due to an undersized exhaust valve guide. Contributing to the accident were the improper manufacture of the engine cylinders, and the operation of…
- [NTSB CEN24LA020](https://openairdocs.org/ntsb/CEN24LA020.md): Piper PA 46-350P · Pierre, SD · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 23, 2023 · N92884 · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.
- [NTSB CEN21LA082](https://openairdocs.org/ntsb/CEN21LA082.md): Piper PA12 · Spearfish, SD · Accident · No injuries · Class 3 · Limited · Final report · Dec 8, 2020 · N2554M · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN20FA022](https://openairdocs.org/ntsb/CEN20FA022.md): Pilatus PC12 · Chamberlain, SD · Accident · 9 fatal · Class 3 · Field · Final report · Nov 30, 2019 · N56KJ · Destroyed
  > The pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…
- [NTSB CEN15LA306](https://openairdocs.org/ntsb/CEN15LA306.md): Air Creation Clipper 582 · Clark, SD · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 2015 · UNREG · Substantial damage
  > The pilot's inability to maintain control of the weight-shift control aircraft during initial climb due to his impairment from ethanol, methamphetamine, cocaine, and marijuana.
- [NTSB CEN15FA264](https://openairdocs.org/ntsb/CEN15FA264.md): Bellanca 7GCBC · Kadoka, SD · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2015 · N11698 · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB CEN14CA392](https://openairdocs.org/ntsb/CEN14CA392.md): Bellanca 7GCBC · Caputa, SD · Accident · No injuries · Data collection · Final report · Jul 26, 2014 · N5530K · Substantial damage
  > The student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.
- [NTSB CEN12LA634](https://openairdocs.org/ntsb/CEN12LA634.md): North Wing Design Apache Sport · Vermillion, SD · Accident · 1 fatal · Limited investigation · Final report · Sep 14, 2012 · N850GB · Destroyed
  > The pilot’s failure to maintain control of the weight-shift-control aircraft during initial climb, which resulted in an aerodynamic stall/spin.
- [NTSB CEN12FA579](https://openairdocs.org/ntsb/CEN12FA579.md): Lee Paul SQ 2000 · Pierre, SD · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2012 · N416 · Substantial damage
  > The airplane's entry into a pilot-induced oscillation and the pilot’s loss of airplane control during the takeoff initial climb. Contributing to the accident was the left entrance door opening in flight for undetermined reasons.
- [NTSB CEN12LA357](https://openairdocs.org/ntsb/CEN12LA357.md): Rockwell International S-2R · Howard, SD · Accident · No injuries · Limited investigation · Final report · May 23, 2012 · N8421V · Substantial damage
  > A fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.
- [NTSB CEN12LA103](https://openairdocs.org/ntsb/CEN12LA103.md): Beech C23 · Watertown, SD · Accident · No injuries · Limited investigation · Final report · Dec 9, 2011 · N6717K · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN10LA573](https://openairdocs.org/ntsb/CEN10LA573.md): Cessna 152 · Tea, SD · Accident · No injuries · Limited investigation · Final report · Sep 24, 2010 · N5364H · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.
- [NTSB CEN10LA429](https://openairdocs.org/ntsb/CEN10LA429.md): Warth Dennis J Classic Sport S-18 · Tea, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2010 · N216TB · Substantial damage
  > A loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.
- [NTSB CEN10CA305](https://openairdocs.org/ntsb/CEN10CA305.md): Cessna 337 · Custer, SD · Accident · No injuries · Data collection · Final report · Jun 5, 2010 · N2267X · Substantial damage
  > A partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.
- [NTSB CHI07CA155](https://openairdocs.org/ntsb/CHI07CA155.md): Champion 7EC · Sioux Falls, SD · Accident · No injuries · Data collection · Final report · May 25, 2007 · N9904Y · Substantial damage
  > The pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.
- [NTSB CHI07CA148](https://openairdocs.org/ntsb/CHI07CA148.md): Cessna A188 · Scotland, SD · Accident · No injuries · Data collection · Final report · May 19, 2007 · N926LT · Substantial damage
  > The pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.
- [NTSB CHI05CA271](https://openairdocs.org/ntsb/CHI05CA271.md): Bell 206B · Elk Point, SD · Accident · No injuries · Data collection · Final report · Sep 15, 2005 · N2995W · Substantial damage
  > The loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.
- [NTSB CHI05LA261](https://openairdocs.org/ntsb/CHI05LA261.md): Piper PA-28-235 · Faulkton, SD · Accident · 1 fatal · Limited investigation · Final report · Sep 9, 2005 · N8523W · Destroyed
  > The pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.
- [NTSB CHI04LA145](https://openairdocs.org/ntsb/CHI04LA145.md): Betchan KR II · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2004 · N250KB · Destroyed
  > Failure of the engine rocker arm installation resulting in a loss of engine power. A contributing factor was the power lines.
- [NTSB CHI03LA227](https://openairdocs.org/ntsb/CHI03LA227.md): Ullrich Auriga FT · Aberdeen, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 27, 2003 · N512EA · Destroyed
  > A loss of engine power due to the lack of design fuel pressure for undetermined reasons.
- [NTSB CHI03LA109](https://openairdocs.org/ntsb/CHI03LA109.md): Cessna 152 · Red Owl, SD · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 2003 · N93564 · Substantial damage
  > The pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.
- [NTSB CHI02LA159](https://openairdocs.org/ntsb/CHI02LA159.md): Galbraith Piel Emeraude · Hot Springs, SD · Accident · 1 fatal · Limited investigation · Final report · Jun 11, 2002 · N71PE · Substantial damage
  > The loss of engine power due to the connecting rod fatigue failure during takeoff climb.
- [NTSB CHI01LA262](https://openairdocs.org/ntsb/CHI01LA262.md): Grice Avid Flyer · Belle Fourche, SD · Accident · No injuries · Limited investigation · Final report · Aug 6, 2001 · N312GR · Substantial damage
  > The pilot failed to maintain aircraft control during the forced landing. A factor associated with the accident was the excessive adjustment that the pilot made to the propeller's pitch prior to the flight.
- [NTSB CHI98LA217](https://openairdocs.org/ntsb/CHI98LA217.md): Air Tractor AT-301 · Ipswich, SD · Accident · No injuries · Limited investigation · Final report · Jun 25, 1998 · N31677 · Substantial damage
  > the pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.
- [NTSB CHI98LA073](https://openairdocs.org/ntsb/CHI98LA073.md): Cessna 402B · Watertown, SD · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 1997 · N5087Q · Destroyed
  > the pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.
- [NTSB CHI97LA106](https://openairdocs.org/ntsb/CHI97LA106.md): Air Tractor AT-401 · Highmore, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1997 · N1008P · Substantial damage
  > a premature lift-off of the airplane by the pilot in command.
- [NTSB CHI96LA295](https://openairdocs.org/ntsb/CHI96LA295.md): Beech V35 · Custer, SD · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1996 · N2055V · Destroyed
  > loss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.
- [NTSB CHI96LA197](https://openairdocs.org/ntsb/CHI96LA197.md): Grumman American AA-1C · Custer, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1996 · N39048 · Substantial damage
  > the pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.
- [NTSB CHI96LA069](https://openairdocs.org/ntsb/CHI96LA069.md): Taylorcraft BC-12 · Winner, SD · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1995 · N39244 · Substantial damage
  > the pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.
- [NTSB CHI96LA056](https://openairdocs.org/ntsb/CHI96LA056.md): Maule M-4 · Hot Springs, SD · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1995 · N12010 · Substantial damage
  > an unauthorized modification of the air induction system by the pilot.
- [NTSB CHI95LA206](https://openairdocs.org/ntsb/CHI95LA206.md): Beech 23A · Spearfish, SD · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1995 · N2397Q · Destroyed
  > The pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.
- [NTSB CHI95LA077](https://openairdocs.org/ntsb/CHI95LA077.md): Cessna 150F · Castlewood, SD · Accident · No injuries · Limited investigation · Final report · Jan 21, 1995 · N8981S · Substantial damage
  > the pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.
- [NTSB CHI95LA014](https://openairdocs.org/ntsb/CHI95LA014.md): Mooney M-20J · Aberdeen, SD · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 1994 · CGJRA · Substantial damage
  > the pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…
- [NTSB CHI94DTK02](https://openairdocs.org/ntsb/CHI94DTK02.md): Ayres S2R · Letcher, SD · Accident · No injuries · Final report · Jun 22, 1994 · N3102E · Destroyed
  > the loss of engine power due to the failure of the engine driven fuel pump and shaft.
- [NTSB CHI93LA298](https://openairdocs.org/ntsb/CHI93LA298.md): Cessna 182P · Buffalo, SD · Accident · No injuries · Limited investigation · Final report · Aug 7, 1993 · N4724K · Substantial damage
  > The pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.
- [NTSB CHI93DTK01](https://openairdocs.org/ntsb/CHI93DTK01.md): Crowser Avid MK 3.75 · Philip, SD · Accident · 1 fatal · Final report · Jul 5, 1993 · N42CJ · Destroyed
  > The pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.
- [NTSB CHI92DTK02](https://openairdocs.org/ntsb/CHI92DTK02.md): Weatherly 201C · Timber Lake, SD · Accident · No injuries · Final report · Jun 1, 1992 · N1290W · Destroyed
  > The pilot's improper use of the propeller control during takeoff and initial climb.
- [NTSB CHI93LA381](https://openairdocs.org/ntsb/CHI93LA381.md): Cessna 172 · Union Center, SD · Accident · No injuries · Limited investigation · Final report · Jan 19, 1992 · N8529U · Substantial damage
  > Improper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.
- [NTSB CHI91LA209](https://openairdocs.org/ntsb/CHI91LA209.md): Champion 7KCAB · Hill City, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1991 · N1844G · Substantial damage
  > Poor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.
- [NTSB DEN90FA055](https://openairdocs.org/ntsb/DEN90FA055.md): Mitsubishi MU-2B-60 · Rapid City, SD · Accident · 1 fatal · Field investigation · Final report · Feb 9, 1990 · N64MD · Substantial damage
  > Failure of the pilot to maintain adequate airspeed (VMC), which resulted in a loss of aircraft control. A factor related to the accident was: fatigue failure of a coupling shaft in the #1 engine, which resulted in loss of power in that engine.
- [NTSB DEN89LA108](https://openairdocs.org/ntsb/DEN89LA108.md): Piper PA-28-180 · Milbank, SD · Accident · No injuries · Limited investigation · Final report · Apr 14, 1989 · N8272W · Substantial damage
  > Failure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.
- [NTSB DEN89LA082](https://openairdocs.org/ntsb/DEN89LA082.md): Stinson 108-2 · Custer, SD · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 1989 · N150C · Substantial damage
  > The improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.
- [NTSB DEN88FA186](https://openairdocs.org/ntsb/DEN88FA186.md): Luscombe 8A · Dimock, SD · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1988 · N71572 · Destroyed
  > The plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked…
- [NTSB DEN88LA153](https://openairdocs.org/ntsb/DEN88LA153.md): Piper PA-22-150 · Spearfish, SD · Accident · No injuries · Limited investigation · Final report · Jul 11, 1988 · CGCCF · Substantial damage
  > The accident involved a tri-pacer with four persons and about 150 pounds of baggage on board who were from Canada and vacationing in the U.S. The pilot said the acft became airborne and climbed to about 100 ft above the rwy, but would not maintain altitude…
- [NTSB DEN88LA145](https://openairdocs.org/ntsb/DEN88LA145.md): Sikorsky S-58J · Sioux Falls, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1988 · N62243 · Substantial damage
  > N62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…
- [NTSB DEN87LA133](https://openairdocs.org/ntsb/DEN87LA133.md): Piper PA-22-108 · Milbank, SD · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N5448Z · Substantial damage
  > The private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…
- [NTSB DEN87LA053](https://openairdocs.org/ntsb/DEN87LA053.md): Mooney M20C · Eureka, SD · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 1987 · N3451X · Substantial damage
  > After normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.

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

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