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 FTW82DA181Accident · Minor injuriesFinal reportCessna 172N · Houston, TXOn landing roll the aircraft began to swerve to the right. The pilot attempted to correct by applying power, left rudderand brake and the aircraft began to swerve to the left. The aircraft departed the runway, across a taxiway and into a row of parked…NTSB ATL82DA147Accident · No injuriesFinal reportPiper J3C-65 · Charlotte, NCThe pilot stated that during takeoff roll he turned and reached for a bag that had started to fall out the door. The right wing of the aircraft struck the ground causing the aircraft to turn sideways and collapse the gear.NTSB ATL82DA131Accident · No injuriesFinal reportCessna 205 · Hopkinsville, KYDuring landing roll the pilot applied right brake and rudder. The application seemed ineffective so he applied more rudder and the aircraft veered off the runway to the right, colliding with a ditch. The aircraft then nosed over. The wind was calm.NTSB LAX82DA184Accident · No injuriesFinal reportCitabria 7GCBC · Willits, CAThe student pilot stated that on approach the winds were from the west. After touchdown and on the rollout the wind caught the right wing and turned the aircraft.NTSB DEN82DA085Accident · Minor injuriesFinal reportCessna 180 · Cut Bank, MTThe pilot reported that during landing, the aircraft veered off the right side of the runway even though he used left rudder. After departing the runway, the aircraft encountered a shallow ditch and went over on its back. The pilot reported that the winds…NTSB ANC82DA040Accident · No injuriesFinal reportPiper PA-20S · Gulkana, AKThe owner, a private pilot, was getting dual instructional training in his tailwheel equipped aircraft. The aircraft was a Piper PA-20 that had been converted from a model PA-22. The owner had accumulated about 10 hours of flight time in this make and model.…NTSB FTW82DA177Accident · No injuriesFinal reportGrumman G-164A · Elreno, OKDuring takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over.NTSB CHI82DA161Accident · No injuriesFinal reportCessna 152 · Romeo, MIThe student pilot was practicing touch and go landings. On the third takeoff the aircraft veered to the left and the student was unable to correct. The aircraft continued into a soft field and nosed over. The wind was calm and the weather clear.NTSB LAX82DA169Accident · No injuriesFinal reportCessna 152 · San Fernando, CAThe student pilot lost directional control during landing and veered into a parked van. This was his second supervised solo flight.NTSB NYC82DA093Accident · No injuriesFinal reportPiper PA-38-112 · Endicott, NYDuring takeoff roll the aircraft veered to the left. The pilot stated that he applied right rudder and aileron into the wind, however; the aicraft continued to the left. The pilot then closed the throttle and the aircraft collided with runway lights causing…NTSB MKC82DA077Accident · No injuriesFinal reportMaule M-4 · Cozad, NEThe aircraft was landed on runway 31 with a 20 degree quartering headwind from the right at 10 gusting 15 knots. During landing, the aircraft veered to the left and the pilot applied right rudder. However, the aircraft continued into a ground loop and was…NTSB SEA82DA068Accident · No injuriesFinal reportde Havilland 2 · 15n Of Medford, ORThe pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control…NTSB LAX82DA165Accident · No injuriesFinal reportPiper PA-18-150 · San Carlos, CAThe aircraft ground looped during landing. The wind was 240 degrees at 20 knots. This would be a 60 degree cross-wind for runway 30. It is not known which direction the pilot used.NTSB LAX82FVG23Accident · 1 fatalFinal reportBoeing A75N1 · Pleasant Grove, CAThe pilot reported that he landed toward the north with the wind from the northeast at 8 to 10 knots. When the tailwheel touched down, the aircraft veered right. The pilot reported that he could not stop the turn. He opened the throttle while attempting to…NTSB CHI82DA155Accident · No injuriesFinal reportCessna 180 · Aurora, ILOn takeoff the aircraft veered off the side of the runway and struck a drainage ditch. The pilot reported a gust of wind caught the aircraft.NTSB MIA82DA117Accident · No injuriesFinal reportPiper PA-38-112 · Gainesville, FLThe student pilot stated that on his third landing, the crosswind was more noticeable. During the landing roll, he lost directional control while he was applying brakes. The aircraft went off the runway, collided with a ditch, and was substantially damaged.NTSB LAX82DVG24Accident · Minor injuriesFinal reportBoeing A75 · Maxwell, CADuring the takeoff roll from a local farm strip, the aircraft veered to the right and went off the runway. The pilot reported that the plane went into a small ditch and flipped over. No mechanical failures were reported.NTSB FTW82DA168Accident · No injuriesFinal reportPiper PA-34-200T · Harrison, ARDuring landing the aircraft porpoised and on the second bounce the nose gear assembly buckled, the windshield support buckled and the right windshield popped partially out of its channel. The pilot regained control and taxied in. The props and engine nacelles…NTSB LAX82DA160Accident · No injuriesFinal reportPiper PA-38 · Willcox, AZStudent pilot on first solo cross-country ground looped during an en route landing. The pilot's flight bag had fallen off the right seat and lodged itself between the rudder pedals. Rudder control was lost.NTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…NTSB FTW82DA165Accident · No injuriesFinal reportPiper PA-18-150 · Marfa, TXDuring the takeoff roll for a dual instructional flight the aircraft began to veer to the left. The instructor was able to overpower the student on the rudder pedals but not the aft stick pressure. The aircraft lifted off then settled back to the runway in a…NTSB FTW82DA162Accident · Minor injuriesFinal reportPiper PA-25-235 · Lubbock, TXPrior to the flight, the aircraft had been serviced in preparation for the beginning of the spraying season. As part of the servicing, the operator/pilot added hydraulic fluid to the left brake. However, he did not purge the system of air after adding the…NTSB CHI82FA146Accident · No injuriesField investigationFinal reportBeech 56TC · Chicago, ILThe pilot stated that during landing, the touchdown was smooth. Shortly after touchdown, the left wheel began to wobble and thump and the aircraft started to veer to the left. Reportedly, the right brake would not hold the aircraft on the runway. The aircraft…NTSB LAX82DA157Accident · No injuriesFinal reportPiper PA-18-150 · Chandler, AZDuring landing roll the pilot stated that a gust of wind or a dust devil picked up the left wing and turned the aircraft to the right. The aircraft departed the runway and went into a small plowed field coming to rest in the opposite direction of the runway.NTSB DEN82DA077Accident · No injuriesFinal reportMooney M20E · Hanksville, UTThe pilot stated that during the landing touchdown on runway 19, a gust of wind from about 270 degrees was encountered and the plane veered to the left. The pilot reported that he had applied corrective action, and the plane was tracking back to the runway,…NTSB LAX82DA153Accident · No injuriesFinal reportCessna 182E · Markleeville, CADuring the takeoff roll of a touch and go landing the pilot stated that the aircraft abruptly swerved to the left and went off the runway. Substantial damage occurred when the aircraft collided with two trees.NTSB ANC82DAG19Accident · No injuriesFinal reportPiper PA-18-150 · Birchwood, AKAfter making one takeoff and landing, the pilot elected to do a short field takeoff. He held the brakes and applied full throttle. His right foot slipped off the right brake and the aircraft turned sharply to the left. During the turn, the aircraft went up on…NTSB LAX82DA150Accident · No injuriesFinal reportBellanca 7GCBC · Deeth, NVThe pilot chose to land on an abandoned highway on a heading of 240 degrees. Reportedly, the winds were from the northeast at 8 gusting 18 knots. While making a wheel landing, a gust of wind was encountered about when enough speed had been lost to lower the…NTSB LAX82DVG21Accident · No injuriesFinal reportPiper PA-28-140 · Live Oak, CAThe student pilot was indorsed to fly solo in the Piper PA-38 aircraft, but reported no previous flight time in a Piper PA-28. Reportedly, he took off to practice touch and go landings. The student stated that the right wheel locked after the fourth landing…NTSB CHI82DA136Accident · No injuriesFinal reportBellanca 7ECA · Maple Lake, MNThe pilot lost directional control during landing in strong crosswind conditions with gusts to 22 knots. The aircraft departed the runway and collided with a parked aircraft. The pilot stated that he was not currently proficient in crosswind landing, should…NTSB NYC82DA078Accident · No injuriesFinal reportNorth American SNJ-2 · Flushing, NYThe flight proceeded without incident until the tail wheel was unlocked during the landing roll. The aircraft drifted to the left and struck a parked cherokee. Both aircraft were substantially damaged. Inspection revealed that residue of a recent paint…NTSB DEN82DA066Accident · No injuriesFinal reportCessna 182P · Enderlin, NDDuring a landing on runway 13, the aircraft veered off the runway after touchdown, then went into a freshly plowed field and nosed over. The pilot estimated that the wind was from 200 degrees at 20 gusting 25 knots. There was a 2640 ft turf runway (04/22) on…NTSB FTW82DA147Accident · No injuriesFinal reportTailwind A-M-1 · Carlsbad, NMThe pilot attempted a precautionary landing on a road due to deteriorating weather and an intermittent engine problem. The pilot stated he lost directional control due to gusty winds and the aircraft nosed over.NTSB ATL82DA112Accident · No injuriesFinal reportCessna 172 · Buckhannon, WVThe pilot reported making a normal approach to runway 26 in turbulent and windy conditions. He estimated that the wind was from 360 degrees at 15 to 20 knots. After the main wheels touched down, he encountered a gust of wind that he estimated was above 30…NTSB NYC82DA075Accident · No injuriesFinal reportPitts Special S-1C · Latrobe, PAThe pilot initiated a takeoff in winds that were gusting to 19 knots. As he raised the tail during the takeoff roll, the plane swerved right. The pilot stated that he overcorrected to the left. Subsequently, the plane departed the left side of the runway. The…NTSB LAX82DA142Accident · No injuriesFinal reportMaule M-4 · Wickenburg, AZDuring landing roll the left wing came up and the aircraft turned sharply to the right. The aircraft left the runway and came to rest in a gully.NTSB LAX82DA141Accident · No injuriesFinal reportCessna 172 · Bakersfield, CAThe pilot was landing on an airstrip with a vineyard about 20 ft left of the runway. There was a left quartering headwind at 10 knots. The first landing was aborted after touchdown when the plane started to veer left as the brakes were applied. The next…NTSB FTW82FPG09Accident · Serious injuriesFinal reportStampe Renard SV4B · Clarksville, ARThe pilot was participating in a spot landing activity at a fly-in. He stated that he made a poor landing and allowed the aircraft to drift left and off of the runway. In order to miss the runway lights, he added power and initiated a go-around. After…NTSB ATL82DA116Accident · No injuriesFinal reportCessna 172N · Pikeville, KYDuring a landing on the second solo flight, the student pilot swerved to aviod standing water and a rough spot on the runway. The student reported that the swerve "worsened", and subsequently, the left main gear struck a mowing tractor beside the runway.NTSB NYC82DA072Accident · Minor injuriesFinal reportCessna 172N · Trenton, NJDuring a departure, the pilot initiated an intersection takeoff with about 4000 ft of runway remaining. He reported that the takeoff proceeded normally through lift-off to about 25 ft AGL. From there, the aircraft returned to the runway surface and bounced.…NTSB DEN82DA059Accident · Minor injuriesFinal reportCessna 170A · Williston, NDThe pilot noted unfavorable winds when he arrived for landing. He elected to fly in the local area until the winds subsided. After flying locally for about one hour, he elected to land on runway 29 with a crosswind from 020 degrees. While on downwind, he…NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.NTSB NYC82DA070Accident · No injuriesFinal reportStinson 108-1 · Factoryville, PAThe pilot was practicing landings in gusty wind conditions. He reported that the first landing was uneventful, but the second landing was aborted due to gusty turbulence. He stated that the third landing was made in relatively calm wind conditions until just…NTSB CHI82DA121Accident · No injuriesFinal reportRand K.R.1 · Plymouth, MIOn takeoff roll the left upwind wing lifted and the pilot lost directional control. The aircraft swerved to the right and struck a parked bonanza, N5587D, causing substantial damage to both aircraft. Investigation revealed that the pilot attempted to takeoff…NTSB LAX82FUQ14Accident · No injuriesFinal reportCessna 180 · Goleta, CAThis was the second dual instructional flight that the new owner and instructor pilot had flown in this aircraft. The owner, a private pilot needed 10 hrs of flight time to meet insurance requirements. After about 30 minutes of airwork, they returned to the…NTSB SEA82DA051Accident · Minor injuriesFinal reportCessna 172N · Pocatello, IDThe pilot stated that the aircraft encountered a gust of wind shortly after commencing takeoff roll which moved it directly across the runway. Initially the pilot maintained full power while attempting to regain control of the aircraft however shortly…NTSB FTW82DA122Accident · No injuriesFinal reportCessna 172 · Gallup, NMOn the second landing of the flight the aircraft veered to the left and departed the runway. The aircraft nosed over after hitting soft dirt and a drainage ditch. The pilot stated that the aircraft swerved on the first landing and he felt that the passenger…NTSB ANC82DAG20Accident · No injuriesFinal reportTaylorcraft F-19 · Kenai, AKThe pilot-in-command had just purchased the aircraft and was in the porcess of improving her skills. The other occupant was an instructor pilot. While landing on runway 01 with a wind from 310 degrees at 14 knots, the aircraft bounced and veered to the right.…NTSB LAX82DA131Accident · No injuriesFinal reportCessna 172 · Holbrook, AZThe student pilot was on his first solo flight. During the first touchdown, the aircraft bounced to the right. The student reported that after bouncing, the airspeed deteriorated as the aircraft floated and settled to the right. The aircraft struck sagebrush…NTSB ATL82DA099Accident · No injuriesFinal reportPiper PA-28-140 · Huntsville, ALShortly after a normal touchdown the aircraft yawed and veered to the left. The pilot elected to go-around and added full power. The aircraft departed the left side of the runway and collided with a barbed wire fence. The aircraft settled into a plowed field…