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 SEA86LA040Accident · No injuriesLimited investigationFinal reportCessna 501 · North Bend, WAWhile on final the fss gave the pilot the current winds and the favored runway. The pilot was attempting to land the aircraft on runway 04 with a right gusting quartering tail wind and wet runway. Hydroplaning occurred and the pilot elected to go-around when…NTSB SEA86LA038Accident · No injuriesLimited investigationFinal reportCessna 150-M · Mead, WAThe pilot was attempting to land on the runway which was covered with 11 inches of snow. The main gear dug into the snow and the right wing tip caught turning the aircraft sideways.NTSB CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.NTSB DEN86LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Fargo, NDThe acft contacted a snowbank following a loss of directional control during landing. This was the plt's first landing on his second solo flt. Previous to this landing, the student had been practicing landing on rwy 17 with his CFI.NTSB MKC86LA046Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, NEN30535 was making a night takeoff on a rwy covered by 3' deep snow. There were also drifts along the lt side of the rwy which were 8 to 10 inches deep. During the takeoff roll moisture blew onto the windshield and the acft drifted to the lt. the acft then…NTSB FTW86LA032Accident · 3 fatalLimited investigationFinal reportSikorsky S-76A · Grand Isle Bl73The acft rolled over in a high x-wind after landing while deplaning passengers. The acft had landed on a moving barge. A landing into the wind was blocked by a crane so the plt sideslipped from a flt path that paralleled the ships movement. The wind was…NTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…NTSB DEN86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · West Fargo, NDAccording to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt.NTSB MKC86LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Olathe, KSThe pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He…NTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…NTSB CHI86LA059Accident · No injuriesLimited investigationFinal reportCessna 180J · Hibbing, MNThe plt landing in a direct 90 deg x-wind, lost directional control, struck a snowbank and nosed over inverted.NTSB DEN86LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Broomfield, COThe acft drifted off the runway during the flare/touchdown phase of ldg due to plt failure to correct for a 20 kt xwind condition. The plt attempted to make a go-around at a low a/s and with ldg flaps (25 degrees) extended, resulting in loss of control and…NTSB CHI86LA054Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNThe aircraft collided with a snowbank while goundlooping after landing at the completion of a cargo flight from chicago ill. The winds were calm. The pilot stated that he needed to take timely and sufficient action.NTSB ANC86LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Homer, AKThe plt stated, during a touch and go landing he lost directional control of the acft and a ground loop resulted.NTSB NYC86LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mttituck, NYPilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft…NTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…NTSB CHI86LA051Accident · No injuriesLimited investigationFinal reportFairchild SA226TC · Cleveland, OHThe crew obtained visual contact with the rw evironment 100 ft above dh. During the landing roll the a/c traveled along the left edge of the runway until it collided with a snow bank. The runway was covered with patches of ice and packed snow.NTSB ANC86LA018Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe pilot stated that on landing at a frozen lake he lost control of the aircraft causing the plane to ground loop. The aircraft then struck a snow bank on the beach.NTSB LAX86LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Arbuckle, CAThe 35-HR student plt was authorized to fly on a solo instructional flight to the colusa county arpt. But, for 'personal reasons' the student disobeyed his CFI & landed at an uncharted, gravel, private airstrip. During landing roll out the student failed to…NTSB MKC86LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Aurora, MOThe pilot stated there was patches of snow and ice on the runway surface a snow on the sides and as he pulled up the flaps, the airplane veered right, off the runway. He said that after he got the airplane back on the runway, it ground- looped to the left and…NTSB DEN86LA045Accident · No injuriesLimited investigationFinal reportCessna 150L · Aurora, COAccording to the CFI, during a touch & go landing, the student allowed the acft to drift to the left side of the rwy where it contacted a snow bank. The CFI stated she failed to correct for the drift soon enough to prevent the accident. The landing was being…NTSB CHI86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dodgeville, WIAfter a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank.NTSB ANC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKAircraft lost control during landing and crashed into another private aircraft. Witness reported seeing aircraft make a fast appraoch, land long, ground loop and slide side ways into parked Aeronca. Witness stated that aircraft landed with a tailwind,while…NTSB MKC86LA034Accident · No injuriesLimited investigationFinal reportCessna 402B · Gardner, KSLanding on an ice covered rwy, the cross-wind was stronger than rptd. The acft drifted left despite control input to correct. The nose gear collapsed before the plt could initiate a go-around. The rptd wind was 340 degrees at 8 knots. The plt stated it was…NTSB MIA86LA042Accident · No injuriesLimited investigationFinal reportBeech E-18S · Opa Locka, FLThe plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass.NTSB MKC86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Topeka, KSN4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking…NTSB DEN86LA042Accident · No injuriesLimited investigationFinal reportCessna 172P · Missoula, MTThe solo student plt was attempting to land during a local flt when he lost control of the acft during the landing roll. The plt stated that the acft veered to one side of the ice covered rwy where it contacted 6 to 8 inches of snow, the acft continued…NTSB LAX86LA058Accident · No injuriesLimited investigationFinal reportCessna 210D · Flagstaff, AZThe plt noticed a weakness of the acft's left brake during taxi for takeoff but elected to make the flt. Control tower personnel at the destination arpt stated the acft landed long and attempted to turn onto the right highspeed taxiway. The plt stated that…NTSB LAX86LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAAfter completing a personal flight the plt landed the acft. Upon touchdown on the 8899 ft-long by 150 ft-wide rwy the plt failed to maintain directional control of the acft. There was a 70 deg, 8 kt. Right x-wind. The acft overran the runway's edge, entered a…NTSB CHI86LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · East Liverpool, OHAccording to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The…NTSB LAX86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calexico, CAThe acft ground looped during a landing on rwy 08 at Calexico arpt. The plt reported that upon touchdown the acft began to swerve to the right. The plt applied left rudder to arrest the right swerve. The acft then began a swerve to the left and the plt was…NTSB DEN86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 II · Greeley, COAccording to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention.NTSB NYC86LA042Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries WW-24 · Worcester, MAAccording to the pilot, the flight was normal, upon touchdown the reversers were deployed, pilot had information that braking action was poor and rwy was icy but had been sanded, pilot landed on the left side of the rwy centerline aircraft began to drift…NTSB SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.NTSB MIA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot loaded the ac with 100 pounds of fuel,himself and 5 passengers and departed for a short local flight. The ac was landed 15 minutes later 382 pounds over max gross weight, and landed long on a 2800 ft runway, in a crosswind. The ac then skidded left…NTSB ATL86LA019Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Sylacauga, ALDuring takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted.NTSB MIA86LA019Accident · No injuriesLimited investigationFinal reportBeech G35 · Destin, FLThe acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind.NTSB MKC86LA016Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Ogallala, NEWhile practicing touch and go landings the plt rptd that during the landing roll the left brake locked. The plt applied opposite rudder, but the acft veered off the left side of the rwy until striking a ditch which collapsed the gear. Inspection of the gear…NTSB ATL86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, GADuring an attempted touch and go landing the student plt lost directional control of the acft. The acft ballooned during touchdown, veered off the rwy and nosed over.NTSB NYC86LA018Accident · No injuriesLimited investigationFinal reportBeech BE-95-100 · Grove City, PAAfter turning on to final for rwy 270 transition/upgrade pilot observed he was high. Power was then reduced aircraft was then on short final a power adjustment was made causing aircraft to land 400/500 feet pass rwy threshold. On contact with rwy nose gear…NTSB MKC86LA014Accident · No injuriesLimited investigationFinal reportPitts S1C · Goodland, KSThe acft rolled forward unrestrained after the plt hand started the eng. A tie down tied to the tailwheel pulled free from the ground tie down eye used to restrain the acft during the hand start procedure. The acft rolled forward striking several objects. The…NTSB LAX86LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino Valley, AZWhen the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing…NTSB CHI86LA011Accident · No injuriesLimited investigationFinal reportMaule M-4C · Blue Earth, MNThe acft nosed over after departing the rwy following a loss of directional control during landing. The CFI stated that as the tailwheel touched the rwy the acft began veering to the right. He applied brakes and full left rudder causing theleft wheel rim to…NTSB SEA86LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Lebanon, ORA loss of directional control occurred during landing roll. The acft veered to the right, struck a ditch and then nosed over. A helicopter was hovering to the left of the landing rwy, probably causing enough wake turbulence to cause the loss of directional…NTSB ANC86LAG02Accident · No injuriesFinal reportMaule M5-235C · King Salmon, AKThe plt stated he misjudged the x-wind and water current during landing. The acft floats dug into the water and the acft nosed over and sank.NTSB ANC86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe acft cartwheeled after dragging the right wing during an attempted takeoff from a gravel strip. The plt reported the takeoff was attempted to the west with a 10 to 15 mph left x-wind. Another person in the area when the accident occurred stated the wind…NTSB MKC86LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Salina, KSThe pilot did not top off the fuel tanks before departing lincoln, NE for pratt, KS. Enroute winds necessitated a fuel stop at Salina, KS. These same winds flipped over the airplane as it was turning off the runway to taxi in.NTSB LAX86LA006Accident · No injuriesLimited investigationFinal reportLeslie Quickie II · Porterville, CAThe acft received substantial damage during a landing at Porterville while on a local pleasure flt. According to the plt, he bounced the acft several times and it began to porpoise. During the porpoise motion, the propeller and left canard contacted the rwy.…NTSB DEN86FTE01Accident · Minor injuriesFinal reportSkurich FOCKE-WULF 190 · Falcon, COThe acft groundlooped to the rt during an attempted go-around after landing. The plt was landing at a arpt with watch he was unfamilar. He thought he saw wires at the approach end of the rwy so he landed long and then attempted a go-around. The acft…NTSB ANC86LAG03Accident · No injuriesFinal reportPiper PA-18A-150 · Homer, AKThe landing gear axle failure was due to the oversize tires that were installed on the aircraft.