NTSB investigations, 2012, GA
5 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 2 |
| 2010 | 8 |
| 2011 | 2 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 6 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
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\") = 2012
AND c.\"eventStateOrRegion\" = 'GA' 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") = 2012 AND c."eventStateOrRegion" = 'GA' 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 ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB ERA12LA315Accident · No injuriesLimited investigationFinal reportBerry Dean Glasair I · Columbus, GAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…NTSB ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.NTSB ERA12CA235Accident · No injuriesData collectionFinal reportPiper J3C-65 · Douglas, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's lack of experience in the tailwheel-equipped airplane.NTSB ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.