NTSB investigations, 2021, WA
4 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2021
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\" = '342' 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") = 2021 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" = '342' 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 WPR21LA351Accident · No injuriesClass 4 · LimitedFinal reportGeorge A. Thiel Just Aircraft Highlander · Monroe, WAThe in-flight malfunction of the throttle control pivot arm, which resulted in a total loss of engine power and the subsequent collision with terrain during the forced landing.NTSB WPR21LA172Accident · No injuriesClass 4 · LimitedFinal reportMichael J Robbins Searey · Friday Harbor, WAPartial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.NTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…NTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.