NTSB investigations, 2003, UT

10 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 2003, UT per year, 1964–2026: 544 cases
19649
196513
196616
19678
196812
19698
197012
19718
197210
197318
197413
197512
197612
197713
197817
197914
198014
198117
19828
198320
198414
198513
19868
198719
198810
19897
19907
19916
19928
19936
19948
19956
19963
19976
19988
19995
200010
20016
200211
200310
20047
20053
200610
200711
20086
20099
20104
20116
20124
20134
20143
20154
20164
20173
20185
20195
20202
20215
20223
20238
20243
20256
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\") = 2003
    AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…Oct 3, 2003 · N7357W · DestroyedNTSB DEN04LA001Accident · No injuriesLimited investigationFinal reportElliott Mustang II · Cedar City, UTThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power.Oct 1, 2003 · N9XQ · Substantial damageNTSB DEN03LA110Accident · No injuriesLimited investigationFinal reportAlexander Schleicher · Paragonah, UTThe pilot's encounter with unsuitable terrain during a precautionary landing. Contributing factors were the strong winds and the approaching vehicle.Jun 24, 2003 · D-KIMK · Substantial damageNTSB DEN03LA088Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Cedar City, UTthe pilot's inadvertently switching the fuel selector to the right tank, resulting in fuel starvation, and his failure to maintain direction control during the forced landing. Contributing factors were the crosswind and the tree.May 23, 2003 · N8199T · DestroyedNTSB DEN03TA079Accident · 1 fatalFinal reportMcDonnell Douglas A-4N · Salt Lake City, UTThe lose of engine power during descent due to the in-flight collision with a bird which FOD damaged the engine and subsequently melted the turbine section. A contributing factor was the airplane's malfunctioning ejection seat.May 10, 2003 · N263WL · DestroyedNTSB DEN03IA067Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Salt Lake City, UTtotal failure of a fuel flex line. A contributing factor was a fuel leak, resulting in an inflight engine compartment fire.Apr 17, 2003 · N6712B · Minor damageNTSB DEN03LA051Accident · Minor injuriesLimited investigationFinal reportPanzl PAN · Vernal, UTthe pilot's inadequate preflight preparation and his lack of familiarity with the airplane, which subsequently resulted in fuel starvation to the engine. Contributing factors were unfavorable wind conditions and the downdraft weather condition.Mar 18, 2003 · N11ZL · Substantial damageNTSB DEN03FA038Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · La Sal, UTthe loss of engine power (total) due to fuel starvation, the pilot not following procedures/directives (fuel management procedures), and the pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the pilot's inadequately…Jan 24, 2003 · N106AW · DestroyedNTSB DEN03IA033Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Salt Lake City, UTthe arcing wires in the lavatory sensor that resulted in the subsequent fire.Jan 11, 2003 · N551UA · Minor damageNTSB DEN03LA027Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH2000 · Milford, UTthe inadequate altitude chosen by the flight instructor, resulting in inadequate clearance and subsequent collision with mountainous terrain. Contributing factors were the instructor's failure to consult pertinent VFR sectional charts for the area, and the…Jan 2, 2003 · N8500R · Destroyed