NTSB investigations, UT
673 cases where the phase of flight was Landing.
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 = 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.
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 = 550)
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 SEA06TA028Accident · Serious injuriesFinal reportAerospatiale SA-319B · Escalante, UTThe pilot's inadequate remedial action when ground resonance was encountered during landing. Contributing factors were the rough/uneven terrain and company inadequate maintenance.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.NTSB DEN05CA097Accident · No injuriesData collectionFinal reportRobinson R44 II · Indianola, UTThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and a hard landing.NTSB DEN05LA061Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Spanish Fork, UTthe student's failure to maintain control of the helicopter. Contributing factors were high airspeed, high rate of descent, the instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB DEN05LA056Accident · No injuriesLimited investigationFinal reportHughes 369HS · Provo, UTthe pilot's improper in-flight planning and decision making, his failure to maintain terrain clearance, and the total failure of the tail rotor drive shaft as a result of the tail rotor strike.NTSB DEN05CA050Accident · No injuriesData collectionFinal reportGrumman G-1159 · Logan, UTthe pilot's improper IFR operation by which he failed to comply to the missed approach procedure, and his improper evaluation of the weather resulting in an encounter with fog and his loss of visual contact with the runway during the landing.NTSB DEN05LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 · Park City, UTthe student pilot's failure to maintain aircraft control, and the instructor's inadequate supervision by her failure to assure adequate rotor rpm was maintained.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB DEN04CA143Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Spanish Fork, UTthe pilot's failure to maintain adequate rotor rpm during a practice autorotation, and the flight instructor's improper flare. A contributing factor was the instructor's inadequate supervision of the pilot.NTSB DEN04CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Logan, UTthe instructor's failure to maintain adequate rotor speed during the landing flare, resulting in a hard landing. Contributing factors include the student's delay in relinquishing the controls and the instructor's improper supervision.NTSB DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.NTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.NTSB DEN04LA084Accident · No injuriesLimited investigationFinal reportCessna 310J · Morgan, UTthe poor friction value on the runway rendering braking action inadequate. Contributing factors include the excessive approach speed, and the pilot's inability to maintain directional control of the aircraft.NTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.NTSB DEN04LA049Accident · No injuriesLimited investigationFinal reportCessna 182P · Hanksville, UTthe pilot's selection of unsuitable terrain to conduct a precautionary landing. Factors contributing to the accident was the soft, dirt road.NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.NTSB DEN04LA039Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. George, UTthe pilot's improper flare which resulted in a hard landing.NTSB DEN04LA028Accident · No injuriesLimited investigationFinal reportCessna 150H · Bountiful, UTthe unqualified person's failure to maintain aircraft control, which resulted in a hard landing. Contributing factors include the instructor's inadequate supervision, the instructor's inadequate recovery from a bounced landing, and the two parked aircraft.NTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.NTSB DEN03LA145Accident · No injuriesLimited investigationFinal reportR. I. Woods Bushby Mustang II · Logan, UTthe pilot's failure to maintain aircraft control, and his inadequate recovery from the bounced landing. A contributing factor was the wind gust.NTSB DEN03LA141Accident · No injuriesLimited investigationFinal reportRichardson RV-6 · Provo, UTthe pilot's failure to maintain aircraft control. Contributing factors were the resulting ground loop and the collapsed right main landing gear.NTSB DEN03LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Vernal, UTthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing that resulted in an inadvertent ground loop/swerve.NTSB DEN03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ogden, UTthe failure of the landing gear retraction/extension assembly due to the improper rigging of the landing gear.NTSB DEN03LA106Accident · No injuriesLimited investigationFinal reportCessna 180 · Ogden, UTthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control.NTSB DEN03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Price, UTthe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A related factor was the crosswind.NTSB DEN03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · St. George, UTthe pilot's improper flare technique, resulting in a hard landing that caused the nose landing gear down-lock to fail and the gear to collapse. A contributing factor was the unfavorable wind.NTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.NTSB DEN03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Tooele, UTthe inadvertent retraction of the landing gear during landing roll by the dual student. Contributing factors included the dual student's lack of familiarity with the aircraft, inadequate supervision by the flight instructor, and improper rigging of the…NTSB DEN03LA015Accident · No injuriesLimited investigationFinal reportCessna 150F · Logan, UTThe pilot's premature flare and his failure to maintain airspeed, resulting in a stall. A contributing factor was the dusk light conditions.NTSB DEN03LA001Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Morgan, UTthe pilot's inadequate inflight planning and decision which resulted in an unsuitable off-field landing site. A contributing factor was downdraft weather conditions.NTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.NTSB DEN02LA094Accident · No injuriesLimited investigationFinal reportCollette RV6 · Nephi, UTThe pilot's failure to maintain aircraft control during landing roll, resulting in his attempt to go-around and an inadvertent stall/mush. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.NTSB DEN02LA095Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Lehi, UTthe pilot's inadequate in-flight planning resulting in the glider impacting terrain short of the runway, and the pilot's subsequent abrupt handling of the glider when it became airborne again, which resulted in a hard second landing. A contributing factor was…NTSB DEN02LA077Accident · No injuriesLimited investigationFinal reportCessna 150L · Hurricane, UTpilot's failure to maintain directional control during landing roll, resulting in an inadvertent ground loop.NTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.NTSB DEN02LA035Accident · No injuriesLimited investigationFinal reportCessna 310B · Provo, UTFailure of the nose landing gear retraction/extension assembly for an undetermined reason, which resulted in collapse of the nose landing gear on landing.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.NTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.NTSB DEN01LA160Accident · No injuriesLimited investigationFinal reportCessna 177RG · St. George, UTbrake system failure for reasons undetermined, which resulted in a loss of control on landing.NTSB DEN01LA137Accident · No injuriesLimited investigationFinal reportBeech A35 · Moab, UTthe pilot's failure to lower the landing gear resulting in a wheels up landing.NTSB DEN01LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Spanish Fork, UTthe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during landing. A contributing factor was the gusty crosswind.NTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB DEN01LA114Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Provo, UTinadvertent retraction of the landing gear by the pilot rated student during landing roll. A contributing factors was the failure of the instructor to adequately supervise the student.