NTSB investigations, 1966, SC

26 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1966, 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\") = 1966
    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 MIA67F0342Accident · No injuriesClosedPiper PA-22 · West Columbia, SCDec 16, 1966 · N5482Z · Substantial damageNTSB MIA67D0316Accident · No injuriesClosedBeech T-34A · Spartanburg, SCNov 19, 1966 · N94595 · Substantial damageNTSB MIA67F0262Accident · No injuriesClosedMooney M20E · Columbia, SCSep 22, 1966 · N9359M · Substantial damageNTSB MIA67F0255Accident · No injuriesClosedErcoupe 415-C · Lancaster, SCSep 21, 1966 · N2249H · Substantial damageNTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCSep 18, 1966 · N8680S · Substantial damageNTSB MIA67F0252Accident · No injuriesClosedPiper PA-30 · Columbia, SCSep 5, 1966 · N7628Y · Substantial damageNTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCSep 4, 1966 · N8070X · Substantial damageNTSB MIA67D0254Accident · No injuriesClosedCessna 210 · Spartanburg, SCSep 2, 1966 · N9542T · Substantial damageNTSB MIA67A0025Accident · No injuriesClosedBell 47D1 · Crescent Beach, SCAug 13, 1966 · N4253A · Substantial damageNTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCAug 8, 1966 · N42595 · Substantial damageNTSB MIA67F0184Accident · No injuriesClosedPiper PA-25 · Darlington, SCAug 4, 1966 · N7276Z · Substantial damageNTSB MIA67D0180Accident · No injuriesClosedCessna 185E · Moncks Corner, SCJul 25, 1966 · N4552F · Substantial damageNTSB MIA67A0016Accident · No injuriesClosedBeech D18S · Landrum, SCJul 24, 1966 · N84U · Substantial damageNTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCJul 4, 1966 · N8483G · Substantial damageNTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCMay 20, 1966 · N8479G · Substantial damageNTSB MIA67F0004Accident · No injuriesClosedPiper PA-28 · Ridgeland, SCMay 13, 1966 · N4586R · Substantial damageNTSB MIA66D0626Accident · No injuriesClosedPiper PA-22 · Cayce, SCMay 12, 1966 · N5668Z · Substantial damageNTSB MIA66D0589Accident · No injuriesClosedBeech A23 · Greenville, SCMay 5, 1966 · N1467L · Substantial damageNTSB MIA66D0544Accident · No injuriesClosedCessna 182 · Little River, SCMay 4, 1966 · N8607T · Substantial damageNTSB MIA66A0123Accident · No injuriesClosedHughes 269A · Orangeburg, SCApr 22, 1966 · N8917F · Substantial damageNTSB MIA66F0506Accident · Minor injuriesClosedErco 415-C · St Stephen, SCMar 20, 1966 · N93538 · Substantial damageNTSB MIA66F0502Accident · No injuriesClosedCessna 210 · Bamberg, SCFeb 26, 1966 · N7303E · Substantial damageNTSB MIA66F0433Accident · No injuriesClosedPiper PA-28 · Columbia, SCFeb 20, 1966 · N7157W · Substantial damageNTSB MIA66A0088Accident · No injuriesClosedHughes 269A · Sumter, SCFeb 14, 1966 · N8853F · Substantial damageNTSB MIA66F0425Accident · No injuriesClosedBeechcraft 23 · Camden, SCFeb 6, 1966 · N2371Z · Substantial damageNTSB MIA66F0434Accident · No injuriesClosedCessna 180H · Columbia, SCFeb 4, 1966 · CF-RVZ · Substantial damage