NTSB investigations
3,846 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 WPR18LA255Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Richland, MOA loss of directional control during a touch-and-go landing in gusting crosswind conditions.NTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB GAA18CA550Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA18CA527Accident · No injuriesData collectionFinal reportCessna 170 · Tulsa, OKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA526Accident · No injuriesData collectionFinal reportCessna 172 · Karluk, AKThe pilot’s failure to maintain proper pitch for a soft-field landing, which resulted in a loss of airplane control.NTSB GAA18CA525Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA18CA579Accident · Minor injuriesData collectionFinal reportPiper PA28 · Porterville, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN18WA404Accident · No injuriesClass 5 · ForeignCessna 680 · Burgas, BulgariaNTSB GAA18CA524Accident · No injuriesData collectionFinal reportLuscombe 8 · Fulton, MOThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA513Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.NTSB GAA18CA509Accident · No injuriesData collectionFinal reportCessna 170 · Prineville, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ANC18CA068Accident · Minor injuriesData collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll when the left main landing gear wheel got caught in a ditch, which resulted in a subsequent nose-over.NTSB GAA18CA510Accident · No injuriesData collectionFinal reportMaule MX7 · Post Mills, VTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.NTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.NTSB GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB GAA18CA497Accident · No injuriesData collectionFinal reportPiper PA18 · Stony RIver, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.NTSB GAA18CA491Accident · Minor injuriesData collectionFinal reportCessna U206 · Barter Island, AKThe pilot's failure to maintain lateral control while taxiing in gusting wind conditions.NTSB GAA18CA520Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB GAA18CA492Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the left wing and horizontal stabilizer striking the ground.NTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…NTSB GAA18CA481Accident · No injuriesData collectionFinal reportHelio H 295 · Great Falls, MTThe pilot’s failure to maintain lateral control of the airplane during takeoff in a quartering tailwind.NTSB GAA18CA489Accident · No injuriesData collectionFinal reportMaule MX7 · Valdez, AKThe pilot's failure to maintain the proper airspeed during landing, which resulted in a bounced landing and subsequent nose-over.NTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.NTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.NTSB CEN18LA307Accident · No injuriesLimited investigationFinal reportGerald Dan Coppock Bade-E · Escanaba, MIThe loss of control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in a ground loop and runway excursion.NTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.NTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.NTSB ANC18WA075Accident · 1 fatalForeign investigationPiper PA28 · Black Diamond, CanadaOn July 30, 2018, about 0133 Coordinated Universal Time, a Piper PA-28-161 airplane, C-GVZJ, was departing a cut hay field and collided with hay bales near Black Diamond, Alberta, Canada, under unknown circumstances. Of the two occupants onboard, 1 sustained…NTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA452Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA448Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lawrenceville, VAThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB GAA18CA436Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT-912-L · Albuquerque, NMThe pilot’s failure to maintain directional control during landing.NTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA437Accident · No injuriesData collectionFinal reportCessna 180 · Bozeman, MTThe pilot's failure to maintain directional control during landing.NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.NTSB GAA18CA422Accident · No injuriesData collectionFinal reportPiper PA18S · Palmer, AKThe pilot's failure to maintain pitch control during the landing roll.