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 DEN83LA109Accident · Minor injuriesLimited investigationFinal reportBeech C-50 · Nephi, UTThe acft collided with rocks and sagebrush during a forced landing after the engine lost power. The acft encountered induction and airframe icing during cruise. The pilots weather briefing forecast the icing which he encountered. The briefing took place about…May 6, 1983 · N322V · Substantial damageNTSB LAX83IA174Incident · No injuriesIncident investigationFinal reportDouglas DC-9-82 · 20n Bryce, UTWhile cruising at FL 350 the flt experienced a flame-out of both engines. The crew declared an emergency to salt lake artc center & the flt was vectored toward page,AZ for a possible emergency landing. At 12,200 ft the captain restarted both engines by…Apr 2, 1983 · N1004F · No damageNTSB DEN83FA090Accident · 2 fatalField investigationFinal reportCessna 150M · Kanab, UTThe acft departed page at about 1150. At about 1238 the acft struck the south slope of a 6,280-FT canyon wall at about 6,000 ft MSL. The canyon is one of a series of about five 'finger' canyons forming the vermilion cliffs group. Sigment lima 15 in effect…Mar 31, 1983 · N714ML · DestroyedNTSB DEN83FA087Accident · 3 fatalField investigationFinal reportCessna T210M · Salt Lake City, UTBefore departing phoenix, AZ, the plt obtained a wx briefing, was advised of forcasted icing conditions & was informed that the Salt Lake City (slc) VORTAC was out of service. While en route, at 0931, he received a wx update. The slc wx at that time was, in…Mar 26, 1983 · N6140B · DestroyedNTSB DEN83FA084Accident · Serious injuriesField investigationFinal reportCessna 182 · Huntsville, UTThe afct collided with a tree and crashed during a go-around. The weather was IMC and the pilot and passenger were seriously injured. The pilot received a weather briefing and was told that VFR flt, on his intended route, was not recommended due to low…Mar 24, 1983 · N9377X · Substantial damageNTSB LAX83IA147Incident · No injuriesIncident investigationFinal reportDouglas DC-9-10 · Salt Lake City, UTDuring climb to 28,000 ft at 20,000 ft the auto-pilot disengaged and the crew reported that they could not move the control column to control pitch. The acft was operating in icing conditions at the time. The crew landed the acft by utilizing the trim control.Mar 17, 1983 · N9356 · No damageNTSB DEN83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Coalville, UTThe acft nosed over during an precautionary landing due to deteriorating weather. The plt had received a weather briefing. The wx conditions deteriorated enroute due to a snow storm and the plt elected to land on a private strip to await improved weather. The…Mar 13, 1983 · N3743M · Substantial damageNTSB DEN83FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Lake Powell, UTThe acft was seen to fly erratically before plunging into the lake during an landing attempt. Investigation revealed a history of pre-existing medical problems that could lead to 'a convulsive episode with accompanied loss of consciousness.' An examination of…Mar 6, 1983 · N96460 · DestroyedNTSB DEN83FA062Accident · 2 fatalField investigationFinal reportPiper PA-23F-250 · Moab, UTThe acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An…Feb 16, 1983 · N63808 · DestroyedNTSB DEN83FA053Accident · 4 fatalField investigationFinal reportCessna T210N · Minersville, UTThe acft impacted in a near vertical attitude near the top of a mountain & adjacent to a highway where witnesses had observed the acft flying at very low altitues under a low ceiling. There was no record of a preflight wx briefing or inflight advisories. No…Jan 28, 1983 · CGRFV · DestroyedNTSB DEN83FA133Accident · 1 fatalField investigationFinal reportCessna 182A · Orderville, UTThe acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330…Nov 8, 1982 · N5149D · DestroyedNTSB DEN83LA014Accident · Minor injuriesLimited investigationFinal reportGrumman AA1 · Bicknell, UTThe pilot stated that shortly after departing the Bicknell airport, a strong downdraft forced the aircraft into the ground while approaching the lee side of a ridge line. He indicated the aircraft was at about 100 mph indicated airspeed when ground contact…Nov 7, 1982 · N555AW · DestroyedNTSB DEN82FTM17Accident · 2 fatalFinal reportCessna 182 · Salina, UTOne of the survivors stated they were flying across the face of a mountain & started a left turn up the mountain. As they made the turn they realized they were too low. When they started their turn to fly over the hill they were expecting the terrain to be…Sep 21, 1982 · N21322 · DestroyedNTSB DEN82DA190Accident · Minor injuriesFinal reportCessna 310P · Wendover, UTThe pilot stated he became disoriented while flying from salt lake city to Wendover. He descended to 8000 ft to keep clear of ice and hail and could not receive a navigational signal from the Wendover or bonneville navigational facility. While attempting to…Sep 13, 1982 · N5836M · Substantial damageNTSB DEN82FTM16Accident · 2 fatalFinal reportVarieze · Milcreek Canyon, UTThe aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…Jul 28, 1982 · N104P · DestroyedNTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…Mar 5, 1982 · N3963F · DestroyedNTSB DEN82FTM09Accident · 1 fatalFinal reportBeech A36 · St. George, UTThe aircraft was on a flight from las vegas, Nevada to St. George, Utah when it flew past the destination and struck the side of a mountain. The crash site was located about 15 miles beyond the destination at an elevation of about 7600 ft MSL. The site was…Feb 19, 1982 · N4295S · DestroyedNTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…Jan 16, 1982 · N6520Y · DestroyedNTSB DEN82FTM02Accident · No injuriesClosedSoloy 47 · Fruitland, UTNov 5, 1981 · N1170W · Substantial damageNTSB DEN82FA005Accident · 3 fatalClosedPiper PA-28 · Provo, UTOct 29, 1981 · N2831R · DestroyedNTSB DEN82FA003Accident · Minor injuriesClosedAerospatial SA315B · Springville, UTOct 20, 1981 · N49531 · Substantial damageNTSB DEN82FA002Accident · 3 fatalClosedCessna 310 · Eureka, UTOct 4, 1981 · N5809X · DestroyedNTSB DEN82FA001Accident · 1 fatalClosedCessna 182RG · La Sal, UTOct 4, 1981 · N4875R · DestroyedNTSB DEN81DTM41Accident · No injuriesClosedPiper PA-38 · Promontory Pt, UTSep 7, 1981 · N9746T · Substantial damageNTSB DEN81FTM38Accident · Minor injuriesClosedCessna 172 · Spring City, UTAug 16, 1981 · N64518 · Substantial damageNTSB DEN81FTM39Accident · 1 fatalClosedPiper PA-28 · Ferron, UTAug 8, 1981 · N2910D · DestroyedNTSB DEN81FA047Accident · 2 fatalClosedTaylorcraft BL-65 · Rosette, UTJul 3, 1981 · N24462 · DestroyedNTSB DEN81FA042Accident · No injuriesClosedCessna TU206G · Cisco, UTJun 18, 1981 · N6303U · Substantial damageNTSB DEN81FTM28Accident · Minor injuriesClosedCessna 210 · Kanab, UTJun 6, 1981 · N732JN · Substantial damageNTSB DEN81FTM26Accident · No injuriesClosedPiper PA-28 · Thistle, UTJun 6, 1981 · N9627K · Substantial damageNTSB DEN81FA037Accident · 2 fatalClosedBeech A-35R · Beaver, UTMay 16, 1981 · N3158V · Substantial damageNTSB DEN81FA028Accident · 2 fatalClosedCessna 172 · Tropic, UTApr 18, 1981 · N19831 · DestroyedNTSB DEN81FTM16Accident · No injuriesClosedCessna 152 · Cedar City, UTApr 14, 1981 · N64909 · Substantial damageNTSB DEN81FA033Accident · 6 fatalClosedPiper PA-32 · Escalante, UTFeb 28, 1981 · N4243T · DestroyedNTSB DEN81FA017Accident · 1 fatalClosedPiper PA-28R · Wendover, UTJan 25, 1981 · N8516E · DestroyedNTSB DEN81FTM04Accident · Serious injuriesClosedPiper PA-28 · Woodland, UTNov 21, 1980 · N8021F · Substantial damageNTSB DEN80FTM41Accident · Serious injuriesClosedCessna 172 · Heber, UTSep 25, 1980 · N8076E · Substantial damageNTSB DEN80FTM40Accident · No injuriesClosedPiper PA-28 · Kamas, UTSep 24, 1980 · N54445 · Substantial damageNTSB DEN80FTM34Accident · Serious injuriesClosedPiper PA-28 · Callao, UTAug 1, 1980 · N8800N · Substantial damageNTSB DEN80FTM33Accident · Serious injuriesClosedCourt Sport A · Richfield, UTJul 29, 1980 · N747R · DestroyedNTSB DEN80FTM28Accident · No injuriesClosedCessna T337D · Ouray, UTJul 3, 1980 · N85876 · Substantial damageNTSB DEN80FTM25Accident · No injuriesClosedPiper PA-28 · Cedar City, UTJun 20, 1980 · N47445 · Substantial damageNTSB DEN80DTM22Accident · No injuriesClosedPiper PA-18 · Santaquin, UTMay 31, 1980 · N6798A · Substantial damageNTSB DEN80FTM19Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTMay 24, 1980 · N1582J · Substantial damageNTSB DEN80FA032Accident · No injuriesClosedBell 206B · Brighton, UTMay 9, 1980 · N1074Z · Substantial damageNTSB DEN80FA024Accident · 1 fatalClosedMooney M20C · Scipio, UTFeb 6, 1980 · N6489U · DestroyedNTSB DEN80FA020Accident · 3 fatalClosedBeech H35 · Copperton, UTJan 24, 1980 · N7935D · DestroyedNTSB DEN80FA018Accident · No injuriesClosedBell 206B · Moab, UTJan 19, 1980 · N206DT · Substantial damageNTSB DEN80FA047Accident · 4 fatalClosedPiper PA-28 · Logan, UTJan 12, 1980 · N9388J · Substantial damageNTSB LAX80DXQ15Accident · No injuriesClosedPiper PA-28R · Wendover, UTNov 23, 1979 · N38398 · Substantial damage