Final NTSB investigations
3,691 cases where the defining event was Loss of control on ground.
Cases per year
| 2008 | 225 |
|---|---|
| 2009 | 226 |
| 2010 | 191 |
| 2011 | 203 |
| 2012 | 235 |
| 2013 | 178 |
| 2014 | 169 |
| 2015 | 183 |
| 2016 | 214 |
| 2017 | 229 |
| 2018 | 236 |
| 2019 | 223 |
| 2020 | 198 |
| 2021 | 181 |
| 2022 | 190 |
| 2023 | 199 |
| 2024 | 189 |
| 2025 | 142 |
| 2026 | 80 |
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 c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
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 c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN26LA315Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · DeQuincy, LAThe pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.NTSB ERA26LA334Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Harvard III · Sanatoga, PAThe pilot’s failure to maintain control of the airplane while landing in a crosswind.NTSB CEN26LA305Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75L300 · Taylor, TXThe pilot’s failure to maintain directional control during landing.NTSB CEN26LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna Claassen 305A(0-1A) · Midland, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA301Accident · Serious injuriesClass 4 · LimitedFinal reportSpirit Engineering SE-1 · Ossipee, NHThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a nose over on the grass runway.NTSB ERA26LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 680 · Statesville, NCThe pilot’s failure to maintain directional control while landing in a strong gusting crosswind.NTSB ERA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Sanford, METhe pilot’s loss of directional control during landing and the flight instructor’s inadequate remedial action, which resulted in a ground loop.NTSB ERA26LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Middlefield, OHThe flight instructor’s failure to maintain directional control during landing.NTSB ERA26LA276Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries Pitts S-2 · Porter Center, NYThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR26LA261Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 STI · Greenwater, WAThe pilot’s failure to maintain directional control during the landing roll, in variable wind conditions.NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.NTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.NTSB WPR26LA243Accident · No injuriesClass 4 · LimitedFinal reportValerie Westedt Zenith Zodiac 650B · Colorado Springs, COThe pilot’s improper flare which resulted in a hard landing and their subsequent loss control of during a go-around. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR26LA248Accident · No injuriesClass 4 · LimitedFinal reportDean J Irvin KFA Safari XL · Saratoga, WYThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.NTSB WPR26LA239Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · El Cajon, CAThe pilot's failure to maintain directional control during landing with a right crosswind,.NTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB ERA26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Morganton, NCThe pilot and flight instructor’s failure to maintain directional control while maneuvering on the runway, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to complete a positive exchange of flight control following…NTSB WPR26LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A · Minden, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN26LA232Accident · Minor injuriesClass 4 · LimitedFinal reportRocky Mountain Kitplanes S-6S · Marvel, ARA partial blockage of the pitot static system that precluded the airspeed indicator from displaying the correct airspeed which led to the faster landing speed and bounced landing.NTSB WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA237Accident · No injuriesClass 4 · LimitedFinal reportSinclair Pete Lancair ES · Youngstown, OHThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with an approach lighting system.NTSB WPR26LA231Accident · No injuriesClass 4 · LimitedFinal reportRans S-7 Courier · Wessington Springs, SDThe pilot’s failure to maintain directional control during landing and subsequent go-around with a gusty right crosswind.NTSB WPR26LA208Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Pasco, WAThe pilot’s inadvertent excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA206Accident · No injuriesClass 4 · LimitedFinal reportPitts Special S-1S · Bartlesville, OKThe pilot’s failure to maintain control during the landing rollout and subsequent aborted landing.NTSB ERA26LA218Accident · No injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G600 · Birmingham, ALThe flight crew’s decision to continue the landing approach into adverse weather conditions, which resulted in a loss visual reference and loss airplane control during landing.NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB ERA26LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGranito Joseph R RV-7A · Jaffrey, NHThe pilot’s failure to maintain directional control of the airplane during landing, which resulted in a touchdown off the paved runway surface and a collision with terrain during the subsequent aborted landing.NTSB CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.NTSB WPR26LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Arco, IDThe pilot's failure to maintain directional control during the landing roll with a right crosswind.NTSB ERA26LA210Accident · No injuriesClass 4 · LimitedFinal reportJohn Bradley Vans RV-7 · Athens, GAContamination of the left wheel brake system with debris, which resulted in a loss of directional control during takeoff.NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB WPR26LA187Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sedona, AZThe pilot’s inability to maintain directional control due to a plastic foreign object jammed in the rudder pedals, while landing with a gusting left crosswind.NTSB CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB ERA26LA202Accident · No injuriesClass 4 · LimitedFinal reportSherry Grobstein LSA-8X · Hyannis, MAThe pilot’s failure to maintain control of the airplane while landing, which resulted in a ground loop and subsequent nose over.NTSB WPR26LA175Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Prineville, ORThe pilot's inability to maintain directional control during the landing roll due to a flat tire.NTSB ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.NTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.NTSB WPR26LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Carlsbad, CAThe student pilot’s failure to maintain airplane control while landing in gusting crosswind conditions.NTSB ERA26LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Lanett, ALThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a runway excursion and collision with taxiway sign.NTSB WPR26LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Española, NMThe pilot’s loss of of directional control during landing roll following an encounter with a dust devil.NTSB WPR26LA156Accident · No injuriesClass 4 · LimitedFinal reportMarshall Daniel R L-21 · Cody, WYThe pilot's failure to maintain control of the airplane during the landing rollout, which resulted in a nose-over.NTSB CEN26LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tahlequah, OKThe student pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.NTSB CEN26LA158Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Luverne, MNThe pilot’s failure to maintain directional control during a gusting crosswind landing, and the flight instructor’s delayed remedial action.NTSB CEN26LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing in gusty wind conditions.