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 SEA97LA089Accident · 1 fatalLimited investigationFinal reportIvan Langston Hawk · Howell, UTThe pilot's failure to maintain control of the aircraft. Heavy rain and gusting winds were a factor.Apr 19, 1997 · N627K · Substantial damageNTSB SEA97GA008Accident · 2 fatalFinal reportPiper PA-18-150 · Holden, UTThe first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…Oct 10, 1996 · N91017 · DestroyedNTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.Jul 11, 1996 · N3086G · Substantial damageNTSB SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.May 30, 1996 · N9980J · Substantial damageNTSB SEA96LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Grantsville, UTthe failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.Jan 12, 1996 · N91130 · Substantial damageNTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.Nov 21, 1995 · N6392Q · DestroyedNTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.Aug 20, 1995 · N1930Q · DestroyedNTSB SEA95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wellsville, UTThe pilot's failure to maintain airspeed. Factors in the accident were the pilot's lack of experience with flying in mountainous terrain and the high density altitude.Jul 26, 1995 · N588BR · Substantial damageNTSB SEA95LA085Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Richfield, UTIce ingestion. Factors to the accident were: aircraft protective coverings were unavailable, inadequate preflight inspection, and uneven terrain.Apr 23, 1995 · N206AH · Substantial damageNTSB SEA95FA048Accident · 2 fatalField investigationFinal reportPiper PA-601P · Tremonton, UTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain. Factors were the clouds, and the dark night.Feb 10, 1995 · N57NW · DestroyedNTSB SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…Dec 29, 1994 · N24741 · Substantial damageNTSB SEA95LA006Accident · 2 fatalLimited investigationFinal reportGlines Acro Duster II SA750 · West Jordon, UTThe pilot-in-command's attempt to perform a low altitude flight maneuver, and his failure to maintain adequate airspeed during the maneuver. This led to an unrecoverable aerodynamic stall.Oct 8, 1994 · N31WD · DestroyedNTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedJul 24, 1994 · N820CW · DestroyedNTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.Jun 8, 1994 · N25074 · DestroyedNTSB SEA94LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Hanksville, UTThe pilot's delay in releasing his tow line when the line became entangled with wires.Feb 28, 1994 · N4082J · Substantial damageNTSB SEA94LA044Accident · No injuriesLimited investigationFinal reportSommerauer Glasair I RG · Ogden, UTA loose fuel line fitting, and fuel starvation. Factors include an intentional wheels up forced landing, and soft rough/uneven terrain.Dec 31, 1993 · HBYDJ · Substantial damageNTSB SEA94FA004Accident · 1 fatalField investigationFinal reportCessna 182P · Heber City, UTThe pilot's improper inflight decisions and failure to maintain proper altitude. Factors include the box canyon.Oct 3, 1993 · N50TH · DestroyedNTSB SEA93LA196Accident · 1 fatalLimited investigationFinal reportAerospatiale SA-365-N2 · Ogden, UTThe pilot's failure to maintain proper altitude. A factor to the accident was glassy water.Sep 10, 1993 · N818R · DestroyedNTSB SEA93LA193Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Price, UTThe failure of the pilot to maintain airspeed above stall.Sep 6, 1993 · N8067E · Substantial damageNTSB SEA93LA161Accident · No injuriesLimited investigationFinal reportBell B206BII · Lake Powell, UTA power loss for undetermined reasons. Factors include landing in water.Jul 26, 1993 · N502AH · Substantial damageNTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.Jan 16, 1993 · N8004K · DestroyedNTSB SEA93FA033Accident · 1 fatalField investigationFinal reportBeech 35-33 · Riverton, UTTerrain clearance was not maintained. Factors to the accident were: snow and flight into known adverse weather.Dec 9, 1992 · N755AA · DestroyedNTSB SEA93FA025Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTClearance from mountainous terrain was not maintained. Factors to the accident were: dark night condition, snow showers, and intentional flight into known adverse weather.Nov 23, 1992 · N5108S · DestroyedNTSB SEA92LA181Accident · 1 fatalLimited investigationFinal reportR.P. Williams Acro Sport II · Herriman, UTInadequate remedial action and poor inflight planning/decision. A factor to the accident was: an uncontrolled stall/spin.Aug 17, 1992 · N122RW · DestroyedNTSB SEA92LA170Accident · No injuriesLimited investigationFinal reportCessna 411 · Lehi, UTThe failure by the pilot to maintain airspeed above VMC, resulting in loss of control in flight, and his failure to lower the flaps and landing gear for the forced landing. A factor relating to the accident was the pilot's decision to perform fuel system…Jul 30, 1992 · N136CH · Substantial damageNTSB SEA92LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Provo, UTFuel exhaustion due to inadequate fuel supply. Factors include a ditch encountered while landing.Jul 21, 1992 · N67819 · Substantial damageNTSB SEA92LA076Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Magna, UTThe overheat of the engine combustion section, and the failure of the turbine blades.Apr 13, 1992 · N315DY · Substantial damageNTSB SEA91LA194Accident · No injuriesLimited investigationFinal reportLet L-13 · Wallsburg, UTThe in flight encounter with downdraft winds and the lack of suitable terrain in the area for a landing.Jul 27, 1991 · N2NV · Substantial damageNTSB SEA91FA131Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nephi, UTPoor inflight planning and decisions. Factors to the accident were: an uncontrolled stall/spin, and inadequate airspeed.Jun 15, 1991 · N4090Z · DestroyedNTSB SEA91LA115Accident · Serious injuriesLimited investigationFinal reportDave Ronneberg LONG-EZE · Kanab, UTLoss of aircraft control in flight which resulted from the pilot's diverted attention and his failure to maintain proper airspeed.May 26, 1991 · N515DR · Substantial damageNTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.Feb 4, 1991 · N63644 · Substantial damageNTSB SEA91FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Salt Lake City, UTThe pilot's intentional buzzing of uninhabited island in the great Salt lake and his misjudging the timing of a pull-up maneuver to clear rising terrain of a ridgeline.Nov 30, 1990 · N4678J · DestroyedNTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.Sep 17, 1990 · N67853 · DestroyedNTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.Sep 16, 1990 · N4183U · Substantial damageNTSB DEN90FA115Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · La Sal, UTA failure of the engine speed governor unit due to improper storage and/or inspection of the speed governor unit prior to placing it in service. A factor in the accident was the pilot carrying passengers on the external load.May 23, 1990 · N402AH · Substantial damageNTSB DEN90FA022Accident · Serious injuriesField investigationFinal reportCessna 182F · Oakley, UTThe pilot diverted his attention, misjudged his altitude and failed to maintain clearance above the trees, while maneuvering at low altitude over mountainous terrain. The mountainous terrain, high density altitude, low airspeed, and trees were contributing…Nov 10, 1989 · N3625U · DestroyedNTSB DEN90FA021Accident · 2 fatalField investigationFinal reportCessna 310I · Provo, UTThe Cessna pilot misjudge his altitude above the water. Contributing factors were: the pilot allowing his attention to be diverted and his lack of visual/depth perception over the calm (glassy) water.Nov 9, 1989 · N145Y · DestroyedNTSB DEN89FA208Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Grantsville, UTImproper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.Sep 7, 1989 · N7835P · DestroyedNTSB DEN89FA200Accident · Serious injuriesField investigationFinal reportCessna 172 · Tremonton, UTThe pilot failed to maintain obstruction clearance while making a low pass over a newly constructed highway. The powerline was considered a contributing factor.Aug 27, 1989 · N4129F · DestroyedNTSB DEN89FA001Accident · 2 fatalField investigationFinal reportCessna 152 · Eden, UTBefore takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft…Oct 1, 1988 · N48926 · DestroyedNTSB DEN88LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lund, UTThe private plt was spraying crops during an aerial application flight. During a right turn at the end of a spray run, he said he diverted his attention into the cockpit to check the metering rate, and may have inadvertently pushed the control stick forward.…Sep 15, 1988 · N9764 · Substantial damageNTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…Jul 13, 1988 · N3541Z · DestroyedNTSB DEN88DTM02Accident · No injuriesFinal reportEagle DW-1 · Enterprise, UTThe plt reported that he had been going under a powerline that ran across the fld being treated. On the acdt pass he lost sight of the powerline and pulled up into the line. The visibility was unrestricted and the pass was being made north to south at mid…Jun 11, 1988 · N8807E · DestroyedNTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…May 20, 1988 · N25934 · DestroyedNTSB DEN88DTM01Accident · Serious injuriesFinal reportCessna 188 · Riverton, UTThis ag operator was fertilizing a field. He was making repetative trips which took about 10 min each. The plt was aware that the fuel gauges were inaccurate, reading less fuel than was actually onboard. While making a swath run the eng lost pwr and the acft…Mar 2, 1988 · N8073V · DestroyedNTSB DEN87LA142Accident · No injuriesLimited investigationFinal reportBell 206B II · Logan, UTThe plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an…Jun 3, 1987 · N59624 · Substantial damageNTSB DEN87LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The…May 26, 1987 · N48590 · Substantial damageNTSB DEN87LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bountiful, UTThe stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…Apr 8, 1987 · N4970B · Substantial damageNTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…Jan 15, 1987 · N163SW · 2 aircraft · DestroyedNTSB DEN86LA245Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Salt Lake City, UTThe plt rprtd that while he was performing aerobatics at an airshow, the acft's eng momentarily lost power during inverted flt at the top of a loop. He was unable to complete the loop. Subsequently, the acft contacted the rwy in a level attitude while it was…Aug 31, 1986 · N260PS · Destroyed