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 GAA26WA180Incident · Minor injuriesClass 5 · ForeignCostruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican RepublicNTSB 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 ERA26LA186Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172M · Crystal River, FLNTSB 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 ERA26LA183Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421 · Richmond, VAOn April 18, 2026, about 1410 eastern daylight time, a Cessna 421C, C-GTGR, was substantially damaged when it was involved in an accident near Richmond, Virginia. The pilot and four passengers were uninjured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA172Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Dry Tortugas, FLOn April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of…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 WPR26LA157Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T182 · Marion, MTOn April 8, 2026, about 1315 mountain standard time, a Cessna T182, N5475N, was substantially damaged when it was involved in an accident near Marion, Montana. Both pilots were uninjured. The airplane was operated as a Title 14 Code of Federal Regulations…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.NTSB ERA26LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Mount Pleasant, SCThe airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.NTSB CEN26LA152Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Boulder, COThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB ERA26LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Bessemer, ALThe pilot’s loss of directional control during the landing roll.NTSB CEN26LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Beloit, KSThe pilot’s failure to maintain directional control during the landing with a quartering headwind. Contributing to the accident was the pilot’s runway selection based on the variable and gusting wind conditions.NTSB WPR26LA137Accident · No injuriesClass 4 · LimitedFinal reportSalt Lake Gyrocopters Calidus · Fairfield, UTThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was nose wheel misalignment at touchdown.NTSB WPR26LA138Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Mesa, AZThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB ERA26LA154Accident · Minor injuriesClass 4 · LimitedFinal reportBeech V35 · Saluda, SCThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, collision with a fence, and a hard landing .NTSB WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN26LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Denton, TXThe pilot’s failure to maintain control of the airplane while in the run-up area in high wind conditions.NTSB CEN26LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Solon Springs, WIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA135Accident · No injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Trinidad, CONTSB CEN26LA127Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B36TC · Durango, COThe pilot’s improper landing flare and subsequent loss of directional control while attempting to land during high crosswind conditions.NTSB ERA26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Gettysburg, PAThe flight instructor’s failure to identify the excess power required to lift off from soft and muddy ground, which resulted in a loss of control and subsequent collision with a hangar during takeoff.NTSB WPR26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Kneeland, CAThe pilot’s failure to maintain airplane control during landing roll on a snow-covered runway.NTSB CEN26LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Pottsboro, TXThe pilot’s failure to maintain control during the landing roll with a crosswind.NTSB CEN26LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Antigo, WIThe pilot receiving instruction’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR26LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Three Forks, MTThe pilot’s failure to maintain directional during the landing roll with a variable wind.NTSB CEN26LA117Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · De Smet, SDThe pilot’s failure to maintain directional control during landing.NTSB ERA26LA128Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C23 · Knoxville, TNThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collision with a ditch.NTSB CEN26LA113Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Des Moines, IAThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a loss of directional control and a runway excursion.NTSB WPR26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Nampa, IDThe pilot’s failure to verify that the seat locking pins were fully engaged before takeoff, which allowed the seat to slide aft during the takeoff roll and resulted in a loss of directional control.NTSB WPR26LA096Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · St. George, UTThe pilot’s improper application of brakes, which resulted in a nose over.NTSB CEN26LA104Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Augusta, KSThe student pilot’s failure to maintain control during the takeoff.NTSB ERA26LA099Accident · No injuriesClass 4 · LimitedFinal reportFrankewich Walter S-21 Outbound · Madisonville, TNThe pilot’s failure to compensate for gusty crosswind conditions during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB WPR26LA084Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Cody, WYThe pilot's failure to maintain directional control during landing roll.NTSB DCA26LA102Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Kodiak, AKThe reduced surface friction of the contaminated ramp which led to a loss of directional control during taxi.NTSB CEN26LA091Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Burnet, TXThe pilot’s improper judgement to relinquish his pilot responsibilities to the passenger with the engine operating, which resulted in a loss of airplane control and impact with a parked vehicle.NTSB WPR26LA080Accident · No injuriesClass 3 · LimitedPreliminary reportFairchild SA227-AC · Prescott, AZOn January 13, 2026, about 0624 mountain standard time, a Fairchild SA227-AC airplane, N370AE, was substantially damaged when it was involved in an accident near Prescott Municipal Airport (PRC), Prescott, Arizona. The pilot was not injured. The airplane was…NTSB CEN26LA090Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 750 · Mountain Village, COOn January 13, 2026 about 1220 mountain standard time, a Cessna 750, N772XJ, was substantially damaged when it was involved in an accident near Mountain Village, Colorado. The pilots and passenger were not injured. The airplane was operated under the…NTSB CEN26LA088Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Early, TXThe unsecured cup holder that restricted left rudder pedal movement, which resulted in a loss of directional control during landing roll.NTSB GAA26WA071Accident · No injuriesClass 5 · ForeignCessna 208 · Nuwara Eliya, Sri LankaNTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 414A · Tampa, FLThe pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.NTSB CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.NTSB CEN26LA075Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Guthrie, OKThe pilot's failure to maintain directional control during landing with a quartering left crosswind.NTSB ERA26LA081Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Louisburg, NCThe pilot’s failure to compensate for gusting crosswind conditions and subsequent loss of directional control following an aborted go-around attempt, which resulted in a runway excursion.