# NTSB investigations, SD: Takeoff

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 · 109 cases

## Latest cases

- [NTSB CEN23LA175](https://openairdocs.org/ntsb/CEN23LA175.md): Cessna 172S · Brookings, SD · Accident · No injuries · Class 4 · Limited · Final report · May 4, 2023 · N1674E · Substantial damage
  > The student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…
- [NTSB CEN23LA030](https://openairdocs.org/ntsb/CEN23LA030.md): Cessna 182Q · Murdo, SD · Accident · No injuries · Class 4 · Limited · Final report · Nov 6, 2022 · N699XM · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff with strong gusty surface winds.
- [NTSB CEN20CA344](https://openairdocs.org/ntsb/CEN20CA344.md): Beech 35 · White Owl, SD · Accident · No injuries · Class 4 · Data collection · Final report · Aug 16, 2020 · N6643Y · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and subsequent impact with an obstacle and terrain.
- [NTSB CEN20LA215](https://openairdocs.org/ntsb/CEN20LA215.md): Mitsubishi MU2B · Sioux Falls, SD · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 7, 2020 · N44MX · Destroyed
  > The pilot’s failure to maintain control of the airplane during takeoff for reasons that could not be determined.
- [NTSB GAA19CA217](https://openairdocs.org/ntsb/GAA19CA217.md): Vans Vans RV-12 · Wall, SD · Accident · Minor injuries · Data collection · Final report · Apr 14, 2019 · N277E · Substantial damage
  > The pilot's improper decision to depart from a slush-covered runway, which resulted in a loss of directional control, a runway excursion, and a subsequent nose-over.
- [NTSB GAA18CA429](https://openairdocs.org/ntsb/GAA18CA429.md): Cessna 170 · Spearfish, SD · Accident · No injuries · Data collection · Final report · Jul 19, 2018 · N432W · Substantial damage
  > The pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.
- [NTSB GAA18CA173](https://openairdocs.org/ntsb/GAA18CA173.md): Cessna 182 · Rapid City, SD · Accident · No injuries · Data collection · Final report · Mar 20, 2018 · N3024Y · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.
- [NTSB GAA18CA166](https://openairdocs.org/ntsb/GAA18CA166.md): Cessna 140 · Madison, SD · Accident · No injuries · Data collection · Final report · Mar 12, 2018 · N2011N · Substantial damage
  > The flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.
- [NTSB CEN16LA006](https://openairdocs.org/ntsb/CEN16LA006.md): Robinson Helicopter R44 · Parkston, SD · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2015 · N442RP · Substantial damage
  > The pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.
- [NTSB GAA15CA117](https://openairdocs.org/ntsb/GAA15CA117.md): Air Tractor AT 401 · Wall, SD · Accident · No injuries · Data collection · Final report · Jun 9, 2015 · N4549E · Substantial damage
  > The pilot's failure to adjust the airplane's useful load to compensate for the high temperature, which resulted in an insufficient climb rate to clear surrounding terrain, and a runway excursion.
- [NTSB CEN14LA284](https://openairdocs.org/ntsb/CEN14LA284.md): Air Tractor AT-301 · Winner, SD · Accident · No injuries · Limited investigation · Final report · Jun 11, 2014 · N8564S · Substantial damage
  > The pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.
- [NTSB CEN13CA481](https://openairdocs.org/ntsb/CEN13CA481.md): Super 18 S18-STD · Humboldt, SD · Accident · No injuries · Data collection · Final report · Aug 10, 2013 · N230AK · Substantial damage
  > The pilot's inadvertent addition of water into the fuel system and his improper preflight inspection, which resulted in a loss of engine power due to fuel contamination.
- [NTSB CEN13LA391](https://openairdocs.org/ntsb/CEN13LA391.md): Air Tractor AT-402B · Ipswich, SD · Accident · No injuries · Limited investigation · Final report · Jul 2, 2013 · N2072D · Substantial damage
  > The pilot’s failure to obtain adequate airspeed during the takeoff roll, which resulted in an aerodynamic stall.
- [NTSB CEN13CA108](https://openairdocs.org/ntsb/CEN13CA108.md): Piper PA-18-150 · Okaton, SD · Accident · No injuries · Data collection · Final report · Dec 11, 2012 · N3471Z · Substantial damage
  > The pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.
- [NTSB CEN12CA375](https://openairdocs.org/ntsb/CEN12CA375.md): Air Tractor AT-502 · Ipswich, SD · Accident · No injuries · Data collection · Final report · Jun 15, 2012 · N45379 · Substantial damage
  > The pilot's failure to abort the takeoff, which resulted in a runway excursion.
- [NTSB CEN12LA059](https://openairdocs.org/ntsb/CEN12LA059.md): Cessna 172M · Sturgis, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2011 · N13584 · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.
- [NTSB CEN11LA563](https://openairdocs.org/ntsb/CEN11LA563.md): Grumman Acft ENG Cor-Schweizer G-164A · Mansfield, SD · Accident · No injuries · Limited investigation · Final report · Aug 10, 2011 · N127FC · Substantial damage
  > The loss of engine power due to debris in the engine air intake system.
- [NTSB CEN11CA301](https://openairdocs.org/ntsb/CEN11CA301.md): Ayres S2R-R1340 · Estelline, SD · Accident · No injuries · Data collection · Final report · Apr 25, 2011 · N3104S · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during takeoff.
- [NTSB CEN11LA273](https://openairdocs.org/ntsb/CEN11LA273.md): Cessna 414A · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Mar 23, 2011 · N4057C · Substantial damage
  > The pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.
- [NTSB CEN10CA415](https://openairdocs.org/ntsb/CEN10CA415.md): Skykits Savannah VGW · Bison, SD · Accident · No injuries · Data collection · Final report · Jul 7, 2010 · N391EU · Substantial damage
  > The pilot's failure to maintain directional control of the airplane after encountering a gust of wind while taking off with a crosswind.
- [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 CHI08CA296](https://openairdocs.org/ntsb/CHI08CA296.md): Piper PA28 · Gann Valley, SD · Accident · No injuries · Data collection · Final report · Sep 27, 2008 · N6266J · Substantial damage
  > The pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.
- [NTSB CHI08CA111](https://openairdocs.org/ntsb/CHI08CA111.md): Veldhuizen Highlander · Onida, SD · Accident · No injuries · Data collection · Final report · Apr 18, 2008 · N8888V · Substantial damage
  > The separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.
- [NTSB CHI08CA029](https://openairdocs.org/ntsb/CHI08CA029.md): Cessna 172R · Brookings, SD · Accident · No injuries · Data collection · Final report · Oct 29, 2007 · N77LU · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.
- [NTSB CHI06FA067](https://openairdocs.org/ntsb/CHI06FA067.md): Piper PA-32-300 · Pierre, SD · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2006 · N8745E · Substantial damage
  > The loss of engine power during takeoff-initial climb due to the pilot's failure to correctly position the fuel selector, which resulted in fuel starvation and a forced landing.
- [NTSB CHI04LA201](https://openairdocs.org/ntsb/CHI04LA201.md): Piper PA-28-140 · Custer, SD · Accident · No injuries · Limited investigation · Final report · Jul 31, 2004 · N4345J · Substantial damage
  > The pilot's poor preflight planning/preparation and the pilot used improper aborted takeoff procedures by not reducing the throttle. Factors associated with the accident were the high density altitude and the tailwind.
- [NTSB CHI03LA154](https://openairdocs.org/ntsb/CHI03LA154.md): Braunschmidt RV-6A · Tea, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2003 · N160BM · Substantial damage
  > The loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.
- [NTSB CHI02CA211](https://openairdocs.org/ntsb/CHI02CA211.md): Cessna 172N · Spearfish, SD · Accident · No injuries · Data collection · Final report · Jul 18, 2002 · N1373E · Substantial damage
  > The probable cause of this accident was the pilot's failure to maintain directional control of the airplane during the takeoff roll. Differences in control forces and aircraft handling due to initiating the takeoff without fully retracting the flaps is a…
- [NTSB CHI01LA060](https://openairdocs.org/ntsb/CHI01LA060.md): Cessna 172S · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Jan 4, 2001 · N727SP · Substantial damage
  > Aircraft directional control not being maintained by the student pilot during the takeoff roll. Factors to the accident were the snow bank and the student pilot's lack of total experience.
- [NTSB CHI01LA051](https://openairdocs.org/ntsb/CHI01LA051.md): Cessna 172M · Sturgis, SD · Accident · No injuries · Limited investigation · Final report · Dec 19, 2000 · N13584 · Substantial damage
  > The pilot failed to maintain control of the airplane during takeoff and he discontinued an aborted takeoff once initiated. Factors associated with the accident were the inaccurate elevator trim indicator, the pilot's failure to verify the trim setting,…
- [NTSB CHI00LA192](https://openairdocs.org/ntsb/CHI00LA192.md): Creed Lancair 235 · Hot Springs, SD · Accident · No injuries · Limited investigation · Final report · Jul 4, 2000 · N235RC · Substantial damage
  > the failure of the pilot to select the correct runway for takeoff. Factors to the accident were the inadequate preflight planning/preparation, the aborted takeoff not performed, and the tailwind.
- [NTSB CHI00LA013](https://openairdocs.org/ntsb/CHI00LA013.md): Piper PA-32-300 · Custer, SD · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1999 · N2XT · Destroyed
  > the pilot's inadequate preflight planning and decision to perform an intersection takeoff, and the improper short field, rolling, intersection takeoff. A factor relating to this accident was the trees.
- [NTSB CHI99LA214](https://openairdocs.org/ntsb/CHI99LA214.md): Weatherly 620B · Timber Lake, SD · Accident · No injuries · Limited investigation · Final report · Jul 6, 1999 · N350WR · Substantial damage
  > the pilots selection of the shorter runway and his failure to abort the takeoff. Factors to the accident were the high density altitude, the fence and the fence posts.
- [NTSB CHI98LA118](https://openairdocs.org/ntsb/CHI98LA118.md): Air Tractor AT-401 · Highmore, SD · Accident · No injuries · Limited investigation · Final report · Apr 3, 1998 · N1008T · Substantial damage
  > the pilot failed to abort the takeoff in a timely manner and could not stop on the runway.
- [NTSB CHI96LA167](https://openairdocs.org/ntsb/CHI96LA167.md): Air Tractor AT401 · Letcher, SD · Accident · No injuries · Limited investigation · Final report · May 20, 1996 · N1019X · Substantial damage
  > the pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.
- [NTSB CHI93LA314](https://openairdocs.org/ntsb/CHI93LA314.md): Cessna 188 · Martin, SD · Accident · No injuries · Limited investigation · Final report · Aug 7, 1993 · N78516 · Substantial damage
  > the pilot's failure to maintain control of the airplane during the takeoff roll.
- [NTSB CHI91LA239](https://openairdocs.org/ntsb/CHI91LA239.md): Piper PA-38 · Bridgewater, SD · Accident · No injuries · Limited investigation · Final report · Aug 1, 1991 · N6373A · Substantial damage
  > Directional control was not maintained by the pilot. A factor related to the accident was a fence.
- [NTSB CHI90LA224](https://openairdocs.org/ntsb/CHI90LA224.md): Piper PA-28-180 · Sturgis, SD · Accident · No injuries · Limited investigation · Final report · Aug 10, 1990 · N15803 · Substantial damage
  > Poor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.
- [NTSB DEN90LA125](https://openairdocs.org/ntsb/DEN90LA125.md): Cessna 188A · Martin, SD · Accident · No injuries · Limited investigation · Final report · Jun 4, 1990 · N78516 · Substantial damage
  > The on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.
- [NTSB DEN88LA208](https://openairdocs.org/ntsb/DEN88LA208.md): Cessna 421B · Winner, SD · Accident · No injuries · Limited investigation · Final report · Sep 20, 1988 · N44HV · Substantial damage
  > The private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…
- [NTSB DEN87LA195](https://openairdocs.org/ntsb/DEN87LA195.md): Cessna 182L · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N3371R · Destroyed
  > The plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed…
- [NTSB DEN86LA204](https://openairdocs.org/ntsb/DEN86LA204.md): Piper PA-25-260 · Sisseton, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N8629L · Substantial damage
  > The plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…
- [NTSB DEN86LA166](https://openairdocs.org/ntsb/DEN86LA166.md): Piper PA-36 · Onida, SD · Accident · No injuries · Limited investigation · Final report · Jun 19, 1986 · N3856E · Destroyed
  > The plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…
- [NTSB DEN86FTK02](https://openairdocs.org/ntsb/DEN86FTK02.md): Aero Commander Callair A-9B · Dell Rapids, SD · Accident · No injuries · Final report · May 20, 1986 · N7757V · Substantial damage
  > The plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.…
- [NTSB DEN85LA100](https://openairdocs.org/ntsb/DEN85LA100.md): Cessna 172 · Wesbter, SD · Accident · No injuries · Limited investigation · Final report · Mar 19, 1985 · N7979B · Destroyed
  > The student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…
- [NTSB DEN85FA002](https://openairdocs.org/ntsb/DEN85FA002.md): Hamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SD · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1984 · N127MW · Destroyed
  > The hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…
- [NTSB DEN84LA233](https://openairdocs.org/ntsb/DEN84LA233.md): Cessna A188B · Stratford, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N9108R · Substantial damage
  > Plt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…
- [NTSB DEN84LA217](https://openairdocs.org/ntsb/DEN84LA217.md): Weatherly 201 · Watertown, SD · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N86686 · Destroyed
  > The spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan of…
- [NTSB DEN84LA197](https://openairdocs.org/ntsb/DEN84LA197.md): Cessna T188C · Philip, SD · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N9952J · Substantial damage
  > The plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.
- [NTSB DEN83LA164](https://openairdocs.org/ntsb/DEN83LA164.md): Cessna T188C · Carthage, SD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N2060J · Substantial damage
  > The acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…

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

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