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 CHI83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Springfield, OHThe acft swerved during landing and the landing gear sheared off. This was a supervised solo flt and the pilot had made one sucessful touch and go landing. During the 2nd landing the acft swerved to the left and the landing gear collapsed.NTSB LAX83LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Palo Alto, CAThe pilot and his passenger returned to the airport after a local night flight. Upon landing the nose wheel began to shimmy and then the aircraft departed the left side of the runway. After leaving the runway the nose gear collapsed. During his pre-flight the…NTSB FTW83LA081Accident · No injuriesLimited investigationFinal reportCessna 170A · Temple, TXThe student plt reported he was taking off, directly into the wind, when directional contorl was lost. Subsequently, the acft veered off the left side of the rwy & the right gear failed.NTSB ATL83LA087Accident · No injuriesLimited investigationFinal reportLockheed 18-56 · Madison, GAThe plt reported that after he taxied to the rwy, the #1 oil temp was not up to the minimum temp. He set the parking & advanced the #1 throttle to 1500 RPM until the engine warmed up. When both oil temps were within limits, he advanced both throttles to 30…NTSB CHI83LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Monee, ILThe acft ran off the right side of the runway during landing on rwy 27. The wind was from 320 to 350 degrees at 12-15 KTS. After the acft left the rwy it encountered soft plowed ground and nosed over. The pilot had only 6 hrs solo in make and model.NTSB CHI83LA071Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Plato Center, ILThe wind at the nearest facility was reported to be from 350 degrees at 12 KTS. The pilot reported the wind sock at the airport was showing wind from 310-320 degrees at 10 KTS or less and gusting. He made two go-arounds because of gusty winds and difficulty…NTSB MKC83LA050Accident · No injuriesLimited investigationFinal reportCessna 182P · Maryville, MOAircraft ran off runway during takeoff. Pilot said he was unable to control veer and the aircraft continued off into soft terrain and nosed down.NTSB MKC83LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Oakley, KSDuring landing the aircraft hit a patch of ice, swerved to the left, hit a runway light and slid off the runway.NTSB MKC83LA047Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearney, NEPilot landed on icy runway and started to swerve. Go-around was initiated. Before aircraft could takeoff it collided with a snow bank.NTSB LAX83LA065Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Calistoga, CAInitial information indicated that the acft landed with a quartering tailwind, ground looped & collided with a parked glider. A pilot/operator accident report was not received.NTSB LAX83FVG07Accident · 1 fatalFinal reportPiper PA-28-180 · Clearlake, CAThe acft was observed to touch down 1/2 to 2/3 down the rwy at a high rate of speed. The acft then veered right off the rwy into some brush & then came back onto the rwy. Power was applied & the acft became airborne in a stall attitude, turned left & went…NTSB ANC83LAG01Accident · No injuriesFinal reportCessna 152 · Chugiak, AKThe student pilot reported that he was practicing touch-and-go landings on a runway with patches of ice. He stated that on his second touch-and-go, he touched down to the right of the centerline. Reportedly, he retracted the flaps, added full power, and…NTSB ATL83LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nelly'S Ford, VADuring takeoff roll the aircraft swerved to the left. The pilot applied full right rudder but was not able to straighten the aircraft. The pilot reduced the power and applied brakes. The aircraft collided with a fence at the end of the runway. Fifteen knot…NTSB SEA83IA034Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Klamath Falls, ORDuring takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires…NTSB ATL83LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Benning, GAStudent was doing a touch and go landing. While changing flap, carb heat and applying full throttle aircraft veered left. Recovery was attempted throttle off but aircraft left runway and collapsed nose gear, before flipping over.NTSB ATL83FKG06Accident · No injuriesFinal reportQuickie 2 · Stockbridge, GAReportedly, when the aircraft was landed, it touched down long and with excessive airspeed. The aircraft veered off the right side of the runway, when brakes were applied, and overturned. The wind was report as light and variable.NTSB NYC83LA046Accident · No injuriesLimited investigationFinal reportBeech 56TC · Gasport, NYDuring the takeoff roll from a snow covered runway the aircraft slid to the left of the runway and into a snow bank. The left main and nose gear collapsed.NTSB DEN83LA036Accident · No injuriesLimited investigationFinal reportSwearingen SA-227AC · Gillette, WYDirectional control was lost in the early stage of the takeoff roll. The acft departed the rwy 400 ft down the rwy & travelled 85 ft off the side of the rwy. One rwy light was destroyed. The acft had come from the factory equipped with an anti-skid brake…NTSB MIA83LA052Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · New Port Richey, FLAccording to the instructor (CFI), the tail wheel equipped aircraft veered left and headed toward trees after the tail rose, but while the main wheels were still on the ground. He attempted to recover with right rudder and brakes. Fearing a ground loop, the…NTSB LAX83LUG09Accident · No injuriesFinal reportCessna 170B · Big Bear City, CAThe accident occured after touchdown when the pilot temporarily lost control and the aircraft veered off the runway. The wing and propeller collided with a frozen snow bank.NTSB NYC83LA042Accident · No injuriesLimited investigationFinal reportCessna T303 · Newburgh, NYSimulated engine-out emergencies were being practiced. During takeoff the CFI failed the right eng. The student hesitated & the acft swerved to the right. The CFI was unsuccessful in gaining directional control & the acft ran off the rwy into a ditch.NTSB LAX83LVM05Accident · No injuriesFinal reportPitts S1C · 6 N.W. Half Moo, CAAircraft landed and a gust of wind turned the aircraft. Aircraft continued off right side of runway and nosed over in soft ground.NTSB CHI83LA053Accident · No injuriesLimited investigationFinal reportCessna T210 · Frankfort, ILAfter touchdown the right wing of the aircraft suddenly lifted, directional control was lost and the aircraft struck a row of trees.NTSB ATL83LA055Accident · No injuriesLimited investigationFinal reportPitts Special 51C · London, KYThe aircraft ground looped during landing. Investigation revealed there was slight crosswind and the tail wheel steering spring failed.NTSB NYC83IA040Incident · No injuriesIncident investigationFinal reportAeronca 11AC · Monticello, NYAs the flight made a three point landing in strong, gusting, left crosswinds, a gust of wind lifted the aircraft's left wing. Directional control was lost and the aircraft departed the right side of the runway. It came to rest at the bottom of a grassy slope…NTSB LAX83FVM04Accident · No injuriesFinal reportSwearingen SA226-T · San Francisco, CADuring arrival, the winds were reported from 350 to 360 deg at 20 gusting 25 KTS, and while landing, they were from 360 deg at 21 KTS. The acft's max demo x-wind capability was 22 KTS. The plt reported that during the landing, the power levers were retarded…NTSB DEN83LA028Accident · No injuriesLimited investigationFinal reportCessna T188C · Santa Rita, MTAircraft nosed over during landing. Aircraft was swerving left after brake application. More braking was used and aircraft nosed over.NTSB LAX83LA043Accident · No injuriesLimited investigationFinal reportContinental 305 · Glendale, AZThe pilot stated he attempted 2 times to land on runway 17 on the third landing attempt the pilot lost control and collided with a fence. The winds were from 080 degrees at 15 knots.NTSB SEA83LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Gustavus, AKThe pilot reported that slush accumulation on the runway prevented the aircraft from reaching takeoff speed. He aborted the takeoff and with braking action "nil" slid off the end of the runway. Gustavus airport is owned and operated by the state of Alaska and…NTSB DEN83LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Afton, WYThe pilot stated that he touched down on the snow covered runway and the brakes were frozen. The aircraft hit bare pavement and veered to the left. Wheel dropped off edge of runway into a snow bank. The aircraft nosed over. An interview with the pilot…NTSB ANC83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe plt stated that during an earlier takeoff from a frozen lake that he struck an unknown object imbedded in deep snow. He noticed that his right gear & ski were damaged, & continued his flight to Anchorage. Approaching Anchorage he was advised by lake hood…NTSB DEN83LA024Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Erie, COThe pilot reported that he made a wheel landing on runway 33 with the wind variable from 360 deg at 15 gusting 25 knots. As the tailwheel was lowered, the aircraft veered to the right. He corrected back to the left and initiated a go-around, but the aircraft…NTSB CHI83LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Batesville, INAfter completing an NDB approach to the airport, runway 18, the aircraft touched down past the midpoint of the runway. The pilot stated that during his initial attempt to brake the aircraft, before retracting flaps, the aircraft ballooned and departed the…NTSB CHI83LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Middletown, OHThe student pilot was practicing touch-and-go landings on her second solo flight. As she applied power to takeoff (after landing), the aircraft veered to the left. It continued into a muddy/sodded area, struck a shallow ditch and nosed over.NTSB CHI83LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILDuring arrival, the pilot landed on runway 24 with a left quartering, gusty head wind at 8 to 10 KTS. The pilot reported that during the landing, the aircraft suddenly veered left and went off the runway. After departing the runway, the aircraft hit a…NTSB FTW83LA037Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Houston, TXDuring the landing roll the pilot experienced a malfunction when he applied his brakes. When applied, the right brake worked but the left brake did not. The pilot repeatedly pumped the brakes, nevertheless the aircraft ran off the right side of the runway and…NTSB FTW83LA036Accident · No injuriesLimited investigationFinal reportChampion 7FC · Alexandria, LADuring landing, the aircraft touched down with a right quartering tailwind. The pilot stated that after making a normal approach and landing, he overcontrolled the rudder. The aircraft veer off the runway and collided with a ditch before reaching the taxiway.…NTSB ATL83FA033Accident · No injuriesField investigationFinal reportCessna 411A · Plymouth, NCThe pilot attempted a takeoff on a wet turf runway and lost control of the aircraft. The aircraft left the runway and collided with trees. Sometime later the aircraft caught fire. The pilot did not cut the switches off. The origin or destination of the flight…NTSB DEN83LA023Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Durango, COThe pilot landed at a private airstrip and lost control of aircraft in a crosswind. The aircraft departed the runway and collided with a ditch. The pilot believed he lost control of his aircraft because of the wet runway and strong crosswind.NTSB NYC83LA026Accident · No injuriesLimited investigationFinal reportCessna C152 · Ellington, CTDuring landing, the aircraft hit hard on all three landing gear and bounced about 3 or 4 feet, landing on the nose gear. The left wing, prop, nose gear and cowling were damaged.NTSB CHI83LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Hope, MIThe pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The…NTSB DEN83LA013Accident · No injuriesLimited investigationFinal reportBeech G35 · Cut Bank, MTThe pilot started to takeoff on runway 31 with a wind from 270 deg at 20 KTS. During the takeoff roll, the aircraft veered and went off the left side of the runway. The pilot stated that after about 400 to 500 ft in the takeoff roll, the "plane veered right…NTSB SEA83LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Ritzville, WAThe pilot reported that during a landing, the aircraft bounced twice and went off the left side of the runway. Reportedly, he initiated a go-around, but the plane struck a fence and crashed.NTSB MIA83LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Daytona Beach, FLAccording to the pilot, he lost directional control while taking off on runway 06R. The aircraft veered off the left side of the runway and collided with VASI lights. The wind was reported to be from 002 deg at 13 KTS.NTSB FTW83LA023Accident · Minor injuriesLimited investigationFinal reportQuickie TWO · Grants, NMThe pilot had purchased the aircraft and was planning to ferry it to richmond, VA. After taking off on a local flight, he elected to land on runway 13 with winds variable from 190 to 270 deg at 10 gusting 22 KTS. During the landing, the aircraft ran off the…NTSB DEN83LTK01Accident · No injuriesFinal reportEipper-Formance MX-II · Watertown, SDWhile on rollout a gust of wind caught the aircraft's right wing and caused the aircraft to swerve to the left. The pilot attempted to compensate by applying full power but the aircraft traveled left, out of control and collided with a row of "t" hangars.NTSB LAX83FUG05Accident · No injuriesFinal reportE.L. Craig Craigcraft · Chino, CAThe acft veered off the left side of the rwy & collided with a camera tripod.NTSB MIA83LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Okeechobee, FLThe site chosen for landing was an old road with high weeds which the pilot had used the week before. The left wing caught in the weeds during landing. The pilot stated that the right rudder was used to straighten the aircraft's course, however, the aircraft…NTSB LAX83LA015Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Ukiah, CAThe pilot began taking off in calm wind conditions. He reported that when he almost reached the airspeed for takeoff, the aircraft veered to the right. Subsequently, the aircraft hit a brush pile and a fence and was damaged.NTSB NYC83LA010Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe pilot stated that while practicing touch-and-go landings he encountered turbulence during a touchdown. When he aborted the takeoff segment the aircraft departed the runway and the landing gear collapsed.