NTSB investigations, 2024, WA
3 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 2024
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\" = '220' 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") = 2024 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" = '220' 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 WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.NTSB WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.NTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.