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 ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.NTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.NTSB CEN23LA392Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Midlothian, TXThe pilot’s failure to maintain directional control during landing which resulted in the right main landing gear collapse.NTSB CEN23LA428Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-31A · Maurice, IAThe pilot’s failure to maintain directional control during the landing.NTSB ANC23LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chinitna Bay, AKThe pilot’s failure to maintain directional control on takeoff.NTSB WPR23LA328Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Hillsboro, ORThe student pilot’s failure to maintain airplane control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB WPR23LA337Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 195B · Los Lunas, NMThe pilot’s failure to secure the seat’s position in the seat rail, which resulted in a loss of directional control and nose over.NTSB CEN23LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 182T · Klein, TXThe pilot’s failure to maintain directional control during the crosswind landing.NTSB CEN23LA378Accident · No injuriesClass 4 · LimitedFinal reportPiper J4 · Cleburne, TXThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions.NTSB ERA23LA343Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-17 · Millbrook, NYThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB CEN23LA375Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Rice, MNThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB CEN23FA369Accident · 1 fatalClass 3 · FieldFinal reportPiper J5A · Iola, WIThe pilot’s failure to maintain control of the airplane after landing on a grass taxiway with a tailwind, which resulted in a nose over.NTSB ANC23LA072Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Palmer, AKThe pilot’s failure to maintain directional control during the landing rollout.NTSB WPR23LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Moab, UTThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB CEN23LA366Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Derby, KSThe pilot’s loss of directional control during takeoff roll due the passenger’s interference with the rudder pedals, which resulted in a runway excursion.NTSB CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.NTSB CEN23LA362Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Harvard, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a runway excursion and an impact with the cornfield.NTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.NTSB CEN23LA356Accident · No injuriesClass 4 · LimitedFinal reportVans JV-Special / RV8 · Roanoke, TXThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB GAA23WA232Accident · No injuriesClass 5 · ForeignCessna 180H · Lolland, DenmarkNTSB WPR23FA301Accident · 1 fatalClass 3 · FieldFinal reportGlasair Glastar · Idaho City, IDThe pilot’s loss of airplane control during takeoff for reasons that could not be determined.NTSB ERA23LA318Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Laconia, NHThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane, which resulted in a ground-loop.NTSB CEN23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Sherman, TXThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.NTSB CEN23LA343Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCX-1865 · Charleston, WVThe pilot’s failure to maintain direction control during the landing roll.NTSB CEN23LA334Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Aberdeen, SDThe pilot's failure to maintain directional control while taxiing with a quartering tailwind, which resulted in a ground loop.NTSB ANC23LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Point Baker, AKThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB WPR23LA284Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Red Lodge, MTThe pilot’s loss of directional control during landing with wind gusts, which resulted in a ground loop and collision with a fence.NTSB ERA23LA311Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Winter Haven, FLThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with a taxiway sign.NTSB WPR23LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12S · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.NTSB ERA23LA312Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Roanoke, VAThe student pilot’s failure to maintain directional control during the landing, and the flight instructor’s inadequate remedial action.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.NTSB WPR23LA276Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chelan, WAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and subsequent nose over.NTSB CEN23LA368Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Eagle River, WIThe pilot’s failure to maintain proper airspeed on approach, which resulted in an extended touchdown, loss of control, and runway excursion.NTSB CEN23LA429Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Muncie, INA loss of directional control during the landing roll due to the left wheel seizing from insufficient grease in the left wheel bearing.NTSB CEN23LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Greenwood, INThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN23LA300Accident · No injuriesClass 4 · LimitedFinal reportAcrosport II · Hertford, NCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with vegetation.NTSB WPR23LA271Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Burlington, WAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB GAA23WA206Accident · No injuriesClass 5 · ForeignBeecraft 1A · Bengaluru, IndiaNTSB CEN23LA301Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot’s failure to maintain helicopter control while on the ground when his attention was diverted for post flight activities.NTSB CEN23LA289Accident · No injuriesClass 4 · LimitedFinal reportMooney M20A · Frankston, TXThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA268Accident · No injuriesClass 4 · LimitedFinal reportVickers-Armstrong Spitfire IX · Deer Park, WAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR23LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fremont Island, UTThe pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.NTSB CEN23LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Grand Prairie, TXThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the unexpected sudden wind shift.NTSB WPR23LA248Accident · No injuriesClass 4 · LimitedFinal reportFound FBA2C · Moses Lake, WAThe pilot’s failure to maintain directional control during landing.NTSB CEN23LA288Accident · No injuriesClass 4 · LimitedFinal reportAirborne XT 582 · Oregon, ILThe pilot’s failure to maintain directional control after a bounced landing.NTSB ERA23LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s loss of directional control while landing, which resulted in a runway excursion and collision with an airport sign.NTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.