NTSB investigations, UT

544 cases where the phase of flight was Enroute.

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 = 400)
  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 SEA92LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Delta, UTThe failure of an intake valve and the poorly executed forced landing.Jul 11, 1992 · N9871G · Substantial damageNTSB DEN92IA067Incident · No injuriesIncident investigationFinal reportBell 222UT · Scipio, UTAn encounter with clear air turbulence.Jun 28, 1992 · N222UH · Minor damageNTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.Apr 22, 1992 · N7252X · Substantial damageNTSB SEA92LA066Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Soldier Summit, UTThe fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.Apr 1, 1992 · N582MK · Substantial damageNTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.Feb 23, 1992 · N1852Z · Substantial damageNTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…Feb 6, 1992 · N4370B · DestroyedNTSB SEA92LA023Accident · No injuriesLimited investigationFinal reportKitfox Ten Model 2 · West Jordan, UTThe loss of engine power when it overheated due to low coolant level, which resulted from the inadequate preflight inspection by the pilot. A factor relating to the accident was the obstruction in the landing area.Nov 23, 1991 · N66257 · Substantial damageNTSB SEA91FA235Accident · 1 fatalField investigationFinal reportPiper PA32RT-300T · Mayfield, UTPoor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.Sep 6, 1991 · N3006J · DestroyedNTSB SEA91LA162Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · West Jordan, UTThe pilot's delayed switching of the fuel tank selector, the engine failure from fuel starvation and the unsuitable terrain for a forced landing.Jul 7, 1991 · N36831 · Substantial damageNTSB SEA91LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Milford, UTFuel exhaustion, and the pilot's misjudgment of proper descent rate. Factors include inadequate preflight planning, poor in-flight decision, becoming lost/disoriented, and a fence.Jul 4, 1991 · N816CB · Substantial damageNTSB SEA91LA050Accident · 4 fatalLimited investigationFinal reportBeech F33A · Ogden, UTThe pilot elected to fly into known adverse weather and encountered icing conditions. Contributing to the accident was the pilot's inadequate evaluation of the weather and a loss of engine power for undetermined reasons.Feb 13, 1991 · N66841 · DestroyedNTSB SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.Jan 13, 1991 · N235M · DestroyedNTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.Dec 20, 1990 · N2911B · DestroyedNTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.Dec 19, 1990 · N2466X · DestroyedNTSB SEA91LA028Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Vernal, UTA malfunction/failure of the helicopter's main rotor lead-lag damper.Dec 3, 1990 · N316BS · DestroyedNTSB DEN90FA159Accident · 1 fatalField investigationFinal reportCessna P210R · Ogden, UTFailure of the #1 piston due to pre-ignition/detonation in the #1 cylinder, and inadequate visual lookout by the pilot (his failure to see-and-avoid the obstruction). The obstruction (power line) was a related factor.Jul 12, 1990 · N6203A · DestroyedNTSB DEN90LA143Accident · No injuriesLimited investigationFinal reportCessna 150 · Bountiful, UTPower loss due to fuel exhaustion. A factor was the pilot's failure to refuel.Jun 24, 1990 · N7885F · Substantial damageNTSB DEN90LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Hurricane, UTThe engine oil leak induced connecting rod failure and subsequent total power loss.Mar 13, 1990 · N1530V · Substantial damageNTSB DEN90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Provo, UTImproper installation by maintenance personnel and fatigue failure and leakage of the left intermediate exhaust pipe, which resulted in an in-flight fire in the engine compartment. Contributing factors were: inadequate service bulletin provided by the…Feb 3, 1990 · N21492 · Substantial damageNTSB DEN90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Ogden, UTAn engine stoppage for undetermined reasons.Oct 11, 1989 · N7409E · Substantial damageNTSB DEN89LA198Accident · No injuriesLimited investigationFinal reportCessna 150-L · Logan, UTImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to lack of fuel. Factors related to the accident were: darkness and a fence in the emergency landing area.Aug 23, 1989 · N6697G · Substantial damageNTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…Jul 18, 1989 · N1086C · DestroyedNTSB DEN89LA160Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Holden, UTThe pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.Jul 8, 1989 · N6754Q · Substantial damageNTSB DEN89LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Moab, UTFailure of the pilot to refuel the aircraft before the flight and company induced pressure by the company/operator management, which resulted in fuel exhaustion from a lack of fuel. The terrain conditions and the tree were considered to be contributing…Jun 10, 1989 · N92299 · Substantial damageNTSB DEN89LA105Accident · No injuriesLimited investigationFinal reportCessna 172F · Morgan, UTInadequate servicing of the aircraft by the pilot, partial blockage of the fuel line and fuel filter, and fuel starvation. Contributing factors were: the downward sloping runway and a fence.Apr 10, 1989 · N7847U · Substantial damageNTSB FTW89MA047Accident · 1 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-32F · Salt Lake City, UTImproper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…Feb 9, 1989 · N935F · No damageNTSB DEN89FA034Accident · 2 fatalField investigationFinal reportCessna 421 · Tooele, UTNov 16, 1988 · N222BL · Substantial damageNTSB DEN89LA031Accident · Serious injuriesLimited investigationFinal reportSkypower 6 · Circleville, UTThe commercial balloon pilot and a commercial rated passenger were making an overnight flight. The balloon was equipped with instruments and equipment that allowed flight following by los angeles ARTCC. The flight became engulfed in a cold front and endured…Nov 14, 1988 · N46SP · Substantial damageNTSB DEN89FA020Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Laketown, UTThe plt departed salt lake city on a pleasure flt to bear lake to overfly a home that he owned. Witnesses near the acc site stated they saw the acft circle over the house and then depart the area over a ridge of mtns. The acft turned out over the lake and was…Oct 20, 1988 · N6069U · DestroyedNTSB DEN89DTM01Accident · 1 fatalFinal reportMickelson Mark V · Ogden, UTTotal loss of engine power for reasons undetermined which resulted in a forced landing. The pilot inadvertently stalled the aircraft during the forced landing, and that is considered a factor in the accident.Oct 19, 1988 · N555KM · DestroyedNTSB DEN89LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Price, UTThe pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The…Oct 6, 1988 · N7335N · Substantial damageNTSB DEN88DTM03Accident · 2 fatalFinal reportFalco F8L · Grantsville, UTThis acdt involved a homebuilt, side-by-side, two place, low wing, high performance aircraft. The purpose of the flt was to visit an airshow at wendover. The weather was reported to be clear with light winds. Radar track data showed the acft tracked straight…Aug 7, 1988 · N69WD · DestroyedNTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…Apr 16, 1988 · N2738R · Substantial damageNTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…Apr 14, 1988 · N3850M · DestroyedNTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…Mar 24, 1988 · N9393C · Substantial damageNTSB DEN88LA046Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe commercial plt and two passengers were surveying a road route in mountainous terrain. At cruise, the pilot noticed a drop in manifold pressure, followed by a loss of oil pressure. The plt reported that the engine quit. An autorotation to a snow covered…Jan 2, 1988 · N400AH · Substantial damageNTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…Dec 15, 1987 · N2138J · DestroyedNTSB DEN88FA030Accident · 2 fatalField investigationFinal reportBeech J35 · Knolls, UTThe last comm with the flt was when the plt contacted elko radio and requested the salt lake city wx. He reported that he was at 11500 ft and VFR on top. The specialist on duty was unable to provide the wx info due to a computer sys outage but recommended…Nov 26, 1987 · N2EE · DestroyedNTSB DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…Nov 7, 1987 · N9447B · DestroyedNTSB DEN87LA245Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Bountiful, UTWhile on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir.Sep 26, 1987 · N5692D · DestroyedNTSB DEN87LA241Accident · No injuriesLimited investigationFinal reportCessna TU206G · Spanish Fork, UTWhile cruising at 10,500 ft with the power set at 28 inches map & 2350 RPM, the eng suddenly lost pwr & began knocking. The plt noted a rapid drop in oil pressure & saw a 3-inch hole in the top of the eng cowling. He attempted to land on a highway, but was…Sep 16, 1987 · N756HD · DestroyedNTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…Sep 7, 1987 · N3037L · Substantial damageNTSB DEN87FA230Accident · 1 fatalField investigationFinal reportCessna 170B · Cedar City, UTWhile on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon.Sep 4, 1987 · N3541D · DestroyedNTSB DEN87LA217Accident · No injuriesLimited investigationFinal reportRockwell 200D · Ogden, UTThe pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was…Aug 14, 1987 · N2909T · Substantial damageNTSB DEN87LA165Accident · No injuriesLimited investigationFinal reportCessna 150-J · Ogden, UTThe plt and his son were returning home to Ogden. The plt reported to Ogden tower, 'I'm out of fuel.' The plt later stated, 'I landed in a field of two foot tall grass about five miles north of Ogden arpt. Prior to coming to a stop the acft struck a ditch…Jul 3, 1987 · N60154 · Substantial damageNTSB DEN87LA141Accident · No injuriesLimited investigationFinal reportCessna T210H · Salt Lake City, UTThe plt rprtd dscndg from 10,500 feet MSL for an apch to rwy 34 right at the Salt Lake City arpt. He stated he had selected landing flaps & had moved the mixture to rich & the prop to high RPM. At 8,500 MSL, 'the engine quit.' Subsequently, the plt made a…Jun 12, 1987 · N692RF · Substantial damageNTSB DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…May 31, 1987 · N7744P · Substantial damageNTSB DEN87FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Ogden, UTAcft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…May 25, 1987 · N2888B · DestroyedNTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…May 8, 1987 · N58131 · Substantial damageNTSB DEN87LA097Accident · Minor injuriesLimited investigationFinal reportMclachlan Moni · Tooele, UTThe private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an…Apr 15, 1987 · N96606 · Substantial damage