NTSB investigations, 2003, WA

15 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 2003, WA per year, 1963–2026: 979 cases
19631
196421
196520
196627
196716
196823
196927
197028
19719
197225
197315
197434
197533
197623
197731
197831
197936
198030
198128
198226
198329
198416
198515
198630
198719
198817
198919
199021
199119
199214
19938
199412
199523
199614
19979
199813
19999
200016
20019
200217
200315
200411
200510
20066
20079
20087
20099
20108
20117
20126
20135
20143
20157
20164
20174
20185
20196
20201
20219
20229
20235
20246
20259
20265

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 = 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 SEA03LA197Accident · No injuriesLimited investigationFinal reportThompson Avid Flyer · Roche Harbor, WAA complete loss of power due to fuel starvation for undetermined reason(s).Sep 28, 2003 · N6611 · Substantial damageNTSB SEA03LA186Accident · Serious injuriesLimited investigationFinal reportSchmidt Zodiac 601 XL · Sumner, WALoss of engine power during the initial climb. Factors include the in-flight collision with trees during the uncontrolled descent.Sep 4, 2003 · N819GS · DestroyedNTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…Jul 26, 2003 · N314KA · DestroyedNTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…Jul 22, 2003 · N996JR · Substantial damageNTSB SEA03LA164Accident · No injuriesLimited investigationFinal reportBeech A35 · Freeland, WAA partially blocked fuel injector which led to an over temperature condition in the cylinders resulting in a loss of engine power during cruise flight. Sandy terrain conditions for the landing was a factor.Jul 18, 2003 · N8598A · Substantial damageNTSB SEA03LA132Accident · Serious injuriesLimited investigationFinal reportHanks Avid Flyer · Toledo, WAThe pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.Jul 10, 2003 · N3086G · Substantial damageNTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…Jul 4, 2003 · N279WP · Substantial damageNTSB SEA03FA121Accident · 1 fatalField investigationFinal reportLamb RV-4 · Vail, WAA loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…Jun 29, 2003 · N6596X · Substantial damageNTSB SEA03LA107Accident · No injuriesLimited investigationFinal reportPippert Zenith Air CH 701 · Rochester, WALoose jet in the carburetor while on climb out resulting in a loss of engine power.Jun 7, 2003 · N2748 · Substantial damageNTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.May 30, 2003 · N7301A · Substantial damageNTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.May 8, 2003 · N5030B · DestroyedNTSB SEA03LA075Accident · Minor injuriesLimited investigationFinal reportDeJager RV-6 · Bellingham, WAThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power.Apr 29, 2003 · N239D · Substantial damageNTSB SEA03LA076Accident · No injuriesLimited investigationFinal reportFokker F27MK 600 · Port Townsend, WAThe failure of the accessory drive shaft due to deterioration of bearing number 1 in the aft fork of the universal joint for undetermined reasons during cruise flight.Apr 17, 2003 · N730FE · Substantial damageNTSB SEA03FA026Accident · No injuriesField investigationFinal reportCessna 172K · Gig Harbor, WAThe loss of engine power in the climb due to the fracture of the number seven engine crankshaft cheek due to the propagation of a fatigue crack initiation point. Factors include a vehicle pulling onto the road that the pilot selected for his forced emergency…Jan 14, 2003 · N1909V · Substantial damageNTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.Jan 12, 2003 · N6442Q · Substantial damage