NTSB investigations, UT
221 cases where the phase of flight was Approach.
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 = 500)
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 = 500)
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 DEN90LA151Accident · No injuriesLimited investigationFinal reportCessna 172XP · Tooele, UTThe flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.NTSB DEN90FA100Accident · 4 fatalField investigationFinal reportPiper PA31-325 · Cedar City, UTThe pilot failed to maintain a minimum safe altitude over mountainous terrain during a night VFR approach for landing.NTSB DEN90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Provo, UTFuel starvation due to pilot misjudgement of fuel requirements for the trip and a failure to refuel the airplane en route.NTSB DEN89LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.NTSB DEN89LA224Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Monument Valley, UTThe pilot's failure to adequately compensate for windshear.NTSB DEN89LA085Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Roy, UTThe pilot allowed himself to become distracted by a landing gear problem, which resulted in fuel exhaustion, when he had insufficient fuel to delay his landing. Factors related to the accident were: the landing gear problem and trees in the emergency landing…NTSB DEN89IA067Incident · No injuriesIncident investigationFinal reportBoeing 707-323B · Salt Lake City, UTThe pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…NTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…NTSB SEA87FA036Accident · No injuriesField investigationFinal reportSwearingen SA227AC · Salt Lake City, UTThe f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent…NTSB DEN86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Monument Valley, UTThe plt was on an approach for landing when the acft began to settle. He said that increasing power did not seem to have an effect. Subsequently, the acft landed hard, collapsing the nose gear. The plt believed that he had encountered wind shear during the…NTSB DEN86LA195Accident · No injuriesLimited investigationFinal reportCessna 320C · Cedar City, UTThe plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond…NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…NTSB DEN86LA159Accident · No injuriesLimited investigationFinal reportCessna 150L · Bountiful, UTThe plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on the…NTSB DEN86LA118Accident · No injuriesLimited investigationFinal reportCessna 180G · Roosevelt, UTThe plt stated that after 'landing long', he decided to initiate a go-around. The plt said the aircraft he was piloting contacted a parked aircraft during the go-around which resulted in the accident.NTSB DEN86FA103Accident · 2 fatalField investigationFinal reportI.C.A. Brasov IS-28B2 · Cedar City, UTThe plt and pax were returning from a LCL flt. Two fss specialists observed the glider on final approach to rwy 20. They stated that the acft completed two 360 degree turns with 90 degrees of bank. The glider was in the third 360 degree turn when the…NTSB DEN86FA060Accident · Serious injuriesField investigationFinal reportCessna 152 · Salt Lake City, UTAn instructor with his student plt were returning from a cross-country training flt. Three attempts were made to complete an ILS approach in heavy fog to the arpt. With each approach the instructor partially lost control of the acft and then recovered but on…NTSB DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…NTSB DEN85LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage.NTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.NTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.NTSB DEN85FTM03Accident · 1 fatalFinal reportKillian Briegleb BG-12B · Heber City, UTThe acft was a george Killian/briegleb BG-12B, experimental, home built glider. An owner reported that the plt had come from new Mexico to buy the glider. After spending about 3 hrs in familiarization training, the plt went on his 1st flt which was…NTSB DEN85LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearfield, UTThe plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft…NTSB DEN85FTM01Accident · Minor injuriesFinal reportGamble Sonerai II · Salt Lake City, UTThe acft nosed over during a forced landing short of the rwy following a loss of pwr. The plt stated that after takeoff he noticed a rise in the cylinder head temperature. He attempted a landing and overshot the rwy. During the plt's second landing attempt,…NTSB DEN85LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28L · Salt Lake City, UTThe acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…NTSB DEN85LA089Accident · No injuriesLimited investigationFinal reportBeech E33-C · Richfield, UTThe plt stated that he was returning to the arpt and was on the base leg of the traffic pattern when he experienced a partial loss of eng pwr. The plt stated that when he turned on the boost pump, pwr was restored for a short time. He continued to state that…NTSB DEN85LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Taylor, UTAcft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely.NTSB DEN84LA299Accident · No injuriesLimited investigationFinal reportCessna T207A · Mexican Hat, UTPlt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed…NTSB DEN84FU003Accident · Serious injuriesFinal reportAmerican Falcon · Salt Lake City, UTReportedly, the plt made an apch to rwy 18, then initiated a go-around due to traffic on the rwy. He reported that traffic to the left necessitated a right pattern. There were power lines located aprx 500 ft west of the grass strip, about 40 to 50 ft AGL.…NTSB DEN84FA065Accident · 1 fatalField investigationFinal reportCessna 320C · Provo, UTThe acft had been cleared for an ILS rwy 13 apch. A witness, located just north of the rwy, saw an acft pass overhead & stated that the acft was not an a correct apch. The acft then began heading west as if to circle for a 2nd apch. The witness also estimated…NTSB DEN83LA200Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Tucker, UTThe helicopter was being used on a seismic data acquistion operation. While landing by a road in mountainous terrain at an elevation of aprx 8400 ft, the helicopter was observed to approach to a hover over the roadway. A considerable amount of dust was blown…NTSB DEN83LA160Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Salt Lake City, UTThe acft landed short of the rwy after a power loss at about 100 ft AGL on final approach. The weather was VMC with the temperature at 80 degrees f and the dewpoint 42 degrees f. the pilot had started a let down at 11,500 ft to descend 5700FT for landing.…NTSB DEN83LU001Accident · 1 fatalFinal reportIntl Ultralight Banshee · St. George, UTReportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt…NTSB DEN82DA147Accident · No injuriesFinal reportBell UH1B · Bryce Canyon, UTThe pilot was making an approach to a 10,000 ft mountain, let the RPM decay and made a hard landing. The density altitude was 12,500 feet. There was about 500 or 600 pounds of cargo on the long line.NTSB DEN82FTM11Accident · Serious injuriesFinal reportBell 47G-3B-1 · Vermal, UTThe pilot stated that he experienced a partial loss of engine power during landing at an elevation of about 5280 ft MSL. The temperature was about 50 degrees fahrenheit. He applied full throttle, but the RPM decayed and the plane crash landed. A partial…NTSB DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…NTSB DEN82FA011Accident · 4 fatalClosedBeech 95 · Cedar City, UTNTSB DEN81FA054Accident · 1 fatalClosedPiper PA-34 · Price, UTNTSB DEN81FTM27Accident · Serious injuriesClosedPiper PA-28 · Tooele, UTNTSB DEN81DTM23Accident · No injuriesClosedCessna 182P · Monument Vly, UTNTSB DEN81FTM13Accident · Minor injuriesClosedPiper PA-28 · Alton, UTNTSB DEN81FTM14Accident · No injuriesClosedQuickie · Provo, UTNTSB DEN81FTM05Accident · Minor injuriesClosedBell 206B · Vernal, UTNTSB DEN80FTM37Accident · Serious injuriesClosedGrum-Amer AA-5B · Heber City, UTNTSB DEN80FTM29Accident · No injuriesClosedPiper PA-38 · Provo, UTNTSB DEN80DTM12Accident · No injuriesClosedCessna 182 · Cedar City, UTNTSB DEN80FA012Accident · 2 fatalClosedMitsubishi MU-2B · Provo, UTNTSB DEN80FTM06Accident · Minor injuriesClosedPiper PA-38 · Ogden, UTNTSB DEN79FA024Accident · 2 fatalClosedCessna T206 · Brigham City, UTNTSB DEN79FA022Accident · 1 fatalClosedPiper PA-28 · Logan, UTNTSB DEN79FTM03Accident · Serious injuriesClosedCessna R182 · Bullfrog, UT