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 ERA24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Richmond, VAThe pilot’s failure to maintain directional control of the airplane while landing in rain and gusting wind conditions.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA24WA228Accident · No injuriesClass 5 · ForeignPiper PA-28-181 · Beccles, United KingdomNTSB ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.NTSB WPR24LA220Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Cedar City, UTThe pilot’s failure to maintain directional control during the landing roll, with gusty tailwind.NTSB ANC24LA055Accident · No injuriesClass 4 · LimitedFinal reportGippsland GA-8 · Tuntutuliak, AKThe pilot's failure to maintain directional control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB ANC24LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tok, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.NTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.NTSB CEN24LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Schriever, LAThe pilot’s inadvertent application of the toe brakes during the takeoff roll.NTSB ERA24LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hernando, FLThe pilot’s inadvertent throttle input during landing which resulted in a runway overrun.NTSB CEN24LA232Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Ruston, LAThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA231Accident · No injuriesClass 4 · LimitedFinal reportFoskett James J CH 750 Cruiser · East Troy, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB WPR24LA203Accident · No injuriesClass 4 · LimitedFinal reportJoseph H Mason Bearhawk Patrol · Twin Falls, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Murphysboro, ILThe pilot’s failure to maintain directional control during landing.NTSB ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA224Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 RES · Elbert, COThe pilot’s failure to maintain directional control during the landing with a right crosswind.NTSB CEN24LA225Accident · No injuriesClass 4 · LimitedFinal reportRobert L Staton Javron INC PA-18 REP · Schell City, MOThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway surface.NTSB WPR24LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Nampa, IDLoss of directional control during the takeoff roll.NTSB WPR24LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Fernley, NVThe pilot’s failure to maintain directional control during gusting wind conditions.NTSB CEN24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Ada, OKThe student pilot’s failure to maintain directional control during landing resulting in a runway excursion and impact with a sign.NTSB ERA24LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Painted Post, NYThe pilot’s failure to maintain directional control of the airplane during an aborted landing, which resulted in runway excursion and collision with a ditch.NTSB ANC24LA050Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Bethel, AKThe pilot's failure to maintain directional control during landing which resulted in a ground loop.NTSB CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB WPR24LA168Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Hooper, UTThe inadvertent application of brakes during landing that resulted in a nose over.NTSB ERA24LA238Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Geneseo, NYThe pilot’s failure to maintain directional control during the takeoff roll resulting in a runway excursion, and subsequent nose over.NTSB ANC24LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 170A · Willow, AKThe pilot’s failure to maintain directional control during landing roll, resulting in a ground loop and substantial damage to the airplane.NTSB ANC24LA044Accident · No injuriesClass 4 · LimitedFinal reportJordan Harry James Sportsman 2+2 · Fairbanks, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA177Accident · No injuriesClass 3 · LimitedFinal reportBanes John Scott Kitfox Series 6 · Parowan, UTThe pilot’s inability to control the airplane during landing due to tailwheel assembly damage sustained during a previous shimmy event that occurred for reasons that could not be determined based on the available evidence.NTSB WPR24LA176Accident · No injuriesClass 4 · LimitedFinal reportOklahoma Fat Tire Flyers CCX-2000 · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in aground loop.NTSB ERA24LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · Palmetto, FLThe pilot’s improper decision to re-attempt a takeoff with little runway remaining, after rejecting a takeoff in gusting wind conditions, which resulted in a runway overrun at a higher speed and collision with terrain.NTSB WPR24LA169Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Hillsboro, ORThe pilot’s failure to maintain direction control during the landing roll with a left crosswind.NTSB CEN24LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Forest Lake, MNThe flight instructor’s delayed remedial action and failure to maintain aircraft control during the simulated forced landing.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC24LA041Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Knik, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB WPR24LA165Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Rome, ORThe pilot’s failure to maintain airplane control during landing.NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB CEN24LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Midland, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s failure to take remedial action.NTSB ANC24LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 190 · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a failure of the right main landing gear and subsequent ground loop.NTSB ANC24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Afton, WYThe commercial pilot’s failure to maintain directional control of the airplane during takeoff. Contributing was the student pilot’s application of brakes during the takeoff roll and the failure of both pilots to maintain a positive transfer of controls.NTSB CEN24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Sealy, TXThe pilot’s failure to maintain directional control during the takeoff, that resulted in an impact with a tree and the ground.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.NTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.NTSB WPR24LA145Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot’s failure to maintain directional control during takeoff with a gusty crosswind.NTSB ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.