NTSB investigations, 2011, WA
10 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 16 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 5 |
| 2016 | 12 |
| 2017 | 9 |
| 2018 | 16 |
| 2019 | 9 |
| 2020 | 4 |
| 2021 | 14 |
| 2022 | 3 |
| 2023 | 9 |
| 2024 | 4 |
| 2025 | 11 |
| 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\" = '230' 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" = '230' 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 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 WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.NTSB WPR11CA247Accident · No injuriesData collectionFinal reportSieber Paul P Nieuport 11 · Bellingham, WAThe pilot's failure to maintain directional control during landing rollout.NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB WPR11CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Kahlotus, WAThe pilot's failure to maintain directional control during takeoff.NTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.