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 ANC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kuskalana Pass, AKThe pilot stated that during the landing roll on the tundra he applied wheel brakes too hard causing the aircraft to nose over on its back.NTSB ANC87LA130Accident · No injuriesLimited investigationFinal reportCessna 180F · Cordova, AKThe wind was blowing from the south at approximately 15 knots gusting 30 knots. As he was turning off the runway, the pilot lost directional control of the aircraft causing the aircraft to ground loop on the taxiway.NTSB CHI87LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Phillips, WIDuring the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that…NTSB DEN87LA229Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Manila, UTThe student plt was landing at an uncontrolled airport with an asphalt runway 5300 x 60 ft oriented 250 degrees. She said she made 3 passes over the airport to check for conditions and then executed a normal landing. Shortly after touchdown the aircraft…NTSB CHI87LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILAccording to the plt, the lndg was normal until after touchdown when the acft bgn to 'track' toward the rgt side of the rwy. The plt said he applied left rudder, but the acft contd off the rgt side, went into a drainage ditch with standing water & nosed over.NTSB LAX87LA319Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Glendale, AZDuring landing roll, in crosswind conditions, the aircraft left the runway and went into a ditch. During a telephone interview the pilot stated that he lost control of the aircraft. The pilot was landing on runway 01 and winds were reported to be from 090…NTSB MKC87LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Holly Grove, ARThe pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures.NTSB DEN87DTE04Accident · No injuriesFinal reportCessna A188B · Stonington, COThe plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings…NTSB CHI87DEM12Accident · No injuriesFinal reportPitts S-1 · Charlevoix, MIDuring landing on a short sod strip with a cross wind the pilot lost control when excessive brakes were applied. The aircraft nosed over. The plt stated that after landing he applied the brakes and the acft assumed about a 45 degree nose down attitude and the…NTSB ATL87LA238Accident · No injuriesLimited investigationFinal reportCessna 172M · Marietta, GAThe student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,…NTSB ANC87LA133Accident · No injuriesLimited investigationFinal reportChampion 7GC · Central, AKThe pilot stated that he was attempting to land in gusty, crosswind conditions and lost control of the airplane. He said the accident could have been avoided by choosing a different airport with less crosswind, or by initiating a go-around when he first…NTSB FTW87LA205Accident · No injuriesLimited investigationFinal reportBeech RC-45J · Houston, TXThe pilot was practicing landings, almost to a full stop, when the accident occurred. He had asked a commercial pilot to accompany him on this flight. The plt stated that on the fourth landing the left main gear went slightly off the left edge of the runway…NTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.NTSB CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…NTSB ANC87LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Homer, AKThe pilot stated after the landing rollout he lost directional control of the aircraft causing a groundloop on the runway. This landing was the first full stall landing of the flight.NTSB BFO87LA059Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Grafton, WVAccording to the plt during the water landing the acft encountered the wake of a boat that had crossed the path of the acft. As a result the acft bounced about 20 ft high. The plt applied full power to recover; however, the acft impacted the water. He started…NTSB ANC87LA123Accident · Minor injuriesLimited investigationFinal reportChampion 7HC · Seward, AKThe pilot lost directional control on landing and veered to the right side of the runway. The aircraft then struck a small mound and nosed over on its back. The pilot stated that he landed with a 7 to 10 knot tailwind.NTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.NTSB ANC87LA122Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canning River, AKThe pilot stated that during the landing roll the pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB NYC87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Ellenville, NYThe pilot lost directional control during takeoff at Ellenville airport and the aircraft ran off the runway colliding with trees and was demolished. No mechanical or structural problems were found during investigation of acft.NTSB ANC87LA120Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chackachatna Ri, AKThe pilot stated after he touched down on the gravel bar he lost directional control of the aircraft causing the aircraft to strike a log. The airplane then went up on its nose.NTSB FTW87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · San Marcos, TXThe student pilot lost directional control when the tail wheel came off the runway. The instructor pilot stated that he was late with corrective action and the aircraft ground looped off the runway.NTSB DEN87LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greeley, CON8433D was being flown by the plt/owner with an instructor aboard for the purpose of up-dating the owner's flying proficiency. Several successful landings were made, then a wheel landing was initiated. After touchdown, the acft swerved to the left, departed…NTSB FTW87DQG02Accident · No injuriesFinal reportPiper PA-25 · Lubbock, TXThe toe of the pilots left boot was rubbing on the dispensing hopper which restricted application of rudder and brake. This resulted in a loss of control when exiting the runway and the resultant collision with a sign. The fiberglass hopper had deep abrasions…NTSB NYC87LA213Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, CTWhile landing in crosswind conditions, the pilot failed to compensate for the conditions and lost directional control of the aircraft. The aircraft went down an embankment, collided with a fence and then flipped inverted.NTSB MKC87LA156Accident · No injuriesLimited investigationFinal reportCessna 150M · Atchison, KSThe solo student pilot was practicing touch and go landings. The pilot stated he had successfully performed 2 landings. On the third landing the aircraft touched down to the left of the runway's centerline, veered right and off the runway. Investigation…NTSB DEN87LA209Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Taos, NMThe plt attempted to land on rwy 22 with a left quartering x-wind. Drg the landing, the acft bounced twice, then veered to the right & went off the rwy. The plt applied power & initiated a go-around. The acft became airborne, but its right wing struck the…NTSB NYC87LA270Accident · No injuriesLimited investigationFinal reportRockwell 112A · No Kingstown, RIThe aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.NTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…NTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…NTSB FTW87LA181Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockwall, TXAs the acft touched down, the rgt main wheel contacted a rut in a soft area of the rwy & the acft veered to the rgt. To avoid hitting parked acft on the west side of the rwy, the plt added full power & left rudder & aileron. He stated that as the acft left…NTSB FTW87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Aransas Pass, TXThe plt rprtd that drg a takeoff roll, the acft encountered a gust of wind from the left which caused it to veer off the right side of the rwy. Subsequently, it contacted a ditch & was damaged.NTSB ANC87FA107Accident · No injuriesField investigationFinal reportMaule M-6 · Anchorage, AKThe pilot lost directional control while landing with a quartering tailwind from the left. The aircraft ground looped and struck a chain link fence. The pilot stated that he found the brake shaft broken at the shaft reduction retaining clip point. He…NTSB LAX87LA282Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Rancho Calif, CAWhile landing on runway 12, the plt lost control of the Champion 7ECA and it collided with three other aircraft. About 31 mi northwest at riverside, CA, the 1755 PDT wind was from 290 deg at 9 KTS. A witness at the airport estimated the wind was from 270 deg…NTSB LAX87LA280Accident · No injuriesLimited investigationFinal reportCessna 320D · Banning, CAWhile taxiing to the runway, the right main and nose gear traveled off of the taxiway. The plt added power to the right engine and applied left brake, however, the plt stated that when power was added, the ground speed also increased. The acft traveled off…NTSB LAX87LA278Accident · No injuriesLimited investigationFinal reportCessna 182A · Strathmore, CADuring a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx…NTSB LAX87LA277Accident · No injuriesLimited investigationFinal reportCessna A185F · Chandler, AZThe CFI indicated that the tailwheel began to shimmy during rollout. As forward control yoke pressure was applied the shimmy went away, however, as the acft began to slow down, the tailwheel was lowered and began to shimmy again. As the acft continued to slow…NTSB CHI87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bad Axe, MIDuring a demonstration of an aborted takeoff, the 'power was cut' after the aircraft accelerated to about 75 mph. At about that time, the aircraft encountered a gust of wind and became airborne. A power recovery was initiated, but the aircraft touched down in…NTSB FTW87LA172Accident · No injuriesLimited investigationFinal reportCessna 172K · Brenham, TXThe student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass.NTSB BFO87LA052Accident · No injuriesLimited investigationFinal reportMooney M-20C · Basye, VAWhen the pilot applied brakes during the landing roll the acft swerved left. He applied the right brake to straighten the acft and the acft swerved right. The pilot attempted to correct with left brake and the right main gear collapsed. No malfunctions were…NTSB LAX87LA274Accident · No injuriesLimited investigationFinal reportCessna 182Q · Upper Lake, CANTSB LAX87DVA08Accident · No injuriesFinal reportHastings Thorp T18 · Patterson, CAAt the end of a pleasure flight, the aircraft was landing with a 90 degree crosswind with a velocity of approximately 20 mph. During the landing roll, the aircraft ground looped, ran off the runway and nosed over. There were no reported mechanical failures or…NTSB DEN87LA187Accident · No injuriesLimited investigationFinal reportBeech 58 · Pagosa Springs, COThe plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing…NTSB ANC87LA099Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKThe pilot stated that during takeoff on the river he lost directional control of the aircraft causing the aircraft to collide with a boat dock.NTSB CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…NTSB NYC87LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Andover, NJThe pilot lost directional control during landing roll. As the aircraft drifted left of the runway, power was added for a go-around but the aircraft was left of the rwy. The left wing strut hit the wing of a Cessna 150 in an attempt to avoid colliding with…NTSB NYC87DNC09Accident · No injuriesFinal reportDubois Beta Bird · Biddeford, METhe pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,…NTSB ANC87LA098Accident · No injuriesLimited investigationFinal reportLake LA-4 · Cool Lake, AKThe pilot stated that during the takeoff on the Lake the aircraft would not lift off the water and he lost directional control of the aircraft causing it to collide with the Lake shore.NTSB ATL87LA214Accident · No injuriesLimited investigationFinal reportCessna 150J · Higginsport, OHThe pilot reported that the aircraft skidded off the runway into a piece of parked farm equipment. The sod runway surface was wet. The pilot further reported that the right wing rose and the a/c veered off the runway. The pilot was unable to maintain…NTSB ATL87LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Middlefield, OHThe student plt's seat slid back during the takeoff roll, following a touch-and-go ldg. The student lost directional control and the airplane ran off the left side of the rwy. The airplane impacted a ditch and nosed over. Post-crash exam of the seat assy by a…