OpenAirDocs.org

NTSB investigations, SD

98 cases where the phase of flight was Approach.

Cases per year

19642026

Where

Open the map

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 = 500)
  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 CEN24LA076Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Vermillion, SDThe 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.Dec 29, 2023 · N2774P · Substantial damageNTSB CEN20CA086Accident · No injuriesData collectionFinal reportCessna 182 · Huron, SDThe 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.Feb 15, 2020 · N2019A · Substantial damageNTSB CEN19LA049Accident · 2 fatalClass 2 · LimitedFinal reportBeech 58 · Sioux Falls, SDThe pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.Dec 25, 2018 · N6745V · DestroyedNTSB CEN18LA306Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 3B · Custer, SDThe pilot’s mismanagement of rotor RPM and subsequent forced landing on uneven terrain which led to a dynamic rollover.Aug 2, 2018 · N347BH · Substantial damageNTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe 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.Aug 30, 2017 · N2982U · Substantial damageNTSB CEN16CA364Accident · No injuriesData collectionFinal reportBeech V35B · Sioux Falls, SDThe 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…Aug 30, 2016 · N23583 · Substantial damageNTSB CEN16LA201Accident · No injuriesLimited investigationFinal reportCessna 402B · Sioux Falls, SDThe failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.May 27, 2016 · N76MD · Substantial damageNTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe 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.Feb 12, 2016 · N6691P · Substantial damageNTSB CEN15CA160Accident · Serious injuriesData collectionFinal reportZenith Acft Stol CH 701 · Marion, SDThe 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.Feb 27, 2015 · N511QC · Substantial damageNTSB CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.Jul 23, 2013 · N7507A · Substantial damageNTSB CEN12CA658Accident · No injuriesData collectionFinal reportCessna 175A · Spearfish, SDThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.Sep 25, 2012 · N6979E · Substantial damageNTSB CEN12LA580Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.Aug 25, 2012 · N140XX · Substantial damageNTSB CEN12LA346Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Clark, SDThe pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.Jun 7, 2012 · N18012 · Substantial damageNTSB CEN10LA430Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Spearfish, SDThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Jul 24, 2010 · N1158X · Substantial damageNTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe 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.Dec 29, 2006 · N99TH · Substantial damageNTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe 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.Aug 16, 2006 · N6544T · Substantial damageNTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe 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…Aug 10, 2005 · N9408T · Substantial damageNTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe 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.Nov 6, 2004 · N39971 · Substantial damageNTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe 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.Jul 12, 2004 · N7077N · Substantial damageNTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe 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.Aug 7, 2003 · N9272K · Substantial damageNTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.Jul 4, 2003 · N7256M · DestroyedNTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe 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…Feb 8, 2001 · N107BA · Substantial damageNTSB CHI01LA033Accident · Minor injuriesLimited investigationFinal reportSaab 340-B · Aberdeen, SDthe impact with the flock of snow geese.Nov 9, 2000 · N402XJ · Substantial damageNTSB CHI00FA123Accident · 1 fatalField investigationFinal reportCessna 177RG · Watertown, SDthe pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.Apr 27, 2000 · N1978Q · DestroyedNTSB MIA98FA219Accident · 4 fatalField investigationFinal reportSocata TBM-700 · Spearfish, SDThe 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.Aug 4, 1998 · N69BS · DestroyedNTSB CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.Oct 18, 1997 · N88119 · Substantial damageNTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe 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.Aug 11, 1996 · N4053G · Substantial damageNTSB CHI96LA274Accident · No injuriesLimited investigationFinal reportBeech 35 · Yankton, SDan 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…Aug 3, 1996 · N3392V · Substantial damageNTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.Jul 4, 1996 · N290E · Substantial damageNTSB CHI92LA236Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Winner, SDFailure 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.Aug 7, 1992 · N30MT · Substantial damageNTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.Mar 19, 1992 · N1013E · Substantial damageNTSB CHI91DTK04Accident · 1 fatalFinal reportBoland/Poe Tsunami · Pierre, SDA 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…Sep 25, 1991 · NX39JR · DestroyedNTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe 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.Jun 27, 1991 · N541FL · Substantial damageNTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.Mar 11, 1990 · N35485 · Substantial damageNTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDApr 9, 1988 · N33SV · Substantial damageNTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe 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…Nov 25, 1987 · N1380Q · Substantial damageNTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe 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…Oct 26, 1987 · N1257E · DestroyedNTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis 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.Jul 4, 1987 · N6933V · DestroyedNTSB DEN85FA189Accident · 1 fatalField investigationFinal reportCessna 320F · Rapid City, SDThe 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…Jul 15, 1985 · N90HC · DestroyedNTSB DEN85FA180Accident · 4 fatalField investigationFinal reportHughes 369HS · Keystone, SDMain 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…Jul 6, 1985 · N5410W · DestroyedNTSB DEN84LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stratford, SDAcft 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.Jun 18, 1984 · N9389T · Substantial damageNTSB DEN84FA159Accident · Serious injuriesField investigationFinal reportGrumman American AA-1C · Rapid City, SDThe 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…May 23, 1984 · N9803U · Substantial damageNTSB DEN84FA021Accident · Serious injuriesField investigationFinal reportConvair 580 · Sioux Falls, SDThe 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…Nov 7, 1983 · N7517U · Minor damageNTSB DEN83FTK05Accident · Serious injuriesFinal reportPiper PA28-180C · Sturgis Muni., SDThe 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,…Aug 27, 1983 · N8426W · DestroyedNTSB DEN83FTK03Accident · Serious injuriesFinal reportBeech V35A · Sioux Falls, SDDuring 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…Feb 16, 1983 · N8478N · DestroyedNTSB DEN83FA027Accident · 2 fatalField investigationFinal reportCessna P210 · Sioux Falls, SDAt 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…Dec 1, 1982 · N4721P · DestroyedNTSB DEN83FA001Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wolsey, SDThe 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…Oct 1, 1982 · N6553C · DestroyedNTSB DEN82FA034Accident · No injuriesField investigationFinal reportPiper PA-23 · Mitchell, SDAs 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…Feb 18, 1982 · N5799Y · Substantial damageNTSB DEN81DTK23Accident · Minor injuriesClosedHughes 269C · Wilmot, SDSep 10, 1981 · N8954F · Substantial damageNTSB DEN81FTK13Accident · 1 fatalClosedPiper PA-28 · Rapid City, SDJun 21, 1981 · N4853T · Substantial damage