NTSB investigations, 2004, WA

23 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2004, 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\") = 2004
    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 SEA05LA047Accident · No injuriesLimited investigationFinal reportCessna 182K · Olympia, WAThe pilot's improper flare. Factors include too high of an airspeed and an inadvertent porpoise.Dec 27, 2004 · N2536Q · Substantial damageNTSB SEA05CA030Accident · No injuriesData collectionFinal reportFairchild 24W-41A · Wenatchee, WAThe pilot's failure to maintain directional control during the landing roll. A frozen brake was a factor.Dec 24, 2004 · N28525 · Substantial damageNTSB SEA05CA029Accident · No injuriesData collectionFinal reportBeech 58TC · Everett, WAThe pilot's misjudgment of distance/speed on landing touchdown and rollout, and his subsequent excessive braking. A factor was the fence.Dec 22, 2004 · N7858B · Substantial damageNTSB SEA04CA194Accident · No injuriesData collectionFinal reportCessna 152 · Friday Harbor, WAThe pilot's delay in executing an aborted landing and his failure to obtain altitude/clearance from trees during the aborted landing. A factor was the pilot's failure to obtain the proper touchdown point as a result of his high airspeed on approach.Sep 27, 2004 · N757RD · Substantial damageNTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.Sep 23, 2004 · N56775 · Substantial damageNTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.Aug 26, 2004 · N6141G · Substantial damageNTSB SEA04CA144Accident · No injuriesData collectionFinal reportPiper Aerostar 602P · Seattle, WAThe landing gear extention not performed by the pilot.Jul 26, 2004 · N663W · Substantial damageNTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.Jul 24, 2004 · N2527Y · Substantial damageNTSB SEA04CA159Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Sequim, WAAircraft control not maintained during the landing roll. A factor was the irrigation pipe.Jul 23, 2004 · N88373 · Substantial damageNTSB SEA04CA132Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Waitsburg, WAThe pilot's failure to maintain aircraft control and his inadequate compensation for the wind conditions during the landing. Gusts and high vegetation were factors.Jul 12, 2004 · N23811 · Substantial damageNTSB SEA04LA130Accident · No injuriesLimited investigationFinal reportPetsche Kitfox Kitfox 7 · Arlington, WAThe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control while landing. A factor contributing to the accident was a direct crosswind.Jul 9, 2004 · N1078P · Substantial damageNTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…Jun 23, 2004 · N699DS · Substantial damageNTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.Jun 20, 2004 · UNREG · DestroyedNTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.May 13, 2004 · N1829P · Substantial damageNTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…May 10, 2004 · N54477 · Substantial damageNTSB SEA04LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · North Bend, WAThe pilot's failure to maintain aircraft control during the landing roll. A rough landing surface and tailwind gusts were factors.Apr 29, 2004 · N7631K · Substantial damageNTSB SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.Apr 17, 2004 · N127DD · Substantial damageNTSB SEA04CA059Accident · No injuriesData collectionFinal reportRockwell S-2R · Mattawa, WACompensation for wind conditions not maintained. Factors include a tailwind and a rock pile adjacent to the runway.Mar 26, 2004 · N8420V · Substantial damageNTSB SEA04LA053Accident · No injuriesLimited investigationFinal reportCessna 172E · Raymond, WAThe pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.Mar 21, 2004 · N3950S · Substantial damageNTSB SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.Mar 14, 2004 · N65675 · Substantial damageNTSB SEA04LA056Accident · No injuriesLimited investigationFinal reportCessna R182 · Bremerton, WAThe pilot's failure to maintain directional control which resulted in a loss of control and subsequent wing strike with terrain. A contributing factor was the soft terrain.Mar 10, 2004 · N7362X · Substantial damageNTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · 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 sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…Jan 19, 2004 · C-GTAQ · No damageNTSB SEA04LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Deer Park, WAThe dual student pilot's failure to maintain directional control during the landing roll and the failure of the flight instructor to provide remedial action. A factor was snowbank.Jan 14, 2004 · N185WB · Substantial damage