NTSB investigations, 2019, WA
17 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\") = 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\" = '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") = 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" = '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 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 WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.NTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.NTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.NTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…NTSB WPR19LA200Accident · No injuriesClass 3 · LimitedFinal reportBeech 33 · Battleground, WAA failure of the throttle control assembly for reasons that could not be determined based on available evidence, which resulted in a runway overrun and impact with an obstacle.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 WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.NTSB WPR19LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Copalis, WAAn off-airport landing under circumstances that could not be determined based on the available information, which resulted in substantial damage to the airplane.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 GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.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.NTSB WPR19LA066Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA23 · Ellensburg, WAThe instrument rated pilot’s loss of control due to spatial disorientation.