NTSB investigations, 2015, AL
7 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2014 | 3 |
| 2015 | 7 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2025 | 1 |
| 2026 | 3 |
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\") = 2015
AND c.\"eventStateOrRegion\" = 'AL' 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") = 2015 AND c."eventStateOrRegion" = 'AL' 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 GAA16CA068Accident · No injuriesData collectionFinal reportAviat A-1C · Hurtsboro, ALThe pilot's incorrect use of brake pressure during the landing roll, which resulted in a nose over.NTSB ERA15LA296Accident · No injuriesLimited investigationFinal reportBell 47G 3B 1 · Camden, ALA failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.NTSB GAA15CA213Accident · No injuriesData collectionFinal reportCessna A185F · Dauphin Island, ALThe pilot's loss of directional control during the landing roll in gusty wind conditions which resulted in a ground loop and impact with terrain.NTSB GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.NTSB ERA15CA188Accident · Minor injuriesData collectionFinal reportP&M Pulsr · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in a collision with the ground.NTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.NTSB ERA15LA097Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe student pilot’s failure to maintain airplane control after engine start, which resulted in a ground collision with trees.