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.

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…Dec 19, 1985 · N184FH · DestroyedNTSB 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…Dec 16, 1985 · N739KU · Substantial damageNTSB 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…Jun 9, 1985 · N7346Z · Substantial damageNTSB 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…Jan 3, 1985 · N1356A · DestroyedNTSB 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…Dec 2, 1984 · N8580S · DestroyedNTSB 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…Nov 15, 1984 · N1077T · DestroyedNTSB 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…Nov 13, 1984 · N5109T · DestroyedNTSB 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…Sep 29, 1984 · N8JN · Substantial damageNTSB 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…Sep 7, 1984 · N5211F · Substantial damageNTSB 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…Aug 29, 1984 · N4992M · Substantial damageNTSB 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…Jul 10, 1984 · N878LC · Substantial damageNTSB 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…Jun 25, 1984 · N98220 · DestroyedNTSB 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…Jun 10, 1984 · N29907 · Substantial damageNTSB 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…Mar 6, 1984 · N8260H · Substantial damageNTSB 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,…Feb 26, 1984 · N54KS · DestroyedNTSB 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…Jan 22, 1984 · N500CN · Substantial damageNTSB 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…Sep 30, 1983 · N8693F · Substantial damageNTSB 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…Sep 12, 1983 · N8667F · Substantial damageNTSB 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.…Jul 10, 1983 · N4886R · Substantial damageNTSB 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…May 29, 1983 · N6651Z · Substantial damageNTSB 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 &…May 24, 1983 · N90706 · Substantial damageNTSB 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…Mar 21, 1983 · N4520V · Substantial damageNTSB 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.Nov 24, 1982 · N6011N · DestroyedNTSB 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…Oct 16, 1982 · N63498 · DestroyedNTSB 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…Oct 12, 1982 · N5316V · DestroyedNTSB 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…Sep 14, 1982 · N758JM · DestroyedNTSB 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.Jun 26, 1982 · N221RM · Substantial damageNTSB DEN82FTM13Accident · Serious injuriesFinal reportAerospatiale 315B · Coalville, UTDuring a seismic exploration flight the eng quit. No eng malfunction was found.Jun 3, 1982 · N8237 · Substantial damageNTSB 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…May 31, 1982 · N5380D · Substantial damageNTSB 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…Apr 27, 1982 · N8684F · Substantial damageNTSB 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.…Jan 17, 1982 · N91TW · DestroyedNTSB 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…Jan 17, 1982 · N2600Y · Substantial damageNTSB DEN81DTM40Accident · No injuriesClosedGrumman AG-CAT · Park Valley, UTJul 14, 1981 · N5397 · Substantial damageNTSB DEN81FTM32Accident · Minor injuriesClosedCessna A188B · Layton, UTJun 25, 1981 · N731HD · Substantial damageNTSB DEN81FA044Accident · 2 fatalClosedCessna 172 · Price, UTJun 23, 1981 · N6417B · Substantial damageNTSB DEN81FTM18Accident · Minor injuriesClosedCessna R182 · Eureka, UTApr 17, 1981 · N3291C · Substantial damageNTSB DEN81DTM09Accident · No injuriesClosedHughes 269C · Moab, UTFeb 6, 1981 · N300DS · Substantial damageNTSB DEN80FTM39Accident · No injuriesClosedWeatherly 201 · Delta, UTSep 5, 1980 · N9198W · No damageNTSB DEN80FTM35Accident · No injuriesClosedBeech A-36 · America Fork, UTAug 2, 1980 · N1097W · Substantial damageNTSB DEN80FTM26Accident · 1 fatalClosedSkybolt Steen · Brigham City, UTJun 21, 1980 · N6260 · Substantial damageNTSB DEN80DTM24Accident · No injuriesClosedCessna 188 · Vernal, UTJun 18, 1980 · N9055R · Substantial damageNTSB DEN79FTM21Accident · No injuriesClosedGrumman G-164A · Richfield, UTJul 21, 1979 · N6589 · Substantial damageNTSB DEN79DTM19Accident · No injuriesClosedRockwell A9B · Junction, UTJun 5, 1979 · N7923V · Substantial damageNTSB DEN79FTM12Accident · No injuriesClosedPiper PA-28 · Delta, UTMar 11, 1979 · N47749 · Substantial damageNTSB DEN79FA012Accident · 1 fatalClosedCessna 172A · Park Valley, UTDec 27, 1978 · N7678T · Substantial damageNTSB DEN78FA001Accident · 2 fatalClosedBellanca 8KCAB · Vernal, UTOct 2, 1977 · N53961 · DestroyedNTSB DEN77FTM29Accident · Serious injuriesClosedCallair A-6 · Cedar City, UTSep 12, 1977 · N2958G · DestroyedNTSB DEN77FTM19Accident · Minor injuriesClosedCessna 188B · Vernal, UTJun 13, 1977 · N9300R · Substantial damageNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNov 6, 1976 · N6180P · DestroyedNTSB DEN76FTM47Accident · No injuriesClosedGrumman G-164A · Leland, UTAug 23, 1976 · N6589 · Substantial damage