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 SEA07CA027Accident · No injuriesData collectionFinal reportPiper PA-12 · Antelope Island, UTThe pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB SEA06LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Grantsville, UTA lack of lubrication for undetermined reasons, which resulted in the failure of the Nos. 2, 3, 4, 5 and 6 connecting rods, a subsequent total loss of engine power during descent, which resulted in a forced landing. A factor in the accident was the soft sand.NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB SEA06CA108Accident · Minor injuriesData collectionFinal reportGrumman AA-1B · Bountiful, UTAn obstructed windshield which resulted in the pilot misjudging the distance/altitude during an emergency landing. An oil leak as a result of a leaking crankshaft seal was a factor.NTSB DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.NTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.NTSB DEN05CA144Accident · No injuriesData collectionFinal reportBradford Haines Glastar · Spanish Fork, UTthe pilot's failure to strain the fuel prior to flight resulting in fuel starvation. Contributing to the accident was the loss of engine power due to the plugged fuel filter.NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.NTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.NTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.NTSB DEN04LA128Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Roosevelt, UTthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB DEN04LA069Accident · Minor injuriesLimited investigationFinal reportBranham Vans RV-6 · Paragonah, UTThe pilot's inadequate preflight and in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. The berm and the pilot not stopping to refuel the airplane were contributing factors.NTSB DEN04LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Orem, UTthe pilot's improper in-flight planning and decision making, resulting in fuel exhaustion and the loss of engine power. Contributing factors include the dark night light conditions, and the trees.NTSB DEN04LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Parowan, UTthe pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB DEN03IA033Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Salt Lake City, UTthe arcing wires in the lavatory sensor that resulted in the subsequent fire.NTSB 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…NTSB DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.NTSB FTW03FA048Accident · 2 fatalField investigationFinal reportBeech A36 · Salem, UTThe pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…NTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.NTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB DEN02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tooele, UTthe pilot-in-command failure to obtain/maintain proper rate of climb, resulting in a collision with terrain. Contributing factors were the high density altitude and exceeding the airplane's forward center of gravity limit.NTSB DEN02LA066Accident · No injuriesLimited investigationFinal reportCessna 172M · Hite, UTthe pilot's improper in-flight planning resulting in fuel exhaustion. A factor relating to the accident was the unsuitable terrain encountered during the forced landing attempt.NTSB DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.NTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN02LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver, UTthe pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.NTSB DEN02LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Ferron, UTa loss of engine power due to the ingestion of foreign object(s) into the meshing of the gears, causing a malfunction of the magneto idler gear and failure of maintenance personnel to detect the signs of imminent failure during a mandatory oil filter…NTSB DEN01FA133Accident · 1 fatalField investigationFinal reportWilson Glastar · Henefer, UTthe pilot's failure to maintain aircraft control for an undetermined reason.NTSB DEN01LA102Accident · No injuriesLimited investigationFinal reportCessna T207A · Kanab, UTthe pilot's inadequate fuel consumption planning, and the subsequent fuel starvation, which resulted in a loss of engine power.NTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.NTSB DEN01FA041Accident · 9 fatalField investigationFinal reportBeech 65-A90 · Lake Point, UTthe pilot's exercise of poor judgment and his failure to maintain a safe altitude/clearance above the water. Contributing factors were the weather conditions that included low ceiling and visibility obscured by snow and mist, an inadequately equipped airplane…NTSB DEN01FA027Accident · 1 fatalField investigationFinal reportMooney M20K · Ogden, UTthe pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.NTSB DEN01FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Antimony, UTthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.NTSB DEN01LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTa forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.