NTSB investigations, 2000, WA

7 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 2000, WA per year, 1982–2026: 203 cases
19829
19839
19848
19854
198610
19878
19887
19898
19909
199113
19926
19936
199410
19955
19965
19977
19986
199912
20007
20016
20025
200311
200413
20055
20064
200710

Latest cases

Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
  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 SEA01LA007Accident · No injuriesLimited investigationFinal reportBeech N35 · Arlington, WAThe pilot's failure to abort the takeoff upon experiencing directional control difficulties. Factors included the pilot's failure or inability to maintain directional control, and a taxiway sign.Oct 23, 2000 · N1255Z · Substantial damageNTSB SEA00LA178Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Tacoma, WAThe pilot's inadequate compensation for winds and his failure to maintain directional control. Factors include a gusting crosswind.Sep 15, 2000 · N77948 · Substantial damageNTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.Aug 25, 2000 · N91464 · Substantial damageNTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.Jun 25, 2000 · N6775B · Substantial damageNTSB SEA00LA101Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bridgeport, WAAircraft control was not maintained. Inadequate remedial action and diverted attention were factors.Jun 8, 2000 · N49573 · Substantial damageNTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.Apr 2, 2000 · N2635K · Substantial damageNTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.Mar 28, 2000 · N4653C · Substantial damage