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 CEN23LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Burnet, TXThe pilot’s failure to maintain directional control during the landing roll with an unexpected quartering tailwind.NTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.NTSB WPR23LA005Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Reno, NVThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR22LA366Accident · No injuriesClass 4 · LimitedFinal reportArter Warren Carbon CUB CCK-1865 · Willard, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA437Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · San Antonio, TXThe student pilot’s failure to maintain control of the airplane during the landing.NTSB WPR22LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Hermiston, ORThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.NTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.NTSB WPR22LA346Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Las Vegas, NVThe pilot’s failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN22LA420Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe student pilot’s incorrect application of rudder during landing and the flight instructor’s delayed response to the student pilot’s action.NTSB WPR22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Scappoose, ORThe pilot's failure to maintain airplane control while taxing in gusty wind conditions.NTSB CEN22LA410Accident · Minor injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Coldwater, MIThe pilot receiving instruction’s improper flare during landing and the flight instructor’s inadequate remedial action, which resulted in the airplane exceeding its critical angle-of-attach and experiencing an aerodynamic stall.NTSB WPR22LA372Accident · Minor injuriesClass 4 · LimitedFinal reportCessna P210N · Weston, ORThe pilot’s improper landing flare which resulted in a bounced landing and runway excursion.NTSB ERA22LA400Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Marysville, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaNTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB ANC22LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and impact with terrain.NTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.NTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB CEN22LA399Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Sullivan, INThe pilot’s failure to maintain directional control during landing.NTSB ERA22LA374Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Westfield, MAThe pilot’s loss of directional control while taxiing for takeoff.NTSB CEN22LA388Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28 · Lucedale, MSThe pilot’s failure to maintain directional control while landing on the wet turf runway with a higher speed.NTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB ANC22LA065Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R172K · Fairbanks, AKThe pilot’s failure to maintain control of the airplane during landing.NTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.NTSB ANC22LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain directional control of the airplane during the takeoff roll following a hard landing.NTSB CEN22LA368Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Midland, TXThe student pilot’s failure to maintain control of the airplane while landing with gusting wind.NTSB ERA22LA355Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Cranberry Township, PAThe pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…NTSB ANC22LA082Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Kokhanok, AKThe pilot's failure to maintain directional control of the airplane during takeoff operations.NTSB CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.NTSB WPR22LA289Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fairbank's, AKThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CEN22LA348Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sturgeon Lake, MNThe pilot’s failure to maintain directional control during takeoff from a gravel driveway resulting in an impact with a tree.NTSB CEN22LA372Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-3 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll which resulted in a runway excursion and collision with a ditch.NTSB CEN22LA332Accident · Minor injuriesClass 4 · LimitedFinal reportCessna L-19E · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.NTSB WPR22LA270Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33 · Livingston, MTThe student pilot’s improper landing flare, and the instructor’s lack of remedial action.NTSB WPR22LA269Accident · Minor injuriesClass 4 · LimitedFinal reportMiller-Thorp T-18 Tiger · Angel Fire, NMThe pilot’s failure to maintain directional control during the landing roll in gusting wind.NTSB CEN22LA338Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic YMF-5C · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB WPR22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Lexington, ORThe pilot’s failure to maintain directional control during the landing roll with a gusting wind.NTSB CEN22LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Neosho, MOThe pilot’s inadvertent application of the right brake and subsequent loss of airplane directional control, which resulted in a taxiway excursion and impact with trees.NTSB CEN22LA337Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oshkosh, WIThe pilot’s failure to maintain directional control during the landing roll with a gusty crosswind.NTSB CEN22LA327Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Gordon, NEThe pilot’s loss of control while landing a tailwheel-equipped airplane with a gusty crosswind.NTSB ERA22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · East Haddam, CTThe pilot's failure to maintain directional control during the landing.NTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.