NTSB investigations, 2022, WA
7 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\") = 2022
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") = 2022 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 WPR23LA019Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne SeaRey · Lake Isabel, WAThe pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB WPR22LA218Accident · Serious injuriesClass 4 · LimitedFinal reportAir Creation USA Skypper · Toledo, WAThe pilot’s improper control input during landing which resulted in an exceedance of the aircraft’s critical angle of attack, aerodynamic stall and impact with the ground.NTSB WPR22LA204Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Snohomish, WAThe total loss of engine power during takeoff due to fuel starvation and the pilot’s improper fuel tank selection and inadequate preflight inspection.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.