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 ANC86LA117Accident · No injuriesLimited investigationFinal reportCessna 185E · Tetlin, AKAcft left rwy and crashed during attempted go-around with 10 to 25 knot crosswind. Pilot stated that engine did not develop full power. Examination and test run of engine did not reveal any mechanical failures/malfunctions.NTSB NYC86LA192Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Wolfeboro, NHWhile landing, the aircraft bounced slightly & the plt lost directional control. The aircraft veered left over the runway edge onto a soft shoulder, nosed over & was damaged.NTSB LAX86LA306Accident · No injuriesLimited investigationFinal reportCessna 195 · Ramona, CAThe aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a…NTSB NYC86LA188Accident · No injuriesLimited investigationFinal reportBeech BE-20 · Farmingdale, NYAfter a short distance on the takeoff roll, the aircraft veered sharply to the left. Pilot attempted to correct, but was unsucessful and the aircraft collided with parked unoccupied aircraft.NTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…NTSB CHI86LA188Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Winneconne, WIWhile landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed.NTSB ATL86LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sandusky, OHThe pilot reported that he diverted and landed to reassess the weather before continuing his flight. He said the wind was from the southwest at eight KTS. Just before touchdown on runway 27, the aircraft yawed left and landed while in a crab. The airplane…NTSB DEN86LA206Accident · No injuriesLimited investigationFinal reportTroutman Quickie Q2 · Rawlins, WYThe plt, flying a homebuilt quickie Q2, attempted a ldg on rwy 22 with winds of 20K, gusting to 30K out of 250 degrees. After touchdown the acft weather vaned into the wind. The acft left the rwy, flipped over and was substantially damaged.NTSB ATL86LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7E6A · Alliance, OHDuring the second landing attempt, the pilot lost directional control and ground looped. The aircraft was substantially damaged and the pilot received minor injuries. The pilot did not report any aircraft problems. The pilot had completed a student pilot solo…NTSB NYC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172 M · Olcott, NYThe pilot flying a Cessna 172M with three passengers on board made a landing on a 2500 ft grass runway. This was his first landing on a grass runway. He touched down fast and became airborne, recovered, and became airborne again. His airspeed was too slow to…NTSB CHI86LA177Accident · No injuriesLimited investigationFinal reportCessna 150 · Indianapolis, INThe student plt had been practicing touch and go landings for aprx 1 hour. On the accident landing, the acft veered to the left. The plt overcorrected and the acft began to travel off the right side of the rwy. While attempting a go-around the acft's wing…NTSB LAX86FA297Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Corona, CAThe pilot stated to fire personnel that as he approached touchdown, the sun got in his eyes and a cross wind pushed him off the right side of his private airstrip. The aircraft landed hard on the right wheel, veered off the right side of the runway,…NTSB CHI86LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Allegan, MIGrass steip measures 1800 feet by 45 feet. Seven-foot tall corn stalks surround both sides of airstrip. The aircraft veered off center, to the left, during touchdown. Left wing contacted corn stalks, causing aircraft to cartwheel.NTSB SEA86LA173Accident · No injuriesLimited investigationFinal reportCessna 180 · Thomas Creek, IDThe plt reported not being lined up properly on the airstrip when power was applied for takeoff. A witness reported seeing the tail of the acft pulling to the left causing the acft to slide down the airstrip. The left landing gear dug into the terrain,…NTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…NTSB FTW86LA136Accident · No injuriesLimited investigationFinal reportCessna 305C · Stamford, TXThe pilot was receiving instruction on touch and go landings, in a tail wheel equipped aircraft, when he lost control on touchdown and ground looped the aircraft. The instructor was late with corrective action.NTSB DEN86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minot, NDAccording to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went…NTSB ATL86LA198Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Lake City, SCDuring landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway…NTSB SEA86LA169Accident · No injuriesLimited investigationFinal reportCessna 170B · Roche Harbor, WAThe plt lost directional control of the aircraft during landing rollout with a crosswind. The aircraft drifted to the left of the runway at which time the plt applied full aft elevator, full right rudder and full right aileron. The plt reported the acft made…NTSB MKC86LA149Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Arkansas City, KSThe certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately…NTSB SEA86LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Boise, IDWhile taxiing for takeoff an inadvertant ground loop occurred during which the acft veered left striking another parked acft. The plt stated it felt as though the tailwheel jammed; however, post accident exam failed to disclose any failure/malfunction.NTSB MIA86LA206Accident · No injuriesLimited investigationFinal reportCessna 195A · Orlando, FLThe plt stated that the left main gear collapsed while he was trying to recover from a 45 degree swerve to the right during lanidng.NTSB MKC86LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Olathe, KSThe PIC had mistakenly attempted a landing at another airport 8 miles west of his intended destination. The PIC realized his mistake and diverted to his final destination. The PIC landed at the correct airport, but veered sharply to the right on landing on…NTSB MIA86LA203Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Pompano Beach, FLThe student plt lost control of the acft as power was applied to takeoff. The instructor plt then took control of the acft as it left the rwy, after which the left gear became stuck in sand. The acft nosed over and came to rest inverted.NTSB ANC86LA112Accident · No injuriesLimited investigationFinal reportCessna 180B · Kvichak, AKThe plt attempted to become airborne without sufficient airspeed after noticing that there was not enough rwy remaining to complete the takeoff. The acft mushed and one of the main gears contacted a dirt bank. A loss of directional control resulted and the…NTSB SEA86LA164Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Juneau, AKThe acft veered left and ground looped during landing roll. The right main gear strut collapsed during the landing. The plt had 5 hours total flt time in this acft and stated the toe brakes seemed 'touchy' during the landing.NTSB CHI86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Effingham, ILAcft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of…NTSB LAX86FA282Accident · 1 fatalField investigationFinal reportCessna 150H · Phoenix, AZThe plt performed 1 normal touch & go operation, & touched down normally on the second planed touch & go which was to terminate with a right dep out of the pattern. After touchdown, witnesses observed the acft roll straight along the rwy centerline for about…NTSB FTW86LA122Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · San Antonio, TXThe pilot was cleared to land on runway 12L when he encountered wind gusts on touchdown causing the aircraft to veer off the runway into a grassy area.NTSB LAX86LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vacaville, CAThe student plt indicated that after his third approach, while flying solo, the acft veered to the right and went off the rwy during the landing roll. He attempted to correct the situation, but the acft collided with a 5 ft ditch, located aprx 38 ft from the…NTSB ANC86LA098Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Fairbanks, AKAfter touchdown on the runway, the pilot lost directional control of the aircraft which ground looped to the right. The right main gear was sheared off at the gear box during the ground loop.NTSB MKC86LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, IAThe student PIC was practicing touch and go landings at a pvt strip when on landing the PIC stated he lost directional control and veered off the left side of runway 33. The ensuing departure substantially damaged the acft. Rptd winds were 290 degrees at 10…NTSB NYC86LA167Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJAfter returning to the airport, the pilot lost directional control during the landing and the aircraft veered off the runway. Subsequently, the aircraft struck a runway light and the left main wheel & left wing were damaged.NTSB ANC86LA094Accident · No injuriesLimited investigationFinal reportCessna 180H · Eureka, AKThe airplane approached the short and high elevation airstrip too high and fast. It bounced on the rough surface and ran off the end before nosing over.NTSB NYC86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYDuring roll out after landing, the acft encountered a strong gust of wind & subsequently went off the side of the rwy. Before stopping, the acft went over an embankment & the nose gear collapsed.NTSB MIA86LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Titusville, FLThe plt stated that the wind changed from a crosswind to a tailwind on final apch. He continued the apch, landed, & during the landing roll, realized 'the brakes were not working properly,' & that he would be unable to stop the acft on the rwy. He then…NTSB MIA86LA196Accident · No injuriesLimited investigationFinal reportPiper J5C · Daytona Beach, FLThe plt stated that he overflew the arpt to observe the wind direction as indicated by the wind sock. Upon landing on rwy 23, he lost control of the acft due to a left quartering tailwind. The acft then went through a chain link fence & came to rest in a…NTSB MIA86LA195Accident · No injuriesLimited investigationFinal reportBeech C23 · Pompano Beach, FLThe plt stated that on approach he noted that he had no left rudder control and during landing roll, the aircraft veered off the left side of the runway collapsing the nose gear. Post crash examination of the nose gear revealed that the nose wheel steering…NTSB NYC86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, MAThe plt rprtd he encountered a gust of wind & a wind shift during the flare to land. Subsequently, he lost directional control & the acft went off the side of the rwy, collided with a man-made pyramid of stone & rotated upside down. The plt rprtd the winds…NTSB DEN86LA177Accident · No injuriesLimited investigationFinal reportCessna 182P · Sheridan, WYA loss of directional control occurred during landing roll and the acft departed the left side of the grass/dirt landing strip. The acft then traveled down a slight embankment and collided with a wire fence and fence posts.NTSB ANC86FA092Accident · No injuriesField investigationFinal reportCessna 180H · Anchorage, AKThe pilot and the owner of the airplane serviced the brakes prior to takeoff. When they returned from a local flight, the right brake was inoperative during the landing roll-out. The airplane groundlooped to the left, then went off the left edge of the…NTSB NYC86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot was cleared for closed traffic touch and go landings; however, during his acceleration for takeoff, he lost directional control and the aircraft veered left off the runway. Not being able to regain control, the takeoff was aborted. The…NTSB MIA86LA192Accident · No injuriesLimited investigationFinal reportCessna 172N · Pensacola, FLThe plt stated that he landed long on the wet grass rwy. As he attempted to stop, the acft slid off the side of the rnwyinto a ditch, severing the nose gear & collapsing the left main landing gear.NTSB LAX86LA267Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Mammoth, CAThe plt lost control of the acft & it collided with terrain during a landing to rwy 27. The plt indicated that the winds were from 190 deg at 15 gusting 20 KTS. Reportedly, he landed on rwy 27 with an indicated airspeed of 80 mph. During the landing roll, a…NTSB ANC86LA091Accident · No injuriesLimited investigationFinal reportCessna 170A · Tyonek, AKThe relatively inexperienced private pilot attempted to land his airplane on a gravel beach as the tide was receding. He failed to maintain directional control and the airplane was substantially damaged in the ensuing ground loop.NTSB ANC86LA087Accident · No injuriesLimited investigationFinal reportCessna 305/L-19 · Barrow, AKThe non-certificated flight instructor failed to respond in time to improper control input by the student. The airplane ground looped and went on its nose sustaining substantial damage.NTSB MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.NTSB FTW86LRD15Accident · No injuriesFinal reportGrumman G-164B · Church Point, LAThe acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee.NTSB NYC86LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bally, PAThe pilot landed on ruwnay 34 in winds he estimated to be from 270 degrees at 10-15 knots. He stated that at touchdown, the left wing was caught by a gust and raised. The aircraft drifted right. The pilot stated there was sufficent runway to continue the…NTSB LAX86LA265Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, AZAfter completing a solo instructional flight the 80-HR student plt landed. During rollout the plt inadvertently applied excessive brake & rudder pressure to the left pedal. The plt lost directional control of the acft & it veered off the rwy. The acft…