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 GAA16CA402Accident · No injuriesData collectionFinal reportCirrus Design SR · Henderson, NVThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a landing gear collapse.NTSB GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.NTSB CEN16FA286Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB-505 · Sugar Land, TXThe airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…NTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.NTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.NTSB GAA16CA391Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind HK 36 · Blanchester, OHThe pilot's failure to maintain directional control of the powered glider during the landing roll.NTSB CEN16LA274Accident · No injuriesLimited investigationFinal reportChance Vought F4U 5 · East Troy, WIA failure of the O-ring in the left brake master cylinder for reasons that could not be determined, which resulted in a loss of directional control during landing.NTSB CEN16LA271Accident · Serious injuriesLimited investigationFinal reportGerald Nelson Nelson Woody · Hope, ARThe loss of control upon landing for reasons that could not be determined.NTSB ANC16LA048Accident · No injuriesLimited investigationFinal reportStinson 108 · Haines, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind, which resulted in a ground loop and overstress failure of the left main landing gear wheel axle.NTSB GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.NTSB GAA16CA373Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard · Somerset, KYThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.NTSB GAA16CA366Accident · No injuriesData collectionFinal reportHelio H 295 · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB ERA16LA254Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Machine · Hartford, KYA partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.NTSB CEN16LA263Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · Newark, ILThe student pilot's failure to maintain directional control on landing. Contributing to the accident was the pilot's lack of flight experience.NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.NTSB GAA16CA368Accident · No injuriesData collectionFinal reportAvions Mudry ET Cie CAP · Spring Branch, TXThe flight instructor's inability to maintain directional control during the landing roll as a result of the malfunctioning brake master cylinder.NTSB ERA16CA241Accident · No injuriesData collectionFinal reportCessna 305 · Shirley, NYThe pilot's failure to maintain directional control while landing. Contributing to the accident was the pilot's decision to accept an advised runway rather than determine actual airport winds, which resulted in the airplane landing with a quartering tailwind.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.NTSB GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB ANC16CA041Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a collision with trees and a ground-loop.NTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.NTSB GAA16CA349Accident · No injuriesData collectionFinal reportCessna 150 · Reno, NVThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, impact with a sign, and left wing damage.NTSB GAA16CA344Accident · No injuriesData collectionFinal reportBenjamin Harold E RV-4 · Fitchburg, MAThe pilot's failure to maintain directional control upon landing, which resulted in a runway excursion followed by impact with terrain.NTSB GAA16CA338Accident · No injuriesData collectionFinal reportNorth American SNJ · Jackson, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, right main landing gear collapse, and impact with the ground.NTSB GAA16CA334Accident · No injuriesData collectionFinal reportHubbard William H Lightning · Kokomo, INThe pilot's failure to maintain directional control during the landing flare at night, which resulted in an impact with a runway light and runway sign.NTSB ERA16LA228Accident · Serious injuriesLimited investigationFinal reportAmerican AA1 · Knoxville, TNThe pilot's failure to maintain directional control during the landing roll in a quartering headwind.NTSB CEN16WA232Incident · No injuriesForeign investigationBeech 65A90 · Hannover, GermanyThe Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Beech 65-A90-1 airplane, OO-SAD, that occurred on June 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU…NTSB GAA16CA341Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Freemont Island, UTThe flight instructor's failure to maintain directional control during the landing roll, resulting in an impact with an unknown object during aborted landing and consequent ground impact.NTSB ERA16LA225Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Punta Gorda, FLThe tower controller’s failure to identify and mitigate jet blast from an airplane conducting an engine test run, and the effect of the jet blast on landing traffic, which resulted in a runway excursion when a landing airplane encountered the blast.…NTSB GAA16CA504Accident · No injuriesData collectionFinal reportCessna 152 · Immokalee, FLThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA16WA221Incident · No injuriesForeign investigationGulfstream GULFSTREAM150 · Rionegro, ColombiaOn June 16, 2016, about 1603 Coordinated Universal Time (UTC), a Gulfstream Aerospace LP Gulfstream G150, N963CH, registered to Bank of Utah, and operated by a private individual, experienced a runway excursion during landing at the Jose Maria Cordova…NTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.NTSB GAA16CA318Accident · No injuriesData collectionFinal reportEurocopter EC120 · Ajo, AZThe pilot's decision to exit the helicopter with the engine and rotors turning and the selection of unsuitable terrain for a landing, which resulted in a roll over.NTSB GAA16CA319Accident · No injuriesData collectionFinal reportAmerican AA 1 · Denton, MTThe pilot's premature rotation and failure to attain sufficient airspeed required for a sustained climb, resulting in a runway overrun and collision with a fence.NTSB GAA16CA313Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Cairo, ILThe pilot's failure to ensure that the tailwheel pin was in the locked position prior to the takeoff roll, resulting in a runway excursion, ground loop, and substantial damage.NTSB GAA16CA307Accident · No injuriesData collectionFinal reportLuscombe 8 · Valparaiso, INThe pilot's improper descent rate during landing, which resulted in a bounced landing, failure of the tailwheel suspension leaf spring, a ground loop, and substantial damage to the left wing.NTSB GAA16CA309Accident · No injuriesData collectionFinal reportMaule MX 7 · Ontario, ORThe pilot's failure to maintain directional control during landing, which resulted the right wing impacting the ground, and nose down.NTSB ERA16LA210Accident · 1 fatalLimited investigationFinal reportCameron A-225 · Nunda, NYThe ground crewmember's failure to let go of the balloon's basket when the balloon began to ascend. Contributing to the accident was the pilot's failure to maintain control of the balloon after landing, which resulted in an inadvertent takeoff.NTSB GAA16CA299Accident · Minor injuriesData collectionFinal reportBareiss David A Tango 2 · Sunrise Beach Village, TXThe nosewheel fairing becoming packed with debris during landing on the soft field due to a gap between the nosewheel tire and the fairing, which resulted in a loss of control and subsequent nose-over.NTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB GAA16CA294Accident · No injuriesData collectionFinal reportBellanca 17 30 · Fredericksburg, VAThe pilot's failure to maintain directional control during the landing roll in gusting wind resulting in a runway excursion and substantial damage.NTSB GAA16CA292Accident · No injuriesData collectionFinal reportAeronca 7BCM · Rochester, WIThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, left main landing gear collapse, and a nose down. Contributing to the accident was the wind shift.NTSB GAA16CA290Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Beaumont, TXThe non-pilot owner's decision to start the helicopter while awaiting the pilot's arrival, which resulted in a loss of yaw control and a rollover.NTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.NTSB GAA16CA285Accident · No injuriesData collectionFinal reportMaule M5 · Hamilton, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA276Accident · No injuriesData collectionFinal reportMooney M20C · Williamstown, NJThe pilot's landing area overshoot and failure to maintain surface speed and braking capability, which resulted in a runway overrun and a collision with a fence.NTSB GAA16CA274Accident · Minor injuriesData collectionFinal reportKoons Donald H Cygnet · Zanesville, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, and a nose over.