NTSB investigations
4,590 cases where the sequence of events included 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 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 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 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 CEN25LA174Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Saint James, MNThe failure of the left main landing gear tire casing and tube due to excessive wear which resulted in a loss of directional control during the landing.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 CEN25LA171Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · South Saint Paul, MNThe student pilot’s inadvertent brake application during the touchdown, that resulted in abnormal runway contact and a loss of directional control. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot during the…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 CEN25LA173Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 180F · Duncan, OKOn April 30, 2025, about 1950 central daylight time, a Cessna 180F airplane, N2135Z, sustained substantial damage when it was involved in an accident at the Halliburton Field Airport (DUC), Duncan, Oklahoma. The pilot and passenger were not injured. The…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 WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.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 CEN25LA122Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Dallas, TXOn March 14, 2025, about 0738 central daylight time, a Cessna 208B airplane, N9471B, sustained substantial damage when it was involved in an accident at the Dallas-Fort Worth International Airport (DFW), Dallas, Texas. The pilot was not injured. The airplane…NTSB CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.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.NTSB ERA25LA108Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Ravenswood, WVThe pilot’s distraction during taxi, which resulted in a taxiway excursion.NTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN25LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Spearfish, SDThe pilot’s failure to land on the centerline of the snow-covered runway at night, which resulted in the left wing impacting a snowbank, a subsequent loss of directional control, and runway excursion.