NTSB investigations, UT
276 cases where the phase of flight was Maneuvering.
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 = 450)
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 = 450)
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 DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…NTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…NTSB DEN85LA155Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fillmore, UTThe plt reported the engine failed while he was spraying a corn field, necessitating a straight ahead forced landing. During the landing roll the wheels bogged down in the soft earth and the plane overturned. Subsequent examination of theengine by the plt…NTSB DEN85LA057Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Salt Lake City, UTThe helicopter collided uncontrolled with the terrain during external load operation. A 100 ft steel cable was attached to the cargo hook on the helicopter and a nylon sling was attached to the cable so a snowcat could be pulled out of a mud area. The plt…NTSB DEN85FA035Accident · 2 fatalField investigationFinal reportCessna 182H · Provo, UTThe left seat non-instrument pvt plt was being checked out in the flying club acft by a comm plt. The acft was being flown over Utah lake on a dark night, on final approach to runway 31 at the pvu arpt. While on final, the flying plt manuevered the acft for…NTSB DEN85FA027Accident · 4 fatalField investigationFinal reportBell 206B-11 · Bingham Canyon, UTPilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills…NTSB DEN85FA028Accident · 1 fatalField investigationFinal reportChampion 7ECA · Sevier, UTThe plt was en route from anchorage, Alaska to prescott, Arizona to be with his dying mother. Weather was described as windy, low ceilings, and approaching dusk when the a/c departed richfield, Utah. A/c was loaded with 284 lbs of cargo. A/c crashed on…NTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…NTSB DEN84FTM03Accident · No injuriesFinal reportRotorway Rotorway Executive · Lehi, UTThe student plt was practicing hover taxiing at the abandoned arpt. While taxiing the right skid hit a 3 inch high moundof dirt. The acft bounced up and rolled to the left. The plt attempted to correct using the cyclic but the acft began to roll further to…NTSB DEN84LA271Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Bluffdale, UTPlt was practicing hovering over a 40 x 60 foot helicopter pad. Plt stated, a gust of wind caught the helicopter moving it off the pad and into nearby power lines. The terrain around the pad slopes down. The power lines were located aprx 125 ft from the pad…NTSB DEN84LA216Accident · No injuriesLimited investigationFinal reportBell 206B · Salina, UTThe acft crashed during takeoff. The plt said he was hovering after takeoff at about 20 ft AGL when he noticed a long line draped over the rt skid. He said he thought he could dislodge it. While maneuvring to attempt this, the helicopter rolled to the rt and…NTSB DEN84FA194Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Cedar City, UTThe acft collided with rising terrain in a box canyon. The plt said he found himself trapped with the terrain coming up 'to meet the plane' and decided to try and land on a nearby road. The acft stalled into trees prior to reaching the road. The plt also said…NTSB DEN84LA175Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315B · Salina, UTThe acft was on a maintenance check flt after the main rotor shaft assembly thrust bearing had been replaced after the acft had yawing problems and popping sounds at high pitch settings while liftings loads. The plt tried to duplicate the conditions for the…NTSB DEN84LA105Accident · No injuriesLimited investigationFinal reportCallair A · Tremonton, UTThe acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the…NTSB DEN84FTM01Accident · 1 fatalFinal reportKeith A Smith KR-2 · Salt Lake City, UTThe acft collided with a mountain ridge in a flat'pancake'attitude,no evidence of foward motion was apparent and all thewreckage was confined to the immediate area. The wooden prop was intact with the exception of 2 inches missing from the end of one blade,…NTSB DEN84FA073Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Huntington, UTWhile in a stabilized, out-of-ground-effect hover, at about 300 feet AGL, the helicopter started an uncontrollable right turn. The plt stated that using full left peddle had no effect on stopping the spin. At the onset of the spin, the occupants of the acft…NTSB DEN83FA224Accident · No injuriesField investigationFinal reportHughes 369D (500) · Provo, UTThe helicopter was on a test flt to track & balance the main rotor system & to complete a 100 hr inspection. Prior to the flt, an occasional flicker of the fuel filter light was noted, but it was thought to be a wiring problem. After taking off, the fuel…NTSB DEN83FA215Accident · Minor injuriesField investigationFinal reportHughes 369D · Woodruff, UTThe helicopter was being used to lift seismic materials on a 100 ft long line. After lifting the load to a hover at about 10 to 20 ft, the plt heard a loud 'bang' which was followed by a loss of directional control. The helicopter began uncontrolled spinning…NTSB DEN83LA163Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Hooper, UTThe spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…NTSB DEN83FTM04Accident · Minor injuriesFinal reportPiper PA-25-235 · Delta, UTThe acft collided with two power lines on a clean up swath run. The acft rolled inverted and struck the ground. The field being sprayed was bordered on the north by highly visible wires. The wires that ran along the east side were not so visible. There was…NTSB DEN83LA118Accident · No injuriesLimited investigationFinal reportAerospatiale SA 315B · Fillmore, UTWhile engaged in seismil work, the plt was contacted by radio & was asked to assist in freeing 2 crew trucks that had gotten stuck in sand dunes. He decided to assist since the stuck trucks were delaying the entire operation. He planned to partially raise &…NTSB DEN83LA082Accident · No injuriesLimited investigationFinal reportAmerican AA-5B · Heber City, UTAfter taking off at Heber City, UT, the plt turned to a 090 deg heading & began a climb with full throttle, mixture full rich, 80 to 90 KIAS & aprx 500 fpm rate of climb. At aprx 6500 ft MSL, he altered the course to 110 to 115 deg to provide better terrain…NTSB DEN83FTM03Accident · 3 fatalFinal reportCessna T210M · Tremonton, UTThe acft was observed flying over the interstate highway approximately 100 ft AGL prior to colliding with two high voltage power transmission lines.NTSB DEN83FTM01Accident · 1 fatalFinal reportBowers Flybaby 1A · Ephriam, UTApproximately 4 ft of the inboard section of the left wing separated in flight during an aerobatic maneuver. Witnesses stated that the acft had been performing little loops & then it went straight up & rolled off to the left upside down. It then spiralled…NTSB DEN83LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Blanding, UTThe private single-engine pilot had a student helicopter certificate. He took off to hover and check that the helicopter was in good condition. He stated that before takeoff, the helicopter was fueled with a 5 gallon can that had been painted red. Before…NTSB DEN82FA193Accident · 1 fatalField investigationFinal reportCessna R172K · Vernal, UTThe aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college…NTSB DEN82DA118Accident · Minor injuriesFinal reportAerospatiale SA 315 B · 35 Se Moab, UTHelicopter lifting sling loads lost power in a hover. Pilot jettisoned load and made a forced landing in a ravine, engine had dirt buildup and erosion in the compressor inlet case which led to compressor stall.NTSB DEN82FTM13Accident · Serious injuriesFinal reportAerospatiale 315B · Coalville, UTDuring a seismic exploration flight the eng quit. No eng malfunction was found.NTSB DEN82FA099Accident · 4 fatalField investigationFinal reportCessna 172N · Orem, UTPrior to the accident, the student pilot was observed performing power-on stalls at low altitude with passengers on board. The stalls were being made toward rapidly rising terrain in a mountainous area. After the last recovery, the aircraft was observed…NTSB DEN82DA073Accident · Minor injuriesFinal reportHughes 369D (500D) · Coalville, UTThe helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard…NTSB DEN82FA020Accident · Minor injuriesField investigationFinal reportPiper PA-31T · Delta, UTApproximately 1/2 mi from the arpt after takeoff, the plt noticed the left front baggage door partly open & made a left turn back toward the airstrip. After the turn, the baggage door came completely open, the left wing dropped immediately & the acft stalled.…NTSB DEN82DA019Accident · No injuriesFinal reportCessna 180E · Cedar City, UTThe pilot stated that he intended to fly close to the field surface dragging the tailwheel of the aircraft to determine snow/field conditions. During the low pass he used three notches of flap and added full power with the propeller at full pitch. When the…NTSB DEN81DTM40Accident · No injuriesClosedGrumman AG-CAT · Park Valley, UTNTSB DEN81FTM32Accident · Minor injuriesClosedCessna A188B · Layton, UTNTSB DEN81FA044Accident · 2 fatalClosedCessna 172 · Price, UTNTSB DEN81FTM18Accident · Minor injuriesClosedCessna R182 · Eureka, UTNTSB DEN81DTM09Accident · No injuriesClosedHughes 269C · Moab, UTNTSB DEN80FTM39Accident · No injuriesClosedWeatherly 201 · Delta, UTNTSB DEN80FTM35Accident · No injuriesClosedBeech A-36 · America Fork, UTNTSB DEN80FTM26Accident · 1 fatalClosedSkybolt Steen · Brigham City, UTNTSB DEN80DTM24Accident · No injuriesClosedCessna 188 · Vernal, UTNTSB DEN79FTM21Accident · No injuriesClosedGrumman G-164A · Richfield, UTNTSB DEN79DTM19Accident · No injuriesClosedRockwell A9B · Junction, UTNTSB DEN79FTM12Accident · No injuriesClosedPiper PA-28 · Delta, UTNTSB DEN79FA012Accident · 1 fatalClosedCessna 172A · Park Valley, UTNTSB DEN78FA001Accident · 2 fatalClosedBellanca 8KCAB · Vernal, UTNTSB DEN77FTM29Accident · Serious injuriesClosedCallair A-6 · Cedar City, UTNTSB DEN77FTM19Accident · Minor injuriesClosedCessna 188B · Vernal, UTNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNTSB DEN76FTM47Accident · No injuriesClosedGrumman G-164A · Leland, UT