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 MIA86LA256Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student pilot while on his third supervised solo flight in the traffic pattern veered left off the runway during a touch and go landing. The aircraft crossed the infield area and struck a parked aircraft. Post accident inspection of the aircraft braking…NTSB ATL86LLT09Accident · No injuriesFinal reportBeech 35A · Nashville, TNThe student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his…NTSB ANC86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot reported that he lost control of the airplane during the takeoff run on a dirt road. The accident occurred as the plane was going around a curve in the roadway.NTSB DEN86LA258Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Englewood, COPlt made two unsuccessful attempts to land on rwy 26 but discontinued each approach because of unfavorable winds. Winds were reported to be 220 deg at 20 KTS with gusts to 30 KTS. Plt then made two unsuccessful attempts to land on rwy 17L. On third attempt…NTSB DEN86LA253Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hurricane, UTUpon making a normal landing the aircraft groundlooped to the right, impacting with an embankment. Aircraft became airborne again and touched down in soft earth, nosed over and substantially damaged the aircraft. No injuries occurred on this VFR training…NTSB CHI86FEV05Accident · No injuriesFinal reportNord Stampe SV4C · Lacon, ILThe plt lost control of the acft during the landing roll, & subsequently, one of the main landing gear collapsed. He stated that he applied the left 'drag brake' (a braking device activated during the last portion of rudder travel) & overcorrected to the…NTSB ATL86LA263Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Louisville, KYFollowing a normal touchdown and landing, the pilot lost directional control and the aircraft veered off the left side of runway. The pilot stated that he was unable to correct the directional problem after the aircraft departed the runwaysurface. Examination…NTSB DEN86LTM03Accident · No injuriesFinal reportQuickie Q-2 · Grand Junction, COThe plt reported that the acft entered a porpoise during landing. While attempting to add power the eng quit. The landing gear then broke off and the acft entered a ground loop and ran off the rwy. The plt notes that the acft has a tendency to bounce during…NTSB SEA86LA246Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Reno, NVThe plt had been waiting in line for takeoff on runway 16 for over an hour, due to traffic departing air races. When cleared to depart, winds were 300 deg at 15 KTS, gusting to 22 KTS. Plt elected to attempt takeoff, became momentarily airborne with stall…NTSB LAX86LA350Accident · No injuriesLimited investigationFinal reportCessna 172 · Novato, CAThe pilot attempted a crosswind landing at the end of a pleasure cross country flight. A loss of directional control occurred on short final and the aircraft drifted right of the runway. A go-around was attempted without success and the aircraft rolled off…NTSB ANC86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Naknek, AKDuring the taxi to takeoff phase a strong gust of wind lifted the left wing causing the airplane to flip over on its back.NTSB CHI86LA223Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, INThe aircraft veered off the left side of the gravel runway during the takeoff ground roll. The pilot stated that the airstrip was surrounded by cornstalks, and that on the left side of the airstrip, there was deep loose gravel. Reportedly, the loose gravel…NTSB ATL86LA256Accident · No injuriesLimited investigationFinal reportCessna 310J · Bessemer, ALWhile taxiing for takeoff the plt attempting to taxi between two rows of parked acft. He used the left brake to maneuver the acft between the rows and could not stop the turn by using the right brake. The acft continued in the turn and struck a parked Cessna…NTSB ANC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe plt rprtd that he had flown to the strip a long time ago & did not know that it had deteriorated. During the landing, the acft ran into holes. Subsequently, the main gear & one lift strut were damaged.NTSB ANC86LA153Accident · No injuriesLimited investigationFinal reportFairchild 24-J · Talkeetna, AKAfter touchdown on a gravel bar the pilot lost directional control of the aircraft causing the aircraft to ground loop to the left.NTSB ANC86LA150Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Bradley Lake, AKDuring the landing roll the pilot lost directional control of the aircraft causing the aircraft to veer to the right and nosed over on its back. The plt was landing off the arpt on a sand/gravel bar and due to the rough and uneven nature of the terrain was…NTSB ANC86LA164Accident · No injuriesLimited investigationFinal reportCessna 195A · Willow, AKThe pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure.NTSB MKC86LA186Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Festus, MOThe student plt was on his 2nd solo flt & was practicing stop & go landings. He said that during a landing, he applied brakes before the left main landing gear was on the rwy. The acft swerved to the right & the left main gear collapsed. The plt received a…NTSB LAX86LA337Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Poston, AZAt the end of a local practice flight the plt overflew the rwy and observed the wind sock. She noted the speed and direction to be 5 KTS from the north and elected to land downwind for easy access to the fuel tanks located on the south end. On touchdown, the…NTSB MKC86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Onawa, IAThe student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged.NTSB DEN86LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Aztec, NMThe student plt was returning to the arpt after a local flt when the accident occurred. The plt aborted the first landing attempt on rwy 04. During the second landing attempt, the acft ran off the left side of the rwy, struck a dirt bank and nosed over. The…NTSB CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB NYC86FA218Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Atlantic City, NJUpon lnding the pilot was unable to maintain directional control. He then aborted the lnding and attempted a go around. During this maneuver the acft struck a marsh area aprpox .5 miles from the arpt. The plt and one passenger received fatal injuries, one pax…NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB SEA86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kent, WAThe plt lost control of the acft during landing roll and a ground loop to the right occurred despite the plts attempt to regain control of the acft. The plt stated his ability to use the heel brakes was delayed due to the type of shoes he was wearing.NTSB SEA86LA222Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sandpoint, IDThe plt lost directional control of the acft for unknown reasons during the landing roll and a ground loop resulted.NTSB NYC86LA217Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lakewood, NJThe flight encountered a strong gust of crosswind while taking off. The pilot was unable to correct and lost control of the aircraft at which time the aircraft ran off the rwy and nosed over.NTSB ANC86LA135Accident · No injuriesLimited investigationFinal reportCessna A-185E · Talkeetna, AKThe aircraft lost control upon landing on a gravel bar and nosed over.NTSB ANC86LA133Accident · No injuriesLimited investigationFinal reportCessna U206 · Kamishak Bay, AKAfter touchdown in the bay, the pilot lost directional control of the aircraft causing the aircraft to nose over on its back in the water.NTSB ANC86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcneil River, AKPilot applied brakes too firmly; lost control on landing and aircraft nosed over on its back.NTSB ANC86LA131Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Kotlik, AKThe pilot stated on approach he spotted what appeared to be the airport from several miles off. Instead of landing at the airport, he landed at a gravel bar. After touchdown the pilot lost control of the aircraft and the aircraft nosed over on its back.NTSB ANC86LA128Accident · No injuriesLimited investigationFinal reportCessna 185-F · Caribou Lake, AKThe aircraft settled back on the water and the pilot lost control of the aircraft causing it to nose over on its back.NTSB ANC86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Alexander River, AKAfter touchdown on a gravel road, the pilot lost directional control of the aircraft causing the plane to exit the left side of the road and causing the plane to nose over on its back.NTSB LAX86LA325Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Fallbrook, CAThe acft went out of control during the takeoff ground run on rwy 18 and collided with the terrain. The plt indicated he lost control while attempting a rolling takeoff after taxiing into position on the rwy without stopping. He stated he normally stopped the…NTSB ANC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna T-210 · Alexander Lodge, AKDuring the takeoff roll on a dirt airstrip the pilot lost directional control of the aircraft causing the aircraft to exit the right side of the runway and nose over on its back.NTSB MIA86LA237Accident · No injuriesLimited investigationFinal reportCessna 182-A · Tampa, FLThe 129 hour private pilot was landing on a runway with a 70 degree left crosswind and stated that upon touchdown the aircraft veered to the left and crashed into the trees. Post accident examination of the nose gear steering system and the brakes revealed no…NTSB FTW86LRD23Accident · No injuriesFinal reportGrumman G-164B · Lecompte, LAThe plt was engaged in an aerial application flt when a thunderstorm developed to the southwest of the airstrip. The plt was attempting to land to the east before the storm hit. Control of the acft was lost after touchdown and the acft nosed over. A 25 to 40…NTSB NYC86LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, VTThe plt lost directional control of the acft during takeoff run. The acft traveled off the side of the rwy into tall grass and nosed over. The plt stated that he may have pressed the brake pedal inadvertently instead of the rudder.NTSB MIA86LA234Accident · No injuriesLimited investigationFinal reportBeech F-33-C · Live Oak, FLPlt noted approaching thunderstorm to east and elected to depart to the west due to the current wind being calm. During the takeoff roll a sudden gust from the left rear caused the pilot to loose directional control and the aircraft went off the left side of…NTSB MKC86LA169Accident · No injuriesLimited investigationFinal reportDavid Gordon Whitman Tailwind · Valley Center, KSThe acft rolled forward unrestrained after the PIC had started the eng. The acft was not moored before the PIC attempted the hand start. The acft rolled a short distance where it impacted the edge of a building and sustained substantial damage. Multiple…NTSB NYC86LA246Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Snow, VTPilot lost directional control on landing when he came in long and fast. The aircraft ran off the end of the runway, collided with shrubbery and was destroyed. The plt did not file an acc report.NTSB DEN86LA230Accident · No injuriesLimited investigationFinal reportCessna A188B · Langdon, NDWhile ground taxiing for takeoff the acft left main gear brake failed. During the ensuing right ground loop the left main gear collapsed and the left wing impacted the asphalt taxiway.NTSB ANC86LA123Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kuskatan River, AKDuring the takeoff roll on a River gravel bar, the pilot lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…NTSB ANC86LA121Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe pilot stated that during the landing rollout on the gravel bar he lost control of the aircraft causing the plane to nose over on its back.NTSB CHI86LA196Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Mosinee, WIFollowing departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg…NTSB SEA86LA190Accident · No injuriesLimited investigationFinal reportCessna T210L · Elko, NVDuring landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the…NTSB LAX86FVD09Accident · No injuriesFinal reportJaks Volksplane VP-2 · Ukiah, CAAt the end of a local flight, during the landing roll, the plt was distracted and allowed the acft to veer to the right side of the rwy. The plt applied the brakes when the left main landing gear collapsed.NTSB LAX86LA310Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Oroville, CAA Cessna 140 nosed over in a ditch after aborting a takeoff. The plt indicated he was practicing stop and go landings. During the last landing the right brake was inadvertently applied and the acft veered to the right off the rwy. The plt initiated a…NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.