NTSB investigations, 2003, WA

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

Cases per year

19822026
NTSB investigations, 2003, 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\") = 2003
    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 SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.Oct 18, 2003 · N1841R · Substantial damageNTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.Oct 2, 2003 · N350ME · Substantial damageNTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.Sep 24, 2003 · N9913C · Substantial damageNTSB SEA03LA150Accident · No injuriesLimited investigationFinal reportCessna 185 · Sinclair Is., WAThe pilot's failure to maintain directional control while taxiing for takeoff. Factors contributing to the accident were the ditch and the fence.Jul 19, 2003 · C-FHMY · Substantial damageNTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.Jun 28, 2003 · N8070 · Substantial damageNTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.Jun 15, 2003 · N9566L · Substantial damageNTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.May 15, 2003 · N1977B · Substantial damageNTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.May 9, 2003 · N147DA · Substantial damageNTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…Apr 27, 2003 · N180MK · Substantial damageNTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.Feb 1, 2003 · N75392 · Substantial damageNTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.Jan 28, 2003 · N48769 · Substantial damage