NTSB investigations, 1985, UT

9 cases where the phase of flight was Approach.

Cases per year

19642026
NTSB investigations, 1985, UT per year, 1964–2026: 221 cases
19645
19656
19666
19672
19684
19695
19703
19713
19724
19733
19745
19754
197611
19775
19786
19794
19803
19817
19823
19833
19844
19859
19868
19881
19894
19904
19913
19922
19933
19942
19951
19964
19977
19984
19996
20007
20015
20024
20033
20042
20052
20062
20076
20081
20093
20105
20114
20122
20131
20142
20173
20181
20191
20203
20213
20221
20231
20243
20262

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 = 500)
  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 DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…Dec 29, 1985 · N2082S · DestroyedNTSB DEN85LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage.Sep 4, 1985 · N52456 · Substantial damageNTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.Aug 31, 1985 · N707UR · Substantial damageNTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.Jul 23, 1985 · N2203D · Substantial damageNTSB DEN85FTM03Accident · 1 fatalFinal reportKillian Briegleb BG-12B · Heber City, UTThe acft was a george Killian/briegleb BG-12B, experimental, home built glider. An owner reported that the plt had come from new Mexico to buy the glider. After spending about 3 hrs in familiarization training, the plt went on his 1st flt which was…Jun 23, 1985 · N997 · DestroyedNTSB DEN85LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearfield, UTThe plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft…Jun 14, 1985 · N7259P · Substantial damageNTSB DEN85FTM01Accident · Minor injuriesFinal reportGamble Sonerai II · Salt Lake City, UTThe acft nosed over during a forced landing short of the rwy following a loss of pwr. The plt stated that after takeoff he noticed a rise in the cylinder head temperature. He attempted a landing and overshot the rwy. During the plt's second landing attempt,…Apr 28, 1985 · N922GG · Substantial damageNTSB DEN85LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28L · Salt Lake City, UTThe acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…Mar 14, 1985 · N51671 · Substantial damageNTSB DEN85LA089Accident · No injuriesLimited investigationFinal reportBeech E33-C · Richfield, UTThe plt stated that he was returning to the arpt and was on the base leg of the traffic pattern when he experienced a partial loss of eng pwr. The plt stated that when he turned on the boost pump, pwr was restored for a short time. He continued to state that…Mar 1, 1985 · N8112R · Substantial damage