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 ERA20LA221Accident · No injuriesClass 3 · LimitedFinal reportGulfstream 150 · San Juan, PRThe pilot’s loss of control during landing on a wet runway after encountering standing water.NTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.NTSB WPR20CA071Accident · No injuriesData collectionFinal reportCessna 172 · Sun River, ORThe pilot's failure to maintain directional control during the landing roll on a runway with icy patches, which resulted in impact with a snowbank and a subsequent nose-over.NTSB WPR20CA070Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · Gold Canyon, AZThe pilot's failure to maintain directional control during an aborted takeoff, which resulted in collision with a barricade.NTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.NTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB CEN20WA061Accident · No injuriesForeign investigationRobinson R44 · Wijnendaele, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on December 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the…NTSB WPR20CA053Accident · No injuriesData collectionFinal reportCessna 170 · Missoula, MTThe pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.NTSB WPR20CA052Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's loss of directional control during the landing roll, which resulted in a collision with a taxiway sign.NTSB CEN20CA040Accident · Minor injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot's failure to attain an adequate climb rate during an aborted landing with a left quartering, gusting headwind, which resulted in impact with a tree.NTSB WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB WPR20CA045Accident · Minor injuriesData collectionFinal reportCessna 140 · Lancaster, CAThe student pilot's failure to maintain directional control and his use of excessive braking while taxiing.NTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB ERA20CA048Accident · No injuriesData collectionFinal reportCirrus SR22 · Union City, TNThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a runway excursion and the left wing impacting grass.NTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.NTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.NTSB WPR20LA025Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ-4 · Heber City, UTThe pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rodNTSB GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.NTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.NTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA20CA070Accident · No injuriesData collectionFinal reportCessna 195 · Kalispell, MTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.NTSB GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.NTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.NTSB CEN20WA065Accident · No injuriesForeign investigationLearjet 35 · Cabo San Lucas, MexicoOn November 5, 2019, at 1942 Mexican pacific standard time, a Learjet 35A airplane, Mexican registration XA-VBD, experienced a runway excursion after landing at Cabo San Lucas International Airport, Cabo San Lucas, Mexico. The four occupants sustained no…NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA20CA056Accident · No injuriesData collectionFinal reportPitts S1 · Monument Valley, UTThe pilot's failure to maintain directional control during landing after a wing struck vegetation, which resulted in a runway excursion and subsequent ground-loop.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.NTSB GAA20CA048Accident · Minor injuriesData collectionFinal reportBeech A36 · Le Roy, NYThe pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.NTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.NTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.NTSB GAA20CA079Accident · No injuriesData collectionFinal reportPiper PA28 · Quakertown, PAThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and collision with a drainage culvert.NTSB GAA20CA036Accident · No injuriesData collectionFinal reportTitan Titan Tornado II · Marble Canyon, AZThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.NTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.NTSB GAA20CA029Accident · No injuriesData collectionFinal reportCessna 180 · Flannigan, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a wing strike.NTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneNTSB GAA20CA045Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Buckeye, AZThe pilot's failure to maintain directional control during an aborted landing with a crosswind, which resulted in tailwheel impacting vegetation and the left main landing gear collapsing.NTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA20CA009Accident · No injuriesData collectionFinal reportAeronca 7AC · Waynesburg, PAThe student pilot's failure to maintain directional control during the landing roll due to his foot slipping off the right pedal and becoming stuck between the pedal and fuselage frame, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.NTSB GAA19CA586Accident · No injuriesData collectionFinal reportPiper PA 12 · Williams, CAThe pilot's over application of power during recovery from a runway excursion, which resulted in a ground loop and nose over.NTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.NTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA572Accident · No injuriesData collectionFinal reportPiper PA18 · Boulder, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA19CA564Accident · No injuriesData collectionFinal reportPiper PA18 · Skwentna, AKThe pilot's improper decision to depart from an off-airport surface covered with standing water, which resulted in a noseover.