NTSB investigations, 2002, WA

8 cases where the phase of flight was Approach.

Cases per year

19642026
NTSB investigations, 2002, WA per year, 1964–2026: 546 cases
19644
196514
196615
196715
196815
196916
197020
197111
197218
197316
19749
197519
197619
197713
197815
19799
19809
198114
198210
198316
19849
19855
198611
19877
19889
19898
199015
199114
199216
19936
19948
19956
199610
19975
19986
199910
20003
200110
20028
200313
200410
20057
20066
20075
20086
20093
20102
20113
20123
20133
20142
20152
20162
20174
20185
20195
20205
20211
20223
20235
20244
20251
20263

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 = 500)
  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 SEA03LA020Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1 · Chehalis, WAThe total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.Dec 23, 2002 · N5985L · Substantial damageNTSB SEA02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bellingham, WAThe pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…Aug 12, 2002 · N6420A · Substantial damageNTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…Jul 6, 2002 · N51PL · Substantial damageNTSB SEA02LA113Accident · No injuriesLimited investigationFinal reportCessna 177 · Mt. Vernon, WAThe pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.Jun 26, 2002 · N29441 · Substantial damageNTSB SEA02LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anacortes, WAThe pilot's improper decision to continue his flight after failing to take on fuel at a planned en route refueling stop, which lead to a loss of power from fuel exhaustion while on final approach to his round-robin final destination. Factors include…May 31, 2002 · N496HM · Substantial damageNTSB SEA02FA060Accident · No injuriesField investigationFinal reportBoeing S-307 · Seattle, WALoss of all engine power due to fuel exhaustion that resulted from the flight crew's failure to accurately determine onboard fuel during the pre-flight inspection. A factor contributing to the accident was a lack of adequate crew communication regarding the…Mar 28, 2002 · N19903 · Substantial damageNTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.Mar 14, 2002 · N8065A · Substantial damageNTSB SEA02LA045Accident · No injuriesLimited investigationFinal reportGunderson Floatmaster · Elma, WALoss of engine power for undetermined reasons. Soft terrain was a factor.Feb 27, 2002 · N2425D · Substantial damage