NTSB investigations, 2018, UT

9 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2018, 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\") = 2018
    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 GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.Nov 22, 2018 · N21621 · Substantial damageNTSB GAA18CA576Accident · Minor injuriesData collectionFinal reportRaymon A. King Super CUB Replica · Saratoga Springs, UTThe pilot's failure to maintain directional control during the takeoff roll with crosswind conditions.Sep 29, 2018 · N1698K · Substantial damageNTSB WPR18LA272Accident · No injuriesClass 3 · LimitedFinal reportSmith AEROSTAR601 · Heber, UTA recent hard landing resulted in a fracture of a joint from a cylinder to a main landing gear.Sep 25, 2018 · N90339 · Substantial damageNTSB GAA18CA566Accident · No injuriesData collectionFinal reportVans RV-14 · Heber City, UTThe pilot's loss of directional control during the landing roll and his subsequent attempted go-around.Sep 24, 2018 · N823HE · Substantial damageNTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.Jun 3, 2018 · N67WW · Substantial damageNTSB GAA18CA314Accident · No injuriesData collectionFinal reportSchleicher ASW · Nephi, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a hard off-airport landing.May 30, 2018 · N428US · Substantial damageNTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.May 19, 2018 · N833RD · Substantial damageNTSB GAA18CA202Accident · No injuriesData collectionFinal reportCessna 182 · Nephi, UTThe pilot’s failure to maintain a proper landing flare, which resulted in a hard landing.Mar 30, 2018 · N5292N · Substantial damageNTSB GAA18CA099Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Spanish Fork, UTThe pilot’s incorrect brake application during the landing roll, resulting in a nose over.Jan 11, 2018 · N5923C · Substantial damage