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 CHI86LA140Accident · No injuriesLimited investigationFinal reportCessna 150F · Gaylord, MIOn rollout, while the plt was attempting to correct a drift to the right, the acft suddenly veered to the left and the nose gear collapsed. During the resulting slide, the aircraft began burning and was destroyed. The plt reported that the magnesium hub of…NTSB MKC86LA106Accident · No injuriesLimited investigationFinal reportCessna 188 · Lawrence, KSThe pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over.NTSB SEA86LA123Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Sunnyside, WAAfter completing several touch and goes, the pilot lost control of the aircraft on landing rollout due to a light gusting crosswind. The pilot was unable to avoid departing the runway to the left striking a four foot embankment collapsing the nose gear.NTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…NTSB MIA86LA156Accident · No injuriesLimited investigationFinal reportCessna T210N · Destin, FLThe plt stated that the acft swerved to the left uncontrollably after he applied the brakes during the landing roll. The nose gear then collapsed and the acft slid off the rwy. Investigation revealed no preexisting mechanical malfunction.NTSB LAX86LA216Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Riverside, CAThe CFI reported that during the landing roll on runway 24, at fla-bob airport, Riverside, CA, the airplane began to 'drift to the right.' The CFI applied left rudder to correct the excursion but his left foot slipped off the rudder bar and became lodged…NTSB FTW86LA088Accident · No injuriesLimited investigationFinal reportCessna 337D · Edinberg, TXThe pilot stated he lost both engines while in cruise flight. However, no evidence of engine malfunction was found during the investigation. The pilot is under investigation for illegal drug trafficking. A dea agent suspects the pilot had unloaded his cargo…NTSB SEA86LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakima, WADuring rollout on the third touch & go landing the student had control of the acft. While preparing for a downwind takeoff the acft drifted across the rwy and into a grass area. The instructor was unable to regain directional control. The acft contacted a…NTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…NTSB FTW86LA077Accident · No injuriesLimited investigationFinal reportCessna A185F · Georgetown, TXThe pilot failed to correct for a wing which was lifted in a gust of wind. The wingtip touched the ground and the aircraft nosed over onto it's back and stopped.NTSB ATL86FEI05Accident · No injuriesFinal reportPiper J3 · Wauseon, OHThe plt reported that he was landing on rwy 27 with the wind from about 190 degrees at 15 mph, gusting to 23 mph; he executed a normal ldg and was rolling out when a gust of wind lifted up the left wing and the acft ground-looped. The acft subsequently…NTSB SEA86LA117Accident · No injuriesLimited investigationFinal reportHanson Jungmann 131E · Las Vegas, NVDuring rollout after a left x-wind landing and while decelerating through aprx 20-25 mph, the plt encountered a wind gust. Directional control was lost and the acft nosed over as it departed the rwy. The plt reported having only 2 hrs total flt time in this…NTSB SEA86LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Twin Falls, IDDuring final apch the ATCT advised the plt of a 17 kt x-wind with gusts to 22 KTS. The plt landed but was unable to maintain directional control and the acft departed the rwy into a grass area. The plt attempted to takeoff again, the wind lifted up the wing…NTSB LAX86LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Wickenberg, AZA Cessna 152 veered off the rwy and nosed over while on a VFR solo cross country training flt. The plt indicated that during roll the acft began oscillating up and down for aprx 100 feet of travel down the runway. The acft then veered left off the runway. The…NTSB ANC86LA052Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee L-13 · Fairbanks, AKDuring the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At…NTSB MKC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fulton, MOThe pilot and his passenger were on a short flight to check the operation of a VOR receiver. While they were on the landing roll, a gust of wind turned the nose of the airplane to the left and the airplane ran off the runway and the right gear hit a runway…NTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…NTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…NTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…NTSB SEA86LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dallas, ORA precautionary landing was made due to deteriorating weather. Directional control was lost while attempting to land on the 70 foot wide, wet, grass airstrip during gusty crosswinds. The aircraft veered to the side of the runway striking four parked…NTSB ANC86LA050Accident · Minor injuriesLimited investigationFinal reportInterstate 15B2 · Port Heiden, AKThe pilot stated that during the takeoff roll he lost control of the aircraft causing the plane to nose over on its back.NTSB ANC86LA049Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Polly Creek, AKThe pilot attempted a landing on a sandbar. During the landing roll the pilot lost directional control of the aircraft causing the airplane to ground loop and then nose over on its back.NTSB MIA86LA127Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · San Juan, PRThe plt stated that on landing the acft started to porpoise. He lost control, the landing gear collapsed and the acft slid to a stop on the rwy.NTSB FTW86LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Keller, TXThe pilot reported colliding with a ditch along side the runway at goode airport in Keller, TX, when he failed to maintain directional control on landing. There was substantial damage to the aircraft when the impact tore off the left strut, causing the left…NTSB CHI86LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Augusta, WIThe pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees…NTSB FTW86LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Vernon, TXThe pilot reported landing at above normal speed, when he lost control of the aircraft at touchdown. The aircraft then veered off the runway onto wet grass. Do to the slippery conditions, the aircraft began sliding until it collided with a fence 100 feet from…NTSB ANC86LA046Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot stated that while doing a series of touch and go's, the aircraft veered on the runway; the pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB ANC86LA044Accident · No injuriesLimited investigationFinal reportCessna 120 · Lake George, AKThe pilot stated that during a three point landing the main landing gear broke through a thin layer of ice into approximately six inches of snow and then the aircraft went over on its back.NTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.NTSB LAX86LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Mesa, AZThe plt lost control of the acft during a touch and go maneuver and ran off the rwy. After touchdown the acft lifted back off the ground and drifted right. The acft then settled and touched down on the right shoulder of the rwy. The plt then noticed a…NTSB FTW86LQG14Accident · Minor injuriesFinal reportPiper PA-36-400 · Semonole, TXThe acft nosed over during landing. The plt stated that he landed straight in to the south in a 45 degree tailwind. The landing was made on a dirt strip after an aerial application flt.NTSB DEN86LA122Accident · No injuriesLimited investigationFinal reportRJB Skybolt A-1 · Erie, COThe plt reported that the acft encountered a ridge on the rwy during the landing roll and swerved off the side. He said weather was not a factor. An FAA ops inspector examined the rwy after the acdnt and could not locate the reported ridge.NTSB LAX86LA172Accident · No injuriesLimited investigationFinal reportCessna 182 · Jackson, CAThe acft went out of control and collided with terrain during a landing roll on rwy 19. The plt stated that a gust of wind lifted the right wing during the landing roll and the acft departed the rwy and collided with a ditch. The plt reported that the winds…NTSB FTW86LA065Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Del Rio, TXThe student pilot was being instructed in the landing of a tail dragger aircraft, when he lost control of the aircraft at touchdown. The instructor failed to take corrective action when the student pilot inadvertently applied left brake, causing the aircraft…NTSB LAX86LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe purpose of the dual instructional flight was for the instructor pilot to check out a private pilot in the conventional gear Cessna 140 aircraft. After a series of uneventful full stop & touch & go landings, the student was directed to land. The CFI & a…NTSB ATL86LA106Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hamilton, OHThe plt made a low pass over the drag strip to check the wind. He climbed, made a 180 deg turn and attempted a normal landing. On roll out a wind gust was encountered which tipped the acft up on the right wheel. It veered off the hard surface into a guard…NTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…NTSB LAX86LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Novato, CAA PA-38 lost directional control during a takeoff with both the student and instructor pilot at the controls. The aircraft sustained substantial damage but both pilots were uninjured. The wind was 90 degrees crosswind at 10 knots gusting to 15 knots. The…NTSB FTW86LA057Accident · No injuriesLimited investigationFinal reportCessna 185F · Point Aufer, LAThe pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal…NTSB LAX86LA164Accident · No injuriesLimited investigationFinal reportCessna 150H · Tucson, AZThe pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the…NTSB ATL86LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNDuring landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway.NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.NTSB CHI86FEC03Accident · No injuriesFinal reportCessna U-206B · Tecumseh, MIThe acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing.NTSB SEA86LA086Accident · Minor injuriesLimited investigationFinal reportMaule M5-180C · Sand Point, IDWhile attempting to take off in strong gusty crosswinds, the plt lost control of the acft. The acft veered off the rwy, struck a fence post, and nosed over inverted. The reported winds at coeur d'alene, ID, 33 nmi ssw of Sand Point, were reported as being…NTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…NTSB NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…NTSB MIA86LA107Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ft. Lauderdale, FLThe non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'…NTSB MKC86LA074Accident · No injuriesLimited investigationFinal reportBeech G18S · Cedar Rapids, IAThe pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by…NTSB LAX86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Tucson, AZA Cessna 150 collided with terrain during a takeoff from a road. The student plt indicated he was practicing aerial maneuvers in the training area when the engine quit. He successfully accomplished a power off landing to an asphalt road. A certified mechanic…NTSB DEN86LA104Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Falcon, COAccording to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring…