NTSB investigations, UT

192 cases where the phase of flight was Takeoff.

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 = 300)
  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 WPR11FA232Accident · Serious injuriesField investigationFinal reportCessna T207A · Monument Valley, UTThe pilot's decision to initiate a go-around after a bounced landing at an airport where go-arounds were not advised and his failure to maintain adequate airspeed during the go-around.May 23, 2011 · N803AN · Substantial damageNTSB WPR10CA304Accident · No injuriesData collectionFinal reportCessna A185F · Bryce Canyon, UTThe pilot's inadequate compensation for the crosswinds during takeoff.Jun 23, 2010 · N55TA · Substantial damageNTSB WPR10CA229Accident · No injuriesData collectionFinal reportAviat A-1B · Moab, UTThe pilot's inadequate crosswind compensation resulting in a loss of directional control and impact with bushes.May 6, 2010 · N200HY · Substantial damageNTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…Dec 23, 2009 · N520NE · Substantial damageNTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.Nov 1, 2009 · N2729N · Substantial damageNTSB WPR09LA313Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider OHG LS3-A · Cedar Valley, UTThe pilot inadvertently applied the tow release handle.Jun 25, 2009 · N800JM · Minor damageNTSB LAX08FA233Accident · 3 fatalField investigationFinal reportHughes 369D · Price, UTThe pilot's inadequate preflight performance planning for the takeoff and the loading that exceeded the lift performance capability of the helicopter.Jul 19, 2008 · N400BE · DestroyedNTSB LAX08CA079Accident · No injuriesData collectionFinal reportCessna 180H · Moab, UTThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. A contributing factor was the unexpected dust devil.Mar 18, 2008 · N180LH · Substantial damageNTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damageNTSB SEA08CA002Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Lake Powell, UTThe pilot's inadequate preflight inspection and failure to remove a tie-down strap before departure.Oct 2, 2007 · N644BS · Substantial damageNTSB LAX07CA249Accident · No injuriesData collectionFinal reportAviat Husky A-1B · Moab, UTThe pilot's failure to maintain directional control that resulted in a ground loop.Aug 15, 2007 · C-GTHY · Substantial damageNTSB SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.Nov 25, 2006 · N180BM · Substantial damageNTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.Sep 12, 2006 · N2153R · Substantial damageNTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.Sep 11, 2006 · N4202R · Substantial damageNTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.Oct 20, 2005 · N7377H · Substantial damageNTSB DEN05CA149Accident · No injuriesData collectionFinal reportCessna 206 · Brigham City, UTthe pilot's improper in-flight planning and decision making and failure to maintain aircraft control during the ground roll.. Contributing to the accident was the soft dirt.Sep 28, 2005 · N206FB · Substantial damageNTSB DEN05LA110Accident · Minor injuriesLimited investigationFinal reportCessna TU206F · Vernal, UTThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.Jul 15, 2005 · N1059V · Substantial damageNTSB DEN05LA036Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Provo, UTthe flight instructor's failure to maintain clearance from the water. Contributing to the accident was the flight instructor's inability to detect a descent because of the obscuration between the water and the horizon due to the gray skyDec 15, 2004 · N333UH · Substantial damageNTSB DEN03LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Cedar City, UTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control.May 21, 2003 · N5278H · Substantial damageNTSB DEN03LA075Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Salt Lake City, UTthe pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.Apr 18, 2003 · N157CA · Substantial damageNTSB DEN03LA066Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · West Jordan, UTthe dual student's failure to maintain aircraft control and the flight instructor's inadequate supervision of the student. A contributing factor was the unfavorable wind gust.Apr 16, 2003 · N43591 · Substantial damageNTSB DEN03IA054Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Cedar City, UTthe captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.Mar 17, 2003 · N214SW · Minor damageNTSB DEN02LA044Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Salem, UTa loss of tail rotor effectiveness during takeoff. A contributing factor was the wind gusts.May 18, 2002 · N3894Q · Substantial damageNTSB DEN02LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · St. George, UTThe student pilot's failure to maintain aircraft directional control during take off roll.Jan 20, 2002 · N7693M · Substantial damageNTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.Jul 10, 2000 · N50812 · DestroyedNTSB DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.Jun 11, 2000 · N4514C · DestroyedNTSB DEN00LA100Accident · No injuriesLimited investigationFinal reportCulver LFA · Moab, UTOverheating of the left brake, causing the wheel to lock. Factors were the pilot not being able to maintain directional control, a dirt berm, and a drainage ditch.Jun 2, 2000 · N34783 · Substantial damageNTSB DEN00FA085Accident · No injuriesField investigationFinal reportde Havilland DHC-6-300 · Monument Valley, UTThe pilot-in-command's failure to maintain directional control. A factor was wind shear.May 5, 2000 · N241SA · Substantial damageNTSB DEN00IA032Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · Salt Lake City, UTImproper assembly of the wheel during build up in the operator's maintenance facilities.Dec 24, 1999 · N305WA · Minor damageNTSB DEN99LA161Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Heber City, UTThe pilot's failure to maintain aircraft control during takeoff roll. Factors were the gusting crosswind conditions, and the airport sign.Sep 1, 1999 · N86096 · Substantial damageNTSB DEN99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Delta, UTThe pilot's delayed aborted takeoff. A factor was the high density altitude.Jul 12, 1999 · N7614Z · Substantial damageNTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…Mar 6, 1999 · N4312A · 2 aircraft · DestroyedNTSB FTW98LA155Accident · Minor injuriesLimited investigationFinal reportZito ZMI-A · Ogden, UTthe improper placement of lead ballast by the pilot, resulting in an improper balance of the airplane; and the pilot's excessive control input to correct a nose high attitude, resulting in ground impact.Mar 21, 1998 · N669Z · Substantial damageNTSB FTW98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Ogden, UTthe student pilot not understanding the crew briefing, his premature retraction of the landing gear, and the flight instructor's inadequate supervision of the flight. A factor relating to the accident was: the exchange of unclear information due to the…Mar 12, 1998 · N83DA · Substantial damageNTSB FTW98LA015Accident · No injuriesLimited investigationFinal reportSego Tool Hawk H2X · Tooele, UTThe pilot's failure to maintain aircraft control. Contributing was the inadequate design of the flight control systems, resulting in slow response to pilot input.Oct 15, 1997 · N4412X · Substantial damageNTSB SEA97LA179Accident · No injuriesLimited investigationFinal reportCessna 180B · Spanish Fork, UTThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.Jul 30, 1997 · N929AE · Substantial damageNTSB SEA97LA140Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3-1 · Monument Valley, UTthe pilot's inadequate preflight planing/preparation, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident included: high, gusty, variable winds, and terrain induced downdrafts.Jun 13, 1997 · N6290K · Substantial damageNTSB SEA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Tooele, UTthe pilot's excessive rotation of the aircraft during takeoff, and his failure to obtain/maintain adequate airspeed. Inadequate supervision by the instructor pilot (CFI/check pilot) was a related factor.May 5, 1997 · N977RA · Substantial damageNTSB SEA96LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar City, UTthe pilot's failure to attain proper airspeed during takeoff, which resulted in a premature lift-off and an encounter with the terrain during the aborted landing. Excessive extension of the wing flaps was a related factor.Oct 1, 1996 · N5459H · Substantial damageNTSB SEA96LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tooele, UTfailure of the flight instructor (CFI) to ensure that adequate airspeed was maintained during initial climb after lift-off, which resulted in an inadvertent stall/mush. High density altitude was a related factor.Jun 7, 1996 · N9594V · Substantial damageNTSB SEA96LA073Accident · No injuriesLimited investigationFinal reportCessna 500 · Salt Lake City, UTfatigue failure of the engine compressor impeller. Inadequate quality control by the manufacturer was a related factor.Apr 1, 1996 · N727TK · Substantial damageNTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.Oct 7, 1995 · N25478 · Substantial damageNTSB SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.Aug 18, 1994 · N2732K · Substantial damageNTSB SEA94LA087Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Dutch John, UTThe pilot's inadequate compensations for wind conditions. The gusty crosswind was a factor.Mar 19, 1994 · N2925Z · Substantial damageNTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.Mar 8, 1994 · N5790S · Substantial damageNTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.Feb 26, 1994 · N2752U · Substantial damageNTSB SEA94LA063Accident · No injuriesLimited investigationFinal reportCessna TU206 · Salt Lake City, UTThe pilot's improper aircraft handling during the aborted takeoff.Feb 16, 1994 · N756YH · Substantial damageNTSB SEA94LA046Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Manila, UTThe pilot's failure to maintain clearance. Factors include a tailwind, gusts, and a tree just off the departure end of the field used for takeoff.Jan 2, 1994 · N4244A · Substantial damageNTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.Oct 4, 1993 · N30365 · Substantial damageNTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.Oct 1, 1993 · N21170 · Substantial damage