NTSB investigations, WA
21 cases where the sequence of events included Ground collision.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest 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 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\" = '200' 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.
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 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" = '200' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR26LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Eastsound, WAOn July 23, 2026, about 1720 Pacific daylight time, a De Havilland DHC-3 Otter airplane, N709KA, was substantially damaged when it was involved in an accident near Eastsound, Washington. The pilot and two passengers were seriously injured, and eight…NTSB WPR25LA172Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Spokane Valley, WAThe pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.NTSB DCA25LA117Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-832 · Seattle, WAThe Japan Airlines flight crew’s failure to maintain adequate clearance from the parked Delta Air Lines aircraft while taxiing in congested ramp conditions.NTSB WPR24LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Seattle, WAThe Gulfstream pilot’s failure to maintain clearance from the Cessna while taxiing that resulted in a ground collision.NTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.NTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.NTSB GAA17CA458Accident · No injuriesData collectionFinal reportRandall Marvin L Vans RV 3A · Spokane, WAThe other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.NTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.NTSB WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.NTSB WPR11CA294Accident · No injuriesData collectionFinal reportCessna 172N · Olympia, WAThe pilot's failure to maintain clearance from obstacles.NTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.NTSB WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.NTSB WPR10LA198Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. G-1159 · Seattle, WAThe failure of the pilot to maintain adequate clearance/distance from the fuel truck during taxi.NTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB WPR09FA068Accident · No injuriesField investigationFinal reportBoeing 757-351 · Seattle, WAThe failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…NTSB SEA08CA115Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Twisp, WAThe pilot's failure to maintain adequate clearance from a ground obstacle while taxiing.