NTSB investigations, 1983, SC

12 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1983, SC per year, 1964–2026: 508 cases
196418
196511
196626
196719
196821
196912
197019
197114
197220
197317
19748
197514
197611
19777
197813
19793
19803
19816
198217
198312
198415
198512
19867
198714
198810
19897
19903
19912
19927
19935
19946
19953
19963
19974
19985
19997
20004
20012
20024
20032
20042
20055
20064
20073
20085
20099
20101
20117
20129
20131
20143
20151
20166
20174
201811
201910
20201
20216
20226
20236
20244
20258
20263

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 = 550)
  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 ATL84LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran…Dec 20, 1983 · N69069 · Substantial damageNTSB ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.Nov 23, 1983 · N7221P · Substantial damageNTSB ATL84LA037Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Beaufort, SCThe plt stated that he started having problems with various eletrically operated components during the latter part of the flt. During descent into Beaufort, he lost the ability to transmit and communicated to ATC by transponder. The plt said he put the gear…Nov 4, 1983 · N3688E · Substantial damageNTSB ATL84LA036Accident · No injuriesLimited investigationFinal reportCessna 210 · Charelston, SCWhile on downwind for a second touch and go landing the plt lowered the landing gear but received a safe indication only on the nose gear. After 2 hours of additional flights and 5 attempts to lower the gear the plt was forced to land with the unsafe…Nov 4, 1983 · N8866A · Substantial damageNTSB ATL84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Moncks Corner, SCThe plt reported that he landed on rwy 5 with a wind from the north northwest at 8 to 15 KTS. During the landing, he encountered a gust of wind, the acft veered, and subsequently, the right main gear failed.Oct 6, 1983 · N1561A · Substantial damageNTSB ATL83LA367Accident · No injuriesLimited investigationFinal reportRockwell AC-112A · Batesburg, SCThe acft experienced a gear collapse during landing rollout. The pilot stated that the gear green lights were on prior to landing. The landing and rollout were uneventful until a right turn of 180 degrees was made. During the turn the left main gear folded…Sep 13, 1983 · N1423J · Substantial damageNTSB ATL83LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ridgeland, SCThe acft overran the rwy and collided with a ditch during landing. The weather was VMC with the winds light and variablethe pilot said he found himself high as he crossed the rwy threshold. The acft reportedly floated before touchdown. The pilot used maximum…Aug 22, 1983 · N2531U · Substantial damageNTSB ATL83LA245Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe student plt was practicing landings on rwy 7 & completed 1 successful landing. He reported that on the 2nd approach, a gust of wind blew the acft to the left, so he made a go-around. A 3rd approach was made with the acft lined up slightly to the left of…Jun 27, 1983 · N714HA · Substantial damageNTSB ATL83LA154Accident · No injuriesLimited investigationFinal reportCessna 152B · Conway, SCThe acft bounced during a hard landing and stalled about 10 feet AGL. The second contact with the runway occurred with the nose gear first. The nose gear then collapsed. This was a training flight with a solo student pilot as pilot in command. The weather was…Apr 5, 1983 · N6521B · Substantial damageNTSB ATL83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hampton, SCThe left main landing gear of the aircraft collapsed during a hard landing. The pilot stated that he cleared tall pine trees north of the runway at about 90 mhp (78 KTS). Shortly thereafter the aircraft started to sink 'real fast'. The pilot stated that he…Feb 12, 1983 · N40863 · Substantial damageNTSB ATL83LA098Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charleston, SCThe plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…Feb 6, 1983 · N1810M · Substantial damageNTSB ATL83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Greenville, SCThe aircraft landing gear collapsed during landing rollout. The pilot stated that he raised the gear instead of the flaps during the landing roll.Jan 13, 1983 · N7737Y · Substantial damage