NTSB investigations, 2011, WA
28 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 | 8 |
| 2026 | 6 |
Where
Open the mapLatest 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\") = 2011
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") = 2011 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 WPR12LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.NTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.NTSB WPR12FA010Accident · 1 fatalField investigationFinal reportDG Flugzeugbau DG 1000S · Cle Elum, WAThe pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.NTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.NTSB WPR11CA464Accident · No injuriesData collectionFinal reportCessna 180 · Orcas Island, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR11LA369Accident · No injuriesLimited investigationFinal reportCessna 140 · Wilkeson, WAA partial loss of engine power during takeoff due to water contamination in the fuel system.NTSB WPR11FA367Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Camas, WAThe pilot's failure to maintain control of the airplane while maneuvering in the traffic pattern.NTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11LA356Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Brewster, WAThe pilot did not maintain main rotor rpm while hovering in gusting wind conditions.NTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB WPR11LA340Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lopez, WAA partial loss of engine power due to a cracked engine case near the rear cylinder.NTSB WPR11LA325Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wenatchee, WAThe pilot's failure to maintain control while hovering out of ground effect at low altitude, which resulted in the helicopter settling into trees.NTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB WPR11CA294Accident · No injuriesData collectionFinal reportCessna 172N · Olympia, WAThe pilot's failure to maintain clearance from obstacles.NTSB WPR11CA261Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAThe pilot's failure to maintain clearance from power lines while maneuvering.NTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.NTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB WPR11CA191Accident · No injuriesData collectionFinal reportCessna 172N · Snohomish, WAThe pilot's failure to maintain clearance from a hangar while taxiing.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR11LA168Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Puyallup, WAThe pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.NTSB WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.