NTSB investigations, 2016, AZ
6 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 17 |
| 2010 | 10 |
| 2011 | 19 |
| 2012 | 17 |
| 2013 | 8 |
| 2014 | 12 |
| 2015 | 8 |
| 2016 | 6 |
| 2017 | 12 |
| 2018 | 21 |
| 2019 | 13 |
| 2020 | 10 |
| 2021 | 5 |
| 2022 | 17 |
| 2023 | 9 |
| 2024 | 7 |
| 2025 | 7 |
| 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\") = 2016
AND c.\"eventStateOrRegion\" = 'AZ' 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") = 2016 AND c."eventStateOrRegion" = 'AZ' 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 WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.NTSB GAA16CA461Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Sedona, AZThe pilot’s failure to maintain directional control during the landing in gusting wind conditions, which resulted in a runway excursion.NTSB GAA16CA404Accident · No injuriesData collectionFinal reportCessna 177 · Wickenburg, AZThe pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.NTSB GAA16CA318Accident · No injuriesData collectionFinal reportEurocopter EC120 · Ajo, AZThe pilot's decision to exit the helicopter with the engine and rotors turning and the selection of unsuitable terrain for a landing, which resulted in a roll over.NTSB GAA16CA190Accident · No injuriesData collectionFinal reportMonocoupe 110 · Chandler, AZThe pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.NTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.