NTSB investigations, 1997, OR

8 cases where the phase of flight was Approach.

Cases per year

19642026
NTSB investigations, 1997, OR per year, 1964–2026: 393 cases
196411
19658
196617
196710
196811
196910
19709
19717
19722
19738
19749
197511
19768
197714
197812
19796
19809
19818
198211
19839
198410
19855
19866
19876
19884
19896
19903
19915
19925
19939
19942
19956
19968
19978
19984
19999
20006
20017
20023
20036
20045
20055
20069
20074
20086
20095
20106
20112
20121
20136
20141
20153
20162
20174
20183
20196
20204
20215
20233
20253
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\") = 1997
    AND c.\"eventStateOrRegion\" = 'OR' 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 SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.Oct 18, 1997 · N5482U · Substantial damageNTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.Aug 3, 1997 · N20146 · Substantial damageNTSB SEA97FA130Accident · 1 fatalField investigationFinal reportLockheed P-38L · Tillamook, ORfailure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…Jun 7, 1997 · N7973 · DestroyedNTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.Jun 1, 1997 · N50348 · Substantial damageNTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.May 10, 1997 · N1707P · Substantial damageNTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…May 10, 1997 · N55676 · DestroyedNTSB SEA97LA096Accident · Minor injuriesLimited investigationFinal reportHendrix Talon XP · Redmond, ORincomplete installation (omission of the aft control stick and interlink tube) of the flight control system, resulting in failure of the combined (torque) elevator and aileron rod and a disconnection of the forward flight control stick from the ailerons and…May 2, 1997 · N6291X · Substantial damageNTSB SEA97LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Manzanita, ORThe pilot's failure to adequately compensate for wind conditions, and his failure to maintain directional control of the airplane during the go-around attempt. Factors contributing to the accident are gusty crosswinds.Apr 3, 1997 · CGICR · Substantial damage