NTSB investigations, 2003, OR

9 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2003, OR per year, 1964–2026: 482 cases
19646
196512
196612
19676
19683
196912
19707
197111
197213
197312
197412
19758
19766
197716
197811
19797
198010
19819
19828
198312
19848
198510
19866
19875
19888
198910
19905
199112
199210
19939
199417
199518
199613
199716
19985
19999
20008
20013
20022
20039
20049
20057
20069
200711
20081
20094
20105
20111
20127
20136
20143
20155
20164
20171
20184
20198
20203
20214
20222
20234
20244
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\") = 2003
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  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 SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.Dec 11, 2003 · N29CV · DestroyedNTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.Dec 2, 2003 · N183T · Substantial damageNTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.Nov 18, 2003 · N7825S · Substantial damageNTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.Oct 20, 2003 · N136SB · DestroyedNTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.Oct 18, 2003 · N340P · DestroyedNTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…Oct 14, 2003 · N86W · Substantial damageNTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.Sep 12, 2003 · N48020 · Substantial damageNTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…Jul 29, 2003 · N61442 · Substantial damageNTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.Jul 4, 2003 · N37799 · Destroyed