NTSB investigations, UT
544 cases where the phase of flight was Enroute.
Cases, newest first
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 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.
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 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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN00LA145Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Duchesne, UTThe pilot's use of excessive braking on soft terrain. Factors included fuel starvation, the fuel selector valve not engaging properly, the pilot's incorrect positioning of the fuel selector valve, and the soft terrain on which the forced landing was made.NTSB DEN00IA133Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries 20C-1 · Spanish Fork, UTThe company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.NTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.NTSB DEN00LA099Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Milford, UTThe failure of the turbocharger scavenging pump resulting in the total failure of the engine, and the pilot's failure to compensate for wind conditions that led him to over fly the runway during his forced landing. Factors were the pilot's diverted attention…NTSB DEN00LA090Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Boulder, UTThe pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.NTSB FTW00LA138Accident · Minor injuriesLimited investigationFinal reportNoteman RV6-A · Kanab, UTThe partial loss of engine power as result of the failure of an exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.NTSB DEN99LA168Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Tremonton, UTThe pilot's failure to maintain rotor rpm while attempting a precautionary autorotation landing. A factor was the loss of engine power for undetermined reasons.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.NTSB DEN99LA062Accident · No injuriesLimited investigationFinal reportSly RV-6A · Payson, UTThe development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…NTSB DEN99FA029Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · West Jordan, UTThe pilot's poor judgement by intentionally flying into instrument meteorological conditions without proper certification. Factors were the resulting spatial disorientation, the pilot's failure to maintain control of the aircraft, the in-flight wing…NTSB DEN99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Tooele, UTThe pilot's VFR flight into IMC and his failure to maintain adequate terrain clearance. Contributng factors were fog, low ceilings, high terrain, the pilot's lack of familiarity with the geographic environment and his misinterpretation of terrain features on…NTSB FTW98LA404Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Duck Creek, UTLoose intake valve rocker arm studs that allowed a loss of compression and a loss of oil. A factor was unsuitable terrain on which to make a forced landing and poles next to a cattle guard.NTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB FTW98LA331Accident · No injuriesLimited investigationFinal reportCessna TU206G · Midvale, UTThe pilot's inadequate fuel management which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW98LA326Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS 4A · Salina, UTThe pilot's selection of unsuitable terrain to conduct a landing. Contributing was the loss of thermal lift and high vegetation.NTSB FTW98FA276Accident · 2 fatalField investigationFinal reportBeech A36 · Nephi, UTThe improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…NTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.NTSB FTW98FA044Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Myton, UTThe pilot exceeded the design stress limits of the airplane which resulted in an in-flight airframe overload failure. A related factor was the dark night.NTSB FTW98TA051Incident · No injuriesFinal reportCessna P210N · Bryce Canyon, UTThe failure of the resistor (inverter) in the door seal pressurization air pump due to continuous operation. Factors were a failure in the door seal pressurization system, its inadequate design by the manufacturer, its inadequate written instructions for…NTSB SEA97LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Ogden, UTThe fracture of the no. 4 exhaust valve and subsequent loss of engine power. Factors contributing to the accident include a congested landing area, and rough terrain.NTSB SEA97LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lake Powell, UTA loss of engine power for undetermined reasons.NTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…NTSB SEA97LA061Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morgan, UTDisconnection of the mixture control wire wound cable sheath. A factor was the abrupt, elevated edge of the highway pavement.NTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…NTSB SEA96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salt Lake City, UTthe student pilot's inadequate preflight planning/preparation, by failuring to properly calculate the fuel consumption of the airplane, which led to fuel exhaustion and loss of power during cruise flight, due to an inadequate supply of fuel. A factor relating…NTSB SEA96FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Lehi, UTcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: darkness, low ceiling, and snow.NTSB LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.NTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB SEA95LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mt Pleasant, UTThe pilot in command's failure to maintain airspeed during climbout. Factors include wind shear and high density altitude.NTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.NTSB SEA95FA095Accident · 6 fatalField investigationFinal reportCessna T210L · Milford, UTthe pilot's continued flight into known adverse weather (icing conditions), and his delay in executing a course reversal to exit those conditions, which resulted in airframe ice accumulation and loss of control. A factor was the icing conditions.NTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.NTSB FTW95FA008Accident · 3 fatalField investigationFinal reportCessna T337G · Milford, UTThe pilot's continued flight into adverse weather conditions, which resulted in airframe (structural) ice, a loss of control, and subsequent in-flight breakup of the airplane. A factor related to the accident was: the icing/weather condition.NTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.NTSB SEA94GA203Accident · 1 fatalFinal reportHughes OH-6A · Duchesne, UTThe pilot's improper in-flight planning/decision and failure to maintain sufficient altitude/clearance from the surrounding terrain. Factors related to the accident were: thunderstorms in the area (requiring the pilot to deviate from the desired course), high…NTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.NTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.NTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.NTSB SEA94LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hurricane, UTThe pilot in command's failure to refuel and excessive airspeed during the approach. Factor(s) were: fencepost(s) and the lack of recent experience in type of aircraft.NTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.NTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.NTSB SEA93FA071Accident · 2 fatalField investigationFinal reportCessna 402B · Oakley, UTPoor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.NTSB SEA93LA069Accident · Minor injuriesLimited investigationFinal reportCessna T-210L · Ogden, UTThe loss on engine power from fuel exhaustion due to the inadequate preflt planning/preparation by the PIC and his failure to maintain proper airspeed during an emergency forced landing.NTSB SEA93LA051Accident · No injuriesLimited investigationFinal reportBeech 58P · Hanksville, UTAn improper fuel selector valve position, fuel starvation, and inadequate remedial action. Factors include soft, rough terrain.NTSB SEA93LA017Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Green River, UTThe inadequate preflt planning/preparation by the pilot resulting in inflt encounter with weather and his failure to maintain proper rate of descent during an emergency forced landing. A factor relating to the accident was the turbulent weather conditions.NTSB SEA92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Farmington, UTThe pilot's poor inflight decision. Factors include downdrafts and a box canyon.