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.

NTSB DEN03LA031Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bountiful, UTthe pilot's failure to maintain clearance from the power lines and his improper in flight planning and decision to maneuver on a go around without noting where the power lines were. Factors contributing to the accident were the pilot's inability to see the…Jan 9, 2003 · N16453 · Substantial damageNTSB DEN03LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350BA · Monticello, UTthe pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.Dec 2, 2002 · N20840 · Substantial damageNTSB DEN02LA046Accident · No injuriesLimited investigationFinal reportBell 206B-III · Moab, UTThe pilot's failure to maintain rotor rpm during a forced landing. A contributing factor was fuel starvation.May 24, 2002 · N191RH · Substantial damageNTSB DEN02LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Monument Valley, UTthe pilot's inadvertent stall/mush to the ground during landing flare. Contributing factors were the earth berm along the side of the runway, and the wind shear weather condition on short final.May 11, 2002 · N345M · Substantial damageNTSB SEA02LA050Accident · No injuriesLimited investigationFinal reportUnander Velocity 173RG · West Jordan, UTThe pilot's failure to ensure that the gear was extended prior to landing. Factors included a failure of a hydraulic down-pressure switch, and the pilot's attention diverted to another aircraft executing an opposite-direction traffic pattern.Mar 6, 2002 · N278GJ · Substantial damageNTSB DEN02LA010Accident · Minor injuriesLimited investigationFinal reportAgusta A119 · Ogden, UTimproper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.Nov 9, 2001 · N119RX · DestroyedNTSB DEN01FA162Accident · 1 fatalField investigationFinal reportCessna 337B · St. George, UTtotal loss of engine power on both engines due to fuel starvation and the pilot's inability to access the available fuel supply. Contributing factors were the pilot's inadequate supervision of the refueling operation, and his intentional operation of the…Sep 24, 2001 · N337PM · DestroyedNTSB DEN01LA143Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Morgan, UTthe pilot's inadvertent lowering of the flaps and her failure to extend the spoilers.Aug 11, 2001 · N310GM · Substantial damageNTSB DEN01LA128Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bountiful, UTthe loss of engine power for an undetermined reason. A contributing factor was inadequate clearance of an obstacle during the forced landing by the pilot.Jul 26, 2001 · N21042 · DestroyedNTSB DEN01LA109Accident · Serious injuriesLimited investigationFinal report2001 Mcgirl Questair Venture · Ogden, UTan in-flight fire, which originated from a fuel leak of unknown origin.Jun 1, 2001 · N5QV · DestroyedNTSB DEN01IA036Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Salt Lake City, UTthe captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.Dec 30, 2000 · N909DA · Minor damageNTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.Jul 16, 2000 · N6399L · Substantial damageNTSB DEN00LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Logan, UTin-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.Jul 7, 2000 · N38903 · Substantial damageNTSB DEN00LA101Accident · Minor injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Richfield, UTFuel starvation due to the unavailability of fuel to the engine for undetermined reasons and the pilot's misjudgment of distance/altitude on final approach. Contributing factors were the pilot's premature gear extension and the berm.Jun 4, 2000 · N2H · Substantial damageNTSB FTW00LA141Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monument Valley, UTThe pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.May 7, 2000 · N3622C · Substantial damageNTSB DEN00LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Hanksville, UTThe pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…Mar 25, 2000 · N2722Q · DestroyedNTSB DEN00LA064Accident · Minor injuriesLimited investigationFinal reportJohnson Zodiac CH 601 HDS · West Jordan, UTTotal failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.Mar 24, 2000 · N984J · DestroyedNTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.Aug 10, 1999 · N89186 · Substantial damageNTSB DEN99LA110Accident · No injuriesLimited investigationFinal reportCessna 182A · Salt Lake City, UTA total loss of engine power (nonmechanical) for reasons undetermined. Factors were the existence of conditions conducive to carburetor icing, and unsuitable terrain on which to make a forced landing.Jul 1, 1999 · N6165B · Substantial damageNTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).May 27, 1999 · N2716C · DestroyedNTSB DEN99LA082Accident · No injuriesLimited investigationFinal reportRich RV3-A · Bountiful, UTThe pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.May 21, 1999 · N4461V · Substantial damageNTSB DEN99FA071Accident · 3 fatalField investigationFinal reportMooney M20E · Cedar City, UTThe pilot's inadequate fuel consumption calculations. Factors were the loss of engine power due to fuel exhaustion and the obscuring weather conditions.May 3, 1999 · N5594Q · DestroyedNTSB DEN99LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Wendover, UTThe pilot's improper preflight/in-flight planning and decision making, resulting in fuel supply exhaustion. A factor was the closed runway condition.Apr 26, 1999 · N906DS · Substantial damageNTSB DEN99LA007Accident · No injuriesLimited investigationFinal reportCessna 210A · Provo, UTThe pilot's abrupt throttle control movement that caused the engine to flood, and his failure to follow emergency procedures contained in the Airplane Flight Manual. Factors were increasing the mixture control to full rich and switching the fuel pump to high…Oct 10, 1998 · N9449X · Substantial damageNTSB FTW98FA384Accident · 2 fatalField investigationFinal reportCessna 172 · West Jordan, UTThe pilot's failure to maintain proper airport traffic pattern altitude. Factors were night lighting conditions and the unseen static line.Sep 3, 1998 · N8232B · DestroyedNTSB FTW98LA241Accident · No injuriesLimited investigationFinal reportMader WAG-AERO 2+2 · Hurricane, UTAn encounter with high vegetation and unsuitable terrain during a forced landing. A factor was a partial failure of the engine's exhaust stack during flight.May 24, 1998 · N6272A · Substantial damageNTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.May 16, 1998 · N158R · DestroyedNTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.Aug 10, 1997 · N9666M · Substantial damageNTSB SEA97LA165Accident · No injuriesLimited investigationFinal reportYoung Turbo Cruiser · Milford, UTLoss of engine power due to fuel starvation. Factors include the pilot's fuel consumption calculations based upon insufficient or erroneous information provided by the amateur-built airplane's builder and previous owner, and terrain conditions not suitable…Jul 9, 1997 · N6626W · Substantial damageNTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.Jun 20, 1997 · N345JE · Substantial damageNTSB SEA97FA097Accident · 4 fatalField investigationFinal reportCessna T210M · Bullfrog, UTThe pilot-in-command's failure to maintain adequate flying airspeed, for reason(s) unknown, resulting in a subsequent stall.May 3, 1997 · N732QB · DestroyedNTSB SEA97FA067Accident · 1 fatalField investigationFinal reportBeech 200 · Salt Lake City, UTThe pilot's failure to maintain adequate airspeed on the ILS approach, resulting in a stall. Factors included: low visibility; the pilot's selection of the improper DME for the approach; his resulting failure to attain the proper descent profile for the…Mar 3, 1997 · N117WM · Substantial damageNTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.Feb 15, 1997 · N5514G · Substantial damageNTSB SEA97LA058Accident · No injuriesLimited investigationFinal reportCessna 421C · Cedar City, UTwater contamination in the hydraulic system, which froze in the (right) main gear hydraulic actuator, and restricted movement of the (right) main gear retraction and extension system.Feb 6, 1997 · N45MV · Substantial damageNTSB SEA96LA154Accident · Minor injuriesLimited investigationFinal reportColonial C-1 · Halls Crossing, UTthe pilot's inadequate preflight of the airplane, and subsequent fuel exhaustion due to an inadequate supply of fuel, which resulted in loss of engine power and an emergency landing. Uneven terrain in the emergency landing area was a related factor.Jul 13, 1996 · N248B · Substantial damageNTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.Jul 10, 1996 · N4897P · Substantial damageNTSB SEA96LA065Accident · No injuriesLimited investigationFinal reportNicholson Thorp T18CWS · Grantsville, UTthe pilot's failure to maintain clearance from a powerline. A transmission wire and an oil pressure reading of zero were factors.Feb 28, 1996 · N24WN · Substantial damageNTSB SEA96LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Heber City, UTthe pilot's attempted VFR flight into IMC, and his failure to maintain adequate altitude and clearance from terrain during the landing flare. Factors contributing to the accident were the snowbank, fog, and the pilot's complacent attitude.Feb 6, 1996 · N9242C · Substantial damageNTSB SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…Jun 17, 1995 · N6970E · DestroyedNTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.Oct 10, 1994 · N7327K · Substantial damageNTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.May 17, 1994 · N224FH · DestroyedNTSB SEA94GA024Accident · Minor injuriesFinal reportCessna 182R · Salt Lake City, UTThe pilot in command's maintaining inadequate altitude while crossing over the ground track of the landing Boeing 757. A factor contributing to the accident was wake turbulence.Nov 10, 1993 · N9652X · DestroyedNTSB SEA93LA147Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Heber City, UTThe pilot's improper in-flight planning/decision and failure to maintain runway alignment during the go-around. The weather conditions were related factors.Jul 2, 1993 · N1379R · Substantial damageNTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.Jan 3, 1993 · N1078V · DestroyedNTSB SEA92LA217Accident · No injuriesLimited investigationFinal reportCessna 140 · Moab, UTThe loss of engine power due to fuel exhaustion resulting from inaccurate fuel consumption calculations by the pilot. A factor relating to the accident was the terrain condition (ditch) in the landing area.Sep 25, 1992 · N2553N · Substantial damageNTSB SEA92LA120Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Panguitch, UTShorting of the grounding wire (p lead) to the magnetos followed by overloading of the nose wheel strut. A factor contributing to the accident was: rough/uneven terrain.Jun 7, 1992 · N9035V · Substantial damageNTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.Oct 20, 1991 · N1087H · Substantial damageNTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.Oct 14, 1991 · N8379V · Substantial damageNTSB SEA91LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Pleasant Grove, UTThe pilot's failure to maintian proper airspeed while on final approach.Jun 16, 1991 · N3705U · Substantial damageNTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.Sep 9, 1990 · N5146D · Substantial damage