NTSB investigations, 2003, WA

5 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 2003, WA per year, 1982–2026: 167 cases
19828
198310
19846
19858
19863
19874
19883
19898
19907
19915
199212
19937
19948
19955
19966
19971
19989
19997
200010
20014
20027
20035
20049
20056
20062
20077

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\" = 220)
  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 SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…Nov 29, 2003 · N439AF · DestroyedNTSB SEA03CA200Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Basin City, WAClearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.Sep 30, 2003 · N4451Z · Substantial damageNTSB SEA03LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Newman Lake, WAThe pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.Jul 17, 2003 · N16GL · Substantial damageNTSB SEA03LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stuart Island, WAThe pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.Jul 10, 2003 · N125ER · Substantial damageNTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…Jun 12, 2003 · N8468V · Substantial damage