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 GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.NTSB ERA15LA214Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Inverness, FLA disconnection of the tailwheel steering mechanism during landing, which resulted in the pilot’s loss of directional control.NTSB GAA15CA067Accident · No injuriesData collectionFinal reportMaule M 4-220C · Rigby, IDThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB DCA15WA126Incident · No injuriesForeign investigationBoeing 737 - 8FE · Christchurch, New ZealandThe Australian Transport Safety Bureau (ATSB) of Australia has notified the NTSB of an incident involving a Boeing 737-8FE, which occurred on May 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB GAA15CA065Accident · No injuriesData collectionFinal reportChampion 7ECA · Quincy, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA15CA064Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe landing airplane pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground collision with a taxiing airplane.NTSB GAA15CA068Accident · No injuriesData collectionFinal reportCessna 180 · Hartland, MEAbnormal runway contact which precipitated a loss of control and nose-over.NTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.NTSB GAA15CA059Accident · No injuriesData collectionFinal reportCessna 180K · Pearland, TXThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA15CA056Accident · No injuriesData collectionFinal reportWilliam D Durkee RV-6 · Tunica, MSThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA15CA048Accident · No injuriesData collectionFinal reportCessna 180J · Boise, IDThe pilot's failure to maintain directional control during landing.NTSB GAA15CA045Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Newport, RIThe pilot's failure to maintain directional control during landing.NTSB CEN15CA203Accident · No injuriesData collectionFinal reportCessna 195A · Independence, IAThe pilot's attempt to land in strong crosswind conditions, resulting in his on-ground loss of control. Contributing to the accident was the crosswind that exceeded the crosswind limits of the airplane.NTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.NTSB ERA15CA188Accident · Minor injuriesData collectionFinal reportP&M Pulsr · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in a collision with the ground.NTSB CEN15CA196Accident · No injuriesData collectionFinal reportAeronca 7AC · Cambridge, OHThe pilot's failure to maintain control of the airplane while encountering a wind gust after landing.NTSB CEN15CA197Accident · No injuriesData collectionFinal reportRennicke Midget Musta MM1 · Longmont, COThe pilot's failure attain/maintain pitch control prior to attaining a proper takeoff speed during takeoff roll, which resulted in a premature liftoff of the airplane and loss of control.NTSB GAA15CA036Accident · No injuriesData collectionFinal reportPiper PA 22-135 · Drexel, MOThe pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA15CA033Accident · No injuriesData collectionFinal reportLancair LC 40 550FG · Middleton, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's inadequate compensation for the crosswind during landing.NTSB ANC15CA019Accident · No injuriesData collectionFinal reportCessna A185F · Palmer, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.NTSB ANC15CA016Accident · No injuriesData collectionFinal reportCessna 170B · Wasilla, AKThe flight instructor's inadequate supervision of the student while landing, which resulted in a ground loop. Contributing to the accident was the student pilots failure to maintain directional control of the tailwheel-equipped airplane during the landing…NTSB GAA15LA025Accident · Serious injuriesLimited investigationFinal reportSpaulding Errol Rans S 7 Courier · Pinedale, WYThe pilot’s decision to take off in a crosswind that exceeded the airplane’s maximum demonstrated crosswind capability and his subsequent inability to maintain directional control.NTSB GAA15CA024Accident · No injuriesData collectionFinal reportDavid Shell Zenith CH701 · Fairfield, UTThe pilot's failure to maintain directional control during a precautionary off airport landing.NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB WPR15LA132Accident · No injuriesLimited investigationFinal reportBeech B23 · Flagstaff, AZThe pilot's failure to maintain directional control during landing.NTSB GAA15CA013Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Lake Hamilton, ARThe pilot's overcorrection to the landing pad shifting, which resulted in the helicopter impacting trees. A factor contributing to the accident was the collapse of the landing pad.NTSB WPR15LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA30 - NO Series · Red Bluff, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.NTSB GAA15CA031Accident · Minor injuriesData collectionFinal reportCessna 140 · Easton, MDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.NTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.NTSB ERA15CA162Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · St Marys, PAThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and a nose over.NTSB GAA15LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garrison, IAThe malfunction of the right brake for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB ANC15CA014Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Talkeetna, AKThe pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.NTSB ERA15CA146Accident · No injuriesData collectionFinal reportCub Crafter CC11-160 · Elizabethton, TNThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB ERA15CA148Accident · No injuriesData collectionFinal reportPiper PA 18 · Murfreesboro, TNThe student pilot's failure to maintain directional control while landing and the flight instructor's delayed remedial action, which resulted in a ground-loop and the left wing dragging the runway.NTSB ANC15CA013Accident · No injuriesData collectionFinal reportStinson 108 · Cordova, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.NTSB CEN15CA159Accident · No injuriesData collectionFinal reportArnold Zodiac CH 650 · Greeley, COThe pilot was unable to maintain directional control during the landing due to the foreign object that lodged behind the rudder.NTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.NTSB WPR15CA102Accident · No injuriesData collectionFinal reportCessna 185 - E · Carson City, NVThe pilot's failure to maintain directional control during landing with a crosswind which resulted in a ground loop.NTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.NTSB ERA15LA124Accident · No injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Sebastian, FLThe pilot's failure to conduct all of the required items on the Before Starting Engines checklist, which resulted in her failure to detect an open hydraulic circuit breaker and led to insufficient hydraulic pressure to operate the airplane's brakes, her…