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 CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…NTSB SEA86LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Winnemucca, NVDirectional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over.NTSB CHI86LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHAccording to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft…NTSB NYC85LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittstown, NJDuring an attempted takeoff on a 2439 ft rwy, the plt was unable to apply back elevator pressure thus the acft was prevented from becoming airborne. The acft traveled off the end of the rwy where it contacted a fence and trees. Inspection of the acft…NTSB ANC85LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot stated the aircraft left wing was raised by a gust of wind. The aircraft accelerated rapidly in a si deways attitude to the right. The wind gust encountered and the fact the landing roll was almost completed CA used a situation that was beyond the…NTSB ATL85LA287Accident · No injuriesLimited investigationFinal reportHughes 269A · Winchester, KYThe accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported.NTSB LAX85LA406Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, CAThe acft was observed to turn to the left during the takoeff ground roll on rwy 32R at buchanan airport, Concord, California and exit the rwy environment. The certificated private plt reported that shortly after applying full power the acft 'swerved' to the…NTSB ANC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Feather River, AKWhile landing in gusty surface wind conditions the pilot lost control of he airplane and turned over.NTSB SEA85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Winnemucca, NVThe plt was attmepting to depart rwy 02 and the wind was from 300 degs at 15 KTS gusting to 20 KTS. Directional control of the acft was not maintained and it veered off the side of the rwy during the takeoff ground run.NTSB SEA85LA218Accident · No injuriesLimited investigationFinal reportWaco UIC · Boise, IDThe plt reported that when he landed, the acft began drifting to the left. Since there was a high speed turn-off ahead, he did not make an immediate correction for the drift. When a correction was applied, the acft did not respond & it continued into a ground…NTSB MIA85LA259Accident · No injuriesLimited investigationFinal reportCessna C-152 · Lantana, FLThe plt stated that he was hovering at an altitude of about three feet. Approximately 100 feet north of the rwy. When an out-of-control Cessna 152 tore off their right landind skid. The helicopter landed safely using a wooden dolly for support of the right…NTSB ANC85LA181Accident · No injuriesLimited investigationFinal reportCessna 172 · Shirleyville, AKThe acft nosed over following a loss on control while landing on a gravel road. The plt reported that after a 100 ft landing roll, the right wing caught brush along the side of the road. The acft veered right and the right main gear contacted a log resulting…NTSB ATL85LKG13Accident · No injuriesFinal reportCessna 182N · Panala, ALThe acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the…NTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…NTSB MIA85LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Wesley Chapel, FLThe rated private plt was received a check out in the acft by a CFI. The plt was having difficulty on the rwy as the winds were reported as 070 degs at 13 knts. The rwy being used was rwy 32. A 20 deg right x-wind tailwind condition existed. On the 4th touch…NTSB LAX85LA392Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Reno, NVThe plt had completed a heat race as a participant in the Reno national championship air races and was landing in a gusty x-wind when the acft's left wing was lifted by the wind and the acft cartwheeled, resulting in substantial damage to the wings and to the…NTSB FTW85LRG02Accident · No injuriesFinal reportHomebuilt Tiger Bird · Kerrville, TXThe acft nosed over on landing following a loss of directional control. The plt reported touchdown was made on the first 100 ft of the rwy and as the acft slowed to aprx 10 mph directional control was lost. The acft traveled off the left side of the airstrip…NTSB CHI85LA380Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Bloomington, INThe piloted landed with an 80' left crosswind at 8 knots. During landing roll the wind picked up the left wing. The acft weathervaned into the wind & the right gear collapsed. The right wing was also damaged during the swerve.NTSB CHI85LA376Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Eden Prairie, MNThe student landed on rwy 9R with tower winds reported from 150 degrees at 15 knots. During the landing roll in the tailwheel equipped acft, control was lost and the acft tipped up on its left wing and nose.NTSB MKC85LA214Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt lost directional control of the acft while practicing touch & go landings. Winds in the local area were reported by fss as being from 110 degs at 12 KTS, gusting to 17 KTS. The plt lost control of the acft during a landing roll, ran off the…NTSB DEN85LA239Accident · No injuriesLimited investigationFinal reportCessna T210L · Gallup, NMThe student plt was returning from a solo x-country flt. Prior to landing, he called the fss & was advised that the wind was from 190 deg & was gusty. As he landed on rwy 6, the acft veered to the left, went off the rwy, hit a rwy light & was damaged.NTSB ANC85LA174Accident · No injuriesLimited investigationFinal reportCessna C-206 · Big River, AKThe pilot-in-command was attempting to taxi through shallow water to reach the takeoff point. As the airplane's floats came up on step a gust of wind from the left rear caused the airplane to weather vance and struck the streams bank. The stream was very…NTSB ANC85LA173Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Rainey Pass, AKThe plt was taking off on a strip of tundra about 1000 ft long in calm wind conditions. During the takeoff roll, he lost directional control & the acft ground looped & was damaged. No mechanical problems were reported.NTSB ANC85LA180Accident · No injuriesLimited investigationFinal reportCessna 180-J · Egegik, AKAcft nosed over while taxiing for takeoff from a dry lake bed. He was taxiing with a 35 to 40 kt tailwind.NTSB LAX85LA382Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Placerville, CAAcft ran off the rwy after landing. Plt reported acft veered to the left off the rwy and was able to correct back after application of power. Winds were variable at 7 KTS gusting to 12 KTS.NTSB BFO85FA073Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Norfolk, VAThe acft experienced a complete gear collapse after contacting a rwy light and a taxiway sign during a landing roll. Theflt departed la guardia arpt 230 lbs over the 7000 pld max gross weight of the acft and at least 1 inch aft of the center of gravity limit.…NTSB MIA85LA245Accident · No injuriesLimited investigationFinal reportAeronca 7AC · New Smyrna Bch, FLThe aircraft swerved to the left on landing as the tailwheelcontacted the runway. The aircraft left the runway and collided with an embankment shearing the right main landing gear. A post accident examination of the tailwheel steering entering assembly…NTSB MKC85LA200Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Fredericktown, MOThe plt reports that he lost directional control during the landing roll. The acft swerved off the side of the rwy, down an embankment and collided with a fence. The landing and brake system were examined by a mechanic after the accident and no evidence of a…NTSB CHI85IA359Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAC 1-11-201AC · Green Bay, WIThe airplane landed & touched down in the first 1/3 of the runway. It veered to the left, then back to the center & went off the end the runway showed signs of steam cleaning where the tires were & the tires showed signs of rubber inversion. The pilot elected…NTSB ANC85LA164Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Chetaslina Rvr, AKThe pilot stated that he run out of runway and he did not reach min flying speed for lift off. The tundra run way created more drag than the pilot had anticipated. The pilot then departed thr tundra runway lost directional control of the aircraft crusing a…NTSB NYC85LA225Accident · No injuriesLimited investigationFinal reportBeech G18S · Newark, NJWhile taking off with a left x-wind, the acft began to veer to the left. The plt corrected by using differential power & right brake, but the acft continued to veer left & went off the rwy. Subsequently, the right main gear collapsed & the acft was…NTSB ANC85LA161Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dillingham, AKThe pilot stated that approximately 200 ft into the rollout the right wing lifted into the air, veering the plane to the right losing directional control of the aircraft causing the aircraft to exit the runway into a gravel pit.NTSB NYC85LA220Accident · No injuriesLimited investigationFinal reportCessna 170B · Morrisville, VTAccording to the plt, a post maintenance test flt was performed about 45 mins before the landing occurred. The plt stated that he allowed the right seat passenger a student plt and owner of the Cessna 170, to fly and land the acft. Upon landing the plt…NTSB CHI85LA355Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ashkum, ILThe left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer.NTSB CHI85LA353Accident · No injuriesLimited investigationFinal reportCessna 170B · West Chicago, ILDuring application of pwr during a touch-and go landing the acft 'started to get sideways' on the rwy. The plt allowed the acft to drift off the left side of the rwy into the grass. A ground loop subsequently occurred which substantially damaged the acft.…NTSB ATL85IA251Incident · No injuriesIncident investigationFinal reportCessna 441 · Hilton Head, SCThe pilot reported that the approach sequence and profile were normal, and there were no apparent aircraft problems. After touch down the pilot applied reverse thrust. During the landing roll out, the aircraft veered off the left side of the runway, collided…NTSB MIA85LA232Accident · No injuriesLimited investigationFinal reportBell 206A · Sarasota, FLThe helicopter plt landed the helicopter on a wood decked landing dolly. After landing he reduced the collective pitch control full down and reduced the throttle to idle. At the time of landing the wind was on the nose of the acft. Shortlyafter landing the…NTSB CHI85FA344Accident · No injuriesField investigationFinal reportLearjet 23 · Madison, WIThe plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off…NTSB BFO85FID03Accident · Minor injuriesFinal reportBeech A36 · Roanoke, VAThe plt had boarded two pax and started the eng. When he attempted to taxi he realized he still had a chocked gear. Leaving the eng running he got out and found the nose gear chocked. When he removed the chock, the acft which was parked on an incline began to…NTSB CHI85LA343Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlette, MIThe student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually…NTSB CHI85LA333Accident · No injuriesLimited investigationFinal reportCessna 172XP · Int'L Falls, MNThe acft veered hard to the rt & collided with the water during takeoff at about 45 mph. It was discovered that the left float failed and allowed the left float to turn rt and go under the rt float.NTSB SEA85LA192Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAA ground loop occurred and the steering spring failed. The aircraft's steering spring had failed prior to the accident away from a repair station. The pilot made a temporary repair that failed during this ground loop. The pilot stated that a combination of a…NTSB FTW85LA307Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Olton, TXThe pilot stated that when he touched down on the dirt landing strip the aircraft immediately turned right and no amount of corrective action helped. He further stated the mechanic had to remove the brake pads to get the tire to roll. The aircraft's owner…NTSB MIA85LA226Accident · No injuriesLimited investigationFinal reportCessna 210N · Melbourne, FLAct swerved left after landing and crashed at drainage ditc h appx 50 ft north of rwy. The pilot stated he was unable to effect a timely recovery from the left swerve and that 'a more consistent training effort could sharpen my reactions to this sort of…NTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…NTSB CHI85LA332Accident · Minor injuriesLimited investigationFinal reportMcfarland Quickie 2 · Port Clinton, OHThe pilot failed to release the parking brakes before landing after setting the brakes while enroute. The acft swerved off the runway and nosed over.NTSB ANC85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe plt stated on short final apch he noticed a x-wind stronger then expected. After touchdown directional control of the acft was lost. The acft then exited the rwy into a open ditch. At the time of the accident the wind was 280 degs at 12 KTS.NTSB SEA85LA185Accident · No injuriesLimited investigationFinal reportBeech B-35 · Auburn, WADirectional control of the acft was lost for unknown reasons just prior to rotation. The acft then veered off the right side of the rwy.NTSB CHI85LA323Accident · No injuriesLimited investigationFinal reportMaule M-6 · Iron Mountain, MIDuring landing rollout the aircraft ground looped and the left wing struck the runway. This was the pilot's first flight in this model conventional gear aircraft.NTSB CHI85LA322Accident · No injuriesLimited investigationFinal reportCessna 152II · Indianapolis, INThe student plt lost directional control on rollout following a bounced landing. The CFI attempted to regain control but was not able to before the acft departed the rwy and nosed over.