NTSB investigations, 2025, WA

7 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2025, WA per year, 2008–2026: 283 cases
200826
200919
201016
201128
201223
201312
201420
201523
201615
201720
201824
201917
20209
20212
20227
20236
20243
20257
20266

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\") = 2025
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Sep 27, 2025 · N186X · Substantial damageNTSB WPR25FA294Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172F · Battle Ground, WAOn September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 26, 2025 · N8219U · DestroyedNTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..Sep 18, 2025 · N78316 · Substantial damageNTSB WPR25LA262Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Burlington, WAThe pilot’s failure to see and avoid the light pole, which resulted in a collision with the light pole and subsequent ground impact.Aug 18, 2025 · N877DR · Substantial damageNTSB WPR25LA155Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18-150 · Enumclaw, WAOn May 10, 2025, about 1412 Pacific daylight time, a Piper PA-18-150, N333TM, was substantially damaged when it was involved in an accident near Enumclaw, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…May 10, 2025 · N333TM · Substantial damageNTSB WPR25FA114Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206B II · Mountain Home Park, WAOn March 19, 2025, at 1228 Pacific daylight time, a Bell 206B II, N23SD, was substantially damaged when it impacted electrical cables and terrain near Mountain Home Park, Washington. The commercial pilot was fatally injured. The helicopter was operated as a…Mar 19, 2025 · N23SD · Substantial damageNTSB WPR25FA108Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A150L · Renslow, WAOn March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Mar 4, 2025 · N6167F · Destroyed