NTSB investigations, 2012, TX
13 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 17 |
| 2010 | 20 |
| 2011 | 16 |
| 2012 | 13 |
| 2013 | 16 |
| 2014 | 14 |
| 2015 | 17 |
| 2016 | 28 |
| 2017 | 12 |
| 2018 | 18 |
| 2019 | 15 |
| 2020 | 19 |
| 2021 | 10 |
| 2022 | 25 |
| 2023 | 23 |
| 2024 | 15 |
| 2025 | 11 |
| 2026 | 16 |
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\" = 'TX' 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" = 'TX' 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 CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.NTSB CEN13CA053Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bryan, TXThe pilot’s over-correction in an attempt to stabilize the helicopter during liftoff.NTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.NTSB CEN12CA614Accident · No injuriesData collectionFinal reportCessna L-19E · Lancaster, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN12CA372Accident · No injuriesData collectionFinal reportCessna TP206A · Alpine, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.NTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN12CA303Accident · No injuriesData collectionFinal reportCessna 182S · Houston, TXThe student pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB CEN12CA292Accident · No injuriesData collectionFinal reportRisher Jimmy E Vans Aircraft RV-8 · Pecos, TXThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN12CA226Accident · No injuriesData collectionFinal reportRuiz E RAF 2000 · Anahuac, TXThe student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12CA201Accident · No injuriesData collectionFinal reportJoy Vans RV-6 · McKinney, TXThe pilot did not maintain control of the airplane during takeoff, which resulted in a ground collision with airport construction materials.NTSB CEN12CA190Accident · No injuriesData collectionFinal reportCessna A185F · Fort Worth, TXThe pilot did not maintain directional control of the airplane while landing in gusty wind conditions.NTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.