NTSB investigations, ID
161 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND 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 WPR21LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Lewiston, IDThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in a taxiway excursion and collision with a fence.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.NTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.NTSB WPR21LA153Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Sand Point, IDThe student pilot’s improper landing flare which resulted in a hard landing, loss of directional control and subsequent nose over.NTSB WPR21LA128Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · McCall, IDThe pilot's loss of directional control while landing in a crosswind, which resulted in a ground loop.NTSB WPR20LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Island Park, IDThe pilot’s failure to maintain directional control during a crosswind landing.NTSB WPR20CA307Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC11-160 · Big Creek, IDThe pilot’s failure to maintain directional control during the landing roll with a gusting wind, which resulted in a runway excursion and impact with a tree.NTSB WPR20CA297Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Givens Hot Springs, IDPilot's failure to maintain directional control on takeoff.NTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.NTSB WPR20CA227Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · McCall, IDThe pilot's decision to land with excessive approach airspeed, which resulted in the airplane landing long, the application of additional braking action to stop and subsequent nose over.NTSB WPR20CA231Accident · No injuriesClass 4 · Data collectionFinal reportChad Lewis Kitfox Super Sport · St Anthony, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion, contact with the airport perimeter fence, and subsequent nose over.NTSB WPR20CA100Accident · No injuriesData collectionFinal reportPiper PA28R · Twin Falls, IDThe pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light.NTSB WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB WPR20CA043Accident · No injuriesData collectionFinal reportJohn Sample Bearhawk · Nampa, IDThe pilot's selection of unsuitable terrain for landing, which resulted in impact with a knoll and a subsequent ground-loop.NTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.NTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.NTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.NTSB WPR19TA248Accident · Minor injuriesClass 3Final reportHall Kitfox · Nampa, IDThe owner's improper installation of the tailwheel, which resulted in the pilot's inability to maintain directional control during landing as a result of severe tailwheel vibrations.NTSB GAA19CA479Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Mackay, IDThe pilot's failure to maintain lateral control of the glider during landing in gusting wind conditions, which resulted in the left wing striking the ground and a subsequent ground loop.NTSB GAA19CA393Accident · No injuriesData collectionFinal reportCessna A185 · Stanley, IDThe pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.NTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overNTSB GAA19CA163Accident · No injuriesData collectionFinal reportAir Tractor AT 400A · Parma, IDThe pilot's failure to maintain directional control during landing in variable wind conditions, which resulted in the right wing impacting muddy terrain.NTSB GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA315Accident · No injuriesData collectionFinal reportJim Green CCX · Couer D'Alene, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB GAA18CA245Accident · No injuriesData collectionFinal reportAyres S2R · Weipee, IDThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.NTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.NTSB GAA17CA500Accident · No injuriesData collectionFinal reportBeech C23 · Rexburg, IDThe pilot's delayed decision to land the airplane with insufficient runway remaining after realizing the airplane wasn't climbing.NTSB GAA17CA471Accident · No injuriesData collectionFinal reportChampion 7ACA · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s use of excessive braking, which led to a nose-over.NTSB GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.NTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR17LA162Accident · No injuriesLimited investigationFinal reportCessna A185E · Nampa, IDThe pilot’s failure to maintain directional control of the tailwheel airplane during the landing roll.NTSB GAA17CA396Accident · No injuriesData collectionFinal reportChampion 7KCAB · Cottonwood, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA309Accident · No injuriesData collectionFinal reportMaule MX7 · Payette, IDThe pilot's failure to maintain directional during the landing.NTSB GAA17CA245Accident · No injuriesData collectionFinal reportCessna 185 · Marsing, IDThe pilot’s improper landing flare, which resulted in a bounced landing, the failure of the right main landing gear wheel, and a ground loop.NTSB GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.NTSB GAA16CA522Accident · No injuriesData collectionFinal reportDieterich Robert A AIR CAM · McCall, IDThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear wheel separating from the airplane, followed by an aborted landing, and a subsequent ground loop during the follow-on landing.NTSB GAA16CA459Accident · No injuriesData collectionFinal reportCessna A185 · Gooding, IDThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB GAA16CA446Accident · No injuriesData collectionFinal reportCessna A185 · Caldwell, IDThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA420Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Hailey, IDThe flight instructor's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground loop.NTSB GAA16CA375Accident · No injuriesData collectionFinal reportCessna A185 · Hayden Lake, IDThe pilot's failure to retract the amphibious airplane's land-wheels prior to landing on a lake, which resulted in a nose over.NTSB GAA16CA215Accident · No injuriesData collectionFinal reportCessna 172 · Boise, IDThe pilot's decision to land with a quartering tailwind and failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground loop.