NTSB investigations
3,845 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 ANC22LA056Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot's failure to maintain control of the airplane during taxi operations on a riverbank with shallow water.NTSB WPR22LA252Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · San Martin, CAThe pilot’s failure to maintain directional control during landing.NTSB WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.NTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR22LA244Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Afton, WYThe pilot's inadequate flare and bounced landing which resulted in loss of directional control of the airplane during the landing roll.NTSB GAA23WA010IncidentClass 5 · ForeignBeech 400A · Cornwall, United KingdomNTSB ERA22LA359Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Fitchburg, MAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB GAA22WA230Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Oktyabsky, RussiaNTSB WPR22LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna T210R · Stanley, IDThe pilot’s failure to provide adequate braking during a tailwind landing, which resulted in a runway excursion.NTSB CEN22LA302Accident · Minor injuriesClass 4 · LimitedFinal reportPitts S1 · Sturgeon Bay, WIThe pilot’s failure to maintain airplane control during landing, which resulted in a runway excursion and nose over. Contributing to the accident was the pilot’s inadequate preflight inspection and the pilot’s lack of flight control system knowledge.NTSB CEN22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Walker, MNThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action during a go-around.NTSB ANC22LA059Accident · No injuriesClass 4 · LimitedFinal reportKakeldey Ronald O Smith PA12 EXP · Beluga, AKThe pilot’s loss of control during the landing roll.NTSB WPR22LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Prescott, AZThe pilot receiving instructions failure to maintain directional during the takeoff ground roll and the flight instructor’s inadequate supervision.NTSB WPR22LA233Accident · No injuriesClass 4 · LimitedFinal reportGMK Ventures AL18 · Moab, UTThe pilot’s failure to maintain directional control during a landing attempt, which resulted in a ground loop and collision with terrain. Contributing to the accident was the absence of an airspeed indicator due to an alternator failure.NTSB ERA22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Lewisburg, TNThe pilot’s loss of control during the takeoff roll, which resulted in a runway excursion.NTSB CEN22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cleveland, MSThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and substantial damage.NTSB ANC22LA048Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Elfin Cove, AKThe pilot’s failure to maintain directional control during takeoff which resulted in an impact with terrain. Contributing to the accident was the pilot’s momentary distraction from conflicting boat traffic.NTSB WPR22LA224Accident · No injuriesClass 4 · LimitedFinal reportRobert Fitts Fitts CUB · Hillsboro, ORThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB WPR22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Hailey, IDThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a ground loop.NTSB WPR22LA237Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Auburn, WAThe pilot's failure to maintain directional control during the landing roll, and the flight instructor’s delayed remedial action.NTSB CEN22LA280Accident · No injuriesClass 4 · LimitedFinal reportAero Commander S2R · Maryville, MOThe pilot’s failure to maintain control during the landing with a quartering tailwind.NTSB ERA22LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Owensboro, KYThe student pilot's improper flare, which resulted in a loss of control during landing.NTSB CEN22LA296Accident · No injuriesClass 4 · LimitedFinal reportBaker Eugene L RV6-A · Goldsby, OKThe pilot’s failure to maintain directional control during landing resulting in a runway excursion.NTSB WPR22LA217Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CC19-215 · McCall, IDA loss of directional control during the landing roll due to a fractured brake line fitting on the brake caliper.NTSB WPR22LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Sunriver, ORThe pilot's failure to maintain control of the airplane during takeoff, which resulted in a collision with terrain.NTSB WPR22LA206Accident · No injuriesClass 4 · LimitedFinal reportShea Pitts Special S-1C · Reno, NVThe pilot’s failure to maintain directional control during landing roll.NTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.NTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA231Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC1B · El Paso, TXThe pilot’s failure to maintain directional control of the airplane during take off.NTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ERA22LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Jacksonville, FLThe pilot’s failure to maintain directional control during a touch-and-go landing after applying power for takeoff, which resulted in a runway excursion and noseover.NTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB ANC22LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gulkana, AKThe pilot’s failure to maintain directional during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with terrain.NTSB WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.NTSB CEN22LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Marion, TXThe pilot’s loss of control during landing.NTSB CEN22LA209Accident · No injuriesClass 3 · LimitedFinal reportTextron B300C · Fort Stockton, TXThe pilot’s failure to maintain directional control while landing with a single engine and maximum braking effort.NTSB CEN22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Beach City, TXThe pilot’s failure to maintain directional control in a gusting quartering tailwind that resulted in a loss of control and impact with trees.NTSB WPR22LA187Accident · Minor injuriesClass 4 · LimitedFinal reportTwenty Second Street Backcountry Boss · Douglas, WYThe pilot’s inadequate flare and subsequent loss of airplane control during landing.NTSB ERA22LA225Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Owensboro, KYThe pilot's failure to maintain directional control during takeoff.NTSB WPR22LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Franklin, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR22LA176Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Tucson, AZThe pilot’s failure to maintain directional control during landing.NTSB CEN22LA191Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6A · Mankato, MNThe pilot’s failure to maintain directional control while landing with a higher airspeed.NTSB WPR22LA170Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22/135 · Mesa, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA22LA221Accident · No injuriesClass 4 · LimitedFinal reportKyle M Sward / Larry W Sward CH 750 Cruzer · Lexington, KYThe pilot's failure to maintain directional control during landing.NTSB CEN22LA193Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Huntington, INLoss of directional control during landing that resulted in an impact with terrain.NTSB ERA22LA214Accident · No injuriesClass 4 · LimitedFinal reportNorth American SNJ-6 · Greenwood, SCThe loss of directional control due to a fractured tailwheel steering linkage assembly.NTSB ERA22LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Hampton, GAThe student pilot’s application of excessive left brake during the landing roll, resulting in a loss of directional control and a runway excursion. The flight instructor’s inadequate remedial action was a factor in the accident.NTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.NTSB GAA22WA169Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Konstanz, GermanyNTSB ERA22LA205Accident · No injuriesClass 4 · LimitedFinal reportMaule MX7 · Tampa, FLThe pilot’s failure to maintain directional control during the landing roll.