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 ERA24LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Dyersburg, TNFailure of the tailwheel strut, which resulted in a loss of directional control during landing roll and a runway excursion.NTSB ANC24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a ground loop and nose over.NTSB ANC24LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Buckland, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ERA24LA381Accident · Minor injuriesClass 4 · LimitedFinal reportWalden Robert Vans Aircraft RV-7A · Williamsburg, VAThe pilot’s decision to continue with an unstabilized approach which resulted in a hard landing and loss of directional control during a subsequent landing.NTSB ERA24LA378Accident · No injuriesClass 4 · LimitedFinal reportBrandt Stirling D WAIEX-B · Stratford, CTThe pilot’s failure to maintain direction control of the airplane during a takeoff in crosswind conditions.NTSB CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB WPR24LA301Accident · No injuriesClass 4 · LimitedFinal reportThompson Ryan L Thompson Craft · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR24LA297Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Saint Johns, AZThe pilot’s improper landing flare that resulted in a hard landing.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB GAA24WA274Accident · 1 fatalClass 5 · ForeignPiper 38 · Córdoba, SpainNTSB CEN24LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Lawrence, KSThe pilot’s failure to maintain directional control during takeoff.NTSB WPR24LA292Accident · No injuriesClass 4 · LimitedFinal reportRonald J Mclaughlin Bearhawk Patrol · Shearer, IDThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 65-TAC · Clearwater, FLThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle…NTSB ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.NTSB WPR24LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Stanley, IDThe pilot’s loss of directional control in reduced visibility conditions due to a wind gust, which resulted in a collision with a trailer.NTSB ERA24LA356Accident · No injuriesClass 4 · LimitedFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer R80 · Charleston, WVThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind, which resulted in a ground loop and subsequent landing gear collapse.NTSB ERA24LA353Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Mohawk, NYThe pilot’s failure to maintain directional control during the landing roll in wet conditions, which resulted in a runway excursion and collision with a fence.NTSB CEN24LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Weslaco, TXThe student pilot’s failure to maintain control of the airplane during landing.NTSB CEN24LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Loveland, COThe pilot’s failure to maintain directional control during the landing, that resulted in a ground loop and a runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR24LA279Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Boise, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA24LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elkwood, VAThe pilot’s failure to correctly reinstall the airplane’s left seat, resulting in the movement of the seat during the takeoff roll, and the subsequent loss of control and runway excursion.NTSB ANC24LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Healy, AKThe pilot’s failure to maintain directional control during takeoff, in gusty wind conditions, resulting in a loss of control and a collision with trees.NTSB ERA24LA355Accident · No injuriesClass 4 · LimitedFinal reportYates Elden H Avipro Bearhawk · Roxbury, METhe pilot’s unstable approach which resulted in a landing with insufficient runway remaining to stop and subsequent impact with a river embankment. Contributing was the engine coolant system anomaly.NTSB ERA24LA345Accident · No injuriesClass 4 · LimitedFinal reportKlutts Joe A CUB · DeLand, FLThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Whitewright, TXThe pilot’s incomplete flare which resulted a hard, flat landing.NTSB ERA24LA343Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · North Kingstown, RIThe non-certificated pilot’s lack of experience in the tailwheel-equipped airplane and his decision to land in a quartering tailwind, which resulted in a loss of directional control on landing.NTSB CEN24LA324Accident · No injuriesClass 4 · LimitedFinal reportRans RV8 · Morris, ILThe student pilot’s failure to maintain directional control and the flight instructors delayed remedial action while landing with a gusty crosswind.NTSB ANC24LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control while landing at a short remote airstrip.NTSB ANC24LA076Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 · Skwentna, AKThe pilot's failure to maintain directional control during the landing roll.NTSB WPR24LA276Accident · No injuriesClass 4 · LimitedFinal reportMaule M4 · Scappoose, ORThe pilot’s loss of directional control after an encounter with a wind gust.NTSB CEN24LA300Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · South Park, INThe pilot’s failure to maintain airplane control during takeoff.NTSB ANC24LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Goose Bay, AKThe pilot's failure to maintain directional control during the landing roll.NTSB CEN24LA306Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cleveland, MSThe pilot’s failure to attain/maintain directional control and the flight instructor’s delayed remedial action during landing.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA289Accident · No injuriesClass 3 · LimitedFinal reportEvektor Aerotechnik EV97 · Midland, TXThe pilot’s failure to maintain directional control during taxi due to strong wind gusts.NTSB CEN24LA290Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Fort Worth, TXThe pilot’s decision to allow a non-rated passenger to manipulate the flight controls during the takeoff which resulted in a loss of directional control during the takeoff.NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB WPR24LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Camarillo, CAThe pilot’s loss of directional control during landing, which resulted in a nose over.NTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB CEN24LA283Accident · No injuriesClass 4 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Cahokia Heights, ILThe student pilot’s failure to maintain directional control during landing rollout that resulted in a lateral runway excursion and impact with a runway sign.NTSB ERA24LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Rural Retreat, VAA loss of directional control during the landing roll.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB ANC24LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Pedro Bay, AKThe pilot’s failure to maintain directional control of the airplane during takeoff. Contributing to the accident was sun glare.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA24LA316Accident · 1 fatalClass 3 · LimitedFinal reportSheaffer Leroy B Kitfox Model IV · Palmyra, PAThe pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.NTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.NTSB WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.NTSB CEN24LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188 · David City, NEThe pilot’s failure to maintain directional control during takeoff.NTSB WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.