NTSB investigations, 2004, UT

7 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2004, UT per year, 1964–2026: 276 cases
19641
19651
19665
19673
19693
19702
19711
19723
19731
19741
19752
19765
19773
19781
19793
19804
19815
198210
19836
198412
19854
19861
19874
19886
19894
19904
19914
19926
19936
19945
19955
19964
19974
19986
19993
200011
20015
20025
20035
20047
20056
20066
20077
20087
20094
20109
20113
20127
20134
20147
20158
20165
20174
20184
20193
20202
20213
20225
20233
20243
20251
20264

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\") = 2004
    AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  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 DEN05LA024Accident · No injuriesLimited investigationFinal reportBell 206B3 · Eureka, UTthe pilot's improper in-flight planning and decision making and failure to maintain obstacle clearance, resulting in contact with a power transmission line. Contributing factors include the intentional low-level maneuver, the power transmission line, and the…Nov 13, 2004 · N130JH · Substantial damageNTSB DEN04LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Spanish Fork, UTthe pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.Aug 13, 2004 · N6249K · DestroyedNTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.Jun 17, 2004 · N8214J · DestroyedNTSB DEN04LA086Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Circleville, UTthe encounter with severe turbulence during aerial application and the pilot's inability to maintain aircraft control resulting in the in-flight collision with terrain. A contributing factor was the low altitude.Jun 7, 2004 · N8805D · DestroyedNTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.May 31, 2004 · N5686X · Substantial damageNTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…Feb 12, 2004 · N66952 · Substantial damageNTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.Jan 12, 2004 · N9679R · Destroyed