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 FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…NTSB ATL88LA237Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, ALThe plt reported that he landed on a grass strip adjacent to the paved rwy, to 'save the (airplane) tires' from excessive wear. He stated that the airplane groundlooped during the rollout when it encountered a hole in the turf. A mechanic who examined the…NTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…NTSB BFO88LA074Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Gaithersburg, MDThe pilot reported that the local winds were varying from 340 degrees to 360 degrees at 12 knots gusting to 20 knots. The pilot stated that he lost directional control due to gusty winds while on landing roll. The aircraft contacted a VASI light and then a…NTSB SEA88LA159Accident · No injuriesLimited investigationFinal reportCessna 150D · Athol, IDAcft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over.NTSB NYC88LA221Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Wellsville, PAA private plt on a local flight made a stopover landing on runway 28. The plt reported that during the landing flare, he was temporarily blinded by the setting sun directly in the flight path. At touchdown the airplane weathervaned into the right crosswind,…NTSB ANC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yenta Glacier, AKDuring the takeoff roll on the gravel bar, the pilot lost directional control of the airplane causing the plane to nose over on its back. Examination of the left brake revealed that the brake was frozen with mud.NTSB DEN88LA184Accident · No injuriesLimited investigationFinal reportCessna A185F · Medicine Bow, WYThe pvt plt returned to his ranch strip & landed to the ene with a x-wind from the right. Drg the lndg roll, the acft began to go to the right. The plt corrected with left pedal, but subsequently, the acft ground looped to the left & nosed over. An exam of…NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB CHI88DEM09Accident · No injuriesFinal reportHulliberger Starduster II · White Cloud, MIUnauthorized pilot failed to maintain adequate control of the homebuilt aircraft during the landing roll. The aircraft veered off the right side of the runway, and the left wing struck the ground.NTSB ANC88LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKDuring the takeoff roll on a gravel bar, the pilot lost directional control of the airplane & it bounced into the river. The airplane then nosed over on its back. The pilot and passenger both exited the airplane.NTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…NTSB CHI88LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hobart, INWhile on a solo instructional flight for the purpose of practicing crosswind takeoffs and landings, the student pilot failed to adequately compensate for the crosswind and experienced a loss of directional control shortly after the aircraft touched down. The…NTSB ANC88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kwethluk, AKThe pilot lost directional control of the aircraft while landing. At the time of accident the wind was from 180 degrees at 15 knots gusting 20 knots. The airplane landed on runway 25; after touchdown the airplane departed the right side of the runway into an…NTSB MIA88LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Tupelo, MSThe private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…NTSB ANC88LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chandalar River, AKAfter touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back.NTSB CHI88LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Napoleon, OHThe airplane left the runway and struck a ditch during an attempted soft field takeoff. The student pilot lost directional control of the acft and, after striking a runway light on the left side of the runway, continued until he collided with the ditch and…NTSB ANC88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Galena, AKThe student pilot lost directional control of the airplane during landing on the tundra. During the rollout the airplane nosed over on its back. The pilot could not be found to accomplish the required accident report.NTSB NYC88LA207Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Quaker Street, NYThe Bellanca 8KCAB was making a takeoff when it veered to the right. The right main landing gear contacted a rock wall covered by weeds and the aircraft veered further right coming to rest on the right side of the runway. The pilot was unable to explain the…NTSB FTW88LA144Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kingsland, TXThe tail-dragger touched down on the left gear, then the right gear. The pilot applied power for a go-around but he said he then cut it off because he was going to be going so close to the hangar. The airplane went off the left side of the runway and…NTSB LAX88LA281Accident · No injuriesLimited investigationFinal reportCessna 172P · Imperial, CADuring a solo instructional flt, while landing, a gust of wind raised one wing, putting weight on main wheel and one nose wheel. The pilot regained control; however, the airplane veered off the runway and nosed over in the soft dirt.NTSB DEN88LA177Accident · No injuriesLimited investigationFinal reportRossi Pitts S-1S · Butte, MTNTSB ANC88LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Chignik, AKDuring the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back.NTSB LAX88LA280Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAAll of the pilot's prior flight training was done in tailwheel type aircraft. The pilot had made four full stop landings during the pattern practice instructional session and he said that he experienced directional control problems during each of the…NTSB ANC88LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Wasilla, AKThe pilot stated that during the takeoff roll on a gravel bar type airstrip he lost control of the airplane. The airplane bounced and landed on a stump.NTSB SEA88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter.NTSB DEN88LA173Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Watkins, COThe new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another…NTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…NTSB DEN88LA164Accident · No injuriesLimited investigationFinal reportStinson 108 · Lordsburg, NMDuring takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10…NTSB CHI88DEE08Accident · No injuriesFinal reportTownson Starduster SA100 · Monee, ILPilot failing to maintain control of the airplane during landing touchdown and roll out.NTSB ATL88LA222Accident · No injuriesLimited investigationFinal reportBeech V35B · Parson, TNThe pilot reported that shortly after a heavy weather system passed over, he attempted a takeoff from a wet runway. During the takeoff roll he did not allow the airspeed to accelerate to the lift off speed. As he prematurely lifted off he lost directional…NTSB CHI88LA184Accident · No injuriesLimited investigationFinal reportPiper J-3 · Waynesville, OHDuring a dual instructional flight for the purpose of practicing takeoffs and landings with a pre-solo student, the instructor pilot failed to maintain adequate aircraft control and visual lookout, and the aircraft departed the right side of the runway,…NTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WINTSB ANC88LA099Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Kustatan River, AKThe private pilot was attempting to land his Piper PA-14 airplane at a remote beach fishing site in gusty crosswind conditions. He reportedly encountered a wind gust upon touch down, lost directional control and struck an abandoned hunting shack and an…NTSB MKC88LA139Accident · No injuriesLimited investigationFinal reportGrumman G164-B · Gould, ARThe pilot said that while returning from an aerial application operation, he lost directional control during the ldg. He veered off the concrete runway, into the soft, tall grass border, and nosed over.NTSB ANC88LA098Accident · No injuriesLimited investigationFinal reportCessna 180A · Northway, AKThe commercially certificated pilot was landing at Northway, AK., when the airplane ground-looped to the left. He reportedly had also ground-looped the same airplane when he landed at whitehorse, Canada, just prior to the landing at Northway. A post-accident…NTSB ANC88LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe private pilot and his passenger were uninjured when their Piper PA-18 (super cub) ground-looped while landing at Anchorage international airport, Anchorage, AK. The pilot stated that the right main landing gear tire 'grabbed' when it touched the paved…NTSB MIA88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Sanford, FLThe CFI stated they had completed 2 touch & go ldgs without incident. On the next, the acft 'suddenly yawed to the left & the side load must have weakened the gear as the gear warning horn began to sound indicating the gear was no longer down & locked'. He…NTSB LAX88LA291Accident · No injuriesLimited investigationFinal reportCessna T210K · Huntington Bch, CADuring the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…NTSB ANC88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this…NTSB LAX88LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Redlands, CADuring the takeoff ground run on a solo instructional flight, the student pilot lost control of the airplane. The airplane veered to the left. The pilot applied right rudder, however, the airplane continued to the left, exited the runway and collided with the…NTSB CHI88LA173Accident · No injuriesLimited investigationFinal reportPiper J-3 · Minneapolis, MNWhile practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90…NTSB MIA88LA228Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Lambert, MSThe plt stated there were tstrms in the area when he attempted to takeoff on an aerial application flt. He began his takeoff roll from the duster strip & a strong wind gust from the approaching tstrm blew the tail around. The acft came to rest on its belly in…NTSB NYC88LA182Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Candlewood Lake, CTThe LA-4-200 made a takeoff under reported conditions of gusty wind and waves of 1 to 2 feet. The maximum demonstrated wave height for the aircraft is 1 foot. The pilot reported he aborted the takeoff due to a person on a jet ski in his way and as he tried to…NTSB CHI88LA168Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Menominee, MIDuring a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid…NTSB DEN88LA159Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Gallup, NMNTSB MIA88LA219Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Palm City, FLThe plt stated that he landed long on a dirt and grass road. During landing roll, he applied heavy brakes to stop the acft. The acft swerved to the left. He unsuccessfully tried to regain control. The a/c went down an embankment and the left wing dug into a…NTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.NTSB ANC88LA090Accident · No injuriesLimited investigationFinal reportCessna A185F · Georgetown, AKThe pilot stated that he encountered several up & down drafts prior to lndg. After landing and taxiing toward shore, the pilot saw the surface water on the river being whipped up; the pilot estimated the wind to be 40 knots or more. The aircraft became…NTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.