NTSB investigations, UT

228 cases where the phase of flight was Initial climb.

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 = 350)
  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 DEN05FA114Accident · 3 fatalField investigationFinal reportBeech N35 · West Jordan, UTthe pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…Jul 24, 2005 · N31TE · DestroyedNTSB DEN05LA039Accident · No injuriesLimited investigationFinal reportRaytheon C90A · Salt Lake City, UTthe pilot's failure to obtain/maintain a proper climb rate and the pilot's premature initiation of the turn (low altitude flight maneuver). Contributing factors include the pilot's improper in-flight planning and decision making, the low altitude, the fog,…Dec 19, 2004 · N55EP · Substantial damageNTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.Sep 22, 2004 · N5338H · Substantial damageNTSB DEN04LA052Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Monticello, UTthe pilot's failure to maintain aircraft control during takeoff. Contributing factors include the sudden windshift and the bushes.Mar 15, 2004 · N400DH · Substantial damageNTSB DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.Oct 7, 2003 · N3348R · DestroyedNTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.Jul 26, 2003 · N35KR · DestroyedNTSB DEN03LA134Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Logan, UTthe loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…Jul 18, 2003 · N8036D · Substantial damageNTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.Jun 19, 2003 · N2537R · Substantial damageNTSB DEN03FA099Accident · 1 fatalField investigationFinal reportAgusta A109K2 · Salt Lake City, UTFatigue of the tail rotor trunnion resulting in complete trunnion failure and subsequent tail rotor separation from the helicopter. Factors contributing to the accident were the low altitude, low airspeed, excessive tail rotor loading, and the worn tail-rotor…Jun 8, 2003 · N123RX · DestroyedNTSB DEN03LA041Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350BII · Vernal, UTThe pilot's inadequate planning resulting in his inattentiveness of the attached longline. Contributing factors were the entanglement of the longline in the tail rotor, failure of the tail rotor drive shaft, and subsequent inability of the pilot to control…Feb 7, 2003 · CFLHA · Substantial damageNTSB DEN03LA004Accident · No injuriesLimited investigationFinal reportBeech C24R · Newcastle, UTthe pilot's failure to maintain clearance from the tree during takeoff. A factor was the reduced light conditions.Oct 9, 2002 · N18917 · Substantial damageNTSB DEN02FA076Accident · 2 fatalField investigationFinal reportWheeler Doug 2000 · Ogden, UTthe pilot's failure to obtain and maintain adequate main rotor rpm, resulting in blade flapping and subsequent blade contact with the airframe, severing of the tailboom, and causing loss of aircraft control. Contributing factors were the high gusty winds, and…Jul 17, 2002 · N2058T · DestroyedNTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.Jun 8, 2002 · N146P · Substantial damageNTSB DEN02LA013Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bryce, UTloss of engine power for reasons undetermined. Contributing factors were the low airspeed and altitude at which to perform an autorotation.Dec 1, 2001 · N911KH · Substantial damageNTSB DEN01LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · St. George, UTthe pilot's failure to sump all the fuel drains during preflight and the subsequent loss of power in the right engine during takeoff, the pilot feathering the wrong engine's propeller during the forced landing, the pilot improperly raising the landing gear…Apr 27, 2001 · N27367 · Substantial damageNTSB DEN01LA085Accident · Minor injuriesLimited investigationFinal reportBoyd Young Kolb Mark III · Brigham City, UTthe pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.Apr 11, 2001 · N1225Y · Substantial damageNTSB DEN01LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Spanish Fork, UTImproper weather evaluation by both the pilot and pilot/passenger, and the pilot's inadvertent VFR flight into IMC resulting in his spatial disorientation. Factors were the pilot rated passenger's spatial disorientation, fog, and night conditions.Jan 7, 2001 · N108ES · DestroyedNTSB DEN01LA020Accident · Serious injuriesLimited investigationFinal reportThomas VP-1 · West Jordan, UTthe lack of suitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the pilot to adjust the manual propeller pitch to permit the engine to achieve sufficient rpm for sustained flight, and the…Dec 8, 2000 · N89KD · Substantial damageNTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.Jun 26, 2000 · N9246D · Substantial damageNTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.Jun 6, 2000 · N185RL · DestroyedNTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.May 27, 2000 · N35LP · Substantial damageNTSB DEN00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Tooele, UTThe pilot's failure to correct the descent, and his failure to maintain a visual lookout. Factors were the pilot's improper weather evaluation, his lack of recent experience in type of operation, his inadvertent encounter with instrument meteorological…Jan 19, 2000 · N6445B · Substantial damageNTSB DEN00LA043Accident · No injuriesLimited investigationFinal reportBeech K35 · Fillmore, UTThe pilot's improper use of elevator trim, resulting in his failure to obtain sufficient takeoff airspeed and subsequent inadvertent stall/mush. A Factor was his failure to follow the preflight checklist.Jan 13, 2000 · N9500R · Substantial damageNTSB DEN00IA023Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Salt Lake City, UTTotal failure of the main landing gear retract actuator due to stress corrosion caused by the use of a faulty sealant by company maintenance personnel that allowed moisture to enter the joint. A factor was the use of an improper fillet seal.Dec 6, 1999 · N111DN · Minor damageNTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.Jul 11, 1999 · N7729D · DestroyedNTSB FTW98LA342Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Bryce Canyon, UTA partial loss of engine power due to an oil leak in the turbocharger system. Factors were high vegetation and high density altitude.Aug 4, 1998 · N8619M · Substantial damageNTSB FTW98FA325Accident · 1 fatalField investigationFinal reportCommander 114TC · West Jordan, UTA brittle fracture of the clamp that joins the exhaust pipe to the turbocharger. The pipe separated and hot exhaust gases escaped into the engine compartment. The engine lost power due to the high heat vaporizing fuel in the fuel line. Factors were inadequate…Jul 18, 1998 · N61174 · DestroyedNTSB FTW98FA190Accident · 2 fatalField investigationFinal reportCessna 150H · Parowan, UTThe pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.Apr 23, 1998 · N50385 · DestroyedNTSB FTW98FA093Accident · 4 fatalField investigationFinal reportBell 222UT · Sandy, UTflight by the pilot into known adverse weather conditions, and his failure (or inability) to maintain sufficient clearance or altitude from mountainous terrain. Related factors were: darkness, heavy snow, high winds, the pilot's perception of pressure that…Jan 12, 1998 · N222UH · DestroyedNTSB FTW98LA045Accident · No injuriesLimited investigationFinal reportBeech J35 · Provo, UTthe pilot's failure to properly position the fuel tank selector to a tank with adequate fuel, which resulted in fuel starvation, and a subsequent forced landing due to lack of engine power. His failure (or inability) to extent the gear for landing was a…Nov 5, 1997 · N171Y · Substantial damageNTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.Nov 1, 1997 · N7934F · Substantial damageNTSB FTW97IA363Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200RS · Salt Lake City, UTThe captain's failure to maintain directional control during landing roll. Factors were the loss of hydraulic pressure in the 'A' hydraulic system, the thrust reverser failure on the number one engine, and flight crew coordination not being maintained.Sep 24, 1997 · N205AU · Minor damageNTSB SEA97TA023Accident · 1 fatalFinal reportBell 47G-3B-1 · Fillmore, UTinadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…Oct 29, 1996 · N3098G · Substantial damageNTSB SEA97LA013Accident · 2 fatalLimited investigationFinal reportKeith Vans RV-6A · Hurricane, UTthe pilot's impairment of judgment and performance due to drugs (diphenhydramine) which led to spatial disorientation and loss of aircraft control. Contributing to the accident were: dark night lighting conditions; inoperative airport runway lights; the…Oct 12, 1996 · N16DK · DestroyedNTSB SEA96LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Bountiful, UTinadequate fuel management by the student pilot, which resulted in fuel starvation, due to an improperly positioned fuel selector. Factors relating to the accident were: the pilot's inadequate remedial action, and a ditch in the emergency landing area.Jun 11, 1996 · N5172W · Substantial damageNTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.Sep 14, 1995 · N2478W · DestroyedNTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.Mar 14, 1994 · N8885R · DestroyedNTSB SEA94LA026Accident · 1 fatalLimited investigationFinal reportBird RAF-2000 · Redmond, UTThe pilot in command's exceeding the proper climb rate. A factor contibuting to the accident was the pilot's lack of experience in make/model.Nov 6, 1993 · N70334 · DestroyedNTSB SEA93LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Salt Lake City, UTA power loss for undetermined reasons. Factors include a fence, an animal, and a ditch in the landing roll path.Sep 27, 1993 · N200X · Substantial damageNTSB SEA93LA191Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bryce Canyon, UTLoss of engine power for an undetermined reason. Factors related to the forced landing were: high density altitude and rough terrain.Sep 5, 1993 · N7148Y · Substantial damageNTSB SEA93LA175Accident · No injuriesLimited investigationFinal reportEkins Protech PT2C Prostar · Nephi, UTThe pilot's inadequate preflight inspection which resulted in loss of engine power due to fuel contamination. Factors contributing to the accident was the wet landing surface and terrain condition - ditch.Aug 12, 1993 · N123EK · Substantial damageNTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.May 21, 1993 · N8589K · DestroyedNTSB SEA92LA168Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Brigham City, UTA partial power loss for undetermined reasons and the pilot in command's inability to execute corrective action during the noseover. A factor contributing to the accident was the berm.Jul 29, 1992 · N55625 · Substantial damageNTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.Nov 8, 1991 · N5736B · DestroyedNTSB SEA91LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bryce Canyon, UTThe pilot's entry into a stall/mush condition shortly after take off. Contributing to the accident was the high density altitude.Jul 7, 1991 · N5961U · Substantial damageNTSB SEA91LA132Accident · Minor injuriesLimited investigationFinal reportDuffy Smith Mini Plane · Ogden, UTA premature liftoff and subsequent stall.Jun 15, 1991 · N27JD · Substantial damageNTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.May 24, 1991 · N3671F · Substantial damageNTSB SEA91LA098Accident · Serious injuriesLimited investigationFinal reportRichard Cheney Teratorn Tierra II · Morgan, UTThe inadvertant stall and the pilot's steep banked turn. Factors relating to the accident were the pilot's lack of qualification to conduct the flight and the strong tailwind conditions.May 5, 1991 · N134TA · DestroyedNTSB SEA91LA064Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Loa, UTThe pilot-in-command's failure to maintain airspeed on takeoff climb in a turn resulting in an inadvertnent stall and subsequent in flight collision with terrain. Contributing to the accident was a crosswind with gusts.Mar 10, 1991 · N7108U · Substantial damageNTSB SEA91LA048Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Draper, UTAn undetermined loss of engine power.Feb 6, 1991 · N392X · Substantial damage