NTSB investigations
4,590 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 WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.NTSB ANC21LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Anchorage, AKA loss of control during landing for reasons that could not be determined based on the available evidence.NTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.NTSB ERA21LA182Accident · No injuriesClass 4 · LimitedFinal reportRowe Dennis A Highlander · Bluefield, WVThe pilot’s failure to maintain directional control while landing in a gusty crosswind, which resulted in a ground loop.NTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.NTSB CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.NTSB ANC21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Lime Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a landing gear collapse.NTSB ERA21LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Fayetteville, NCThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.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 CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.NTSB CEN21LA182Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Denver, COThe pilot’s loss of situational awareness, and his unintended landing on a soft unimproved dirt road, which resulted in a loss of directional control into soft ground and the airplane to subsequently nose over.NTSB CEN21LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Austin, TXThe pilot’s failure to maintain directional control while turning onto the taxiway in variable wind conditions.NTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.NTSB WPR21LA167Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Petaluma, CAThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground loop.NTSB WPR21LA147Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Ogden, UTThe pilot's failure to maintain directional control during the landing roll with a light crosswind, which resulted in a runway excursion and collision with terrain.NTSB ERA21LA162Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 1730 · Bessemer, ALThe pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.NTSB ERA21LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · West Chester, PAThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with airport lights and a hangar.NTSB ANC21LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.NTSB CEN21LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Watkins, COThe pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB WPR21LA136Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Myrtle Creek, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB ERA21LA156Accident · Serious injuriesClass 3 · LimitedFinal reportSchempp-Hirth K G MINI-NIMBUS C · Groveland, FLThe pilot’s unsuccessful initial attempt to release from the tow plane at the start of an unstable takeoff roll, which resulted in a runway excursion and collision with a parked vehicle. Contributing to the severity of the accident was the vehicle’s proximity…NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.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 ERA21LA151Accident · No injuriesClass 4 · LimitedFinal reportBeech Sierra · Augusta, METhe pilot’s improper landing flare, which resulted in a bounced landing, and a subsequent runway excursion. Also causal was the flight instructor’s delayed remedial action.NTSB WPR21LA125Accident · No injuriesClass 4 · LimitedFinal reportPhillip B Rolls Pitts 12-EH · Red Bluff, CAThe pilot's failure to maintain directional control during a landing, which resulted in a ground loop and subsequent nose over.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB ERA21LA136Accident · Serious injuriesClass 4 · LimitedFinal reportTurcotte JR Robert L RV6 · North Hampton, NHThe pilot’s failure to maintain directional control during the landing in a crosswind condition, which resulted in a runway excursion.NTSB ERA21LA134Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · St. Marys, PAThe pilot’s decision to continue the approach to a snow-covered runway in low-visibility conditions with limited ability to visually differentiate the left runway edge from the snow berm that ran along that side of the runway.NTSB WPR21LA135Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1C-200 · Carefree, AZThe substandard installation of the airplane’s autopilot system hardware, which resulted in a malfunction of the rudder control system during flight and a loss of directional control during the landing roll.NTSB ANC21LA017Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Tyonek, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the airplane encountering deep snow and coming to rest inverted.NTSB CEN21LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Prairie du Sac, WIThe student pilot’s loss of directional control during takeoff, which resulted in the collision with a snowbank. Contributing to the accident was the compacted snow conditions on the runway surface.NTSB WPR21LA112Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Price, UTThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop, runway excursion and collision with terrain.NTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.NTSB WPR21LA106Accident · No injuriesClass 4 · LimitedFinal reportJabiru SP 250 · Thermal, CAThe pilot’s loss of directional control during landing in gusting wind conditions, which resulted in a runway excursion and nose over.NTSB CEN21LA120Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Clare, MIThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and impact with terrain.