NTSB investigations, 2026, WA
6 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 19 |
| 2010 | 16 |
| 2011 | 28 |
| 2012 | 23 |
| 2013 | 12 |
| 2014 | 20 |
| 2015 | 23 |
| 2016 | 15 |
| 2017 | 20 |
| 2018 | 24 |
| 2019 | 17 |
| 2020 | 9 |
| 2021 | 2 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 3 |
| 2025 | 7 |
| 2026 | 6 |
Where
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\") = 2026
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.
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") = 2026 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
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 WPR26LA275Accident · Minor injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Works Mermaid Skeeter 2 · Cougar, WAOn July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.…NTSB WPR26LA272Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5A · Metaline Falls, WAThe pilot’s distracted attention on approach to landing on their failure to attain a proper touchdown point and his inability to stop the landing roll on the grass runway.,NTSB WPR26FA233Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 195 · Pasco, WAOn June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…NTSB WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR26LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Chehalis, WAThe pilot’s improper recovery from a bounced landing, which resulted in a tail strike.NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.