NTSB investigations, 2009
274 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 262 |
|---|---|
| 2009 | 274 |
| 2010 | 235 |
| 2011 | 242 |
| 2012 | 287 |
| 2013 | 216 |
| 2014 | 192 |
| 2015 | 236 |
| 2016 | 295 |
| 2017 | 284 |
| 2018 | 303 |
| 2019 | 273 |
| 2020 | 232 |
| 2021 | 217 |
| 2022 | 223 |
| 2023 | 236 |
| 2024 | 231 |
| 2025 | 186 |
| 2026 | 166 |
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\") = 2009
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") = 2009 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 CEN10CA086Accident · No injuriesData collectionFinal reportHoover Frank RV-8 · Houma, LAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.NTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…NTSB WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.NTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.NTSB ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.NTSB CEN10CA062Accident · No injuriesData collectionFinal reportCessna 172S · Mt. Comfort, INThe pilot's failure to maintain directional control of the airplane while touching down during the landing.NTSB ERA10CA083Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 · Indian Key, FLThe pilot's failure to secure the collective control prior to departing the helicopter, which resulted in an unmanned departure and subsequent crash of the helicopter.NTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN10CA061Accident · No injuriesData collectionFinal reportCessna 305A · Rochester, INThe pilot's failure to maintain directional control during landing.NTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.NTSB WPR10CA061Accident · Minor injuriesData collectionFinal reportBoeing A75N1 · Deer Valley, AZThe pilot's failure to maintain directional control.NTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.NTSB ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.NTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.NTSB ERA10CA061Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Clarksville, TNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.NTSB WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.NTSB CEN10CA048Accident · No injuriesData collectionFinal reportCessna 150L · Galion, OHThe student pilot's failure to maintain directional control.NTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB WPR10CA041Accident · No injuriesData collectionFinal reportCessna 180 · Bountiful, UTThe failure of the inner tube of the right main tire during the landing roll.NTSB WPR10LA040Accident · Serious injuriesLimited investigationFinal reportHallbauer Dragonfly Mark II · Las Vegas, NVThe CFI's failure to maintain directional control of the airplane during takeoff.NTSB WPR10CA038Accident · No injuriesData collectionFinal reportMooney M20F · Palm Springs, CAThe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.NTSB CEN10CA033Accident · No injuriesData collectionFinal reportCessna 172N · Marysville, OHThe student pilot's failure to maintain directional control during landing.NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.NTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.NTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.NTSB WPR10CA024Accident · No injuriesData collectionFinal reportCessna A185F · Sand Coulee, MTThe pilot's failure to maintain directional control during landing with a crosswind.NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.NTSB CEN10CA109Accident · No injuriesData collectionFinal reportSkistmas George Pietnpol Aircamper · Toledo, OHThe pilot's failure to maintain directional control during landing.NTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.NTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.NTSB CEN10CA020Accident · No injuriesData collectionFinal reportFranklin Pitts Special S-1 · Alamosa, COThe pilot’s failure to maintain directional control on takeoff.NTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.NTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR10LA004Accident · No injuriesLimited investigationFinal reportCessna 172A · Payson, AZThe stress corrosion cracking of the nose gear landing fork, which resulted in the fork's failure during landing.NTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.NTSB WPR09LA472Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · Fresno, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.NTSB ANC09CA107Accident · No injuriesData collectionFinal reportPiper PA-20 · Fairbanks, AKThe student pilot's decision to attempt an off-airport landing and his failure to maintain directional control during the landing roll.NTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB ANC09CA109Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series · Skwentna, AKThe pilot's failure to maintain directional control while landing on a rough, soft, and narrow airstrip.