NTSB investigations, 2003, WA

23 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2003, WA per year, 1964–2026: 1,419 cases
196444
196551
196648
196770
196833
196930
197033
197117
197218
197333
197425
197531
197628
197719
197829
197932
198028
198125
198226
198322
198429
198517
198617
198727
198827
198919
199013
199125
199221
199325
199422
199515
199616
199719
199817
199921
200018
200119
200220
200323
200423
200519
200612
200715
200818
200923
201017
201123
201218
201318
201422
20159
201613
201713
201818
201913
202011
202119
202211
202315
202410
202512
202615

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 = 550)
  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 SEA04LA017Accident · No injuriesLimited investigationFinal reportCessna 150C · Toledo, WAFailure of the main landing gear attachment during the landing roll. An inadequate maintenance modification was a factor.Nov 10, 2003 · N7934Z · Substantial damageNTSB SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.Oct 18, 2003 · N1841R · Substantial damageNTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.Oct 2, 2003 · N350ME · Substantial damageNTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.Oct 2, 2003 · N2695S · Substantial damageNTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.Sep 29, 2003 · N2291A · Substantial damageNTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.Sep 24, 2003 · N9913C · Substantial damageNTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.Jul 23, 2003 · N8492T · Substantial damageNTSB SEA03LA136Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Sullivan Lake, WAThe pilot-in-command's downwind landing. A contributing factor was the tailwind condition.Jul 12, 2003 · N2805L · Substantial damageNTSB SEA03LA135Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Arlington, WAThe pilot's failure to maintain proper approach speed and landing touch down point resulting in a runway overrun. A factor was the tailwind condition.Jul 12, 2003 · N2545H · Substantial damageNTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.Jun 28, 2003 · N8070 · Substantial damageNTSB SEA03LA109Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Moses Lake, WAThe pilot's inadequate compensation for wind conditions during the landing roll. Factors include gusty crosswinds.Jun 20, 2003 · C-FCDM · Substantial damageNTSB SEA03LA108Accident · No injuriesLimited investigationFinal reportMcCarty Avid Magnum · Renton, WAThe flight instructor's unexpected encounter with control interference when the student applied brakes during the landing roll.Jun 17, 2003 · N64KM · Substantial damageNTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.Jun 15, 2003 · N9566L · Substantial damageNTSB SEA03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Wenatchee, WAFailure of the nose gear steering system for undetermined reasons during the landing roll.May 20, 2003 · N71749 · Substantial damageNTSB SEA03LA084Accident · No injuriesLimited investigationFinal reportCessna 172 N · Center Island, WAThe pilot did not attain the proper touchdown point during landing. The pilot's diverted attention, deer near the runway, and trees were factors.May 19, 2003 · N5326J · Substantial damageNTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.May 15, 2003 · N1977B · Substantial damageNTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.May 9, 2003 · N147DA · Substantial damageNTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.Apr 27, 2003 · N159AS · Substantial damageNTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…Apr 27, 2003 · N180MK · Substantial damageNTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…Mar 15, 2003 · N298AA · No damageNTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.Feb 1, 2003 · N75392 · Substantial damageNTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.Jan 28, 2003 · N48769 · Substantial damageNTSB SEA03LA027Accident · No injuriesLimited investigationFinal reportClassic Fighter Industries ME-262 Reproduction · Everett, WAFailure of the left main gear hydraulic actuator locking slide during landing. Factors include an embankment adjacent to the landing runway.Jan 17, 2003 · N262AZ · Substantial damage