NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 LAX92LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lake Havasu, AZThe failure of the pilot to maintain directional control of the aircraft during the landing touch down.NTSB ANC92LA066Accident · No injuriesLimited investigationFinal reportCessna C-170B · Talkeetna, AKLoss of control on landing roll due to the pilot's failure to maintain proper alignment, resulting in collision with terrain during an uncontrolled ground loop/swerve. A factor relating to the accident was the crosswind weather conditions.NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.NTSB ATL92LA094Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Wilmington, NCThe pilot's failure to obtain proper assistance during the engine starting procedure, and his failure to properly attend to the airplane with the engine running.NTSB DEN92LA049Accident · Minor injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Montrose, COFailure of the pilot in command to maintain control of the aircraft during landing roll. A factor was: the aircraft struck a ditch which ran parallel to the runway.NTSB CHI92DCJ03Accident · No injuriesFinal reportSchweizer G-164B · Scotia, NEThe pilot's failure to maintain aircraft control which resulted in a nose over during the precautionary landing. Related factors are the power lines (obstructions) and inadequate altitude.NTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB CHI92LA138Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Sioux Falls, SDThe pilot-in-command's failure to maintain directional control.NTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB MIA92FA118Accident · Serious injuriesField investigationFinal reportCessna 172RG · Cedar Key, FLImproper recovery from the bounced landing by the pilot-in-command, and failure to maintain directional control. Contributing to the accident was the crosswind.NTSB NYC92LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryan, OHThe failure of the student pilot to maintain directional control during landing roll. Factors related to the accident were: the pilot's lack of total experience and lack of recent experience.NTSB ATL92LA087Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Rutherfordton, NCThe pilot's failure to maintain directional control during a landing roll which resulted in a collision with trees.NTSB ANC92LA063Accident · No injuriesLimited investigationFinal reportCessna 170 · Kenai, AKThe pilot's failure to maintain directional control. Factors to the accident were: an inadequate recovery from a bounced landing, and the pilot's lack of familiarity with the modified aircraft.NTSB ANC92LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's failure to maintain directional control. A factor to the accident was: a crosswind.NTSB LAX92LA177Accident · No injuriesLimited investigationFinal reportBeech E18S · Eloy, AZFailure of the pilot-in-command to maintain directional control and to properly compensate for the unfavorable wind conditions encountered during the takeoff ground run. Contributing to the accident was the unforecasted dust devil weather phenomena.NTSB NYC92LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, OHThe failure of the pilot to maintain airplane directional control after landing, which resulted in a departure from the runway and encounter with rough terrain.NTSB SEA92LA071Accident · No injuriesLimited investigationFinal reportCessna A185F · Billings, MTA worn tailwheel steering system and inadequate inspection of the airplane. A factor relating to the accident was the crosswind condition.NTSB CHI92LA124Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Garnavillo, IAThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in aircraft type.NTSB CHI92DEE01Accident · No injuriesFinal reportBoeing E75 · Leland, ILThe pilot's excessive application of brakes. A factor in the accident was the pilot's lack of experience in this model aircraft.NTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.NTSB NYC92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHThe failure of the pilot to maintain directional control during a touch and go which resulted in the airplane departing the runway and striking a ditch. Factors related to the accident were the improper use of the flight controls by the pilot and his lack of…NTSB MIA92LA104Accident · No injuriesLimited investigationFinal reportWaco U1-C · St. Petersburg, FLPilot-in-command's failure to maintain control of the airplane on landing. Contributing to the accident were the gusty crosswinds.NTSB FTW92LA106Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Weatherford, TXThe pilot's failure to maintain directional control during the landing rollout, and the ensuing inadvertent stall during the aborted landing due to the jammed elevator. A factor was the crosswind.NTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.NTSB ATL92LA070Accident · No injuriesLimited investigationFinal reportBeech C-23 · Dalton, GAThe pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.NTSB ANC92LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKDirectional control was not maintained. A factor to the accident was: inadequate recovery from a bounced landing.NTSB DEN92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Erie, COA loss of directional control when the pilot failed to adequately compensate for crosswind conditions during landing roll. A factor was: a 27 knot crosswind gust.NTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.NTSB ANC92LA048Accident · Minor injuriesLimited investigationFinal reportGerald G. Holland Challenger II · Fairbanks, AKExcessive taxispeed and directional control was not maintained. Factors to the accident were: lack of familiarization with aircraft and inadequate airspeed.NTSB LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.NTSB DEN92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Longmont, COThe pilot's failure to maintain directional control during landing. Factors were: a snow bank alongside the runway, and gusty crosswind.NTSB BFO92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Doylestown, PAFailure of the pilot to maintain directional control during touchdown, which resulted in an inadvertent ground swerve. A factor related to the accident was the gusty crosswind condition.NTSB SEA92LA059Accident · No injuriesLimited investigationFinal reportCessna 172G · Billings, MTThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB CHI92LA108Accident · No injuriesLimited investigationFinal reportCessna 150 · Waseca, MNDirectional control was not maintained by the pilot.NTSB ANC92LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · Juneau, AKThe pilot failed to maintain directional control during the landing roll.NTSB ATL92LA061Accident · No injuriesLimited investigationFinal reportCessna 150M · Jesup, GAThe failure of the pilot to properly compensate for the crosswind resulting in failure to maintain directional control during landing. A factor was the crosswind condition.NTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.NTSB FTW92LA087Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe pilot's failure to maintain directional control during the takeoff roll phase of a touch and go.NTSB BFO92LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Brewer, METhe pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.NTSB MIA92LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Gainesville, FLThe improper in flight decision by the pilot-in-command to land with an excessive rate of descent and airspeed. Contributing to the accident was the pilot-in-command's improper recovery from a bounced landing which resulted in an on ground loss of control…NTSB DEN92LA039Accident · No injuriesLimited investigationFinal reportBeech 55 · Longmont, COThe student pilot's failure to maintain directional control and the flight instructor's inadequate supervision.NTSB DEN92LA038Accident · No injuriesLimited investigationFinal reportThorpe T-18 · Albuquerque, NMA failure of the rudder control system when the pilot attempted to correct for an inadvertent ground loop during landing roll.NTSB CHI92LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Peru, ILThe students pilot's inadequate compensation for wind conditions. A factor in the accident was the pilot's lack of experience in the type of operation.NTSB CHI92LA092Accident · No injuriesLimited investigationFinal reportCessna 340A · Lapeer, MIThe pilot's failure to maintain directional control.NTSB ANC92LA037Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Sitka, AKThe pilot/flight instructor's loss of directional control during the landing roll and the subsequent ground loop/swerve. Contributing to the accident was the gusty crosswind condition.NTSB ANC92LA036Accident · No injuriesLimited investigationFinal reportRichard C. Ballow Kitfox 1 · Valdez, AKThe pilot's improper use of the airplane's brakes. Factors which contributed to the accident were the icy runway condition and the pilot's lack of total experience with this type of operation.NTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.NTSB NYC92LA091Accident · No injuriesLimited investigationFinal reportBeech 99 · Bangor, METhe pilot's failure to maintain aircraft control while taxiing on an icy surface. Factors related to the accident were the unfavorable winds and the icy ramp conditions.NTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.