NTSB investigations, 2003, WA

9 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2003, WA per year, 1964–2026: 678 cases
196419
196515
196612
196716
196817
196914
19709
197117
197216
197315
197415
197516
197620
197710
197817
197914
198012
198116
198210
198313
198414
198511
198617
198711
198812
198913
19906
19919
199213
199316
199411
199514
199611
19978
199817
199912
200011
20017
20027
20039
200417
20059
20067
200710
20088
20096
20106
201110
201216
20134
20145
20157
20162
20175
20188
20193
20205
20212
20228
20235
20245
20254
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\" = 'WA' 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 SEA04LA025Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Moclips, WAA sudden loss of engine power during hover for undetermined reasons.Dec 8, 2003 · N8343F · Substantial damageNTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.Aug 16, 2003 · N2054F · Substantial damageNTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…Jun 12, 2003 · N8468V · Substantial damageNTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.Jun 6, 2003 · None · Substantial damageNTSB SEA03LA086Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Basin City, WAThe failure of the torque sensor idler gear duplex bearing during agricultural aerial application, resulting in a total power loss and a forced landing. Factors include tall wheat and soft terrain.May 16, 2003 · N3629E · Substantial damageNTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.Apr 17, 2003 · N4178T · Substantial damageNTSB SEA03LA058Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe entanglement of the fuel quantity sender float in the start pump wiring within the fuel tank as a result of the wiring not being properly secured. This rendered the fuel gauge inaccurate and the low fuel warning light inoperative which led to fuel…Apr 7, 2003 · N5225C · Substantial damageNTSB SEA03LA050Accident · No injuriesLimited investigationFinal reportHiperlight SNS-8 · South Prairie, WAThe failure of the pilot to maintain control of the aircraft during the crosswind turn resulting in an inadvertent spin entry, followed by his intentional stall to a landing resulting in a hard landing and subsequent nose over.Mar 25, 2003 · UNREG · Substantial damageNTSB SEA03FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Eastsound, WAThe pilot's failure to maintain clearance from the water and his failure to reset the altimeter to the local barometric pressure. Contributing factors were fog and night conditions.Jan 19, 2003 · N7282C · Destroyed