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 LAX82DA129Accident · No injuriesFinal reportPiper PA-28R-201 · Napa, CAAfter making 8 touch & go landings, the pilot lost directional control during a full-stop landing. The aircraft slid off the runwway into grass & then onto a taxiway.NTSB CHI82DA116Accident · No injuriesFinal reportCessna 152 · Pontiac, MIWhile the student pilot was on his fifth touch and go pattern, the plane veered to the left after touchdown. The left main gear then encountered snow and pulled the aircraft further left into a snowbank. The student claimed that the owners had advised him to…NTSB CHI82DA115Accident · No injuriesFinal reportSwearingen SA226TC · Fort Wayne, INPrior to landing the crew was advised by Fort Wayne ATC that the 150 foot wide runway had been plowed 140 feet wide with 18 inch windrows on each side of the runway. The runway was reported to be 40 percent covered with finger drifts. The wind was from 010…NTSB LAX82DA128Accident · No injuriesFinal reportCessna 150 · Mendota, CAThe pilot stated he was looking out the left window for the taxiway when the aircraft ran off the runway into a soft field.NTSB FTW82DA113Accident · No injuriesFinal reportCessna 172N · Tomball, TXThe student pilot lost control of the aircraft during a practice touch and go landing. The aircraft swerved off the left side of runway into a plowed area and nosed down.NTSB ANC82DA030Accident · No injuriesFinal reportBeech C23 · Kenai, AKDuring the landing roll the aircraft swerved left, right, then left again before leaving the left edge of the runway about 1700 feet beyond the landing threshold. It passed over a snow berm before coming to rest perpendicular to the runway.NTSB NYC82DA067Accident · No injuriesFinal reportPiper PA-28R-200 · Butler, PAApproximately 100 feet after touchdown a gust of wind lifted the left wing of the aircraft turning it into the wind. Directional control was lost and the aircraft collided with two parked aircraft. A PA-22, N54572, and an Ercoupe, N93552, both of which…NTSB DEN82DTI12Accident · No injuriesFinal reportCessna A188B · Carter, MTThe owner reported that the pilot landed on a road in a crosswind condition. The purpose for landing was to reload for fertilizer application. After touchdown, the aircraft ran off the road and flipped over.NTSB CHI82DA109Accident · No injuriesFinal reportCessna 180 · Nokomis, ILDuring takeoff from a soft sod field the aircraft started gradually turning to the left. The pilot applied full right rudder then reduced power before the aircraft nosed over on its back.NTSB CHI82IA108Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Chicago, ILThe aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose…NTSB CHI82DA104Accident · No injuriesFinal reportCessna 180 · Duluth, MNThe student pilot was making touch and go landings on RUNWAY09 while preparing for a flight check. After landing, he proceeded to open the cowl flaps and push in the carburetor heat control. He stated that at that time, he let the ailerons go to a neutral…NTSB FTW82DA102Accident · No injuriesFinal reportCessna 152 · New Orleans, LAThe student pilot was doing touch and go landings on runway 36. The wind was 290 degrees at 10 KTS. During a landing roll the student lost control and departed the left side of the runway. The aircraft sank into the mud and nosed over.NTSB ATL82DA084Accident · Minor injuriesFinal reportBeech 58 · Ridgeland, SCThe pilot stated that during landing, the left brake was inoperative. When he realized the problem, there was insufficient runway remaining to stop or go-around. At the end of the runway was a deep drop-off. Therefore the pilot used the right brake, and…NTSB LAX82FA119Accident · No injuriesField investigationFinal reportBoeing 707-123B · Marana, AZDuring flight, a decrease was noted in the quantity of utility hydraulic fluid. The engine driven pumps were shut off until just before landing. After extending the gear & flaps, the quantity indicated 3.5 gal & all pressures were normal. After touchdown, the…NTSB ATL82DA085Accident · No injuriesFinal reportCessna 152 · Russellville, KYThe student pilot was on her second supervised solo engaged in touch and go landings. During her second landing the aircraft started to drift left leaving the runway environment and colliding with a ditch before nosing over. The student stated that she had a…NTSB CHI82DA099Accident · No injuriesFinal reportPiper PA-38 · Fort Wayne, INThe student pilot was practicing landings with a headwind directly down the runway at 7 knots. During touchdown on his third landing, he lost directional control and the plane veered left and skidded off the runway. The nose gear encountered a side load and…NTSB LAX82DA116Accident · No injuriesFinal reportHoward DGA-15P · Livermore, CADuring landing roll the aircraft swerved to the right. The pilot countered with left aileron, rudder, and brake but the right wing came up, the turn tightened, and the left main gear collapsed.NTSB LAX82DVG19Accident · No injuriesFinal reportPiper PA-32R · Brownsville, CAThe pilot stated that the aircraft did not touchdown until halfway down the runway and he then applied too much left brake resulting in the aircraft running off the left side of the runway. Before coming to a stop the left landing gear collapsed.NTSB CHI82DA094Accident · No injuriesFinal reportCessna 172 · Clarksville, INThe pilot reported that the wind was blowing at 12 knots when he took off on a local flight. However, when he returned to land, it was from 270 degrees at about 30 knots. While landing on runway 18, the aircraft veered off the left side of the runway into…NTSB SEA82DA040Accident · No injuriesFinal reportLuscombe 8E · Blaine, WAUpon arrival the pilot observed the wind to be 90 degrees to the runway with an estimated velocity of 5 to 7 knots. A low pass was completed followed by a landing on runway 32. During the rollout the aircraft drifted right, the landing gear encountered…NTSB MKC82DA048Accident · No injuriesFinal reportCessna 150 · Sabetha, KSThe pilot initiated a landing approach to runway 1 with the wind from 280 degrees at 18, gusting 25 knots. He entered final approach in a crab and was lined up with the runway. When over the threshold, the plane started to drift right. It settled to the…NTSB CHI82DA093Accident · No injuriesFinal reportCessna 210 · Grantsburg, WIDuring landing roll the aircraft struck a windrow and swerved off the runway. The pilot stated that the winds were out of 350 degrees at 15 knots gusting to 30.NTSB FTW82DA098Accident · No injuriesFinal reportCessna 421C · Weatherford, OKBefore landing, the pilot observed that the wind sock was indicating a wind from 270 degrees. He stated that he tried to call UNICOM several times for wind information, but received no answer. After touchdown on runway 17, a strong gust of wind was…NTSB DEN82DA045Accident · Minor injuriesFinal reportCessna 180J · Casper, WYAfter arriving, the pilot landed on runway 07 in variable wind conditions with gusts to 20 knots. After touchdown, he encountered a crosswind gust, became airborne, and ballooned about 3 ft. he added a slight amount of power to control the aircraft and make a…NTSB CHI82DA092Accident · Minor injuriesFinal reportPiper PA-24-250 · Columbus, OHWhile performing a touch and go landing on runway 27R, the aircraft veered off the runway to the right and struck a drainage ditch. The pilot reported that the wind was from 350 degrees at 15 knots. Runway 32, an asphalt runway with a length of 3040 ft and a…NTSB ATL82DA075Accident · No injuriesFinal reportCessna 182 · Midland, NCThe pilot reported landing on a soft, slick runway at dusk after returning from a parachute jumping mission. The aircraft was landed off of the center of the runway and veered left in soft terrain. The nosewheel sank in mud as the plane crossed a shallow…NTSB MIA82DA076Accident · No injuriesFinal reportCessna 152 · Brooksville, FLThe student pilot was on a solo cross-country flight. While landing at an en route airport, he encountered a gusty, right quartering, headwind. During touchdown, the plane bounced and the pilot applied power. However, he was unable to prevent the plane from…NTSB LAX82FUQ11Accident · No injuriesFinal reportCessna 172 · Lancaster, CAAt 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The…NTSB NYC82DA038Accident · No injuriesFinal reportCessna 182B · Pepperell, MAWhen the pilot arrived at his destination, he landed on an icy runway. Near the end of his landing roll, the aircraft encountered a rut and veered into a snowbank beside the runway. The wind was light and variable.NTSB LAX82DA107Accident · Minor injuriesFinal reportCessna 120 · San Andreas, CADuring a three point landing the aircraft started to ground loop. The pilot used rudder and power to recover but the aircraft ran off the side of the runway and struck a tree.NTSB CHI82DA088Accident · No injuriesFinal reportCessna 182 · Sebring, OHDuring landing, the pilot lost directional control and the plane ran off the side of the runway and overturned. He reported that the winds were from 270 degrees at 25 gusting 40 knots.NTSB CHI82DA087Accident · No injuriesFinal reportCessna 182 · Lake Village, INThe pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost…NTSB CHI82DA086Accident · No injuriesFinal reportBeech 200 · Bryan, OHAfter touching down the aircraft encountered a puddle of water 5-7 inches deep on the runway. The aircraft was pulled into a snowbank on the left side of the runway after which the nose gear collapsed.NTSB SEA82DYM12Accident · No injuriesFinal reportPiper PA-28-181 · Albany, ORWhile proceeding from a restaurant parking area to the runway, the aircraft had to be taxied across a bridge. The bridge was 30 ft wide and 50 ft long. It had no side rails and was used to cross a drainage ditch. A slight right turn was required just before…NTSB CHI82DA095Accident · No injuriesFinal reportCessna 172G · Cambridge, MNAfter landing on runway 16, the aircraft ran off the right side of the runway. It hit a snowbank, and both wing spars were bent.NTSB MKC82DA043Accident · No injuriesFinal reportCessna 150M · Lee'S Summit, MOOn landing the aircraft veered off the left side of the runway and down a bank. The nose gear entered a ditch causing it to fail.NTSB FTW82DA084Accident · No injuriesFinal reportCessna U-206 · Angel Fire, NMThe aircraft was hit by a crosswind gust during the takeoff run. The aircraft went off the right side of the runway and collided with a snowbank.NTSB LAX82DA102Accident · No injuriesFinal reportCessna 172 · San Carlos, CAReportedly, the accident occurred after the aircraft veered right during a landing and the pilot opted to go-around. The pilot did not provide additional information concerning this accident.NTSB SEA82DA034Accident · No injuriesFinal reportRockwell Intl 114 · Everett, WAShortly after touchdown on runway 29, the aircraft veered to the right, became airborne, and then veered sharply to the left. The passenger stated that after the initial touchdown and right drift, the pilot added power, pulled the nose up to a high attitude,…NTSB LAX82DA096Accident · No injuriesFinal reportHoward DGA-15P · Mesa, AZWhile approaching the destination airport, the owner/pilot asked the instructor pilot to land the aircraft. The instructor reported that he maintained a slightly higher than normal airspeed on final approach to compensate for variable wind conditions. He…NTSB FTW82DA085Accident · No injuriesFinal reportCessna 172M · Houston, TXDuring the demonstration of a short field takeoff the aircraft's tail lowered after encountering a moderate dip at a runway intersection. The tail tie-down ring snagged a runway light cable which had been uncovered by recent rains. The cable broke at one side…NTSB MIA82FA064Accident · No injuriesField investigationFinal reportPiper PA-23 · Summerland, FLThe aircraft touched down near the threshold of runway 12, veered left, and departed the defined runway area 400 feet from the threshold. The wind reported at the key west, FL fss was 160 degrees at 9 knots. After leaving the runway environment the aircraft…NTSB LAX82DA094Accident · Serious injuriesFinal reportBarnes AX-7 · Henderson, NVWhile inflating the balloon, the pilot had some trouble keeping the pilot light lit. After the balloon was inflated, it was flown on a 20 minute flight without incident. However, while landing on the second flight, the balloon bounce during touchdown. At…NTSB NYC82DA043Accident · No injuriesFinal reportBeech C-24R · Manchester, NHThe tower controller advised the flight while on base leg that the winds were from 300 degrees at 15 knots. This information was given at 1045 EST and was the last wind information given to the pilot before landing. According to the pilot moderate turbulence…NTSB LAX82DA093Accident · No injuriesFinal reportCessna P337H · Mesa, AZAfter returning from a local flight, the pilot landed with a gusty crosswind from the right. He reported that he was on the landing roll at about 55 knots (20 knots below landing speed) when a severe gust lifted his right wing. The plane abruptly turned about…NTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.NTSB CHI82DA077Accident · No injuriesFinal reportSmith Aerostar 600 · Elyria, OHDuring takeoff on an icy runway, the pilot lost directional control after rolling a few hundred feet. He reported that the plane was sliding left and was below VMC, so he retarded the throttles. The plane struck a snowbank beside the runway and was…NTSB FTW82DA087Accident · No injuriesFinal reportPiper PA-32-300 · Crownpoint, NMThe pilot was landing to the south with a 25 knot wind from the southwest. While on a short final approach, the aircraft drifted to the left of the runway centerline. On touchdown, the left wheel entered soft dirt causing the plane to drift further left. The…NTSB ANC82DA022Accident · No injuriesFinal reportCessna 170 · Poorman, AKAfter making a low pass over the runway and noting that it was plowed with berms on both sides and that there were bare patches on the runway the pilot elected to land. Shortly after touchdown the left ski encountered a bare spot on the frozen snow and ice…NTSB FTW82DA115Accident · No injuriesFinal reportPiper PA-25-235C · Big Spring, TXThe pilot reported that he had been practicing crosswind landings in winds that were gusting to 25 knots. On the last landing, he used flaps. He reported that he had landed and was taxiing on the runway when a gust of wind raised the right wing. The left wing…