NTSB investigations, 2008, UT

17 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2008, 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\") = 2008
    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 LAX08LA240Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Bountiful, UTA partial loss of engine power for undetermined reasons.Jul 22, 2008 · N7672 · Substantial damageNTSB LAX08CA232Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ogden, UTThe pilot's failure to maintain directional control of the airplane during landing.Jul 19, 2008 · N5716D · Substantial damageNTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…Jul 6, 2008 · N7360J · Substantial damageNTSB LAX08CA218Accident · No injuriesData collectionFinal reportCessna 180G · Heber, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was the crosswind weather conditions.Jun 29, 2008 · N98FC · Substantial damageNTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.Jun 7, 2008 · N2375G · Substantial damageNTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.Jun 2, 2008 · N8279C · Substantial damageNTSB SEA08CA148Accident · No injuriesData collectionFinal reportAviat A-1B · Ogden, UTThe pilot's failure to maintain directional control during landing. A contributing factor was the variable wind condition.May 31, 2008 · N172HY · Substantial damageNTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.May 9, 2008 · N9030E · Substantial damageNTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.May 3, 2008 · N185KH · Substantial damageNTSB SEA08LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Blanding, UTThe fatigue failure of the right main landing gear leg during the landing roll.Apr 24, 2008 · N180XP · Substantial damageNTSB SEA08CA111Accident · Minor injuriesData collectionFinal reportAviat A-1C-200 · Bluff, UTThe pilot's inadequate short-field landing procedure and excessive airspeed that resulted in a landing overrun. Contributing to the accident were gusting unfavorable winds, the short runway, and rocks off the departure end of the strip.Apr 24, 2008 · N134DD · Substantial damageNTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.Apr 12, 2008 · N36V · Substantial damageNTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.Mar 11, 2008 · N80318 · Substantial damageNTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.Mar 7, 2008 · N146P · Substantial damageNTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.Feb 26, 2008 · N1732C · Substantial damageNTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.Feb 9, 2008 · N72957 · Substantial damageNTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…Feb 4, 2008 · N73BL · Substantial damage