NTSB investigations
4,591 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN14CA330Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Douglass, KSThe pilot's excessive use of wheel brakes during landing, which resulted in a nose-over. Contributing to the accident were high winds and a short, downhill sloped runway.NTSB WPR14FA195Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS350B3 · Peach Springs, AZThe pilot’s decision to exit the helicopter while it was running and his failure to properly secure the flight controls with the engine operating at flight idle before exiting the helicopter.NTSB ERA14CA251Accident · No injuriesData collectionFinal reportChance Vought F4U 4 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.NTSB CEN14CA250Accident · No injuriesData collectionFinal reportSantschi Chris A Vans RV8 · Bonne Terre, MOThe pilot's failure to maintain aircraft control on takeoff.NTSB WPR14CA192Accident · Minor injuriesData collectionFinal reportCessna 120 · Colville, WAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA14CA240Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Norfolk, VAThe student pilot's failure to maintain directional control during takeoff.NTSB WPR14LA205Accident · No injuriesLimited investigationFinal reportCessna 180A · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN14CA237Accident · No injuriesData collectionFinal reportMooney M20F · Dowling, MIThe pilot's failure to maintain control during landing.NTSB ERA14LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Brooksville, FLThe pilot’s loss of directional control while landing at night, which resulted in a runway excursion and collision with airport signage. Contributing to the accident was the total loss of electrical power, which necessitated the pilot having to land without…NTSB ERA14CA243Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Meadville, PAThe pilot's failure to maintain directional control during an attempted go around in gusty wind conditions which resulted in a collision with terrain.NTSB CEN14CA236Accident · No injuriesData collectionFinal reportMorris Thomas Lee Stolp Strdstr SA300 · Lincoln, NEThe pilot's loss of directional control while landing in gusty crosswinds in a tail wheel equipped airplane.NTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.NTSB CEN14CA231Accident · Minor injuriesData collectionFinal reportPiper J3C 65 · Connersville, INThe pilot's inability to control the airplane while taxiing due to a strong crosswind condition.NTSB ANC14CA026Accident · No injuriesData collectionFinal reportCessna 170B · Soldotna, AKThe pilot's failure to recognize a wind shift, resulting in a tailwind landing, loss of control, and ground loop.NTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.NTSB ANC14CA024Accident · No injuriesData collectionFinal reportCessna 120 · Fairbanks, AKThe pilot's loss of directional control during landing, resulting in a ground loop.NTSB ERA14CA211Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Woodbine, NJThe flight instructor's delayed reaction to the loss of directional control, which resulted in a ground loop.NTSB CEN14LA220Accident · No injuriesLimited investigationFinal reportPiper PA 34-200 · Spring, TXThe loss of right brake effectiveness during landing for reasons that could not be determined based on the available evidence, which resulted in a loss of directional control.NTSB CEN14LA213Accident · Serious injuriesLimited investigationFinal reportCrow Mustang II · Morton, TXThe pilot's improper landing flare after encountering a gusting crosswind and his inadequate recovery from the subsequent bounced landing.NTSB ANC14CA023Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Kenai, AKThe pilot's loss of directional control during takeoff, resulting in a collision with terrain and ground loop.NTSB CEN14LA221Accident · No injuriesLimited investigationFinal reportAmerican AA 1 · Peyton, COThe loss of directional control during takeoff for reasons that could not be determined due to the extent of fire damage.NTSB ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.NTSB ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB CEN14LA210Accident · No injuriesLimited investigationFinal reportRockwell International 114 · Sturgis, MIA cracked nose landing gear pulley, which resulted in the binding of the nosewheel steering system.NTSB WPR14CA170Accident · No injuriesData collectionFinal reportPiper PA 18S-150 · Browning, MTThe pilot's failure to maintain directional control during the landing roll which resulted in a veer off the airstrip and collision with a ditch.NTSB ERA14CA201Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Blountstown, FLThe pilot's inadequate compensation for the tailwind conditions and failure to maintain directional control during landing.NTSB CEN14LA196Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · West Chicago, ILThe failure of the nose gear actuator attachment to the engine mount due to overstress, which resulted in the loss of directional control during landing.NTSB WPR14CA163Accident · No injuriesData collectionFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain directional control during a takeoff, which resulted in the airplane veering off the runway surface and colliding with a sign.NTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.NTSB ERA14CA189Accident · No injuriesData collectionFinal reportMoore Thomas O Zenith Stol CH701 · Frostproof, FLThe pilot's failure to maintain directional control during a precautionary landing. Contributing to the accident was the pilot's delayed decision to divert due to deteriorating weather.NTSB ERA14CA188Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Bethel, METhe pilot's failure to maintain control of the airplane while taxiing after landing during gusty wind conditions.NTSB WPR14CA157Accident · No injuriesData collectionFinal reportRobert A Miller Murphy Rebel Elite · Roundup, MTThe pilot's loss of directional control while landing.NTSB CEN14CA179Accident · Serious injuriesData collectionFinal reportBuckeye Industries Dream Machine · Smithville, TXThe operation of an aircraft by a non-certificated pilot. Contributing to the accident was the non-certificated pilot's failure to maintain aircraft control on take-off in gusty wind conditions.NTSB WPR14CA151Accident · No injuriesData collectionFinal reportAviat A 1B · Eloy, AZThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA150Accident · No injuriesData collectionFinal reportJust Highlander · Yakima, WAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during the landing roll.NTSB ANC14CA021Accident · No injuriesData collectionFinal reportCessna 180 · North Pole, AKThe pilot's failure to maintain directional control of the airplane while taxiing on a snow covered runway, which resulted in a collision with a terrain.NTSB CEN14IA172Incident · No injuriesIncident investigationFinal reportCessna 560XL · Traverse City, MIThe inoperative galley drain tube heater, which allowed water within the tube to freeze and led to its failure; the tube’s failure allowed water to drain onto the rudder cables and freeze and resulted in the rudder binding during landing.NTSB WPR14CA145Accident · No injuriesData collectionFinal reportAeronca 7DC · Fallon, NVThe pilot's failure to maintain directional control during the landing roll with a tailwind.NTSB ERA14CA169Accident · No injuriesData collectionFinal reportCessna 172M · Knoxville, TNThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.NTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.NTSB ERA14LA173Accident · No injuriesLimited investigationFinal reportCessna 206H · Philadelphia, PAThe pilot's failure to maintain control of the airplane while landing in gusty wind conditions.NTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.NTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.NTSB CEN14CA183Accident · No injuriesData collectionFinal reportStinson 108 · Broomfield, COThe pilot's failure to maintain directional control during the landing, which resulted in the airplane departing the runway and nosing over.NTSB CEN14CA162Accident · No injuriesData collectionFinal reportBeech 35 C33A · West Union, OHA loss of aircraft control during landing, due to the pilot's excessive braking. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.NTSB WPR14LA133Accident · No injuriesLimited investigationFinal reportPeter W Stevens Bearhawk Patrol · Salt Lake City, UTThe pilot’s failure to maintain directional control during the landing roll.