NTSB investigations
3,844 cases where the defining event was Loss of control on ground.
Cases, newest first
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.\"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."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 WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB ANC25LA047Accident · No injuriesClass 4 · LimitedFinal reportBrian Peck RV-14 · Camas, WAThe pilot’s failure to maintain directional control during landing roll which resulted in a runway excursion.NTSB ANC25LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Flagstaff, AZThe pilot’s failure to maintain directional control during takeoff in variable and gusty wind, which resulted in a ground loop.NTSB ANC25LA048Accident · No injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Mojave, CAThe pilot’s failure to maintain directional control during landing roll.NTSB ERA25LA374Accident · No injuriesClass 4 · LimitedFinal reportFlying Cloud AL18 · Ridgeland, SCThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN25FA197Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502 · Grady, AROn June 6, 2025, about 1830 central daylight time, an Air Tractor AT-502 airplane, N9185F, was substantially damaged when it was involved in an accident near Grady, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB WPR25LA168Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Port Townsend, WAThe flight instructor’s delayed remedial action and inadequate compensation for shifting wind conditions which resulted in a veer off the runway and collision with a sign.NTSB CEN25LA190Accident · Minor injuriesClass 4 · LimitedFinal reportNelson Special · Hope, ARThe pilot’s failure to maintain airplane control during the landing roll.NTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB ANC25LA040Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · San Luis Obispo, CAThe pilot's failure to maintain directional control during takeoff.NTSB WPR25LA158Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Butte City, CAThe pilot’s use of engine beta prior to ensuring the tailwheel was on the ground during landing roll.NTSB WPR25LA151Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Port of Del Bonita, MTThe pilot’s loss of directional control while landing in gusting wind conditions.NTSB WPR25LA191Accident · No injuriesClass 4 · LimitedFinal reportJeremy S Lezin Just Superstol · Owyhee, ORThe pilot’s failure to maintain directional control during landing.NTSB WPR25LA150Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC19-180 · San Diego, CAThe pilot's failure to maintain directional control during landing roll.NTSB WPR25LA149Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Mojave, CAThe pilot’s exceedance of the airplane’s critical angle of attack during climb out from an aborted landing.NTSB ERA25LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Stevensville, MDThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion.NTSB WPR25LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Placerville, CAThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA141Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Placerville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA25LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Oxford, METhe flight instructor’s failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB ERA25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Bethlehem, PAThe student pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.NTSB ERA25LA180Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8F · Punta Gorda, FLThe pilot’s failure to maintain direction control of the airplane during the landing roll.NTSB WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB WPR25LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oakland, CAThe pilot’s failure to maintain directional control during takeoff roll with a left crosswind.NTSB CEN25LA152Accident · No injuriesClass 4 · LimitedFinal reportCorben Junior ACE · Jeanerette, LAThe pilot’s failure to maintain airplane control during the landing roll.NTSB ANC25LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the lake and collided with terrain.NTSB CEN25LA153Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Wausau, WIThe pilot’s failure to maintain directional control while landing in shifting wind conditions.NTSB CEN25LA150Accident · No injuriesClass 4 · LimitedFinal reportSilvaire 8F · Fairbury, NEThe pilot’s failure to maintain directional control while landing and the flight instructors delayed remedial action.NTSB ANC25LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Manley Hot Springs, AKThe student pilot’s failure to maintain directional control during the landing roll on a snow and ice-covered runway, which resulted in a runway excursion and subsequent nose over.NTSB WPR25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Madras, ORThe pilot’s loss of control during landing roll with gusty winds.NTSB WPR25LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · San Carlos, CAThe pilot's failure to maintain directional control during landing roll with crosswind conditions.NTSB CEN25LA137Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Rusk, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA121Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Tracy, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA25LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Anderson, SCThe pilots’ overcorrection during the landing roll which resulted in a loss of directional control and runway excursion. Contributing was the flight instructor’s inability to correct the pilot’s actions because due to brakes only being installed on the…NTSB ERA25LA152Accident · No injuriesClass 4 · LimitedFinal reportMaule M7 · Birdsboro, PAThe pilot’s decision to land with a quartering tailwind in shifting wind conditions, which resulted in a loss of control and nose-over.NTSB WPR25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Henderson, NVThe pilot’s failure to maintain directional control during the landing, in gusting crosswind conditions.NTSB CEN25LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna P206 · Frankston, TXThe pilot’s failure to maintain directional control during the landing with a gusting crosswind.NTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.NTSB ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.NTSB WPR25LA106Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Heber City, UTThe pilot’s loss of directional control during landing, which resulted in a collision with a snowbank.NTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxnard, CAThe student pilot’s failure to maintain directional control during landing roll.NTSB ERA25LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Culpeper, VAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll, resulting in a runway excursion.NTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.