NTSB investigations, 1983, SC

7 cases where the phase of flight was Approach.

Cases per year

19642026
NTSB investigations, 1983, SC per year, 1964–2026: 253 cases
19644
19655
19664
19676
19687
19697
19707
19716
19728
19736
19747
19758
19763
19776
19786
19794
19804
19819
19823
19837
19849
19853
19866
19871
19885
19892
19903
19914
19923
19934
19947
19954
19963
19977
19981
19994
20003
20011
20023
20034
20046
20054
20066
20074
20082
20095
20103
20111
20121
20135
20142
20151
20162
20171
20182
20203
20214
20222
20232
20241
20252

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 year(c.\"eventDate\") = 1983
    AND c.\"eventStateOrRegion\" = 'SC' 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 ATL84LA066Accident · No injuriesLimited investigationFinal reportCessna P206A · Charleston, SCThe acft undershot the rwy during landing. The weather was VMC but the landing was made one hour after official sunset. Visibility was reported as 10 miles. There were no problems reported with the arpt or acft except the plt during one radio call saying he…Dec 15, 1983 · N4648F · Substantial damageNTSB ATL84LA039Accident · 1 fatalLimited investigationFinal reportRand KR-2 · Greer, SCAccording to a witness, the plt began an apch to rwy 9, but made a go-around, then maneuvered to land on rwy 27. The witness stated that during the turn to final apch for rwy 27, the acft descended rapidly in a nose down attitude until it disappeared behind…Nov 6, 1983 · N25134 · DestroyedNTSB ATL83LA202Accident · No injuriesLimited investigationFinal reportCessna 195 · Florence, SCAccording to the plt, the eng lost power about 3 mi from the arpt after he switched from the right to the left fuel tank. He reported that he switched the boost pump to the 'high' position, but was unable to restart the eng. He estimated there was 5 to 7 gal…May 26, 1983 · N4395V · Substantial damageNTSB ATL83FA185Accident · 2 fatalField investigationFinal reportCessna 150L · Cheraw, SCThe student was on his 5th dual instructional flt & was practicing landings with his instructor. They had completed 3 or 4 landings & were in the traffic pattern for another when an intense thunderstorm cloud moved over the arpt. A plt/witness stated that a…May 12, 1983 · N21991 · DestroyedNTSB ATL83FA150Accident · Serious injuriesField investigationFinal reportCessna 172 · Spartanburg, SCAccording to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,…Apr 5, 1983 · N8253U · Substantial damageNTSB DCA83IA016Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-50 · Greer, SCAcft drifted to the right before a missed apch was initiated during which it made an inadvertent touchdown & struck a rwy light. The plt erroneously used RVR as his landing minimum. Actual RVR was below the published minimum. The sequenceflasher lights were…Feb 7, 1983 · N421EA · Minor damageNTSB ATL83LA089Accident · No injuriesLimited investigationFinal reportCessna 182M · Columbia, SCDuring arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…Jan 18, 1983 · N70872 · Substantial damage