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 CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.NTSB ERA12CA378Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Mocksville, NCThe glider pilot's failure to attain and maintain directional control during takeoff.NTSB WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.NTSB ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB WPR12CA226Accident · Minor injuriesData collectionFinal reportCessna 182M · Vashon Island, WAThe pilot's loss of directional control during a rejected takeoff, which resulted in a noseover.NTSB ERA12CA381Accident · No injuriesData collectionFinal reportBoeing A75N1 · Foley, ALThe pilot's failure to maintain airplane control during landing.NTSB CEN12CA342Accident · No injuriesData collectionFinal reportCessna 172S · Fort Scott, KSThe student pilot’s loss of directional control during the landing roll. Contributing to the accident was the student pilot’s diverted attention to retract the flaps.NTSB ERA12CA370Accident · No injuriesData collectionFinal reportSmith Allen Storch · Titusville, FLThe pilot’s failure to maintain directional control during landing.NTSB CEN12LA323Accident · No injuriesLimited investigationFinal reportThrush S2RHG-T65 · Alicia, ARThe pilot of the Thrush did not execute a go-around prior to landing, which resulted in excessive ground speed after touchdown, and his subsequent loss of directional control, which resulted in a collision with the Air Tractor.NTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.NTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.NTSB ERA12LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot of another airplane to set the parking brake and to maintain a proper visual lookout, which resulted in an on-ground collision.NTSB ANC12CA041Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Talkeetna, AKThe pilot inadvertently landed with the parking brake set.NTSB ERA12CA359Accident · No injuriesData collectionFinal reportBeech V35B · Norwich, NYThe pilot’s failure to maintain airplane control while landing in a crosswind.NTSB ERA12CA347Accident · No injuriesData collectionFinal reportCessna 172R · Crossville, TNThe pilot's attempt to avoid a deer on the runway, which resulted in a runway excursion.NTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.NTSB WPR12CA213Accident · No injuriesData collectionFinal reportRotherwick HR Glasair III · Darby, MTThe pilot’s loss of directional control during an emergency landing on a paved highway.NTSB ERA12CA342Accident · No injuriesData collectionFinal reportPiper PA46 · Springfield, VTThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.NTSB CEN12LA304Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · El Dorado, KSThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB WPR12LA211Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe student pilot's failure to maintain directional control during takeoff.NTSB WPR12LA252Accident · No injuriesLimited investigationFinal reportStaudacher Hydroplanes S300X · Ephrata, WAThe pilot’s inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB WPR12CA202Accident · No injuriesData collectionFinal reportPiper PA-12 · Idaho Falls, IDThe pilot’s improper landing flare, inadequate recovery from a bounced landing, and subsequent failure to maintain directional control.NTSB CEN12CA303Accident · No injuriesData collectionFinal reportCessna 182S · Houston, TXThe student pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB CEN12CA292Accident · No injuriesData collectionFinal reportRisher Jimmy E Vans Aircraft RV-8 · Pecos, TXThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR12LA207Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Roche Harbor, WAA damaged brake master cylinder piston rod, which resulted in a landing with the left brake applied. The damage was a result of normal parking brake operation.NTSB ERA12CA334Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Weirsdale, FLThe pilot's failure to maintain directional control while landing in a gusty variable crosswind.NTSB ERA12CA330Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB ANC12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gakona, AKThe pilot’s decision to take off in variable wind conditions, which resulted in a loss of control and the airplane striking an object after takeoff.NTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.NTSB CEN12CA280Accident · No injuriesData collectionFinal reportCessna A188 · Sterling, ILThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's runway selection based on the wind conditions.NTSB ERA12CA325Accident · Minor injuriesData collectionFinal reportCessna 172R · Culebra, PRThe pilot's failure to remove the flight control lock before takeoff.NTSB WPR12CA215Accident · No injuriesData collectionFinal reportMaule M-7-260 · Brigham City, UTThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB WPR12CA196Accident · No injuriesData collectionFinal reportCessna 195 · Heber-Overgaard, AZThe pilot's loss of directional control during takeoff roll upon encountering a wind gust.NTSB ERA12CA351Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Umatilla, FLThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12CA278Accident · No injuriesData collectionFinal reportGalloway/Ward RV-4 · Redwood Falls, MNThe pilot’s failure to maintain control of the airplane during takeoff in gusty wind conditions.NTSB ERA12LA315Accident · No injuriesLimited investigationFinal reportBerry Dean Glasair I · Columbus, GAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…NTSB WPR12CA192Accident · No injuriesData collectionFinal reportCessna 195B · Sacramento, CAThe pilot’s failure to maintain directional control during the landing roll while landing with a gusting wind.NTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.NTSB WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.NTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.NTSB ANC12CA032Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Alpha · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a tailrotor strike.NTSB WPR12CA177Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Sierraville, CAThe pilot did not maintain directional control during the landing roll.NTSB WPR12CA169Accident · No injuriesData collectionFinal reportCessna 182G · Georgetown, CAThe pilot’s failure to maintain control of the airplane while landing with a gusting wind.NTSB ERA12CA288Accident · No injuriesData collectionFinal reportCessna 180J · Abingdon, VAThe passenger’s inadvertent blockage of the rudder pedals, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB WPR12CA175Accident · No injuriesData collectionFinal reportLuscombe 8E · Winslow, AZThe pilot did not maintain directional control during the landing roll.NTSB WPR12CA170Accident · No injuriesData collectionFinal reportCessna 180F · McCall, IDThe pilot did not maintain directional control during the landing roll.NTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.NTSB ANC12CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot's decision not to initiate a go-around.