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 SEA93LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Logan-Cache, UTThe pilot's failure to maintain directional control, and insufficient remedial action. Factors include a snow bank near the edge of the runway.Mar 13, 1993 · N13008 · Substantial damageNTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.Mar 6, 1993 · N150KC · Substantial damageNTSB SEA93LA028Accident · No injuriesLimited investigationFinal reportCessna A152 · Tremonton, UTDelayed remedial action. Factors include a tailwind.Nov 21, 1992 · N46762 · Substantial damageNTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.Oct 1, 1992 · N2763H · Substantial damageNTSB SEA92FA147Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Woods Cross, UTPilot factor in that he failed to attain and maintain sufficient flying speed. Factors to the accident were: cylinder over temperature, improper use of the mixture and procedures/directives were not followed.Jul 9, 1992 · N9323P · DestroyedNTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.Feb 20, 1992 · N9030X · Substantial damageNTSB SEA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTDirectional control was not maintained. A factor to the accident was: the pilot's lack of total flight experience.Jan 2, 1992 · N65505 · Substantial damageNTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.May 20, 1990 · N4807U · Substantial damageNTSB DEN90LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bountiful, UTThe flight instructor's inadequate supervision of the dual student. Factors in the accident were the premature lift-off by dual student, the rough terrain and the fence.Apr 23, 1990 · N8126W · Substantial damageNTSB DEN90LA065Accident · No injuriesLimited investigationFinal reportCessna P206A · Logan, UTThe pilot flew the aircraft with an improper modification to the fuel system, which resulted in a fuel leak and subsequent fire.Feb 24, 1990 · N4679F · DestroyedNTSB DEN89LA204Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTFailure of the pilot to maintain directional control which resulted in a ground swerve. Soft terrain beside the runway was a related factor.Sep 1, 1989 · N6372K · Substantial damageNTSB DEN89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dutch John, UTInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during the takeoff ground run. Factors related to the accident were: the unfavorable (variable/gusty) wind condition, and the high vegetation and tree beside the…Aug 30, 1989 · N7111W · Substantial damageNTSB DEN89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Salt Lake City, UTThe pilot's improper use of the parking brake and his delay in aborting the takeoff. Factors related to the accident were: the fence & vehicle.Jul 14, 1989 · N6144H · Substantial damageNTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.Apr 5, 1989 · N16733 · Substantial damageNTSB DEN89LA086Accident · No injuriesLimited investigationFinal reportCessna 182 · Tooele, UTInadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors.Mar 9, 1989 · N3613U · Substantial damageNTSB DEN89FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Saint George, UTMalfunction of the nosewheel steering system due to improper installation of the nosewheel steering poppet valve & inadequate maintenance instructions.Feb 11, 1989 · N1010Z · Substantial damageNTSB DEN88LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Hurricane, UTThe student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…Feb 18, 1988 · N67515 · Substantial damageNTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…Jan 22, 1988 · N4897G · Substantial damageNTSB DEN87LA173Accident · No injuriesLimited investigationFinal reportBeech B-60 · Kanab, UTThe commercial corporate plt had deplaned his passengers and was beginning the second leg of a corp/exec flight. During ground run the plt detected a manifold pressure loss on the left engine. The plt aborted the takeoff and applied heavy braking. The…Jul 6, 1987 · N18444 · Substantial damageNTSB DEN87LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · St. George, UTDuring a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy.Nov 26, 1986 · N19224 · Substantial damageNTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…Jul 27, 1986 · N3056A · Substantial damageNTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…Mar 31, 1985 · N50511 · Substantial damageNTSB DEN85FA096Accident · 3 fatalField investigationFinal reportPiper PA-28 · Logan, UTThe plt (non-inst rated) & 2PAX dept Logan airport under extreme IMC conditions. Visability in ice fog was down to just a few feet. The a/c crashed during a rt turn after t/o.there were no survivors.Mar 14, 1985 · N8460Z · DestroyedNTSB DEN85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lapoint, UTThe acft collided with a snowbank while taking off from a road near Lapoint, Utah. The acft was being used to count elk on an indian reservation. The plt landed to relieve himself. On the subsequent takeoff the acft hit a chuckhole in the road which caused it…Feb 25, 1985 · N17RK · Substantial damageNTSB DEN85LA021Accident · No injuriesLimited investigationFinal reportCessna 320B · Glen Canyon, UTOn takeoff roll, plt noted 5 inch difference in manifold pressure between the engs. Acft began to drift to the right. Plt applied corrective difference power, rudder and aileron to correct drift, but stated a gust of wind caused further right drift. Right…Oct 27, 1984 · N9842L · Substantial damageNTSB DEN84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Bryce, UTThe plt said that the wind was calm. The arpt mgr said that the wind was 5-10 KTS from about 180 degrees. The acft according to him went off the left side of the rwy into dirt at full pwr. The acft went back to the rwy heading still atfull power. The plt…Jul 7, 1984 · N25673 · Substantial damageNTSB DEN84LA110Accident · No injuriesLimited investigationFinal reportHiller FH 1100 · Provo, UTThe acft was landed in soggy terrain and the right skid sank into the surface. One of the occupants of the helicopter deplaned to'lighten the load'and the plt overcorrected in an attempt to takeoff. The acrt rolled over onto its left side.Mar 16, 1984 · N5042F · Substantial damageNTSB DEN83LA182Accident · No injuriesLimited investigationFinal reportHelio Courier H-295 · Salt Lake City, UTBefore starting his takeoff, the plt waited for other acft in the pattern to make touch-and-go landings. Immediately before & during his attempted takeoff, the plt saw 2 national guard helicopters hovering over a sod area, west of rwy 34. Reportedly, the 1st…Aug 4, 1983 · N6484V · Substantial damageNTSB DEN83LA145Accident · No injuriesLimited investigationFinal reportCessna 195A · St. George, UTThe prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…Jun 18, 1983 · N1537H · Substantial damageNTSB DEN82FTM15Accident · No injuriesFinal reportOar Acapella · Woods Cross, UTThe pilot reported that as he was lifting the nose wheel during takeoff when the left tire encountered 1 to 2 inches of water and broken pavement. He stated that the plane veered left and he applied full right rudder to recover, then the aircraft went off the…Jul 28, 1982 · N360CB · Substantial damageNTSB DEN82DA145Accident · No injuriesFinal reportCessna 152 · Woods Cross, UTThe student pilot stated that during the takeoff roll, he discovered the airspeed indicator was not operating. Also, he said that he accumulated excessive ground speed and made a decision to abort the takeoff. The aircraft was damaged when the pilot was…Jul 26, 1982 · N758YP · Substantial damageNTSB DEN82DTM06Accident · No injuriesClosedBell 206B · Fruitland, UTDec 3, 1981 · N4717R · Substantial damageNTSB DEN82FTM05Accident · Minor injuriesClosedAerospatle 315B · Cedar City, UTNov 21, 1981 · N47273 · Substantial damageNTSB DEN82FTM04Accident · Minor injuriesClosedHiller UH12C · Logan, UTNov 16, 1981 · N6417V · Substantial damageNTSB DEN82FTM01Accident · No injuriesClosedCessna 140 · Ogden, UTNov 1, 1981 · N2347N · Substantial damageNTSB DEN81FTM37Accident · Minor injuriesClosedRotorway 133 · Price, UTAug 19, 1981 · N2262W · Substantial damageNTSB DEN81FA058Accident · Minor injuriesClosedBell 206B · Escalante, UTAug 18, 1981 · N206LC · Substantial damageNTSB DEN81FTM29Accident · No injuriesClosedAeronca 7AC · Provo, UTJun 4, 1981 · N82742 · Substantial damageNTSB DEN81DTM21Accident · No injuriesClosedCessna 180 · Price, UTMay 5, 1981 · N42099 · Substantial damageNTSB DEN81FTM02Accident · Minor injuriesClosedEnstrom 280C · Salt Lake City, UTNov 16, 1980 · N51780 · Substantial damageNTSB DEN80FA060Accident · 1 fatalClosedBell UH-1B · Provo, UTSep 2, 1980 · N99478 · Substantial damageNTSB DEN80DTM36Accident · Serious injuriesClosedHiller Acft UH-12D · Coalville, UTAug 8, 1980 · N31332 · Substantial damageNTSB DEN80FTM21Accident · No injuriesClosedPiper PA-28 · Nephi, UTMay 26, 1980 · N2138J · Substantial damageNTSB DEN80FTM16Accident · No injuriesClosedBell 47G3B1 · Vernal, UTApr 30, 1980 · N687PH · Substantial damageNTSB DEN80DTM08Accident · No injuriesClosedHughes 269C · Cornich, UTDec 20, 1979 · N9581F · Substantial damageNTSB DEN80DTM01Accident · No injuriesClosedBell 47G3B1 · Torrey, UTOct 1, 1979 · N8537F · Substantial damageNTSB DEN79FA064Accident · Minor injuriesClosedBell 214B1 · Salina, UTSep 20, 1979 · CGBHH · Substantial damageNTSB DEN79DTM10Accident · No injuriesClosedCessna U206 · Monument Vly, UTFeb 23, 1979 · N5080U · Substantial damageNTSB DEN79DTM07Accident · No injuriesClosedPiper PA28R · Ruby'S Inn, UTDec 29, 1978 · N222TC · Substantial damageNTSB DEN78DTM29Accident · No injuriesClosedCessna 185 · Green River, UTJul 20, 1978 · N94201 · Substantial damage