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 ANC24LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Skwentna, AKThe pilot’s failure to maintain directional control while taxiing, which resulted in a collision with trees.NTSB WPR24LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-11 · Death Valley, CAThe pilot’s failure to maintain directional control during the landing rollout, resulting in a ground loop and runway excursion.NTSB ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB DCA24FA120Accident · No injuriesClass 2 · FieldFinal reportBoeing 737-8 · Houston, TXThe captain's decision not to establish and maintain deceleration devices in accordance with company training and standard operating procedures.NTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB WPR24LA101Accident · Minor injuriesClass 4 · LimitedFinal reportUtah County Sheriff CCX-2000 · Spanish Fork, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Paragould, ARThe pilot’s failure to maintain directional control during landing.NTSB WPR24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Albuquerque, NMThe pilot’s loss of control during landing due to a flat tire. Contributing to the accident was the pilot’s failure to replace the worn tire in a timely manner.NTSB CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.NTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.NTSB ERA24LA123Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Moultonborough, NHThe pilots’ failure to maintain directional control of the airplane during the landing.NTSB GAA24WA316Incident · No injuriesClass 4 · ForeignCirrus Design SF50 · Costa-Brava, Ghardaïa, AlgeriaNTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.NTSB DCA24WA114Incident · No injuriesClass 5 · ForeignBoeing 737 · Charleroi, BelgiumNTSB WPR24LA102Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Truth or Consequences, NMThe pilot’s failure to maintain airplane control during approach and landing that resulted in a runway excursion and subsequent impact with a berm.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB CEN24LA118Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182P · Charleston, MSThe pilot’s failure to attain/maintain aircraft control during an approach for landing that resulted in an impact with terrain.NTSB WPR24LA097Accident · No injuriesClass 4 · LimitedFinal reportMark G Ellingson Kitfox IV · Mesa, AZThe pilot’s failure to maintain directional control during landing.NTSB WPR24LA089Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Madera, CAThe pilot’s failure to maintain directional control during landing.NTSB ERA24LA112Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30 · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind.NTSB ERA24LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301T · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll in a gusting crosswind.NTSB GAA24WA138Accident · No injuriesClass 5 · ForeignCessna C208 · Ilaga, IndonesiaNTSB CEN24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Hayward, WIThe pilot’s loss of control during landing rollout.NTSB ERA24LA107Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Elizabethtown, NCThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, right main landing gear collapse, and a collision with a ditch.NTSB ERA24LA100Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Orlando, FLThe failure of the pilot flying to maintain directional control after touchdown with wind gusts that exceeded the airplane’s crosswind limitation. Contributing to the accident were the flightcrew’s continued approach to the runway despite the consistent wind…NTSB WPR24LA079Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Featherville, IDThe pilot's failure to maintain directional control during taxi, which resulted in a runway excursion and impact with terrain.NTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.NTSB WPR24LA077Accident · Minor injuriesClass 4 · LimitedFinal reportDennis Smith Eclipse 10 · Yuma, AZThe pilot’s decision to takeoff with low rotor RPM and his subsequent loss of control.NTSB WPR24LA075Accident · Serious injuriesClass 3 · LimitedFinal reportHarmon Rocket II · Mesquite, NVThe pilot’s loss of control on the landing roll, which led to the airplane coming to rest inverted.NTSB CEN24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lampasas, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Middleton, WIThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN24LA081Accident · No injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Beaumont, TXThe pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a ground loop on the runway.NTSB WPR24LA061Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Prescott, AZLoss of directional control during landing due to an improperly constructed and maintained tailwheel locking assembly.NTSB CEN24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Ponca City, OKThe pilot’s loss of directional control during landing in gusty crosswind conditions.NTSB CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.NTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.NTSB ERA24LA052Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Martinsville, VAThe pilot’s failure to maintain directional control during a wheel landing in crosswind conditions and the flight instructor’s delayed remedial action, which resulted in a ground loop on the runway.NTSB ERA24LA051Accident · No injuriesClass 3 · LimitedFinal reportLancair 235 · Stuart, FLA landing gear collapse due to a hydraulic fluid leak in the landing gear system.NTSB WPR24LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170B · Cameron Park, CAA failure of the right brake master cylinder piston due to a faulty return spring, which resulted in a seized right main landing gear brake and a runway excursionNTSB CEN24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · DeWitt, ARThe pilot’s loss of airplane directional control while landing.NTSB CEN24LA043Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Four · Eau Claire, WIThe pilot’s failure to maintain directional control during landing.NTSB ANC24LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · McCarthy, AKThe pilot’s loss of directional control after touchdown which resulted in substantial damage to the right wing.NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA24LA042Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ogdensburg, NYThe loss of control of the helicopter during taxi, which resulted in rollover.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN24LA040Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Mountain View, ARThe sport pilot’s poor decision to allow a noncertificated pilot to land the airplane which resulted in a loss of control during landing.