NTSB investigations, 1968, UT

15 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1968, UT per year, 1964–2026: 673 cases
196430
196516
196627
196722
196815
196916
197011
19714
197210
197311
19744
19758
197618
197712
19787
197911
198017
198114
198212
19836
198411
19857
198610
19879
19886
19899
19909
199110
19923
199310
19948
19956
19968
199711
199810
19998
200011
200113
200212
200310
200413
20058
20069
200713
200817
200914
20108
201110
20126
20137
20146
20157
20165
20179
20189
201912
20205
20216
202213
202313
202411
20258
202612

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\") = 1968
    AND c.\"eventStateOrRegion\" = 'UT' 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 DEN69F0085Accident · Minor injuriesClosedPiper J3C-65 · Orem, UTAug 22, 1968 · N30513 · Substantial damageNTSB DEN69D0119Accident · No injuriesClosedPiper PA-22 · Sandy, UTAug 11, 1968 · N3250Z · Substantial damageNTSB DEN69D0035Accident · No injuriesClosedMooney M20D · Ogden, UTJul 7, 1968 · N1962Y · Substantial damageNTSB DEN69D0034Accident · No injuriesClosedZefir SZD-19 · Cedar City, UTJun 26, 1968 · N86674 · Substantial damageNTSB DEN69F0016Accident · No injuriesClosedBeech 95-B55 · Salt Lake City, UTJun 13, 1968 · N8909M · Substantial damageNTSB DEN68A0055Accident · Serious injuriesClosedBoeing 727 · Salt Lake City, UTJun 8, 1968 · N7418U · Substantial damageNTSB DEN68D0278Accident · No injuriesClosedPiper PA-28 · Delta, UTJun 1, 1968 · N9250W · Substantial damageNTSB DEN69F0018Accident · No injuriesClosedPiper PA-20 · Ogden, UTMay 29, 1968 · N7767K · Substantial damageNTSB DEN68F0277Accident · No injuriesClosedCessna 185 · Cedar City, UTMay 22, 1968 · N9946X · Substantial damageNTSB DEN68D0276Accident · No injuriesClosedDehaviland DHC-2 · Brigham City, UTMay 17, 1968 · N751 · Substantial damageNTSB DEN68D0255Accident · No injuriesClosedPiper PA-22 · Blanding, UTMay 6, 1968 · N6163D · Substantial damageNTSB DEN68D0228Accident · Minor injuriesClosedCessna 180 · Green River, UTMar 25, 1968 · N2988C · DestroyedNTSB DEN68D0203Accident · No injuriesClosedCessna 182 · Logan, UTFeb 8, 1968 · N8358S · Substantial damageNTSB DEN68F0198Accident · No injuriesClosedBeech E50 · Beaver, UTJan 13, 1968 · N952A · Substantial damageNTSB DEN68F0184Accident · No injuriesClosedPiper PA-30 · Salt Lake City, UTJan 5, 1968 · N7042Y · Substantial damage