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 WPR10CA291Accident · No injuriesData collectionFinal reportCessna 188B · Blackfoot, IDA loss of directional control during the landing roll as a result of a worn tail wheel locking mechanism.NTSB WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.NTSB ERA10CA310Accident · Serious injuriesData collectionFinal reportCessna 170 · Campbellsville, KYThe pilot’s failure to maintain directional control during an aborted landing.NTSB ANC10CA052Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain directional control while landing in variable wind conditions.NTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.NTSB ERA10CA304Accident · No injuriesData collectionFinal reportCessna 305A · Toms River, NJThe pilot-in-command's loss of airplane control during landing, which resulted in a ground-loop.NTSB ANC10CA051Accident · No injuriesData collectionFinal reportStinson 108-1 · Galena, AKThe pilot's failure to maintain directional control during takeoff, resulting in a ground-loop, and collapse of the right main landing gear.NTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.NTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.NTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.NTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.NTSB WPR10CA282Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Chandler, AZThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.NTSB ANC10CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Anchorage, AKThe pilot's failure to maintain directional control during the landing.NTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.NTSB ANC10LA044Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Anchorage, AKThe commercial pilot’s loss of airplane control while landing in a crosswind, resulting in a nose-over. Contributing to the accident was the check pilot's inadequate supervision of the commercial pilot while landing.NTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.NTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB WPR10CA255Accident · No injuriesData collectionFinal reportCessna 172P · Las Vegas, NVThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during taxi.NTSB WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.NTSB ERA10CA279Accident · No injuriesData collectionFinal reportPZL Mielec M18 · Lake Placid, FLThe pilot's failure to maintain directional control during the takeoff roll.NTSB WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.NTSB ERA10CA276Accident · No injuriesData collectionFinal reportCessna P210N · Cambridge, NYThe pilot's loss of directional control during takeoff.NTSB WPR10LA250Accident · Serious injuriesLimited investigationFinal reportWildman RV6-A · Columbia, CAThe pilot’s inadequate compensation for the gusting crosswind and improper landing flare.NTSB WPR10CA246Accident · No injuriesData collectionFinal reportCessna 180K · Renton, WAThe pilot's inadequate compensation for the wind conditions, resulting in the loss of directional control during the landing roll.NTSB ERA10CA270Accident · Serious injuriesData collectionFinal reportHealy RAF 2000 · Hopkinsville, KYThe pilot’s overcompensation for gusting wind conditions during the takeoff roll, which resulted in a loss of control.NTSB ERA10CA282Accident · No injuriesData collectionFinal reportCessna 172S · Jekyll Island, GAThe pilot's loss of airplane control while landing with a crosswind.NTSB ERA10CA268Accident · No injuriesData collectionFinal reportCessna 172N · Blue Hill, METhe flight instructor’s inability to maintain directional control while landing with gusting winds.NTSB CEN10CA260Accident · No injuriesData collectionFinal reportCessna 180 · Duluth, MNThe pilot's failure to maintain directional control during landing.NTSB WPR10LA242Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Monument, ORThe pilot’s misjudged flare during landing resulting in a hard landing and loss of directional control.NTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.NTSB CEN10CA333Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL-104 Wilga 80 · Linton, NDThe pilot's failure to maintain aircraft control during landing with a 90-degree crosswind.NTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.NTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR10CA230Accident · No injuriesData collectionFinal reportCessna 172S · Palo Alto, CAThe student pilot's failure to maintain directional control and the certified flight instructor’s delayed response to the student pilot's loss of control during the takeoff roll.NTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.NTSB WPR10CA225Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Yuba City, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA222Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Los Alamos, CAThe pilot's inadequate compensation for the crosswind conditions resulting in the loss of directional control while landing.NTSB ANC10CA033Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.NTSB CEN10CA231Accident · No injuriesData collectionFinal reportBeech 35 · Boulder, COThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ERA10CA243Accident · No injuriesData collectionFinal reportGlobe GC-1B · Carollton, GAThe pilot's improper recovery from the bounced landings, resulting in a loss of directional control.NTSB ERA10CA245Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hoensdale, PAThe pilot's improper final approach, resulting in a bounced landing and ground loop. Contributing to the accident was the pilot's lack of experience in tailwheel airplanes.NTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.NTSB ERA10CA239Accident · No injuriesData collectionFinal reportNew Standard D-25 · Vidalia, GAThe pilot’s failure to maintain directional control during landing.NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB WPR10TA213Accident · No injuriesFinal reportCessna T206H · Fullerton, CAThe pilot’s inadequate compensation for the wind conditions during the landing flare and failure to maintain directional control on the ground.NTSB CEN10CA221Accident · No injuriesData collectionFinal reportPiper PA-24-250 · West Chicago, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.NTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.