NTSB investigations, 1985, UT

13 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 1985, UT per year, 1964–2026: 544 cases
19649
196513
196616
19678
196812
19698
197012
19718
197210
197318
197413
197512
197612
197713
197817
197914
198014
198117
19828
198320
198414
198513
19868
198719
198810
19897
19907
19916
19928
19936
19948
19956
19963
19976
19988
19995
200010
20016
200211
200310
20047
20053
200610
200711
20086
20099
20104
20116
20124
20134
20143
20154
20164
20173
20185
20195
20202
20215
20223
20238
20243
20256
20264

Latest cases

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 year(c.\"eventDate\") = 1985
    AND 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 DEN86FA232Accident · 2 fatalField investigationFinal reportCessna T210L · Salina, UTThe non-instrument rated plt did not obtain a wx briefing nor file a flight plan. He and his wife took off from bullfrog basin airport, glen canyon, UT, en route to heber city, UT, on 12-30-85. Acft did not arrive. Civil air patrol search was conducted from…Dec 30, 1985 · N27CF · DestroyedNTSB DEN86FA054Accident · 1 fatalField investigationFinal reportBell 206-L3 · Monument Valley, UTThe helicopter contacted power lines and the terrain during an attempted takeoff from a hospital after a cancelled med-evac flt. The hospital is located in a box canyon surrounded by high terrain and power lines. The plt was aware of the power line that…Dec 25, 1985 · N10UB · DestroyedNTSB DEN86LTM01Accident · Serious injuriesFinal reportCessna 172 · Brigham City, UTThe acft contacted mountainous terrain during a descent through fog. The plt stated that on the return flt from malad, ID, he began following a mountain range which he believed would take him back to ogden. However, the range guided him southwest of the…Dec 22, 1985 · N64005 · DestroyedNTSB DEN86LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe plt stated he had just departed a site located on top of a mountain, which is approximately 12,200 ft MSL. The pilot said 30 seconds later, the helicopter lost partial power. Requiring him to make a force landing. The inspection of the turbocharger…Nov 1, 1985 · N400AH · Substantial damageNTSB DEN86LA005Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Fillmore, UTThe plt departed delta, UT on a VFR x-c flt after being advised by fss that VFR was not recommended due to IMC conditions on the proposed route of flt. He flew into an area of rising terrain, encountered IMC wx conditions, attempted to reverse course and…Oct 9, 1985 · N3339V · DestroyedNTSB DEN85LA235Accident · No injuriesLimited investigationFinal reportCessna 182N · Moab, UTThe plt stated after the accident that he experienced a loss of power while cruising at 8500 MSL. He was unable to restore power and executed an emergency landing in an open area covered by sage brush. During the landing roll, the acftnosed over. Examination…Sep 3, 1985 · N9229 · Substantial damageNTSB DEN85FA233Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Ogden, UTThe plt and his party were en route from minden, NV to casper, WY and had stopped at Ogden, UT to refuel. The plt obtained an updated wx briefing fr fss and field an IFR flt plan. After takeoff the plt was told to climb in the holding pattern to 13000 ft.…Sep 2, 1985 · N75015 · DestroyedNTSB DEN85FA227Accident · Serious injuriesField investigationFinal reportPiper PA-31B-310 · Vernal, UTThe plt cancelled his IFR plan and began descent from 13000 ft in preparation for landing at Vernal, UT. The acft impacted ground in wings level attitude under power. Plt was seriously burned by post-crash ground fire. Investigation revealed no evidence of…Aug 21, 1985 · N7497L · DestroyedNTSB DEN85FA222Accident · 4 fatalField investigationFinal reportCessna 172P II · Cedar City, UTThe plt took three of his friends up for a pleasure flt in the local area of Cedar City, Utah. VMC prevailed at the time. The plt continued to climb his acft as it passed over rising terrain. The flt terminated in a box canyon with high terrain on all sides.…Aug 18, 1985 · N54168 · DestroyedNTSB DEN85LA215Accident · No injuriesLimited investigationFinal reportCessna U-206 · Bullfrog Basin, UTThe plt was flying on a VFR x-county flt when he allowed the rt fuel tank to run dry which resulted in eng stoppage. After switching fuel an attempted eng restarted was unsuccesfull. The subsequent forced lng resulted in substantial damage to the acft.Aug 10, 1985 · N2187F · DestroyedNTSB DEN85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Thistle, UTThe plt had just completed an aerial spray mission and was flying through a canyon when the acft collided with pwr lines. Control of the acft was lost and it contacted the terrain.Jul 15, 1985 · N7614Z · Substantial damageNTSB DEN85LA106Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTOn April 1, 1985, a Cessna 210 with mexican registry, xbcke,piloted by a mexican national, lost engine power and landed short of the runway at Salt Lake City international airport the flight had depated the grand canyon AZ airport. Post accident examination…Apr 1, 1985 · XBCKE · Substantial damageNTSB DEN85FA074Accident · 1 fatalField investigationFinal reportBeech BE-23-24 · Eureka, UTOn feb 6, 1985,a Beech BE-23-24 musketeer,owned and operated by the plt crashed into the side of a 7000 ft mtn at the 6700 ft level. The ac was demolished and the plt received fatal injuries. The wx conditions were reported as VMC by provo, Utah and by a…Feb 6, 1985 · N5781V · Destroyed