NTSB investigations
3,845 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 WPR22LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Gila Bend, AZThe pilot's failure to maintain directional control during the landing rollNTSB GAA22WA092Accident · No injuriesClass 5 · ForeignPiper PA-46 · Ontario, CanadaNTSB ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.NTSB CEN22LA112Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Hortonville, WIThe loss of direction control while maneuvering off the plowed surface to avoid a collision with a vehicle.NTSB WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.NTSB WPR22LA082Accident · No injuriesClass 4 · LimitedFinal reportWight Albert A Kitfox Speedster · Shelton, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.NTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.NTSB CEN22LA101Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6C · San Antonio, TXThe pilot’s loss of directional control during landing.NTSB WPR22LA088Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Phoenix, AZThe failure of the right brake due to the separation of the brake pad from the brake assembly. Also causal was the improper maintenance of the airplane, which resulted in the use of a brake pad that was inappropriate for the airplane make and model.NTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB WPR22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Creswell, ORThe pilot’s excessive left brake pedal application during landing roll, which resulted a loss of directional control, runway excursion, and nose over.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.NTSB CEN22LA097Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1B · Matagorda Island, TXThe pilot’s loss of directional control during an intentional off-airport landing.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB WPR22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Mojave, CAThe pilot’s failure to maintain airplane control during an encounter with a wind gust during taxi.NTSB WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22LA051Accident · No injuriesClass 4 · LimitedFinal reportTravel Air 4-D · Riverside, CAThe pilot's failure to abort a high-speed taxi in time before the airplane exited the end of the airstrip which resulted in the pilot’s over application of the brakes and subsequent nose over.NTSB ERA22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Kissimmee, FLThe pilot’s inadvertent application of brakes during touchdown, which resulted in a noseover.NTSB ERA22LA079Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Cornelia, GAThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB WPR22LA052Accident · No injuriesClass 4 · LimitedFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Fairfield, UTThe pilot's failure to maintain directional control during takeoff with a right crosswind.NTSB ERA22LA093Accident · No injuriesClass 4 · LimitedFinal reportTecnam P92 · Apopka, FLThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a runway excursion and impact with a hangar.NTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB ERA22LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna/Air Repair 305F · Anne Arundel, MDThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and substantial damage.NTSB ERA22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Newport Richie, FLA loss of directional control on landing for undetermined reasons.NTSB CEN22LA030Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G36 · Frankenmuth, MIThe pilot’s failure to maintain directional control while landing on a wet grass strip.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22LA027Accident · No injuriesClass 4 · LimitedFinal reportSanta Fe CCX-2300 · Taos, NMThe pilot’s failure to maintain directional control during a landing roll, which resulted in a ground loop and impact with the ground.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB CEN22LA028Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Greeley, COThe pilot’s loss of directional control during the landing roll.NTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.NTSB ERA22LA027Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB500 · Orlando, FLThe pilot's inadvertent application of the right brake during the landing roll, which resulted in a loss of directional control and a subsequent runway excursion.NTSB ANC22LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Juneau, AKThe pilot’s loss of directional control for reasons that could not be determined.NTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.NTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.NTSB WPR22LA008Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Garberville, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with an unoccupied parked airplane.NTSB ERA22LA003Accident · No injuriesClass 4 · LimitedFinal reportCulp John S Culps Specl Sopwith · Pottstown, PAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA394Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Apopka, FLA loss of directional control during landing for reasons that could not be determined based upon the disposition of the wreckage following a late accident report.NTSB ERA21LA387Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLThe pilot’s loss of helicopter control after landing. Also causal was the pilot’s intentional operation of the helicopter without the required training, experience, and endorsements.NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB WPR21LA361Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Elk River, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a fence.NTSB WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB CEN21LA451Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Eden Prairie, MNThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB ANC21LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s failure to maintain control of the airplane after landing in gusty wind conditions.NTSB WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.NTSB ERA21LA370Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Walnut Cove, NCThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun, collision with an airport boundary fence, and a nose over event.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.