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 ANC88LA087Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Quartz Creek, AKAccording to the flight instructor, he and the student pilot attended a picnic and were returning. During the departure, and while attempting a step taxi turn, they struck the trees along the shoreline.NTSB DEN88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aurora, COThis was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The…NTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILNTSB MIA88LA216Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLWhile on a sightseeing flt, during the landing roll with a direct crosswind from the rt at 9 KTS, the plt reported that the acft turned into the wind. He was unable to correct this with left rudder & braking before the acft travelled into a ditch. He further…NTSB LAX88LA244Accident · No injuriesLimited investigationFinal reportCessna TR182 · Niland, CADuring the takeoff ground run on a dirt road, witnesses stated that the pilot had lifted the nose of the airplane so high that the tail dragged on the ground. The airplane became entangled in weeds near the road, the pilot lost control and the airplane…NTSB ATL88LA209Accident · No injuriesLimited investigationFinal reportCessna 195A · Memphis, TNThe plt reported that the left wheel separated from the airplane during ldg rollout on rwy 27, allowing the left gear to drag on the rwy. The airplane then bounced, veered to the right, and skidded to a stop. The left ldg gear collapsed as the acft stopped.…NTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…NTSB LAX88DVG08Accident · No injuriesFinal reportGrumman G-164A · Gridley, CADuring the landing roll, the left wing caught on high weeds. The pilot lost control of the airplane, veered off the landing strip, and collided with a ditch paralleling the runway. There were no reported mechanical failures or malfunctions with the airplane…NTSB DEN88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTNTSB BFO88LA062Accident · No injuriesLimited investigationFinal reportTravel Air D4D · Roanoke, VAThe plt reported that during the landing roll the tail wheel began to shimmy. He stated that since there was not enough airspeed to lift the tail of the acft, he applied brakes in an attempt to slow the acft. At this time the acft veered to the right. He…NTSB FTW88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Charles, LABetween flights, the pilot noticed the nose was very high while taxiing but thought it was because the strut had failed to compress. On the next touchdown, on the main wheels, the airplane started porpoising and despite the pilot's corrections, the porpoising…NTSB ANC88LA076Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe 70 hour private pilot was attempting to take off from a private turf airstrip with her non-pilot husband onboard. As she advanced the throttle to the one-half open position, the airplane veered sharply to the left. She said that she pulled the airplane…NTSB ANC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shismaref, AKThe pilot stated he decided to land on the beach due to weather. After touchdown on the beach the main landing gear dropped into an area of soft sand; the aircraft then went over on its back.NTSB LAX88LA235Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Agua Dulce, CAThe plt completed his participation in the 'bomb drop' portion of an air show and he attempted to land on rwy 22. The plt reported that his touchdown was normal but he lost control of his acft during the landing rollout. The wind direction was variable & its…NTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…NTSB ANC88LA072Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Creek, AKAccording to the pilot he made a landing on the gravel bar. Shortly after touchdown the pilot lost directional control and ground looped. The acft struck a tree stump and collapsed the left lndg gear.NTSB ANC88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Bethel, AKThe 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted…NTSB MKC88LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARThe pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage.NTSB FTW88LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Clifton, TXThe student pilot was on her third landing during her first solo flight. The pilot reported that she lost control and the airplane ground looped during the landing roll.NTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.NTSB MIA88FA191Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe 25 yr old student plt was practicing take-offs & ldgs on rwy 11L in preparation for his pvt plt flt test. When he departed, about 1.9 hrs prior to the accident, the winds were 090 degs at 13 knts. At the time of the accident the winds had increased to 18…NTSB LAX88LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZWhile flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the…NTSB SEA88IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Seattle, WAAfter the main gear touched down, thrust levers were placed in the idle reverse position. Once the aircraft's nose gear contacted the runway, braking and full reverse thrust was applied. The aircraft started to drift to the left of the runway centerline. The…NTSB DEN88LA165Accident · No injuriesLimited investigationFinal reportHall HP-18 · Westcliffe, COThe plt said his glider was being towed for takeoff from a dry, dusty, grass strip. He said the tow plane blew up the dust and he was unable to see to maintain alignment with the 75 ft wide strip. There was a drop off on the lt side of the strip and tall…NTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…NTSB NYC88LA164Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Marlboro, NJThe pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a…NTSB NYC88LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lehighton, PAThe student pilot, on his third solo, experienced a loss of directional control during a go-around and settled into low trees and brush on the south side of the runway. The pilot reported the winds as calm. He stated that the left main wheel went off the left…NTSB NYC88LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Robbinsville, NJThe acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3…NTSB LAX88LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Redding, CADuring a solo instructional flt, the pilot stated that he may have had his foot on the left rudder pedal on landing. When the airplane touched down it veered to the left off the runway and into a ditch. There were no reported mechanical failures or…NTSB FTW88LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roanoke, TXThe pilot lost directional control while attempting a takeoff. The airplane ran off the right side of the runway and struck a wind tetrahedron, a fence, and a low concrete wall. The plt did not submit an acc report.NTSB FTW88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Cleveland, TXThis acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…NTSB FTW88LA116Accident · No injuriesLimited investigationFinal reportCessna 182L · Angola, LAThe pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in…NTSB ATL88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · East Liverpool, OHThe student pilot reported that he flared late during ldg. The airplane ballooned and started drifting to the right. The student added pwr and left rudder in an attempt to maintain control; he 'overcompensated' with left rudder input, and lost directional…NTSB CHI88FA128Accident · No injuriesField investigationFinal reportDornier 228-201 · Chicago, ILThe capt was completing the checklist drg pax loading & the f/o secured the door & came fwd. The capt started the #2 eng& bgn single eng taxi while atmtg a rgt turn to stay clr of a parked Dornier (N264MC). As N259MC bgn rolling fwd, the capt noted the…NTSB LAX88LA210Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Hemet, CADuring the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path…NTSB DEN88LA124Accident · No injuriesLimited investigationFinal reportCessna A-185F · Phillipsburg, MTNTSB CHI88LA126Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aledo, ILDuring takeoff roll the pilot reported he experienced a loss of directional control and elected to lift the aircraft off the ground prematurely in an effort to avoid running into a cornfield. Unable to establish the proper rate of climb, and unable to clear…NTSB DEN88LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Gettysburg, SDThe commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right…NTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…NTSB ANC88LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Chugiak, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway.NTSB NYC88DFA01Accident · No injuriesFinal reportLloyd Feary VJ-22 · Kingston, NYThe aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted…NTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.NTSB FTW88DRA13Accident · No injuriesFinal reportHudson Mustang II · Tomball, TXThe acft was substantially damaged when control was lost during the rollout after ldng with a 12 knot left crosswind. Following the loss of control, the acft veered left of the rwy, struck a rwy lt, hit a ditch, and flipped over.NTSB BFO88LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Annapolis, MDDuring the landing rollout the aircraft drifted to the left. The left main wheel departed the pavement and encountered soft terrain. The aircraft groundlooped and nosed over. The pilot did not file an accident report.NTSB LAX88LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · S. Lake Tahoe, CAThe pilot lost control and dragged a wing while taxiing. The pilot indicated that he had just completed an uneventful landing and was taxiing to parking. He also indicated that he was taxiing too fast when he turned off the runway and the wing dipped and…NTSB ATL88LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Florence, SCThe accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…NTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.NTSB MIA88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ocean Springs, MSThe instructor stated that they were on their third touch and go and had made a wheel landing, and just as she started to retract the flaps, the aircraft made an aprx 30 degree turn off the right side of the runway. She then stated that no matter how much…NTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…NTSB ANC88FA056Accident · No injuriesField investigationFinal reportCessna U206 · Anchorage, AKA deaf-mute adult male, who has a history of mental health problems, and who was a mental health ward of the state of Alaska at the time of the accident, entered a Cessna 206 airplane equipped with amphibious floats without permission while it was parked on…