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 ANC86LA086Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bulchitna Lake, AKThe airplane struck a wingtip on the water while step taxiing downwind attempting a left turn.NTSB LAX86LA264Accident · No injuriesLimited investigationFinal reportPiper J-3 · Columbia, CAThe acft nosed over in soft ground during landing roll after veering off rwy 17. The plt indicated that the right brake pedal was jammed by 1/2 inch carpet that had been installed in the acft. The acft veered off the right side of the rwy 17. When the plt…NTSB DEN86LA172Accident · No injuriesLimited investigationFinal reportCessna 180K · Ronan, MTAccording to the plt, during the takeoff ground run, his seat slid to the full aft position. The plt stated he lost control & the acft ground looped.NTSB DEN86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Last Chance, COThe plt said while on landing roll a cross wind drifted N8844W off right hand side of rwy on a farm strip. Lost control in soft dirt and nosed over. The vehicle was substantially damaged, and the plt was uninjured.NTSB FTW86LA117Accident · No injuriesLimited investigationFinal reportCessna 172K · Weatherford, TXThe pilot reported losing control of the acft during touchdown due to the crosswind. The landing was being made on runway 16 and there was a 7 kt wind from 200 degrees.NTSB FTW86LA113Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Palacios, TXDuring the ground run portion of the takeoff, the acft contacted a mud hole which resulted in it veering off the grass and into bushes alongside the strip. The plt did not select suitable terrain for the takeoff.NTSB ANC86LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Theodore River, AKThe pilot stated that upon attempting a soft field takeoff the aircraft drifted to the left. The left main landing gear struck a sand berm which caused the aircraft to exit the road into an open ditch.NTSB LAX86LA255Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Quincy, CAThe commercial plt/cfi, attempted to takeoff when a left 40 deg, 15 to 25 knot crosswind existed. The plt lost directional control of the acft, & when attempting to abort the takeoff the acft's gear collapsed & the acft collided with a drainage ditch. The plt…NTSB FTW86LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Mineola, TXThe student pilot was practicing touch and go landings when he lost control of the acft on landing. He stated he lost directional control due to windy conditions. However, winds in the area were reported to be calm. The aircraft veered off the runway damaging…NTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.NTSB ANC86LA076Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Egegik, AKThe pilot stated that after touchdown he lost directional control of the aircraft causing the plane to nose over. At the time of the accident there was a direct crosswind.NTSB MIA86LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vaiden, MSThe plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest…NTSB ANC86LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanunak, AKThe plt stated that after touchdown he lost directional control of the acft which resulted in a ground loop and nose over.NTSB ANC86FA074Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Volkmar Lake, AKAfter touchdown the pilot lost directional control of the aircraft causing the right wingtip to strike the water. The aircraft then rolled over and sank. The PIC was operating the aircraft and carrying passengers with only student pilot certificate.NTSB ANC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Theodore River, AKThe pilot stated that during the takeoff roll he lost directional control of the aircraft causing the aircraft to strike a row of trees.NTSB MIA86LA178Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt stated that he was attempting a practice soft-field takeoff from rwy 18. Just prior to rotation the main gear contacted a bump in the airstrip and the acft drifted to the left. The acft continued left where it struck trees alongside the rwy.…NTSB ANC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 15 AC Sedan · Neal Lake, AKAccording to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was…NTSB FTW86LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Witchita Falls, TXDuring the ground run portion of the takeoff, the pilot lost directional control of his taildragger aircraft. As the aircraft was spinning around the right gear struck a small ditch and broke the landing gear off, causing the aircraft to come to rest on its…NTSB SEA86LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Boise, IDDuring rollout after landing, the pilot was asked by the tower to expedite clearing the runway due to landing traffic. As the aircraft had slowed, the pilot attempted a turnout when a groundloop occurred. A gust of wind precipitated the groundloop. The wind…NTSB FTW86LA105Accident · No injuriesLimited investigationFinal reportMaule M7-235 · New Orleans, LAThe plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop.NTSB BFO86LA033Accident · No injuriesLimited investigationFinal reportCessna 152-II · Gaithersburg, MDWith the wind out of the east at about 10 knots, the student pilot touched down on the centerline of runway 32. Shortly thereafter, the aircraft swerved right and then left and the CFI attempted to take over the controls. She stated that she could not…NTSB ATL86LA268Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roanoke, ALReportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA…NTSB ANC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot stated that after the landing roll, directional control of the aircraft was lost causing the aircraft to exit the left side of the runway striking an airport sign.NTSB NYC86LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PADuring takeoff roll and as the aircraft was brought to full power, the flight started to veer left. Attempts to correct with right rudder but the aircraft continued to roll left. The aircraft could not be brought under control before contact with two parked…NTSB MKC86LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Nevada, IAWitnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes…NTSB FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…NTSB SEA86LA138Accident · No injuriesLimited investigationFinal reportRose A4C · Winnemucca, NVDuring landing roll the pilot lost directional control of the aircraft. The right main gear collapsed dragging the right wing.NTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage.NTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…NTSB CHI86LA148Accident · No injuriesLimited investigationFinal reportCessna 182K · Durand, WIAccording to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge…NTSB ANC86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKWhile high speed taxiing on a runway in gusting wind conditions, the pilot lost control of his airplane and it veered into a parked airplane adjacent to the runway. The pilot reported the wind was from 130 degrees at 15 gusting 25 knots.NTSB FTW86FPA18Accident · 1 fatalFinal reportEagle Eagle DW-1 · Howe, TXThe acft appeared to stall during a sharp pull-up and turn during a test flt after a low pass over the airstrip. The plt was testing the spray equipment and made the low pass so the ground observer could see the spray pattern. No malfunctions in equipment…NTSB DEN86LA144Accident · No injuriesLimited investigationFinal reportHispano Aviacion ME109 · Casper, WYDuring takeoff ground roll on a test flt, the acft left brake failed causing the left main wheel to lock up. The plt lost directional control and the acft departed the left side of the runway where it ground looped. The aircraft was destroyed. The pilot was…NTSB CHI86LA145Accident · No injuriesLimited investigationFinal reportCessna 182P · Platteville, WIThe plt landed the acft on rwy 7 which was wet. Winds at the time were from 120 degs at 12 KTS. The plt stated that the wind caused the acft to skid and travel off the left side of the rwy. The acft nosed over after contacting soft soil alongside the rwy.NTSB ANC86LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Bradley Ski, AKThe pilot stated that after touchdown he lost control of the aircraft causing the plane to nose over on its back. At the time of the accident the wind was less than six knots.NTSB LAX86LA234Accident · No injuriesLimited investigationFinal reportMooney M-18C · Lakeport, CAThe plt indicated that there was a gusty left crosswind present during landing. The acft drifted right off the 40 ft wide asphalt rwy and collided with a small ditch and dirt bank. The acft then nosed over into the arpt drainage ditch.NTSB SEA86LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Raymond, WAThe pilot chose to land at an alternate airport to await improving weather. During a gusty crosswind, loss of directional control occurred during landing flare. The aircraft departed the runway to the left and nosed over inverted.NTSB ANC86LA060Accident · 1 fatalLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot stated that at the time of the accident the wind was 30 knots gusting to 35 knots. After touchdown on the water, the pilot lost control of the aircraft causing the aircraft to nose over on its back and sink.NTSB MKC86LA116Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Crete, NEThe plt of this tail-wheel acft attempted a landing on a rwy with a strong x-wind. After a go-around, he started an apch to a turf rwy that was better aligned with the wind but made a go-around when he thought the grass was too high. He then attempted another…NTSB LAX86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springerville, AZThe acft collided with two parked acft after the student pilot lost control during a go-around. The student stated that during his first landing of the day the acft started to 'slide sideways' and he elected to go-around. He increased the throttle and the…NTSB ATL86LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Peachtree City, GAThe plt reported that the acft began to 'wheelbarrow' on the nose gear during the ldg roll. The acft veered off the rwy into a ditch. The plt said that he might not have had the pitch trim set correctly at touchdown. The acft flt manual before landing…NTSB LAX86LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Lompoc, CAThe bellance champion went out of control an collided with two other parked acft after a hand propped start. The plt indicated that the acft was tied down with two chains attached to each of the wings at one end and to a cable that stretched across the ramp…NTSB DEN86FTK02Accident · No injuriesFinal reportAero Commander Callair A-9B · Dell Rapids, SDThe plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.…NTSB MKC86LA111Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Montezuma, KSThe pilot stated that as the aircraft touched down on the runway the left wing struck crops in a wheatfield which arrested the forward motion of the wing. According to th e pilot, the aircraft veered out of control into the wheatfield, cartwheeled twice, and…NTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB MIA86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe plt stated that during the takeoff portion of a touch and go landing he lost directional control of the acft. The acft veered left off the rwy, struck a ditch and the landing gear collapsed.NTSB MIA86LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tallahassee, FLWhile on final apch the acft was blown to the right of the rwy where the left wing struck a dirt mound. The acft then spun to the left and came to rest aprx 75 ft from the edge of the rwy. The plt stated that he decided to try and salvage the landing during…NTSB LAX86LA217Accident · No injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe student pilot was returning to Thermal airport, Thermal, CA after completing a round robin solo cross country flight. While landing on runway 30 the student encountered a 90 degree right crosswind and lost control of the airplane. The airplane exited the…NTSB ANC86LA056Accident · No injuriesLimited investigationFinal reportCessna A185E · Tok, AKThe pilot-in-command stated that upon landing in a crosswind, a gust of wind caused the airplane to become airborne. Upon touching down again the airplane was in a crab and the pilot lost control and the airplane struck the left wingtip, then the right…