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 ERA15WA034Accident · No injuriesForeign investigationBombardier CL 600 2B16 · Charallave, VenezuelaNTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.NTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.NTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.NTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.NTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.NTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.NTSB CEN14CA025Accident · No injuriesData collectionFinal reportAviat A 1B · El Paso, TXThe pilot did not maintain directional control of the airplane while landing with a crosswind.NTSB WPR14CA026Accident · No injuriesData collectionFinal reportCessna T210 - H · Lodi, CAThe student pilot's inadequate flare and failure to maintain directional control during landing.NTSB WPR14CA033Accident · No injuriesData collectionFinal reportTecnam P92 · Watsonville, CAThe pilot's failure to maintain directional control during landing.NTSB WPR14CA028Accident · No injuriesData collectionFinal reportCessna 180 · Butte, MTThe pilot's failure to maintain directional control of the airplane while landing with a crosswind.NTSB ERA14CA030Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Charleston, MSThe pilot's failure to maintain directional control, which resulted in a runway excursion and collision with a fence.NTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.NTSB ERA14LA005Accident · No injuriesLimited investigationFinal reportAerotek Pitts S 1T · Punta Gorda, FLThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot’s decision to operate the airplane with known ergonomic restrictions due to his size.NTSB ERA14CA003Accident · Minor injuriesData collectionFinal reportCessna 305A · Slatington Airport, PAThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident was the pilot's decision to land with a tailwind condition and the airfield's inaccurate windsock.NTSB CEN14LA008Accident · No injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Wichita, KSThe pilot’s improper brake application during landing, which resulted in a loss of directional control.NTSB ERA14CA012Accident · No injuriesData collectionFinal reportClassic Waco YMF · Somerville, NJThe pilot's failure to maintain aircraft control while applying wheel brakes during landing roll resulting in the airplane nosing over.NTSB WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.NTSB ANC14CA001Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Iliamna, AKThe pilot's failure to maintain aircraft control during the landing roll with a tailwind.NTSB WPR14CA002Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Waco, TXThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB WPR14CA001Accident · No injuriesData collectionFinal reportUnknown Unknown · Mount Pleasant, UTThe pilot's failure to maintain aircraft control during landing.NTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.NTSB ANC13CA106Accident · No injuriesData collectionFinal reportCessna 185E · Pilot Point, AKThe pilot's decision to land the airplane on the ramp, in the vicinity of buildings, in gusty wind conditions.NTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.NTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.NTSB ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.NTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.NTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.NTSB WPR13LA414Accident · No injuriesLimited investigationFinal reportCessna 180 - B · Redmond, ORThe pilot's inability to counter an unexpected wind gust after touchdown, which resulted in a loss of directional control.NTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ANC13CA098Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Akhiok, AKThe pilot's failure to maintain directional control during takeoff in a gusty tailwind.NTSB ERA13CA419Accident · No injuriesData collectionFinal reportPiper PA28 151 · Abingdon, VAThe failure of the pilot to maintain directional control during a crosswind landing resulting in collision with terrain and aft displacement of the nose landing gear.NTSB CEN13CA544Accident · No injuriesData collectionFinal reportCessna 170A · Victoria, TXThe student pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB ERA13LA418Accident · No injuriesLimited investigationFinal reportFleet 7 · Louisa, VAMaintenance personnel’s improper service, adjustment, and inspection of the brakes, which resulted in a runway excursion and subsequent noseover.NTSB CEN13LA541Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMThe pilot's failure to maintain airplane directional control during the landing roll due to his diverted attention.NTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.NTSB CEN13CA529Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluff, IAThe student pilot's loss of directional control during takeoff.NTSB CEN13CA526Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Edgerton, MNThe pilot's delay in aborting the landing which resulted in the airplane contacting the terrain off the departure end of the runway.NTSB WPR13CA394Accident · No injuriesData collectionFinal reportHenderson Michael E Glastar · Sequim, WAThe pilot's improper soft field landing technique, and failure to maintain aircraft control during the landing.NTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.NTSB ANC13CA086Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's loss of control of the airplane during takeoff, resulting in a ground loop.NTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ERA13CA377Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s decision to depart with a known deficiency following a hard landing. Contributing to the accident was an anomaly of the airplane’s nosewheel steering that could not be replicated during post-accident examination.NTSB CEN13LA497Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · Zanesville, OHThe pilot’s loss of directional control during landing.NTSB ANC13CA082Accident · No injuriesData collectionFinal reportCessna 185 · Sleetmute, AKThe pilot's failure to maintain directional control during landing.NTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.NTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.NTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.NTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.