OpenAirDocs.org

NTSB investigations, SD

12 cases where the phase of flight was Standing.

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 = 150)
  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 CEN19LA092Accident · Minor injuriesLimited investigationFinal reportBell 407 · Union Center, SDThe ambulance driver’s failure to see the helicopter’s rotating main rotor blades in dark night conditions, which resulted in the ambulance’s inadvertent collision with the helicopter. Contributing to the accident was the ambulance driver's failure to follow…Mar 3, 2019 · N450AM · Substantial damageNTSB CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.Jul 26, 2001 · N714GF · Substantial damageNTSB CHI00LA295Accident · Serious injuriesLimited investigationFinal reportAerostar S-81A · Custer, SDThe ground crew's failure to maintain control of the balloon until all passengers were disembarked. A factor related to the accident was the gust of wind.Sep 12, 2000 · N9174Z · Minor damageNTSB CHI96LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Parker, SDengine compartment fire from accumulated fuel in the carburetor, and failure of the pilot to follow the emergency checklist procedure.Jul 12, 1996 · N50104 · DestroyedNTSB CHI93IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Sioux Falls, SDThe pilot-in-command's inadequate preflight.Dec 29, 1992 · N31SV · Minor damageNTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…Aug 14, 1988 · N5301Z · Substantial damageNTSB DEN85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, SDPlt said he performed a 'hasty' preflight. During engine pre-start the plt inadvertently left the throttle open. The engine srated and the acft taxied across the ramp and hit a fence post before the plt could regain control of the acft.Feb 16, 1985 · N4513R · Substantial damageNTSB DEN84LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Yankton, SDThe plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…Nov 17, 1983 · N52419 · No damageNTSB DEN82DTK07Accident · Serious injuriesFinal reportRaven RX-7 · Phillip, SDAfter the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…Aug 22, 1982 · N4010S · Minor damageNTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damageNTSB MKC66D0234Accident · Serious injuriesClosedCessna 172D · Lak Preston, SDAug 11, 1965 · N8585X · Substantial damageNTSB UNK64X3229Accident · No injuriesClosedPiper J3C · Hot Springs, SDAug 5, 1964 · N3477N · Substantial damage