NTSB investigations, SD

183 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, SD per year, 1964–2026: 183 cases
19644
19655
19664
19673
19685
19694
19702
19713
19724
19733
19741
19753
19763
19775
19787
19796
19804
19815
19825
19834
19847
19856
19865
19873
19881
19891
19906
19914
19923
19935
19943
19952
19961
19974
19982
19992
20004
20012
20032
20041
20053
20073
20093
20101
20116
20122
20132
20142
20152
20161
20171
20181
20194
20202
20221
20241
20254

Latest cases

Query with SQL
duckdb -csv -c "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 = 450)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…Jul 28, 2025 · N9642D · Substantial damageNTSB CEN25LA221Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Pierre, SDThe pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.Jun 24, 2025 · N107ML · Substantial damageNTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.Jun 19, 2025 · N6174A · Substantial damageNTSB CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.Feb 27, 2025 · N6555C · No damageNTSB CEN24LA229Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander S2R · White, SDA low-level collision and engine ingestion with ducks, which resulted in a total loss of engine power, a forced landing, and a subsequent nose over.Jun 13, 2024 · N1746S · Substantial damageNTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…Jan 31, 2022 · N3177F · Substantial damageNTSB CEN20LA389Accident · 2 fatalClass 3 · LimitedFinal reportChampion 8KCAB · Groton, SDThe pilot’s loss of airplane control during a low-altitude aerobatic maneuver.Sep 13, 2020 · N83DH · Substantial damageNTSB CEN20LA309Accident · 1 fatalClass 3 · LimitedFinal reportCessna A188 · Corsica, SDThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control.Jul 27, 2020 · N53163 · DestroyedNTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · DestroyedNTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.Sep 12, 2019 · N100CK · Substantial damageNTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.Aug 16, 2019 · N500KA · Substantial damageNTSB CEN19LA053Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Salem, SDThe incapacitating effects of an acute myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.Jan 13, 2019 · N75191 · Substantial damageNTSB CEN18LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, SDA stuck No. 3 cylinder exhaust valve, which resulted in failure of the associated rocker arm, a partial loss of engine power, and the subsequent forced landing into tall vegetation.Aug 14, 2018 · N6341K · Substantial damageNTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.Jul 26, 2017 · N421CA · Substantial damageNTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.Jun 7, 2016 · N921RP · Substantial damageNTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.Sep 4, 2015 · N321DA · Substantial damageNTSB GAA15CA196Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Forest City, SDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.Jul 2, 2015 · N824DK · Substantial damageNTSB CEN15CA001Accident · No injuriesData collectionFinal reportPiper PA 25-235 · Yankton, SDThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Oct 1, 2014 · N6659Z · Substantial damageNTSB CEN14CA317Accident · Serious injuriesData collectionFinal reportQuicksilver Enterprises MXL II Sport · Watertown, SDThe uncertificated pilot's loss of control while maneuvering at low altitude.Jun 19, 2014 · N4474P · Substantial damageNTSB CEN13LA375Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colome, SDThe loss of engine power for reasons that could not be determined because a postaccident engine run revealed no anomalies that would have precluded normal operation.Jun 26, 2013 · N3168X · Substantial damageNTSB CEN13FA324Accident · 1 fatalField investigationFinal reportWeatherly 620B · Ludlow, SDThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was task- and/or work-related fatigue.Jun 7, 2013 · N350WR · Substantial damageNTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.May 23, 2012 · N30951 · Substantial damageNTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.Apr 5, 2012 · N104MH · Substantial damageNTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…Dec 9, 2011 · N421SY · Substantial damageNTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.Aug 20, 2011 · N7051Z · Substantial damageNTSB CEN11FA437Accident · 3 fatalField investigationFinal reportAmerican Champion 7GCBC · Hayti, SDThe pilot's decision to attempt low-altitude flight and his failure to maintain adequate clearance from power lines.Jul 3, 2011 · N711AT · Substantial damageNTSB CEN11LA452Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Estelline, SDThe pilot’s failure to maintain control of the airplane during takeoff for undetermined reasons because the pilot did not recall the accident.Jun 28, 2011 · N1588M · Substantial damageNTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.Jun 18, 2011 · N7018Z · Substantial damageNTSB CEN11LA399Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Highmore, SDThe pilot did not maintain control of the airplane while maneuvering at low altitude.Jun 17, 2011 · N57885 · Substantial damageNTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.May 29, 2010 · N88399 · Substantial damageNTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.Aug 16, 2009 · N98AW · Substantial damageNTSB CEN09CA616Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Clark, SDThe pilot's inadequate visual lookout and failure to maintain clearance from a levy.Jun 12, 2009 · N57625 · Substantial damageNTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.Mar 6, 2009 · N648LA · Substantial damageNTSB CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.Jul 30, 2007 · N661FB · Substantial damageNTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.Jul 7, 2007 · N14067 · Substantial damageNTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.May 19, 2007 · N40097 · DestroyedNTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.Jul 5, 2005 · N3211R · Substantial damageNTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.May 19, 2005 · N8505F · Substantial damageNTSB CHI05CA117Accident · Serious injuriesData collectionFinal reportAviat A-1B · Lodgepole, SDThe poor inflight planning and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the low altitude at which the airplane encoutnered its own wake.May 19, 2005 · N102AM · Substantial damageNTSB CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.Jun 23, 2004 · N1013N · Substantial damageNTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.Aug 10, 2003 · N4656M · Substantial damageNTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.Aug 2, 2003 · N4923X · Substantial damageNTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.Jul 31, 2001 · N5551X · DestroyedNTSB CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.Jun 3, 2001 · N484WB · DestroyedNTSB CHI01FA001Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Rapid City, SDSuicideOct 3, 2000 · N294ND · DestroyedNTSB CHI00FA288Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Custer, SDThe pilot not maintaining clearance from the tree. Factors relating to this accident were the pilot's inadequate preflight planning and preparation, the high density altitude, the inadequate rate of climb, the pilot's improper in-flight decision to fly into…Sep 8, 2000 · N4730Z · DestroyedNTSB CHI00LA108Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Arlington, SDthe CFI's improper use of the throttle control during a simulated loss of engine power emergency. A factor associated with the accident was the rough terrain on which the forced landing was conducted.Mar 31, 2000 · N8371V · Substantial damageNTSB CHI00LA100Accident · No injuriesLimited investigationFinal reportPiper J-3C · Eureka, SDthe foreign object (shot gun shell) which jammed the control stick. Factors associated with the accident were the low altitude at which the control stick jammed and the rough terrain which the airplane contacted.Mar 30, 2000 · N71060 · Substantial damageNTSB CHI99FA285Accident · 2 fatalField investigationFinal reportBell 206B · Custer, SDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's inadvertent settling with power.Aug 10, 1999 · N67JJ · DestroyedNTSB CHI99LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Veblen, SDwas the pilot not maintaining clearance from terrain. A factor was the pilot not performing a load jettison.Jun 24, 1999 · N3159M · Substantial damage