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 DEN82DA164Accident · No injuriesFinal reportCessna 172N · Durango, COThe pilot reported that he was starting his flare to land when a gust of wind was encountered. He reported that the aircraft touched down on the left main gear and got out of alignment with the runway. The pilot stated that rudder was applied, but he was…NTSB ANC82DAG41Accident · No injuriesFinal reportCessna 336 · Anchorage, AKThe aircraft was equipped with a stol kit. The pilot stated that during a landing, the plane touched down at about 80 mph and veered slightly left when he reduced power. He compensated with right rudder and the right main wheel lifted off the surface. The…NTSB LAX82DA301Accident · No injuriesFinal reportCessna 152 · Santa Rosa, CAThe student pilot was on his first supervised solo flight. He had completed his first landing and was following through on a touch and go when he lost directional control. The aircraft veered left, ran off the side of the runway, hit a ditch and came to rest…NTSB LAX82DA300Accident · No injuriesFinal reportTaylorcraft DCO-65 · Santa Cruz, CADuring arrival, the pilot entered traffic to land on runway 31 with a wind from 130 deg at 5 KTS. The first approach to land was high, so a go-around was made. On the second approach, the aircraft was low and fast. Reportedly, the aircraft began to veer to…NTSB FTW82DA329Accident · No injuriesFinal reportCessna 152 · Santa Fe, NMThe student pilot was on his first supervised solo flight. During a touch-and-go landing, when power was added for takeoff, at about 50 KTS, he lost control of the aircraft departed the runway, it struck a bush and nosed over.NTSB LAX82DA303Accident · Minor injuriesFinal reportCessna 172N · Pine Springs, AZPlt stated he landed at what he thought was his destination arpt. The field was soft & an attempted takeoff was unsuccessful. He then taxied to an adjacent paved road & a second takeoff was attempted. The main landing gear went off the shoulder & the acft…NTSB LAX82DA298Accident · No injuriesFinal reportCessna 152 · Livermore, CAThe student pilot was departing on a solo cross-country flight. He lost control of the aircraft on the takeoff roll, hit a ditch and nosed over. The aircraft owner, who was also his instructor, stated that a moderate crosswind existed during the takeoff roll.…NTSB FTW82DRG40Accident · No injuriesFinal reportBeech E18S · Corpus Christi, TXThe pilot reported that during the landing roll-out, the aircraft swerved after it had traveled some 1500 to 1700 ft down the runway. During the accident, the nose gear failed and the bottom of the aircraft was damaged from the forward spar to the nose. Also,…NTSB FTW82DA325Accident · No injuriesFinal reportCessna 172A · Sandia, TXThe pilot-in-command (PIC) reported that he was of mexican nationality, had a mexican medical certificate, and was an instructor pilot. He had a total flight time of only 230 hrs. The aircraft had departed Sandia, TX on a local training flight about 30…NTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.NTSB LAX82DA285Accident · No injuriesFinal reportPiper PA-18 · Lake Berryessa, CAPilot landed too fast in a no wind condition and groundlooped trying to stop. Heavy braking in grass caused a nose over the pilot says he will lengthen the 720 foot runway.NTSB FTW82DA341Accident · No injuriesFinal reportBoeing E75 · Monahans, TXPilot lost control of aircraft during landing and groundlooped.NTSB FTW82DA349Accident · No injuriesFinal reportCessna 172N · Antoine, ARThe pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch.NTSB MKC82DA139Accident · No injuriesFinal reportPiper PA-20 · Scottsbluff, NEDuring takeoff, the pilot raised the tail at about 50 mph and the aircraft veered to the left. Despite the pilot's countermeasures, it departed the left side of the runway. The right gear then collapsed and the right wing and propeller were damaged. An…NTSB NYC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, CTThe pilot began taking off on runway 19 with a right crosswind. Reportedly, a strong gust of wind was encountered and the aircraft veered off the left side of the runway. It headed toward the opening of a culvert that went under the runway. To avoid the…NTSB NYC82DA197Accident · No injuriesFinal reportBellanca 8KCAB · Hanover, NJThe pilot stated that during the landing, the right brake failed after he touched down about midway on the runway at night. He stated that he tried to stop by using a combination of right rudder and left brake. However, the aircraft veered off the left side…NTSB CHI82DA310Accident · No injuriesFinal reportCessna 195A · Dixon, ILThe pilot landed downwind on runway 26 and the aircraft groundlooped during the landing roll. The main landing gear and left wing tip were damaged during the swerve.NTSB ANC82DA066Accident · No injuriesFinal reportPiper PA-17 · Anchorage, AKWhile landing with a light crosswind, the aircraft veered to the right and the left gear collapsed. There was no evidence of a pre-accident malfunction of failure.NTSB LAX82DA286Accident · No injuriesFinal reportCessna 172N · Novato, CAThe pilot landed on runway 31 with a left crosswind. While landing, the aircraft went off the right side of the runway and nosed over in a drainage ditch. The pilot estimated that the wind was from 220 deg at 10 KTS. The official observation at oakland, CA…NTSB FTW82DA309Accident · No injuriesFinal reportStinson 10A · Los Lumas, NMWhile landing, the plane touched down in a crosswind from the right at 15 knots. The pilot reported that the plane weathercocked to the right and went into a ditch. Reportedly, the pilot was unable to control the heading of the aircraft in the crosswind.NTSB ATL82FA224Accident · No injuriesField investigationFinal reportCessna 172 · Mt Airy, NCAfter arriving at the destination, the pilot landed on runway 36 with a westerly wind at about 7 gusting 10 KTS. After touchdown, the plane veered to the right, hit a ditch and was damaged. A post crash examination revealed no discrepancies with the braking…NTSB ATL82DA255Accident · Minor injuriesFinal reportBenson B8M · Ashland, KYThe pilot had a private license with a single engine land rating, but only had about 1 hr of previous flight time in the bensen gyrocopter. The owner stated that he told the pilot not to climb above 5 to 6 ft. the owner also stated that the pilot told him he…NTSB FTW82DA303Accident · No injuriesFinal reportCessna T21OM · Los Lunas, NMDuring arrival, the pilot landed on a wet runway while in a light crosswind from the right. During the landing roll-out, the aircraft drifted off the left side of the runway. After departing the runway, the nose and left main gear hit a concrete gutter and…NTSB FTW82DA301Accident · No injuriesFinal reportBeech B99A · Abilene, TXThe pilot was in the left seat and was getting a check ride from the chief pilot who was in the right seat. After making a series of touch-and-go landings, the aircraft pulled slightly to the left during a takeoff. A full pattern was then flown to runway 17R…NTSB DEN82FTM15Accident · No injuriesFinal reportOar Acapella · Woods Cross, UTThe pilot reported that as he was lifting the nose wheel during takeoff when the left tire encountered 1 to 2 inches of water and broken pavement. He stated that the plane veered left and he applied full right rudder to recover, then the aircraft went off the…NTSB NYC82DA167Accident · No injuriesFinal reportCessna 182P · Hunter, NYThe brakes were ineffective during landing & the acft ran off the side of the rwy & came to rest inverted in bushes against a small hill. The brake linings were changed 204 flt hours prior to the accident. Inspection verified that the brakes were considerably…NTSB MKC82DA130Accident · Minor injuriesFinal reportPiper PA-28 · Council Bluffs, IAThe pilot was making his first solo landing, swerved off the runway, attempted a go-around and collided with a ditch.NTSB MIA82DA163Accident · No injuriesFinal reportCessna 188B · Malone, FLThe flight departed a private grass strip to dispense liquid chemicals on a nearby cotton field. Upon returning to land following the spraying operation the pilot experienced a loss of the right main brake. The pilot stated that the brakes had been serviced…NTSB LAX82DA270Accident · Minor injuriesFinal reportLuscombe 8A · Kernville, CADuring roll-out the plt lost directional control. The plt applied hard brakes to prevent the acft from entering the water adjacent to the rwy & the acft flipped over.NTSB FTW82DA287Accident · No injuriesFinal reportGrumman G-164B · Humnoke, ARThe pilot reported that during takeoff, the left main gear got off the side of the rough airstrip and into a rice field. Subsequently, the plane flipped over.NTSB DEN82DA138Accident · Minor injuriesFinal reportCessna 172 · Billings, MTThe aircraft crashed during a landing on runway 27R. At the time of the accident, the winds were reported to be from 210 degrees at 11 KTS. The pilot stated that he encountered moderate turbulence during the approach. He believed that he also encountered a…NTSB FTW82DA288Accident · No injuriesFinal reportCessna 152 · Huntsville, TXThe student stated that on her fourth landing of the day, she felt she was too FAR down the runway and to high to make a good landing, so she "put in flaps and power and was going to make a go-around." Reportedly, the aircraft landed, she lost directional…NTSB ATL82DA204Accident · No injuriesFinal reportGulfstream G-164B · Edison, GAWhile landing on a private sod strip to reload, the aircraft began pulling to the right. The pilot stated that all efforts to counteract with left brake, rudder, and power had no effect. Subsequently, the right wing struck a fence and the plane flipped over…NTSB MKC82DA127Accident · No injuriesFinal reportPiper PA-28-235D · Falls City, NEThe pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…NTSB FTW82DA284Accident · No injuriesFinal reportBeech 95-A55 · Jonestown, TXThe pilot stated that during the takeoff roll, he encountered a strong pull to the right. The aircraft departed the right side of the runway, went down an eight foot embankment, and was substantially damaged. After the accident, the wheels rolled freely and…NTSB CHI82DA252Accident · No injuriesFinal reportCessna 150 · Bloomington, INThe student pilot reported that during arrival, he was unable to contact UNICOM. He stated that he saw other aircraft using runway 35. A landing was made on runway 35 with the wind from 180 at 12 KTS. The pilot stated that during the roll-out, the aircraft…NTSB ATL82DA201Accident · No injuriesFinal reportCessna 182E · Taplin, WVThe pilot stated that the sod runway had just been mowed. During the takeoff roll, the left wheel pant became filled with cut grass and locked the wheel. Subsequently, the aircraft veered to the left. The pilot reported that the left wing contacted low trees…NTSB CHI82DA264Accident · No injuriesFinal reportCessna 152II · Zanesville, OHAircraft swerved off runway into tire casings used as a ditch barrier and flipped inverted during landing roll.NTSB ATL82DA197Accident · No injuriesFinal reportBellanca 7ECA · Savannah, GAThe owner/pilot stated that he was checking out the other pilot in the tailwheel equipped aircraft. The owner was a private pilot and the other pilot was reportedly a flight instructor (ip). During the landing roll, the ip overcorrected with the rudder and…NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…NTSB LAX82DA263Accident · No injuriesFinal reportCessna A185F · Bakersfield, CAThe pilot reported that during landing, the aircraft encountered a gust of wind and veered to the right. Reportedly, the aircraft went off the right side of the runway, went into soft dirt and nosed over. The pilot reported that the wind was from 320 deg at 5…NTSB NYC82DA149Accident · No injuriesFinal reportBellanca 7GCBC · North Adams, MAThe pilot reported that during the landing roll-out, the aircraft had slowed to about 20 mph when it started to veer slightly to the left. He stated that a slight right rudder and brake correction was made and the plane veered to the right. Reportedly, he was…NTSB LAX82DA251Accident · No injuriesFinal reportCessna P-210N · Reno, NVThe aircraft veered off the runway during landing. The weather was VMC and no flight plan was filed. The landing was on runway 16 and the wind was from 300 degrees at 14 knots. The pilot did not file an accident report.NTSB NYC82DA146Accident · No injuriesFinal reportCessna 305A · Morrisville, VTThe pilot reported that he landed on runway 19 with a wind from 250 deg at 15, gusting 20 knots. He reported that as the aircraft rolled out, a severe gust of wind was encountered that put the plane on the left gear only. Subsequently, the left gear failed…NTSB FTW82DA272Accident · No injuriesFinal reportBeech B35 · Ft. Worth, TXThe pilot stated that while he was on final approach, he was carrying a little power since he was a little low. He stated that as the aircraft crossed the threshold, he reduced power and the plane yawed to the right. Subsequently, the aircraft headed toward a…NTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.NTSB ATL82DA186Accident · No injuriesFinal reportCessna A188 · Statesboro, GAThe pilot stated that he landed the aircraft on the numbers but was close to the left side of the runway. He delayed applying right rudder and the aircraft ground looped. The right landing gear collapsed and the right wing was substantially damaged.NTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.NTSB ATL82DA187Accident · No injuriesFinal reportMooney M20J · Swan Quarter, NCThe pilot landed with an effective crosswind component of about 10 KTS. He stated that after he retracted the flaps, the aircraft began to yaw to the left. He applied right rudder and started to go around, but subsequently, the left wing impacted 8-foot high…NTSB CHI82DA229Accident · Minor injuriesFinal reportClancy Skybaby · Grand Haven, MIDuring the pilots fourth takeoff roll of the day the right wing began to drop and the aircraft drifted off the runway. Power was reduced and brakes applied but the aircraft overturned after encountering a soft sodded area. After the accident it was noted that…