NTSB investigations, 2019, WA
6 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 9 |
| 2019 | 6 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
| 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\") = 2019
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\" = '060' 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") = 2019 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" = '060' 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 WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.NTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.NTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…NTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.