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 FTW82DA078Accident · No injuriesFinal reportBellanca 8GCBC · Mena, ARThe pilot was flying to maintain proficiency. He had not flown this make and model within the last 90 days, but he had flown another tailwheel equipped aircraft on 12/4/81.while landing, he touched down while correcting for a crosswind, but then believed that…NTSB ATL82DA061Accident · Minor injuriesFinal reportHomebuilt PDQ-2 · Laurel, MSWhile practicing high speed taxiing a gust of wind lifted the aircraft off the ground. The pilot elected to apply full throttle and proceed to takeoff. When he had climbed to 800 feet the engine began to misfire. Unable to control the plane the pilot collided…NTSB NYC82DA030Accident · No injuriesFinal reportPiper PA-38-112 · Easton, PAA takeoff was initiated on runway 17 with the wind from the southwest at 15 knots. During the takeoff roll, control of the aircraft was lost when a gust of wind was encountered. The plane struck a snowbank beside the runway and was substantially damaged.NTSB MIA82DA060Accident · Minor injuriesFinal reportCessna 170 · New Port Richey, FLThe pilot reported that during landing touchdown, the plane encountered a gust of wind and turned toward other aircraft on the ramp. He applied full power to go-around and cleared the other aircraft. However, during the initial climb, he lost control of the…NTSB LAX82IA086Incident · Minor injuriesIncident investigationFinal reportAeronca 11AC · Weldon, CAPilot stated that while at cruise, the engine began running rough and a precautionary landing was executed. During the touchdown, the aircraft struck a bump disconnecting the steering springs. He then lost directional control, striking a tree and fence on the…NTSB SEA82DA030Accident · No injuriesFinal reportPiper PA-28-181 · Jerome, IDThe student was practicing night landings under supervision of an instructor. There was a 40 degree left cross- wind prevailing at 16 knots. While landing, the aircraft bounced and drifted right. The instructor thought there was plenty of room, so he did not…NTSB MKC82DA040Accident · No injuriesFinal reportCessna 152 · Mcpherson, KSAfter returning from a local flight, the student pilot landed on runway 36 with a wind from 070 degrees at 13 knots. He reported that he lost control on the landing roll and departed the left side of the runway. The aircraft ran into muddy terrain and nosed…NTSB CHI82DA073Accident · No injuriesFinal reportCessna 150 · Manchester, MIDuring takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left.NTSB CHI82IA072Incident · No injuriesIncident investigationFinal reportSwearingen SA-227 · Chicago, ILThe pilot stated that at the departure airport, the runway was slippery and the turn onto the runway was difficult. The nosewheel steering was activated momentarily to straighten the nose, but was turned off prior to the takeoff roll. At the destined airport…NTSB CHI82DA075Accident · No injuriesFinal reportBeech 23 · Aitkin, MNAfter landing on a partially snow covered runway the pilot lost directional control and struck a snowbank. The aircraft traveled approximately 15 feet before nosing down into the snow covered terrain.NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…NTSB CHI82DA070Accident · No injuriesFinal reportCessna 152II · Oxford, OHAfter a normal landing the pilot retracted the flaps and opened the throttle. As the aircraft gained speed it started drifting off the runway. The pilot attempted to correct with rudder but the aircraft veered off the runway. Power was reduced before the nose…NTSB CHI82DA068Accident · No injuriesFinal reportPiper PA-60 · Cleveland, OHDuring takeoff roll from a dry runway the pilot reported the aircraft started veering to the left. The pilot attempted to straighten the aircraft with power & brakes to no avail then pushed in throttle in an attempt to fly out. The aircraft departed the…NTSB MKC82DA035Accident · No injuriesFinal reportCessna 152 · Tipton, IAThe student pilot said that he was on the takeoff roll when the aircraft veered left and collided with a snowbank beside the runway. He reported that the runway was clear and dry, and the wind was not a factor.NTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…NTSB CHI82DA062Accident · No injuriesFinal reportBeech 56TC · Huntington, INDuring a night touch and go landing, the aircraft veered left and struck a snowberm as the pilot was adding power to takeoff. Snowberms were located inside of the runway lights making the usable runway less than 75 ft and possibly restricting the lighting.…NTSB MKC82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Perryville, MOThe student pilot landed on runway 19 at his home airport after returing from a solo cross-country flight. The wind was from 220 degrees at 12 knots. After touchdown, the aircraft drifted to the right and impacted a snowbank beside the runway.NTSB LAX82FUA11Accident · No injuriesFinal reportQuickie · Torrance, CADuring landing, the pilot lost directional control. The aircraft veered off of the right side of the runway and struck a sprinkler system.NTSB CHI82DA069Accident · No injuriesFinal reportCessna 180 · New Richland, MNThe pilot was returning home after completion of an annual inspection of the aircraft. After returning, the aircraft was landed on a wet, icy sod runway. During the landing roll the aircraft came in contact with a snowbank and nosed over.NTSB CHI82DA050Accident · No injuriesFinal reportPiper PA-31-310 · East Saint Loui, ILThe aircrew did not key the approach lights on during the first ILS approach at night. Therefore, a missed approach was made. On the second approach, the lead-in lights were visible from over one mile. However, the visibility was much worse at touchdown,…NTSB MKC82DA032Accident · No injuriesFinal reportCessna 152 · Chesterfield, MOThe student pilot was making a touch and go landing. He failed to keep the aircraft on the runway during the takeoff. The plane departed the runway to the left and ran up onto a snowbank. The right side of the aircraft tipped down. The propeller and right…NTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…NTSB CHI82DA051Accident · No injuriesFinal reportCessna 152(II) · Fort Wayne, INThe student was on his sixth touch-and-go landing when the mishap occurred. After landing and before adding power to takeoff, he looked into the cockpit to retract the flaps and remove carburetor heat. During this time, the student lost directional control…NTSB MKC82DA034Accident · No injuriesFinal reportCessna 152 · Moberly, MOThe pilot had made five landings prior to the mishap. The final landing was made on runway 12 at night with the wind from 180 degrees at nine knots. There was snow on the edges of the runway. The pilot reported that he failed to keep the plane in the center…NTSB MKC82DA031Accident · No injuriesFinal reportCessna 150 · Chesterfield, MOThe student pilot was making a full-stop practice landing on runway 25. The wind was from 200 degrees at 11 knots. After touchdown, the aircraft veered left, hit a snowbank at the edge of the runway, and went over on its backs.NTSB MIA82DA057Accident · No injuriesFinal reportPiper PA-28-140 · Miami, FLTakeoff was made on a north/south roadway with the surface winds reported out of the east at 18 knots. The aircraft veered off the road and collided with a tree.NTSB FTW82DA058Accident · No injuriesFinal reportCessna 152 · Cleveland, TXOn the second landing of a supervised solo flight, the aircraft veered and the student pilot lost control. The aircraft collided with the wind sock pole and was substantially damaged.NTSB CHI82DA053Accident · No injuriesFinal reportPiper PA-28-161 · Dwight, ILAfter landing the aircraft encountered ice on the runway. The pilot applied brakes, swerved left, and collided with a snowbank.NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…NTSB MIA82DA048Accident · Minor injuriesFinal reportAeronca 7AC · Pensacola, FLThe aircraft landed with a right quartering tailwind in gusty conditions. It swerved off the runway into a bell helicopter that was stored just off the right side of the runway.NTSB CHI82DA054Accident · Minor injuriesFinal reportCessna 152 · Elyria, OHThe student was practicing takeoffs & landings. While taxiing after the first landing he detected a noticably bad shimmy. He continued his takeoffs & landings, and during the last landing he was unable to maintain directional control and collided with a…NTSB DEN82DA030Accident · No injuriesFinal reportCessna 421B · Spanish Fork, UTThe aircraft tookoff from an airport with slush on the runway, about 10 minutes later, the pilot landed at another airport. The runway at the destination airport was covered with dry snow. During touchdown, the aircraft veered left and hit a snowbank beside…NTSB CHI82DA044Accident · No injuriesFinal reportCessna 172 · Anoka, MNThe pilot was practicing touch and go landings. He reported that on his last landing, the wind pushed him toward the right side of the runway. The right main gear encountered snow and pulled the aircraft further to the right into a drift beside the runway.…NTSB CHI82DA042Accident · Minor injuriesFinal reportPiper PA-28-161 · Valparaiso, INThe right wing was observed rising and left wing striking the runway during the student pilot's third touch and go on an initial solo flight. When the main gear settled on to the runway the right wing again lifted into the air and the left wing struck a…NTSB ATL82DA050Accident · No injuriesFinal reportCessna 140 · Statesboro, GADuring the second landing of a supervised solo flight, a gust of wind picked up the right wing and the left wing struck the ground. The student pilot applied power while initiating corrective action. However, the plane ground looped and flipped over on its…NTSB ATL82DA048Accident · No injuriesFinal reportBeech C-23 · Nashville, TNThe accident occurred while the pilot was making a touch and go landing on his second supervised solo flight. After touchdown on his first landing, the pilot inadvertently pulled back on the control yoke while adding power and raising the flaps. The nose…NTSB SEA82DA027Accident · No injuriesFinal reportPiper PA-28-180 · Prosser, WAAfter returning from a local flight, the student pilot landed on runway 25. The wind was from 090 degrees at 5 knots. The landing was without difficulty until the nosewheel touched down, then the aircraft veered left. The pilot reported that he corrected with…NTSB NYC82DA033Accident · No injuriesFinal reportBellanca 7KCAB · Marthas Vineyard, MAAfter arriving at the destination, the pilot landed on runway 24. The wind was from 330 degrees gusting to 20 KTS. During the landing roll-out, the aircraft ground looped when a crosswind gust was encountered. The plane ran off the runway into a rough grassy…NTSB MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.NTSB MKC82DA028Accident · No injuriesFinal reportPiper PA-38 · Washington, IAThe student pilot began taking off on runway 17 with a right quartering headwind. There was snow and ice on the runway. During the takeoff roll, the aircraft started toward the left and the pilot added right rudder for directional control. The aircraft…NTSB CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…NTSB MKC82DA027Accident · No injuriesFinal reportPiper PA-28-140 · Springfield, MODuring landing on runway 31, the student pilot perceived that he was high. He moved his touchdown point down the runway to the intersection with runway 19. There was an icy spot at the touchdown point on the intersection. After touchdown, the aircraft veered…NTSB CHI82DA039Accident · No injuriesFinal reportPiper PA-28-181 · East Lansing, MIThe pilot initiated his takeoff on a snow covered, sod runway that had been plowed with a 50 ft wide strip. The plowed area had a snow base and there were four foot snow banks at the edges. Although the runway had been plowed on the previous night and it had…NTSB CHI82DA036Accident · No injuriesFinal reportCessna 182H · Peoria, ILThe owner of the aircraft was a student pilot. Another person, who was a private pilot, stated that he was invited to ride along. The private pilot reported that he was unaware that the aircraft owner was not a certificated pilot. After returning from a local…NTSB CHI82DA035Accident · Minor injuriesFinal reportCessna 150 · Buffalo, MNThe instructor and student departed with the intention of making a touch and go landing after takeoff. During the landing, the aircraft veered to the right and struck a 3 to 4 ft snowbank. The student stated that on short final, the aircraft dropped and…NTSB SEA82DA026Accident · No injuriesFinal reportBellanca 7KCAB · Burns, ORDuring landing in calm wind conditions, the aircraft bounced slightly. On the second touchdown, it veered left and struck a snowbank. The student pilot reported that it seemed like the left brake froze. The left brake was examined for possible dragging and…NTSB SEA82DA024Accident · No injuriesFinal reportCessna U206G · Moses Lake, WAThe pilot stated that he encountered a freak gust of wind during the landing. The plane touched down on the right side of the runway in an area of soft terrain. The aircraft veered farther to the right and continued into an earthen drainage ditch. The ditch…NTSB LAX82DVM10Accident · No injuriesFinal reportTaylorcraft F19 · Mt. Hamilton, CAAfter landing, the pilot's right heel slipped off of the right heel brake while he was applying brakes. Subsequently, the aircraft veered to the left before he released the left brake. The right main gear collapsed as the aircraft stopped in a small ditch…NTSB LAX82DA059Accident · No injuriesFinal reportCessna TR182 · Las Vegas, NVThe pilot stated that on landing after the second bounce the plane veered left and ran off the runway on to the desert and flipped over.NTSB DEN82DTM10Accident · No injuriesFinal reportSmith Miniplane BK-1 · West Jordan, UTThe pilot had just purchased the aircraft and was making touch and go landings for familiarization. He was using a paved runway with patches of ice and was landing with about a 10 knot right crosswind. On about his eighth landing, the plane began to drift to…