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 DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB FTW89LA046Accident · No injuriesLimited investigationFinal reportCessna 180B · Nocona, TXThe pilot's disregard of the aircraft performance data/operational limitations by landing in excess of the crosswind capability of the aircraft, and the resultant loss of directional control during the landing roll.NTSB SEA89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Puyallup, WAFailure on the part of the student pilot to maintain directional control of the aircraft. Contributing to the accident were poor approach and flare technique and lack of recent experience.NTSB LAX89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Show Low, AZDelayed retraction of flaps and the inadvertent application of left rudder due to diversion of attention resulting in the airplane's departure from the runway. A contributing factor was the inexperience of the student pilot.NTSB ANC89LA038Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot failed to properly align the airplane on the runway for landing, then failed to maintain directional control after landing. Contributing to the accident was the pilots operation of the airplane with an inoperative landing light and the dark night…NTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.NTSB ANC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's failure to maintain control of the airplane while attempting to takeoff from a sloped terrain that was too steep for a safe operation. Contributing to the accident was the downhill, icy terrain conditions and the pilot's overconfidence in both his…NTSB NYC89LA071Accident · No injuriesLimited investigationFinal reportMooney M20J · Lumberton, NJFailure of the pilot to maintain directional control during a touch-and-go, which resulted in an inadvertent ground swerve. The presence of trees near the runway was considered to be a factor.NTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.NTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.NTSB MKC89LA052Accident · No injuriesLimited investigationFinal reportStinson 108-1 · South St. Paul, MNThe failure of the pilot to maintain directional control of the airplane. Contributing to the accident were the crosswind conditions.NTSB BFO89LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe pilot's failure to maintain directional control of the airplane during landing and the failure to achieve sufficient airspeed during the go-around to initiate a climb.NTSB NYC89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Turners Falls, MALoss of control during landing roll due to ice on the runway, and collision with a snow bank off the runway which sheared the left main landing gear.NTSB MIA89LA062Accident · No injuriesLimited investigationFinal reportCessna 210L · Greenwood, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB LAX89LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Alturas, CAThe failure of the instructor pilot to maintain directional control of the airplane on the snow-covered runway, resulting in a nose-over when the airplane continued off the runway into deeper snow.NTSB LAX89LA079Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Calexico, CAA binding brake system torque plate. Factors related to the accident were: inadequate maintenance by other maintenance personnel, and operation of the airplane with a known efficiency by the pilot.NTSB DEN89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Craig, COUnsuitable terrain (runway condition) selected by the pilot. Factors related to the accident were: the adverse weather conditions, inadequate removal of snow from the runway by airport personnel, uneven snow covered runway, lack of visual perception by the…NTSB LAX89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe excessive speed which the pilot was maintaining and his improper operation of the brake system. Contributing to the accident was the inexperience of the student pilot.NTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILNTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…NTSB LAX89LA072Accident · No injuriesLimited investigationFinal reportBeech A24R · Grass Valley, CAAt the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There…NTSB ANC89LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Girdwood, AKThe private pilot escaped injury when his airplane collided with snow removal vehicles while landing at the Girdwood airport, Girdwood, AK. The pilot reported that he flew over the airstrip, in his ski-equipped airplane, saw the equipment on the runway, and…NTSB NYC89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Wiscasset, METhe plt lost control during an attempted go-around, and collided with trees off the side of the runway. The pilot said that a gust of wind turned the acft 45 degrees to the runway on landing roll, and during the attempted go-around he hit tree tops off to the…NTSB LAX89LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Corona, CAThe aircraft was found abandoned at the airport. A witness reported that the aircraft had flipped over on runway 25. The sole occupant, a male, was not injured. The aircraft was moved by the occupant and several other unidentified people to a tiedown area on…NTSB MKC89LA044Accident · Minor injuriesLimited investigationFinal reportMaule M-7 · Harrisonville, MODuring a crosswind landing the pilot lost directional control of the aircraft. The pilot elected to abort the landing by applying takeoff power and becoming airborne. The pilot attempted a turn at low airspeed and low altitude to avoid trees in his flight…NTSB ATL89LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Sandusky, OHThe plt landed the acft on rwy 27 in winds that he estimated were from 240 deg at 10 to 15 KTS with gusts to 25 KTS. He stated that when the groundspeed had slowed to about 20 KTS, the left wing started to raise. He applied full power & the acft lifted off…NTSB NYC89LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hyannis, MAThe acft ran off the runway and hit a landing light and terrain as the pilot attempted to make a crosswind landing, at barnstable airport, Hyannis, MA.NTSB NYC89LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Pedricktown, NJDuring landing the pilot lost directional control of the aircraft and ran off the left side of the runway, hit a dirt bank and flipped over.NTSB MKC89LA042Accident · No injuriesLimited investigationFinal reportBeech 58 · Elkhart, KSWhile attempting to land in strong crosswind conditions, the plt lost directional control. The acft veered off the runway and was substantially damaged. The winds were gusting over 40 knots, with occasional gusts of 60 knots.NTSB LAX89LA065Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Phoenix, AZThe pilot lost control during the landing roll and collided with a fence. He reported that he was completing his landing roll on runway 25L, when the aircraft was blown sideways by a gust of wind. He stated that he then applied power to avoid a ground loop.…NTSB CHI89LA032Accident · No injuriesLimited investigationFinal reportCessna 152II · Lake In The Hls, ILThe pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience.NTSB ANC89FA022Accident · No injuriesField investigationFinal reportCessna 172I · Chugiak, AKThe pilot lost control, skidded off the left side of the wet icy runway, and nosed over in a snowbank during the landing phase of an attempted touch and go landing. He stated that while on downwind, he saw the wind sock indicate a change of wind direction,…NTSB MIA89LA047Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Tampa, FLThe plt stated that he failed to maintain directional control during landing in a crosswind. He further stated that he aggravated the loss of control by over-application of the controls and adding full throttle which led to the aircraft departing the rwy and…NTSB DEN89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Englewood, COThe CFI and her student were practicing landings on rwy 10 with winds reported as 090 deg at 5 KTS. The student was on the controls, flared too high, and the acft bounced at touchdown. The CFI told him to add power to recover from the bounced landing. The…NTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.NTSB MKC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeview, ARDuring a personal cross country flight, the newly certificated private pilot said he was attempting to land on a 3200 foot grass strip with an existing gusting crosswind. He lost directional control during the landing, hit a runway light, tearing off the left…NTSB LAX89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring the first solo flight, the student pilot reported that while on final approach, the airplane was high. The student reduced power and extended full flaps. During the landing roll, the student was intending to exit the runway on a right taxiway, however,…NTSB MKC89LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Little Falls, MNWhile attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…NTSB ATL89LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe accident occurred during the student pilot's first supervised-solo flight. The student reported that she pushed the acft's nose down while on final appch after realizing she was too high, which led to an increase in airspeed. The student's instructor…NTSB DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…NTSB LAX89LA056Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Twentynine Palm, CAThe pilot stated that while landing, during the flare, a gust of wind raised the left wing. The pilot corrected just prior to touchdown. When the airplane touched down it ground looped to the right. The airplane ran off the runway and collided with a berm and…NTSB LAX89LA055Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAThe pilot stated that he lost directional control of the gyroplane during the landing roll, departed the rwy and nosed over. The gyroplane touched down normally on the main landing gear at an indicated airspeed of about 20 mph. As the gyroplane slowed…NTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…NTSB NYC89LA031Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Latrobe, PALoss of directional control while taxiing at an excessive speed.NTSB FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…NTSB NYC89LA026Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Pittstown, NJUncontrolled contact with trees after the pilot lost directional control of the aircraft during an attempted landing.NTSB MIA89IA028Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that on landing rollout, the acft veered off the left side of the runway and as it was slowing down, hit a depression in the ground and the left main gear collapsed. The acft then spun around and came to rest.NTSB DEN89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, MTThe commercial plt was landing after a pipeline patrol flight. There were no pax. The plt made a wheels landing on rwy 30 with wind reported from 270 at 28 KTS. During landing roll, a wind gust from the left side, estimated by the plt as 50 KTS, lifted the…NTSB DEN89LA027Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COThe private plt was flying 2 friends to his farm. His dirt strip runs east and west, but prevailing winds were 320 deg at 40, gusting to 50 KTS. A cross wind landing to the west had to be aborted and the plt elected to land to the north, on an access road.…