NTSB investigations, 2003, WA

6 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19822026
NTSB investigations, 2003, WA per year, 1982–2026: 145 cases
19823
198312
19843
19853
198611
19873
19884
19894
19903
19913
19924
19934
19945
199510
19964
19979
19987
19996
20009
20017
20023
20036
20044
20056
20067
20075

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\" = 130)
  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 SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.Sep 18, 2003 · N3555L · Substantial damageNTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…Jul 26, 2003 · N314KA · DestroyedNTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…Jul 22, 2003 · N996JR · Substantial damageNTSB SEA03LA128Accident · No injuriesLimited investigationFinal reportMooney M20-J · Renton, WAIn-flight failure of the electric landing gear motor during the initial takeoff climb.Jul 4, 2003 · N201DV · Substantial damageNTSB SEA03LA098Accident · No injuriesLimited investigationFinal reportCessna R182 · Kent, WAThe failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…Jun 12, 2003 · N7568T · Substantial damageNTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.Apr 12, 2003 · N125MZ · Substantial damage