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 ATL84LA009Accident · No injuriesLimited investigationFinal reportBeech E18S · Denver, NCAfter taxiing onto the rwy the plt ran the engs up to takeoff power of 36' mp & began the takeoff roll. Shortly thereafter she reduced power to about 25'-30' mp because the acft appeared to accelerate slowly. After a quick scan of the instruments which…NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…NTSB MKC84LA001Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cedar Rapids, IAThe plt reported that when he landed on rwy 13, the wind was from 170 deg at 10 gusting to 20 KTS. He said that about 30 ft beyond the touchdown point, a gust of wind picked up the right wing & the acft swerved to the right. Subsequently, the left main gear…NTSB DEN84LA001Accident · No injuriesLimited investigationFinal reportCessna TU206G · Medicine Bow, WYThe purpose of the flt was to take photographs of an oil drilling rig. The plt was unable to find the rig & decided to land on a dirt road to talk to the driver of an oil company truck. The plt made three low passes over the road, which was oriented to the nw…NTSB ATL84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sewanee, TNThe acft collided with trees during landing roll. The plt has recounted several variations of the accident from locked brakes (parking) to a flat left tire with full right rudder to maintain directional control. There was a left tire skid mark from touchdown…NTSB ATL84LA002Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbia, SCThe student plt reported he was practicing touch-and-go takeoffs & landings on rwy 11. While rolling after the 4th landing, power was applied for takeoff. At about that time, the acft veered to the left & ran off the rwy. Subsequently, it struck a drainage…NTSB DEN83LA226Accident · No injuriesLimited investigationFinal reportBeech H35 · Salida, COThe acft touched down about 1/2 way down the rwy, left of centerline. The acft then struck a small ridge of dirt & rocks& came to rest with the left landing gear collapsed.NTSB ATL83LA385Accident · No injuriesLimited investigationFinal reportBeech 58 · Birmingham, ALThe acft swerved off the rwy after the left tire deflated during heavy braking & the left landing gear collapsed during the swerve. The pilot stated the acft was rolling too fast after landing to make the first turn off. The pilot then applied heavy braking…NTSB ANC83LA183Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot stated that during takeoff rotation, which occurred at 44 KTS the aircraft began a slow turn to the left apparently a torque stall, causing a wing stall and the left wing struck the ice. The pilot aborted the takeoff and the right float struck a mud…NTSB CHI83LA444Accident · No injuriesLimited investigationFinal reportCessna 172P · Sandwich, ILDuring landing the plt used forward slip, & after touchdown the acft went off the right side of the rwy striking a taxiway. The jar of hitting the taxiway resulted in the plt unintentionally advancing the throttle & the acft became airborne. The plt retarded…NTSB NYC83LA255Accident · No injuriesLimited investigationFinal reportBeech B55 · Pomona, NJDuring the landing roll the plt applied brakes and the left main landing gear collpased. The acft turned to the left and the remaining gear collapsed. The acft veered off the side of the rwy, dug into the soft dirt and spun around.NTSB ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…NTSB LAX83LA449Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe acft collided with a sand bank during takeoff roll, a fuel leak developed and the acft was consumed by fire. The pilot was attempting a takeoff on a dry lake bed when the acft hit a few sand bumps. The nose went up in the air andthe acft came back down…NTSB CHI83LA431Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Hamilton, OHThe plt reported that he encountered gusty x-winds on final apch. According to him, a quartering tail wind was encountered after touchdown which pushed the acft on its nose. The acft skidded on its nose until it contacted sod at the edge of the rwy, then…NTSB MKC83LA221Accident · No injuriesLimited investigationFinal reportCessna 182 · Kansas City, MOThe plt reported that after landing, she was taxiing to a ramp area when a gust of wind lifted the left wing & rolled the acft over on its top. The winds were reported from 190 deg at 20 gusting to 30 kt.NTSB MKC83LA220Accident · No injuriesLimited investigationFinal reportCessna 172N · Morland, KSWhile landing on a country road, the acft landing gear encounter a sand pit on the road. The plt reported that the plane ground looped on the sand, ran into a ditch & hit a tree.NTSB MIA83LA243Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Augustine, FLOn the previous flt, the plt noted that the left brake was weaker than the right brake. Before taking off again, he added fluid to the left brake sys. After flying about 1 hr, he returned & landed. During the landing roll, the left brake failed to operate.…NTSB FTW83LA436Accident · No injuriesLimited investigationFinal reportCessna 180K · El Reno, OKThe acft nosed over while landing. The 2nd plt was transitioning into tailwheel acft. The PIC demonstrated one landing and the 2nd plt attempted the next. The acft bounced and the PIC took over the controls too late to prevent the nose over.NTSB MKC83LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrence, KSThe pilot stated that he was taking off for his fourth touch and go landing when the acft weathervaned and he lost control of the acft. The nose wheel struck a concrete drainage ditch.NTSB SEA83LA199Accident · No injuriesLimited investigationFinal reportBellanca Gcbc · Spokane, WAAccording to the operator, the plt was practicing touch & go landings. During a landing, the acft ground looped & the left horizontal stabilizer struck a VASI light. The plt reported that he had 4.2 hrs in this make & model.NTSB NYC83FU010Accident · Serious injuriesFinal reportRotec Rally 3B · Franklin, MAAccording to the plt, the registered ultralight acft was brought to a field during the morning to check out the control rigging & to familiarize him with the vehicle. There was no intention to fly the ultralight at that time. Later in the day, the plt was…NTSB CHI83LA422Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Galesburg, ILAfter landing at the Galesburg arpt, the plt was turning onto the taxiway when the acft ground looped in strong wind conditions. The left wing was substantially damaged during the mishap.NTSB ATL83LA364Accident · No injuriesLimited investigationFinal reportPiper PA-38-12 · Louisville, KYThe acft collided with a sandbank on a private airstrip during landing. The weather was clear and the wind was calm. Therwy was 75 ft wide and dry. As the acft slowed during the rollout it drifted to the left, the plt overcorrected with right rudder and the…NTSB NYC83LA238Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Glens Falls, NYDuring the landing the acft bounced and the plt decided to go-around. As power was added and carburetor heat removed, the acft veered off the rwy to the left and nosed over.NTSB CHI83LA421Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Galesburg, ILThe plt stated that when he was landing on rwy 20 with a x-wind, it switched to a rear quartering wind. At about that time, the acft went off the rwy & struck a rwy marker with its tailwheel. The acft then ground looped, damaging the lower left wing.NTSB LAX83LA428Accident · No injuriesLimited investigationFinal reportCessna 172N · Novato, CAThe plt stated that he attempted to takeoff in strong x-wind conditions. During the takeoff roll, the acft veered off the right side of the rwy. After unsuccessfully trying to get back onto the rwy, the plt aborted the takeoff. However, the acft continued…NTSB FTW83LA419Accident · Serious injuriesLimited investigationFinal reportChampion 7GCB · Danevang, TXThe plt stated that after touchdown, he turned too fast & lost directional control of the acft.NTSB DEN83LA208Accident · No injuriesLimited investigationFinal reportCessna 182F · Fort Morgan, COThe acft went off the rwy and nosed over during landing. The plt landed on rwy 14 with the wind reported as being from 250 degrees at 5 KTS with gusts to 7 KTS. The plt reported a gust of wind picked up the right wing. He lost directional control, the acft…NTSB CHI83LA416Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankfort, ILThe plt stated that he touched down with a slight angle to the rwy and went off to the left side into the grass. He misjudged the distance to the trees and the left wing contacted a tree.NTSB SEA83LA200Accident · No injuriesLimited investigationFinal reportMaule M-4 · Monroe, WAThe plt reported that he was practicing touch-and-go landings with a friend that was a certified flt instructor (CFI). After a landing, the friend indicated his desire to fly the acft. The plt offered to let his friend fly it from the left seat. The friend…NTSB FTW83LA403Accident · No injuriesLimited investigationFinal reportCessna 140 · Hitchcock, TXThe acft nosed over during takeoff. The flt said that the rwy was 50 ft wide but had been mowed only to a width of 20 ftthe plt allowed the acft to drift into the high grass alongside the rwy. The acft continued off the rwy and nosed over in tail grass.…NTSB ATL83LA343Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600-A · Florala, ALThe pilot stated that during takeoff roll he experienced a power surge but the engine did not quit. He aborted the takeoff by reducing power on both engines and applying brakes. This resulted in the aircraft swerving off the right side of the runway, rolling…NTSB CHI83LA394Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe plt lost directional control during the landing roll & the acft struck 3 landing lights. The left gear collapsed & there was substantial damage to the left wing. The pilot stated that his landing light was inoperative during the landing and lack of…NTSB ANC83FAG09Accident · No injuriesFinal reportCessna 140 · Kotlik, AKThe acft ran off the rwy and the right main landing gear collapsed.NTSB DEN83LA201Accident · No injuriesLimited investigationFinal reportCessna 180 · Busby, MTAccording to the pilot he was making a downwind landing to avoid taxiing over rough ground any farther than necessary. After touchdown he travelled about 150 yards up the runway when a gust of wind picked up the tail and he lost control ending in a ground…NTSB NYC83LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Brockport, NYThe CFI and student plt had conducted about 4 touch & go landings prior to the CFI authorizing a first solo takeoff. According to the CFI, at about 1/3 of the way down the runway, the acft drifted to the left onto the grass and continued until contact with a…NTSB FTW83LA395Accident · No injuriesLimited investigationFinal reportCessna 172H · Plano, TXThe acft collided with 2 parked acft after the student plt lost control during landing. The plt stated that he experienced a crosswind gust or updraft during touchdown. The landing was on rwy 16 and the wind was estimated to be from 220 degrees at 12 KTS. The…NTSB ANC83LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKDuring arrival, the plt landed on a gravel strip with a left x-wind at 10 gusting 20 KTS. Reportedly, he encountered a gust of wind during the landing & lost control when the left wheel went into soft gravel on the bank of the strip. Subsequently, the acft…NTSB NYC83LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYThe student pilot was on a solo flt, practicing touch-and-go landings. While on a landing roll, the acft veered to the left. The student stated that he applied right rudder, but the acft continued to the left. Reportedly, the student applied brakes to stop,…NTSB LAX83LA405Accident · No injuriesLimited investigationFinal reportPiper PA-20-150 · Auburn, CAThe acft veered off the rwy into a ditch. Wind was gusting 15 KTS.NTSB LAX83LA407Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Poston, AZDuring takeoff from the unlighted strip the acft went off the right side. The right main landing gear went into the softsandy shoulder & the acft flipped over.NTSB MIA83LA209Accident · No injuriesLimited investigationFinal reportCessna 172N · Manati, PRThe plt reported that during the landing, a gust of wind blew the acft to the left. Subsequently, the acft collided with a fence that paralleled the left side of the rwy, then nosed over.NTSB FTW83LA391Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lissie, TXThe acft ran into a ditch during takeoff and collapsed the landing gear. The plt said he was steering around some mud holes when the wing became entangled in high grass alongside the rwy. The acft groundlooped off the rwy into a ditch. The wings and landing…NTSB FTW83LA389Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bryan, TXThe student plt was on a x-country flt to the college station easterwood arpt near Bryan, TX. When he arrived in the vicinity, he saw a nearby arpt, the Texas a&m flt test station. He stated that at about the same time, the eng missed momentarily, 2 times,…NTSB ATL83LA334Accident · No injuriesLimited investigationFinal reportCessna 150F · Gordonsville, VAThe acft veered off the right side of the rwy during a landing after an aborted takeoff. The student pilot had just completed 5 takeoffs and landings with a CFI. The student was then told to do two solo full stop takeoffs and landings. The first takeoff and…NTSB ATL83LA329Accident · No injuriesLimited investigationFinal reportCessna A 152 · Lynchburg, VAThe acft ran off the rwy and collided with a ditch during takeoff. The student pilot was practicing touch and go landings. During one running takeoff after full power was applied the plt noticed that full flaps were still extended. While retracting the flaps…NTSB ANC83LA149Accident · Serious injuriesLimited investigationFinal reportCessna T-207A · Atmautluak, AKThe plt stated that during the takeoff roll, his seat slid backwards & he was unable to reach the controls. Subsequently, the acft veered to the right, departed the rwy & went into a shallow pond. The plt reported that the seat latch malfunctioned & was…NTSB ANC83LA148Accident · No injuriesLimited investigationFinal reportPiper J-5 · Fairbanks, AKThe acft ground looped during landing and collided with two parked acft. The pilot landed on rwy 24 at Fairbanks and during the landing he lost directional control of the acft. The acft left the rwy and collided with two parked and unoccupied acft. The parked…NTSB LAX83LA394Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAThe plt stated that her apch for landing was high & fast, which resulted in a touchdown on the middle 1/3 of the rwy. During the roll-out, she applied brakes to slow down, but the acft swerved off the south side of the rwy. Subsequently, it struck a tree,…NTSB LAX83LA391Accident · No injuriesLimited investigationFinal reportCessna 172 · Herndon, CAThe pilot reported that the approach and landing were normal. During rollout, the acft's landing light failed and the pilot was unable to see well enough to maintain his course on the rwy. The acft veered off the left side onto soft terrain and the nose gear…