NTSB investigations, 2010, TX
20 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
Latest 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\") = 2010
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") = 2010 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 CEN11CA126Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Hemphill, TXThe student pilot’s improper decision to carry an unauthorized passenger and the passenger’s loss of control of the helicopter during take-off.NTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN11CA121Accident · No injuriesData collectionFinal reportPiper J3C-65 · Cypress, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB CEN11CA019Accident · No injuriesData collectionFinal reportCessna 195 · Midland, TXThe private pilot’s loss of control during the landing roll and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.NTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.NTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.NTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.NTSB CEN10CA328Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Arcola, TXThe student pilot’s failure to maintain directional control of the tailwheel-equipped airplane during the landing roll.NTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.NTSB CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.NTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.NTSB CEN10CA213Accident · No injuriesData collectionFinal reportWaco YPF-7 · Houston, TXThe pilot's inability to maintain control during landing due to the failure of the tailwheel locking mechanism to remain engaged prior to landing.NTSB CEN10CA175Accident · No injuriesData collectionFinal reportVan Dusen John M Longeze · Houston, TXThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB CEN10CA167Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Sugar Land, TXThe pilot's failure to maintain a proper glidepath and rate of descent during approach, resulting in a hard landing.NTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.NTSB CEN10LA149Accident · Serious injuriesLimited investigationFinal reportStump Davis · Seguin, TXThe pilot's improper flare, which resulted in a bounced landing and noseover during a downwind landing.NTSB CEN10LA117Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Amarillo, TXThe pilot's loss of directional control while landing on an ice/snow covered runway.NTSB CEN10CA104Accident · No injuriesData collectionFinal reportCirrus SR22 · Fredericksburg, TXThe pilot's failure to maintain directional control during landing, and his failure to properly execute a go-around.