NTSB investigations, 2002, WA

20 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2002, 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\") = 2002
    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 SEA03LA018Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125 · Seattle, WAThe landing gear down and locked was not verified prior to landing. The checklist was not followed, and an inoperative landing gear warning horn were factors.Dec 17, 2002 · N55RF · Substantial damageNTSB SEA03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Pasco, WAIcing conditions and the pilot's failure to maintain adequate airspeed during the landing. An inadvertent stall was a factor.Dec 1, 2002 · N9260P · Substantial damageNTSB SEA03LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Longview, WAThe pilot's failure to maintain clearance from trees while landing. A contributing factor was trees.Nov 22, 2002 · N82W · Substantial damageNTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.Sep 28, 2002 · N132ND · Substantial damageNTSB SEA02LA181Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Shaw Island, WAThe pilot's failure to adequately compensate for ambient wind conditions. Factors include the pilot's misjudgment of distance/altitude, gusting crosswinds, and trees growing near the edge of the airstrip.Sep 26, 2002 · N736PJ · Substantial damageNTSB SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.Sep 23, 2002 · N9641 · Substantial damageNTSB SEA02LA166Accident · No injuriesLimited investigationFinal reportAero Commander S2R Thrush · Connell, WAThe pilot's failure to adequately compensate for wind conditions and his failure to maintain directional control. Factors include rough uneven terrain.Aug 21, 2002 · N8870Q · Substantial damageNTSB SEA02LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Quincy, WAThe pilot's failure to maintain the proper descent rate during the descent for landing. A proper glide path was not attained, inadequate remedial action, and a fence were factors.Aug 3, 2002 · N3766X · Substantial damageNTSB SEA02LA147Accident · No injuriesLimited investigationFinal reportCessna 177B · Elma, WAThe pilot's failure to maintain directional control during a bounced landing and recovery resulting in the aircraft's departing the runway. Contributing factors were the high brush/vegetation the aircraft rolled into and the pilot's reduced visual acquisition…Aug 1, 2002 · N34633 · Substantial damageNTSB SEA02LA139Accident · No injuriesLimited investigationFinal reportCessna R182 · Puyallup, WARestricted movement of the left main landing gear resulting in the gear not extending for the landing. A misaligned brake line was a factor.Jul 30, 2002 · N7592Y · Substantial damageNTSB SEA02LA136Accident · No injuriesLimited investigationFinal reportStearman C3-R · Arlington, WAThe pilot's inadequate remedial action when responding to the swerve/veer of the tailwheel equipped aircraft, leading to a failure to maintain directional control during the landing roll. Factors include the pilot’s lack of experience in the make and model…Jul 23, 2002 · N656K · Substantial damageNTSB SEA02TA110Accident · No injuriesFinal reportBell 206B · Rainier, WAThe pilot's failure to maintain aircraft control while trying to land. Rough/uneven terrain, inaccurate performance data calculations, inadequate in-flight planning and lack of familiarity with the geographic area were factors.Jun 25, 2002 · N1087L · Substantial damageNTSB SEA02FA106Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics LA-4-200 · Puyallup, WAFailure to maintain aircraft control during a go-around. Trees were a factor in the accident.Jun 19, 2002 · CGHIT · Substantial damageNTSB SEA02LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Vancouver, WAThe pilot's delayed remedial action during the landing sequence. Factors include a wet runway surface.May 28, 2002 · N26221 · Substantial damageNTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.May 26, 2002 · N69AG · Substantial damageNTSB SEA02LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · South Prairie, WAThe pilot's improper touchdown point. Factors include a wet landing surface.May 11, 2002 · N321D · Substantial damageNTSB SEA02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAThe failure of the brake system during the landing roll. An intentional ground loop and a dirt bank were factors.Mar 28, 2002 · N1810P · Substantial damageNTSB SEA02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Deer Park, WALoss of directional control while landing. A drainage ditch was a factor.Mar 17, 2002 · N77301 · Substantial damageNTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.Feb 26, 2002 · N168B · Substantial damageNTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.Jan 28, 2002 · N23849 · Substantial damage