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 CEN13LA482Accident · No injuriesLimited investigationFinal reportGlos Wallis Richard JR LONG-EZ · Schaumburg, ILThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ANC13CA073Accident · No injuriesData collectionFinal reportCessna U206F · Kokhanok, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR13CA377Accident · No injuriesData collectionFinal reportAviat A-1B · West Jordan, UTThe pilot’s failure to maintain directional control during landing.NTSB ERA13CA351Accident · No injuriesData collectionFinal reportCessna 170B · Meridian, MSThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13CA485Accident · No injuriesData collectionFinal reportCessna 150D · Hermleigh, TXThe pilot's improper positional awareness, which resulted in an off airport landing and impact with terrain.NTSB WPR13CA356Accident · No injuriesData collectionFinal reportCessna 170B · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR13CA362Accident · No injuriesData collectionFinal reportBellanca 7GCBC · West Yellowstone, MTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with an approach slope indicator system component.NTSB CEN13CA457Accident · No injuriesData collectionFinal reportStearman A75 · Appleton, WIThe pilot’s inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB WPR13LA351Accident · Minor injuriesLimited investigationFinal reportStribling RV4 · San Manuel, AZThe pilot’s loss of directional control during takeoff with a tailwind, which resulted in a runway excursion.NTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.NTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.NTSB CEN13LA451Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Lombardville, ILThe pilot's failure to maintain airplane control during takeoff.NTSB ERA13LA343Accident · No injuriesLimited investigationFinal reportCessna 175 · Willimantic, CTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN13CA449Accident · No injuriesData collectionFinal reportDean David E Kitfox Classic 4 · Grinnell, IAThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB WPR13CA352Accident · No injuriesData collectionFinal reportCessna 180J · Hungry Horse, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.NTSB WPR13CA341Accident · No injuriesData collectionFinal reportCessna A185F · Pocatello, IDThe pilot's failure to maintain directional control during landing with gusting wind and a quartering tailwind.NTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.NTSB ANC13LA089Accident · No injuriesLimited investigationFinal reportHoward M. Shepherd Supercub · Hoonah, AKThe pilot’s selection of an unsuitable off-airport landing site and his subsequent landing at too high of an airspeed, which resulted in his excessive use of brakes during the landing roll and resulted in a nose-over.NTSB ERA13CA333Accident · Minor injuriesData collectionFinal reportMillhouse D Scott Kitfox II · Logan, WVThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose over. Contributing to the accident was the flight instructor’s inadequate supervision of the student.NTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.NTSB CEN13CA411Accident · No injuriesData collectionFinal reportLuscombe 8 · Rose Hill, KSThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB ANC13LA065Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKThe pilot’s loss of airplane control during landing for reasons that could not be determined based on the available evidence.NTSB ANC13CA064Accident · No injuriesData collectionFinal reportCessna A185F · Kenai, AKThe pilot's loss of control of the airplane while landing in variable wind conditions.NTSB WPR13CA327Accident · No injuriesData collectionFinal reportStearman C3-B · Everett, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR13LA310Accident · No injuriesLimited investigationFinal reportRockwell NA-265-65 · Las Vegas, NVThe pilots’ failure to follow the airplane manufacturer’s emergency procedures for a hydraulic system failure and emergency braking, which resulted in the loss of braking action upon landing and the subsequent loss of directional control while turning off the…NTSB WPR13CA324Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Canby, ORThe pilot's failure to maintain directional control during the landing rollout in gusting wind conditions.NTSB CEN13CA399Accident · Minor injuriesData collectionFinal reportCessna 140 · Vernon, TXThe pilot’s excessive use of wheel brakes during the takeoff roll, which resulted in a nose-over.NTSB WPR13LA299Accident · No injuriesLimited investigationFinal reportCessna 172 - N · Trout Lake, WAThe pilot's failure to maintain clearance from trees during takeoff from a soft field and to abort the landing when the airplane reached the runway’s midpoint at a low airspeed.NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.NTSB ERA13CA305Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Stevensville, MDThe pilot's failure to maintain directional control during the takeoff. Factors in the accident were the pilot's over-rotation at takeoff, and his failure to abort the takeoff prior to the runway excursion.NTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.NTSB WPR13CA276Accident · No injuriesData collectionFinal reportGary W Bettis Harmon Rocket II · South Lake Tahoe, CAThe pilot's failure to maintain directional control during landing with a crosswind.NTSB CEN13CA410Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Elbert, COThe pilot's failure to maintain aircraft control while landing in gusting crosswind conditions. Contributing to the accident was the pilot's delayed return to the airport.NTSB ERA13CA286Accident · No injuriesData collectionFinal reportLuscombe 8A · Orangeburg, SCThe inadvertent slippage of the pilot's foot off the right rudder pedal, resulting in a loss of directional control on the ground, and the pilot's overly aggressive application of wheel brakes, resulting in a nose over.NTSB ANC13CA055Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Juneau, AKThe pilot did not maintain directional control while attempting to recover from a bounced landing.NTSB WPR13CA268Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Truckee, CAThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions.NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13LA332Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Oklahoma City, OKThe pilot's failure to maintain directional control of the airplane.NTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.NTSB WPR13LA267Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORThe pilot’s unstabilized approach and use of an excessive speed at touchdown, which resulted in a loss of directional control during the landing and a subsequent runway excursion.NTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.NTSB CEN13CA317Accident · No injuriesData collectionFinal reportStinson 108 · Lebanon, INThe pilot did not maintain control of the airplane during the landing roll.NTSB CEN13LA323Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Hamlin, TXThe pilot's decision to land the airplane with a crosswind that exceeded the airplane's capabilities.NTSB WPR13CA255Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Martin, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.NTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.NTSB WPR13CA249Accident · No injuriesData collectionFinal reportBeech V35B · Kernville, CAThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions.NTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.