NTSB investigations, 2000, WA

11 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2000, WA per year, 1964–2026: 678 cases
196419
196515
196612
196716
196817
196914
19709
197117
197216
197315
197415
197516
197620
197710
197817
197914
198012
198116
198210
198313
198414
198511
198617
198711
198812
198913
19906
19919
199213
199316
199411
199514
199611
19978
199817
199912
200011
20017
20027
20039
200417
20059
20067
200710
20088
20096
20106
201110
201216
20134
20145
20157
20162
20175
20188
20193
20205
20212
20228
20235
20245
20254
20264

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\") = 2000
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  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 SEA01LA024Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Lake Kachess, WAThe pilot's failure to comply with the flight manual regarding the use of an induction system deflector kit (snow baffles) while operating in snow, and the ingestion of foreign material/snow that resulted in an engine flameout while hovering. A snow baffle…Nov 23, 2000 · N2062D · Substantial damageNTSB SEA01LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Conconully, WAThe pilot's failure to maintain clearance from the trees while flying at a very low altitude in mountainous/hilly terrain. Factors include, forested mountainous/hilly terrain, flight at a very low altitude, and an encounter with a downdraft.Oct 30, 2000 · CGDNN · DestroyedNTSB SEA01FA001Accident · 1 fatalField investigationFinal reportCessna 208B · Lummi Island, WAThe pilot's attempted flight into known adverse weather conditions, and his subsequent failure to maintain altitude above, or clearance with, trees. Factors contributing to the accident included low ceilings, fog, the pilot's low-altitude flight, rising…Oct 9, 2000 · N941FE · Substantial damageNTSB SEA00LA192Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Columbia River, WAClearance from a transmission power line was not maintained. The power line was a factor.Sep 27, 2000 · N5111A · Substantial damageNTSB SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…Sep 24, 2000 · N9355F · Substantial damageNTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…Jul 11, 2000 · N311KA · Substantial damageNTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.Jun 8, 2000 · N80193 · Substantial damageNTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.Jun 5, 2000 · N6549K · Substantial damageNTSB SEA00LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Quincy, WAFailure to maintain terrain clearance. Factors include mountainous/hilly terrain.Mar 22, 2000 · N229CP · Substantial damageNTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.Mar 6, 2000 · N8170W · Substantial damageNTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.Feb 7, 2000 · N7780V · Substantial damage