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 ANC85LA104Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ungalikthluk Rv, AKThe plt reported that when he was landing the float plane on a river, an extreme gust of wind cocked the acft causing loss of control. Subsequently, the acft struck a river bank & was damaged. The plt noticed that after the landing, the winds had changed,…NTSB ANC85LA103Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe aircraft swervd on the runway and ground looped, the pilot stated he lost control of the acft due to the wind condition.NTSB MKC85LA135Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · York, NEThe plt reported that he had completed a landing & had come to a near stop, then he applied power & was on the brakes for control. He stated that the left brake locked & the acft went off the rwy into hi weeds & rough terrain. There was no damage due to…NTSB ANC85LA101Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bering River, AKThe plt stated that during a 15 to 20 min period after he had landed, the wind velocity increased greatly. He managed to taxi the float plane to an area where he could takeoff into the wind. As the acft was on the step for takeoff, the left wing lifted as if…NTSB ANC85LA098Accident · No injuriesLimited investigationFinal reportCessna 180 · Northway, AKDuring arrival, the plt landed the tail wheel equipped acft on rwy 22 with a x-wind from 290 deg at 8 KTS. After touchdown, the acft entered a ground loop & was damaged. A check of the plt's blood showed an alcohol level of 0.249%.NTSB ANC85LA097Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKPlt lost control on landing and ground looped. Wx and field conditions not a factor.NTSB CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…NTSB CHI85LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Starbuck, MNPlt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.NTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…NTSB NYC85LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Red Hook, NYThe acft contacted trees following a loss of directional control during a landing roll on rwy 19.NTSB MKC85LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Pratt, KSStudent pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a…NTSB LAX85LA281Accident · No injuriesLimited investigationFinal reportOtis G. Lyons Marquart Charger MA5 · Upper Lake, CAThe plt elected to take off in his taildragger on rwy 19 which is 4050 ft long & 200 ft wide during a period when the wind was estimated at 270 deg, 20 KTS, with gusts to 25 KTS. The plt stated that at rotation full rt rudder was applied, but his homebuilt,…NTSB DEN85LA156Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COOn June 15, 1985, a Cessna 170B ground looped during a touch and go landing at contennial arpt, Englewood, CO. The plt said a gust of wing caught him by surprise. The acft departed the runway and flipped over on its back. The plt was not injured.NTSB SEA85LA136Accident · Minor injuriesLimited investigationFinal reportCessna R-172-K · Las Vegas, NVDuring landing rollout on runway 19R directional control was lost with the aircraft verring to the right of the runway. Correction was made to the left, but the aircraft veered off the runway to the left. The wind was from 160 at 9. The density altitude was…NTSB LAX85LA271Accident · No injuriesLimited investigationFinal reportCessna 172RG · Upland, CAThe plt stated that on the flt prior to the accident he felt a slight pull to the right as he applied brakes. On the next flt he touched down normally, lowered the nose and lightly applied brakes. The pull to the right was more severe this time. He applied…NTSB CHI85LA232Accident · No injuriesLimited investigationFinal reportPiper J-3 · Gaylord, MIThe plt attempt to take the float plane across a lake in wind that was from 270 deg at 20 gusting 40 KTS. Subsequently, the acft capsized & was damaged. In a revised statement, the plt reported that he was 'sailing' (letting the wind blow the acft) across the…NTSB ANC85FA090Accident · No injuriesField investigationFinal reportAeronca 7AC · Anchorage, AKThe acft collided with a parked helicopter during landing. The acft had left the rwy at midfield & collided with the parked acft. The plt stated that he lost directional control after lndg. A rwy light on the left side of the rwy aprx 900 ft from the approach…NTSB MIA85LA186Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City, FLThe plt stated that while taking off in a x-wind he lost control of the acft. The acft contacted the lip of a large drainage ditch, cartwheeled 180 degs to the right and crashed into a ditch.NTSB MIA85LA185Accident · No injuriesLimited investigationFinal reportHughes 269C · St.Petersburg, FLThe helicopter was landing after a training flight with an instructor pilot and a non-rated-non-certificated student pilot on board. As the helicopter touched down a severe resonant vibration started. The instructor stated that he attempted to lift off the…NTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…NTSB MKC85LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Des Moines, IADuring a full stop landing the plt applied brakes to arrest the landing roll and upon application of the brakes, the acft veered slowly to the left without slowing down. The check plt applied his brakes to assist the plt, but without any effect. The acft…NTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…NTSB SEA85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brentwood, CAOn the student plts seventh attempted landing, directional control was lost and a groundloop occurred. The student plt had less than two hours of total pilot in command time.NTSB SEA85LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · North Las Vegas, NVLoss of directional control occurred during the student pilot's second attempted touch and go. The aircraft veered let, struck a berm with the nosewheel and then nosed over. FAA inspectors attempted to physically check flight controls but movement was limited…NTSB FTW85LA246Accident · No injuriesLimited investigationFinal reportCessna A188B · Friona, TXThe plt lost directional control and ground looped off the side of the rwy. The purpose of the flt was to check the adjustment of the acft's spray dispensing equipment. Twenty gallons of water were on board to be used as a substitute for chemical spray. The…NTSB LAX85LA266Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Hesperia, CAWhile en route, the plt noted thunderstorms & towering cumulus clouds over the tehachapi mountains & elected to divert to Hesperia. He stated that all fields within range had 'severe winds and storms closing.' He said that during the landing at Hesperia,…NTSB DEN85LA148Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bountiful, UTOn June 1, 1985, an Aeronca 7AC, piloted by a private plt, ground looped while making a touch and go landing at sky park airport, Bountiful, UT. The plt stated that he lost control of the airplane. The winds were reported to be calm.NTSB CHI85LA224Accident · No injuriesLimited investigationFinal reportStearman E-75 · Lake Odessa, MIUpon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed…NTSB ANC85LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe acft sustained substantial damage when the pilot lost control of the acft and nosed over on its back. The weather was VMC but the pilot said he encountered a gust and crosswind during landing.NTSB FTW85LA252Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAThe left brake failed during the landing roll. The acft veered to the right of the rwy and ground looped. During the groundloop, the left tire blew and the tail wheel spring bolt assembly failed. Cause of the brake failure was not determined.NTSB FTW85LA243Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Edna, TXThe pilot lost directional control during a crosswind takeoff from a ranch road. The acft veered off the right (north) side of the road where it contacted a ditch in a rice field.NTSB FTW85FPA03Accident · No injuriesFinal reportMooney M20 · Fort Worth, TXThe acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating…NTSB FTW85LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164A-600 · Dalhart, TXThe plt had accumulated 12 hrs experience in this model acft. He stated the acft bounced on the rough airstrip, and he applied too much brake on the next touchdown. The acft nosed over, damaging the top wing and empennage.NTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.NTSB FTW85LA232Accident · Minor injuriesLimited investigationFinal reportPitts Special S-1C · Lubbock, TXThe pilot, although well experienced, had recorded only one hour of flight time in this make and model aircraft and no flight time in any aircraft within the 90 day period preceding the accident. This is the information recorded on the pilot/operator aircraft…NTSB ANC85FA086Accident · No injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKAcft lost control during landing & groundlooped. The plt stated the heel of his shoe slipped off the brake pedal when an attempt to apply the brakes was made.NTSB DEN85LA140Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Watkins, COA witness stated the acft veered aprx 30 degs during the landing roll and was heading toward the north edge of the rwy when full pwr was added to abort the landing. The acft took off and traveled over a grass and wheat field, which borders the rwy, with the…NTSB CHI85LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Valparaiso, INAcft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident.NTSB NYC85LA127Accident · No injuriesLimited investigationFinal reportCessna C152 · Newry, PAThe student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the…NTSB CHI85LA203Accident · No injuriesLimited investigationFinal reportCessna 140A · Owosso, MIThe plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the…NTSB MIA85LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Jekyll Island, GAThe student plt was on her 1st supervised solo. During a touch-&-go landing, the acft veered off the left side of the rwy & subsequently hit a culvert. The student said that after she landed, she applied too much left rudder.NTSB NYC85LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJAccording to the student, the acft encountered a sudden wind shift from the east as he was landing. He stated that this caused the plane to tip over to the plt's right & come to rest on its top. The student also reported that the wind was from 050 deg at 7…NTSB LAX85LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAOn the student plt's third supervised solo flt he landed the acft. After touchdown he applied pwr to make a touch & go, & then raised the flaps. The acft veered left, rolled off the rwy, collided with a small dirt mound & nosed over. The student had 18.2…NTSB ANC85LA082Accident · No injuriesLimited investigationFinal reportCessna C-185 · Anchorage, AKThe pilot in command touched down on a dry runway in a crab angle and lost control of the airplane resulting in ground loop.NTSB LAX85LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pacoima, CAPlt attempted a no-flap landing during which excessive airspeed was used. The acft drifted off the right side of the rwy during the flare and subsequently touched down in soft terrain. While braking directional control was lost and the acft collided with a…NTSB CHI85LA196Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Conneaut, OHThe plt stated that he elected to begin his takeoff roll 300 ft down the rwy due to a mud hole located at that point. During his initial climb, the plt believed the acft might not clear trees at the departure end of the rwy & elected to turn right in an…NTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.NTSB ATL85LA158Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Greenville, ALThe plt stated that he made a normal apch for a full stop, 3-point landing. During the landing roll, the acft began to vibrate & shake laterally. The plt reported that the vibration was caused by a tail wheel shimmy, but at first, he did not realize what…NTSB ANC85LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKPlt did not use all available takeoff area and failed to recognized need to abort until too late. Possible overweight airplane loaded beyond centre of gravity rangeNTSB ATL85LA163Accident · No injuriesLimited investigationFinal reportCessna 182A · Dover, TNThe student plt and his pax, a private plt, flew to another arpt and made several takeoffs and landings. Then returned to the private airstrip where their flight had originated. The student plt was at the controls on this apch. After touchdown the acft became…