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 ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…NTSB LAX88LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Tucson, AZThe pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot…NTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…NTSB SEA88LA007Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Petersburg, AKThe plt of the floatplane rprtd that after the acft touched down drg a water lndg & was on the 'roll-out,' she pushed the carb heat in & leaned forward to raise the flaps. At about that time, the floatplane bgn to swerve. She attempted to regain control;…NTSB BFO88DHD02Accident · No injuriesFinal reportBoeing A75N1 · Milton, DEThe pilot's improper brake application during a 'wheel' landing, which resulted in the aircraft nosing over. The slight downslope of the airstrip, a quartering tailwind, inadequate supervision on the part of the check pilot, and the pilot's lack of…NTSB CHI88FA005Accident · No injuriesField investigationFinal reportCessna TU-206G · Lansing, MIImmediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered…NTSB ANC88LA006Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Tin City, AKThe pilot stated the wind was a direct crosswind and the velocity was 30 knots gusting to 38 knots. During the take off roll, the airplane lifted off the ground and then settled and ran off the end of the runway.NTSB DEN88LA009Accident · No injuriesLimited investigationFinal reportCessna A185F · Glasgow, MTThe plt reported that he was landing on rwy 12 with the winds, as reported by UNICOM, 100 deg at 10 KTS. He said that shortly after touchdown the acft was hit by a strong gust from the rt. The rt wing lifted, the lt wing hit the ground, and the acft nosed…NTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.NTSB LAX88LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · San Jose, CAThe pilot stated that during the landing roll he was distracted and looked downward. He said that when he looked back up the ground loop had started and it was too late to correct it. He did not report any mechanical problems prior to the accident.NTSB DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…NTSB DEN88LA005Accident · Serious injuriesLimited investigationFinal reportRockwell 690B · Albuquerque, NMAcft was landing on rwy 17 at coronado airport, 9 NM n of Albuquerque, NM intl arpt. Plt said he brought props into reverse and acft went off right side of rwy. Plt brought props out of reverse, realigned acft on rwy, and reversed props again. Acft went off…NTSB FTW88LA004Accident · No injuriesLimited investigationFinal reportCessna L-19 · San Marcos, TXOn touchdown the aircraft's left main tire was flat. Control was lost when the pilot attempted to taxi off the active runway. The aircraft slid off the runway into some grass causing substantial damage to the aircraft.NTSB DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…NTSB LAX88LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Big Bear City, CAThe student pilot bounced during landing and collided with runway lights and a taxiway sign. He landed on runway 25 with winds reported 040 degrees at 8 knots. He said he could not receive wind information because he had inadvertantly turned off his radio.NTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…NTSB NYC88LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Mansfield, MAAccording to the plt, the winds were from the south-southwest at 15 to 20 KTS. He rprtd that drg the landing roll on rwy 22, he applied full right rudder against the prevailing wind, but the acft veered left with the application of brakes. Subsequently, it…NTSB CHI88DEP01Accident · Minor injuriesFinal reportGrumman G-44 · Delevan, WIOn initial takeoff roll the aircraft experienced a loss of control in a strong crosswind, departed the runway to the left, struck a tree line and over turned.NTSB ANC88LA001Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Fairbanks, AKThe plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over.NTSB CHI87LA225Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Rochester, INThe tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over.NTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…NTSB NYC87LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Waynesburg, PAThe pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the…NTSB NYC87LA267Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Irwin, PADuring taxi operation, the pilot lost directional control of the aircraft and it struck a tree stump which was located to the side of the runway. The aircraft then continued to roll about 500 feet off the rwy where it came to rest with substantial damage.NTSB LAX87LA346Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Lakeport, CAThe pilot stated that the aircraft groundlooped during landing roll just as the tailwheel touched down. There were no reported mechanical problems and winds were light and variable. However, the pilot stated that he thought he felt a gustof wind.NTSB DEN87LA239Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Colorado Sprgs, COThe plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and…NTSB FTW87LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXDrg a practice touch-&-go landing, the plt raised the flaps after making a normal lndg & applied full power for a go-around. However, the acft veered off the left side of the rwy & contacted soft ground. Subsequently, the nose gear collapsed & the left wing…NTSB BFO87DID04Accident · No injuriesFinal reportBennetter-Stevens Starduster · Roanoke, VAThe plt went on an orientation flt in the home built starduster. Drg the lndg, the acft touched down at about 40 mph. The plt stated that as it slowed to about 25 mph, the 'right brake or something locked, plane pulled hard right, then up on nose & over on…NTSB CHI87DEX09Accident · Serious injuriesFinal reportde Havilland Dragonfly DH-90 · Sellersburg, INAircraft began left drift during takeoff roll. Pilot corrected with right rudder, and aircraft veered sharply right. Aircraft did not respond to application of left rudder or increased thrust from right engine; departed runway and crashed into drainage ditch.…NTSB ANC87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Talkeetna, AKThe airplane was substantially damaged after it nosed over during the takeoff roll, but the pilot and his passenger were uninjured. The pilot stated that he had landed at an off-airport site to set up his moose hunting camp and that during a subsequent…NTSB DEN87DTI02Accident · No injuriesFinal reportBakeng Deuce · Gillette, WYThe plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &…NTSB ANC87LA166Accident · No injuriesLimited investigationFinal reportCessna 170A · Melozitna River, AKThe pilot attempted to takeoff from a River sandbar close to the water's edge. During the take off roll, one main landing gear tire entered the water and pulled the airplane into the water. The airplane subsequently nosed over and incurred substantial damage.NTSB MKC87LA174Accident · No injuriesLimited investigationFinal reportCessna 120 · Creighton, NEThe flt dptd harvard, NE., with a dest of wausa, NE abt 1 hrs flying dist to the northeast. The departure commenced abt 1 hr and 40 min's prior to dark. The PIC stated he encountered strong headwinds along the route which delayed his progress. The acft…NTSB LAX87LA345Accident · No injuriesLimited investigationFinal reportCessna 180K · San Diego, CAA Cessna 180K dragged its' wing tip during landing roll on runway 28R. The pilot indicated that he encountered a wind gust from the left raising the right wing. The pilot stated that he 'over corrected' in that when the gust subsided the aircraft rolled left…NTSB LAX87LA344Accident · No injuriesLimited investigationFinal reportCessna 150 · Marana, AZThe student pilot lost control of the airplane during landing roll on rwy 30. He indicated that the winds were from 280 deg at 9 KTS gusting to 12 KTS. The airplane veered right departing the rwy. The nose gear subsequently collapsed in rough and uneven…NTSB LAX87LA343Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZA Piper PA-28-180 collided with a tree after veering off runway 15. The pilot indicated that he encountered a right crosswind during the landing roll and veered off the left side of the runway. The aircraft's left wing then struck a tree severing it from the…NTSB CHI87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grayslake, ILThe aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…NTSB ANC87LA147Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft.NTSB DEN87LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Collins, CODuring the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop…NTSB DEN87LA238Accident · No injuriesLimited investigationFinal reportMaule M-5-210TC · Moab, UTThe pilot aborted his approach to runway 21 at canyon lands airport when he had 'indications of a crosswind.' The pilot radioed Moab UNICOM and reported he could not find the windsock and requested wind information. Moab UNICOM reported thewind was 'straight…NTSB ANC87LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot stated that after touchdown on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. He also indicated that the strip was soft and the nose wheel dug in after touchdown.NTSB LAX87LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Franklin, CAThe student pilot was on his first flight in the aircraft after it had been modified with a tail wheel conversion. During the landing, he lost control and the aircraft ground looped. No preimpact part failure or malfunction was evident.NTSB ANC87LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gold King, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees.NTSB ANC87FA140Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Coal Lake, AKThe pilot of the airplane stated that he had step-taxied to the east end of the Lake in preparation for a takeoff to the west. During the take off run, the airplane struck the wake he had just created and became prematurely airborne. He reduced power in an…NTSB CHI87LA207Accident · No injuriesLimited investigationFinal reportCessna 150L · Ludington, MIDrg the takeoff roll, the acft went off the left side of the rwy. The student rprtd the takeoff roll seemed normal untilrotation, but when the nose wheel lifted off the rwy, the acft began to veer to the left. He stated he was unable to correct the situation…NTSB ANC87LA145Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kahlitna Glac, AKThe pilot stated after touchdown on the lake, he lost directional control of the aircraft causing the plane to nose over on its back and the aircraft sank in 20 to 25 feet of water.NTSB ANC87LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kwethluk, AKThe pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust…NTSB NYC87DNE05Accident · Minor injuriesFinal reportHall B-80M · Waterford, CTThe gyrocopter was observed to touch down and become airborne again. After becoming airborne it was observed to pitch down, with the main rotor blades striking the ground in front of the aircraft. The pilot said his right contact lens wasbothering him and he…NTSB NYC87LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeton, NJThe pilot made a landing with a tailwind of 8-10 knots. During landing roll the aircraft pulled to the left and power was added for a go around. The pilot reported, however, that the aircraft would not become airborne so he then decreased the power and the…