OpenAirDocs.org

NTSB investigations, SC

17 cases where the phase of flight was Standing.

Cases per year

19652026

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\" = 'SC' 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 GAA15CA043Accident · No injuriesData collectionFinal reportShort Bros SD 360-300 · Greer, SCThe fuel truck driver's inattention, which resulted in backing over a warning cone and into the horizontal stabilizer of the airplane.Apr 16, 2015 · N688AN · Substantial damageNTSB ATL04LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Summerville, SCThe pilot's inadequate start procedure, which resulted in a run-away airplane.Feb 7, 2004 · N21266 · Substantial damageNTSB MIA01LA135Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Greenville, SCThe failure of the pilot to obtain the assistance of a person to act as a safety pilot while hand propping the engine with the airplane tied down. A factor in the accident was the failure of the tie down rope.Apr 28, 2001 · N86217 · Substantial damageNTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.Jul 26, 1995 · N3036M · Substantial damageNTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…Jun 14, 1986 · N30265 · DestroyedNTSB ATL84LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Spartanburg, SCThe acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.Dec 21, 1983 · N2354G · No damageNTSB ATL82FLG04Accident · No injuriesClosedPiper PA-32 · Columbia, SCNov 30, 1981 · N8564E · Substantial damageNTSB MIA76FLG38Accident · Minor injuriesClosedHughes 269A · Fair Play, SCJul 12, 1976 · N8718F · Substantial damageNTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damageNTSB MIA76DLG12Accident · No injuriesClosedHughes 269B · Saluda, SCAug 23, 1975 · N9560F · DestroyedNTSB MIA73DLG09Accident · No injuriesClosedCessna 150G · Charleston, SCJul 30, 1972 · N6364S · Substantial damageNTSB MIA71FLG11Accident · Minor injuriesClosedPiper PA-32 · Newberry, SCSep 28, 1970 · N3399W · DestroyedNTSB MIA68F0453Accident · No injuriesClosedBeech 65 · Columbia, SCFeb 10, 1968 · N216P · Substantial damageNTSB MIA68D0205Accident · Serious injuriesClosedErco 415-C · Columbia, SCSep 17, 1967 · N94654 · No damageNTSB MIA68F0186Accident · No injuriesClosedCessna 182B · Greenville, SCFeb 23, 1967 · N7230E · Minor damageNTSB MIA66D0600Accident · Serious injuriesClosedCessna 170 · Darlington, SCMay 7, 1966 · N2595V · Minor damageNTSB MIA65D0109Accident · Serious injuriesClosedCessna 182 · Anderson, SCMay 4, 1965 · N8430T · No damage