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 FTW82DA253Accident · Minor injuriesFinal reportBeech E18S · Lubbock, TXThe pilot reported that after a normal approach and touchdown, he retracted the flaps and lowered the tail. As he applied brakes, the right brake functioned, but the left brake had no braking action and the aircraft swerved to the right. He advanced the right…NTSB CHI82DA227Accident · No injuriesFinal reportCessna 310K · Bluffton, OHThe pilot stated the right gear started to skid during landing. The aircraft slid off the runway into a ditch and the right main landing gear collapsed. No preimpact malfunction or failure of the gear assembly was determined.NTSB CHI82DA225Accident · No injuriesFinal reportBoeing E75 · Bloomington, ILThe pilot stated that almost immediately after touchdown the aircraft began tracking to the left. During the attempt to arrest the swerve, the aircraft ground looped 180 degrees to the right. The tail struck two taxi lights as it rotated and the aircraft came…NTSB SEA82DA099Accident · No injuriesFinal reportCessna A188B · Othello, WAAt the completion of a spray operation, the pilot returned to the airport to land. During the landing roll realizing that no braking was available on the left wheel, the aircraft was intentionally ground looped in an effort to reduce the damage. According to…NTSB DEN82DA116Accident · No injuriesFinal reportGrumman G-164 · Lamar, COPilot landed in 90 degree crosswind of 31-40 KTS and groundlooped into soft terrain where he nosed over.NTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.NTSB FTW82FRA23Accident · No injuriesFinal reportGreat Lakes 2T-1A-2 · Tomball, TXThe pilot reported that he made a 3-point landing, and after rolling about 3 or 4 seconds, the aircraft suddenly pulled to the right. He tried to correct with left rudder and brake, but the plane continued swerving to the right. Subsequently, the left main…NTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.NTSB DEN82DA111Accident · No injuriesFinal reportWeatherly 201C · Near Rapelje, MTWhile landing on a county road, the pilot lost directional control and the aircraft veered to the left and struck a pole. An investigation revealed that an 0-ring, pn 101-00500, on the parking brake valve in the right master cylinder had failed and hydraulic…NTSB DEN82DA104Accident · No injuriesFinal reportLuscombe 8A · Wendover, UTThe pilot reported that during the landing roll, he applied moderate braking to avoid a long taxi distance back to the parking area. He was wearing unfamiliar boots with higher than normal heels, and while using the small heel brake peddles, the aircraft…NTSB LAX82DA229Accident · No injuriesFinal reportCessna 170B · Pacoima, CAThe pilot reported that he landed on runway 12 with a slight crosswind from the right. After touchdown, the aircraft veered to the right, the left wingtip and the propeller struck the surface, and the plane nosed over.NTSB FTW82DA282Accident · No injuriesFinal reportBoeing A75L300 · Tulsa, OKThe pilot reported that during a wheel landing, the aircraft began to veer to the right and all efforts to straighten it with rudder failed. As the plane went off the runway. The left wing dropped, striking the runway, and the lower left wing spar broke. The…NTSB CHI82DA216Accident · Minor injuriesFinal reportPiper PA-28-140 · Dodgeville, WIThe student pilot was on a cross-country flight and had made four landings that day. After visually sighting Dodgeville, the pilot cancelled her VFR flight plan with the flight service station. She reported that nobody answered her numerous calls on UNICOM…NTSB ATL82DA167Accident · Minor injuriesFinal reportPiper PA-28-161 · Atlanta, GAThe student pilot was practicing touch-and-go landings in winds that were variable 330 to 340 degrees at 10 knots. During the second touch-and-go, the aircraft touched down normally. However, as it was accelerating for takeoff, the plane suddenly swerved to…NTSB ANC82DAG36Accident · No injuriesFinal reportTaylorcraft BC-12D · Settlers Bay, AKWhile on a cross-country flight from wasilla to king lake the pilot decided to do some touch and go landings at Settlers Bay. The pilot stated that on his third landing the left brake locked and the aircraft swerved off the runway into a ditch nosing over.NTSB NYC82DA126Accident · No injuriesFinal reportBeech A23-19 · Plainville, CTThe pilot lost directional control on the second landing roll and swerved off runway onto a railroad track.NTSB MKC82DA107Accident · No injuriesFinal reportCessna A188 · Appleton City, MOThe pilot elected to land on a crowned, asphalt, farm road while repositioning the aircraft for an agricultural operation. He reported that shortly after touchdown, the aircraft pulled to the left and the left wing entered high weeds. He said he was unable to…NTSB DEN82DA109Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDThe student pilot was practicing takeoffs and landings on his third supervised solo flight with a left quartering wind at 10 KTS. Upon landing, the student began his takeoff roll. Subsequently, the aircraft veered off the runway, traveled about 600 ft, and…NTSB ATL82DA172Accident · No injuriesFinal reportCessna 402C · North Myrtle Be, SCThe pilot made a VOR approach to runway 05, but was unable to see well enough at the mda to land. He was informed that other aircraft had previously landed on runway 23 and had reported better visibility. The pilot then requested and was vectored for an ILS…NTSB FTW82DA231Accident · No injuriesFinal reportSouthern Airmotive Corp Sac SAC · Graham, TXThe pilot reported that he began a takeoff on runway 17 to ferry the aircraft from Graham to houston, TX. He reported that the wind was from 340 deg at 15 KTS. Reportedly, he had no previous flight time in this make and model of aircraft. The pilot stated…NTSB DEN82DA112Accident · No injuriesFinal reportCessna 172 · Colorado Spring, COThe pilot saw thunderstorms near pueblo and Colorado springs, CO, and checked the ATIS at both places. He encountered turbulence on the approach to the airport, but otherwise, the approach and touchdown were normal. According to the pilot, a strong gust of…NTSB ATL82DA176Accident · No injuriesFinal reportBensen B-8M · Parsons, TNThe pilot reported that just prior to touchdown, a gust of wind yawed the gyrocopter which he attempted to control with rudder and increased propeller RPM. He stated that the power increase resulted in a sharp yaw to the left and a loss of control. The…NTSB FTW82DPA13Accident · No injuriesFinal reportCessna 152 · Mckinney, TXThe student pilot practicing touch and go landings lost control of the aircraft and swerved off the runway. The aircraft then contacted a fence and nosed over.NTSB DEN82IA103Incident · No injuriesIncident investigationFinal reportGrumman G-159C · Gillette, WYThe acft was on a scheduled, domestic, pax flt. The coplt was the company's chief plt and was flyng the acft from the left seat. He was under supervision of the pilot-in-command (PIC) who was in the rt seat. Drg arrival, the crew elected to make a…NTSB ANC82DAA04Accident · No injuriesFinal reportCessna 170 · Chicken, AKThe student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before…NTSB LAX82DA211Accident · No injuriesFinal reportPiper PA-18 · Colusa, CAThe pilot reported that during a 3-point landing in calm wind conditions, the aircraft veered to the right as soon as the main gear touched down. The pilot stated that he applied full left rudder and brake, but to no avail. The plane continued to the right…NTSB NYC82DA118Accident · No injuriesFinal reportBeech V35B · Toms River, NJDuring landing, the aircraft swerved off the left side of the runway and encountered soft terrain. The nose and left main landing gear were substantially damaged and there was minor damage to the right wing, flap, and aileron. The pilot reported that during…NTSB DEN82DA102Accident · No injuriesFinal reportBellanca 8GCBC · Philip, SDThe pilot flew to an open field where he landed to work on a truck. While he was working on the truck, the wind increased to the point that he was afraid to leave the aircraft on the ground. When he got in the plane, the wind prevented him from turning and…NTSB CHI82DA201Accident · No injuriesFinal reportCessna 140 · Stevens Point, WIDuring arrival, the pilot entered traffic for runway 21. The wind was from 180 degrees at 15 gusting to 35 KTS. The pilot stated that while on final approach, he slipped the plane to the right to land on the grass, but went beyond the smooth grass. After…NTSB ATL82IA154Incident · No injuriesIncident investigationFinal reportBeech 18 · Macon, GAAccording to the pilot, the flight was being conducted under ferry flight provisions. The flight was issued a takeoff clearance for runway 05,with reported surface winds of 320 degrees at 10 knots. The copilot started the takeoff roll and was unable to…NTSB LAX82DA210Accident · Minor injuriesFinal reportCessna 210 · Lovelock, NVDuring arrival, the pilot was unable to contact the fss. He was unaware that the fss station had already closed. He observed the wind sock and elected to land on runway 01 with a wind from 325 degrees at 30 knots. On final approach, a distinct crab of about…NTSB NYC82DA117Accident · No injuriesFinal reportPiper PA-22-108 · Syracuse, NYDuring a landing, the pilot slowed to taxi speed when the tower instructed him to expedite a turnoff onto a taxiway. While complying with this request and making a right turn, the pilot lost directional control. The aircraft veered off the right side of the…NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…NTSB CHI82DA197Accident · No injuriesFinal reportAdams A55 · Fritchton, INThe pilot decided to land due to deteriorating weather. A descent was initiated but the pilot was waved off by the owner of the property. The pilot regained altitude and landed in a corn field. A gust of wind caused the balloon to drift, the basket was drug…NTSB LAX82DA200Accident · No injuriesFinal reportCessna TP206A · Sedona, AZDuring touchdown the aircraft started to porpoise. The pilot elected to go-around and added power however the aircraft departed the left side of the runway and came to rest nose down in the dirt.NTSB SEA82DA123Accident · No injuriesFinal reportCessna 150 · Chelan, WAThe pilot reported that during arrival, the wind sock provided little information since it had previously been torn by a wind storm. At wenatchee, WA, the wind was from 260 degrees at 16 gusting 22 KTS. The pilot reported that during a crosswind landing, the…NTSB MKC82DA090Accident · No injuriesFinal reportLuscombe 8E · Goodland, KSWhile en route, the pilot encountered headwinds and elected to land at Goodland, Kansas to refuel. He landed on runway 12 with a crosswind from 320 degrees at 6 knots. The pilot stated that after touchdown, he got a cramp in his right leg and removed his…NTSB DEN82DA096Accident · No injuriesFinal reportCessna TU206G · Price, UTThe aircraft encountered a dust devil shortly after touchdown during a landing on an unimproved area. The pilot reported that the dust devil moved the aircraft to the right and into a ditch.NTSB CHI82DA183Accident · No injuriesFinal reportCessna 310R · Holland, MIDuring landing roll pilot said right brake malfunctioned. His attempts to control aircraft with rudder failed as aircraft slowed. Aircraft left runway and collided with a ditch. Brake had air in the line.NTSB ANC82DAG27Accident · 4 fatalFinal reportCessna 180 · N. Cordova, AKWitnesses stated that the pilot was landing diagonally to katalla beach into a strong headwind. Upon touchdown the left wing lifted up and the aircraft began a gentle turn to the right. Witnesses heard the engine power increase and observed the aircraft…NTSB LAX82DA188Accident · No injuriesFinal reportCessna 195 · Scottsdale, AZThe pilot, a resident of Canada, landed the foreign registered aircraft on runway 21 with a wind from 240 deg at 6 KTS. Reportedly, the aircraft ground looped during the landing.NTSB LAX82DA187Accident · No injuriesFinal reportGrumman G-164A · Pleasant Grove, CAAs the aircraft slowed during the landing roll, it began to drift right when the rudder became ineffective. The pilot was unable to obtain left braking action to maintain directional control. Subsequently, the right main gear struck a small earth bank and the…NTSB DEN82DA092Accident · No injuriesFinal reportCessna 180D · Gillette, WYThe aircraft swerved off the runway to the left 1500 feet from the approach end and the right main gear collapsed. Examination revealed three of five "brake anti-rattle clips" were missing from each brake assembly, allowing the brake disk to wabble.…NTSB CHI82IA179Incident · No injuriesIncident investigationFinal reportBac 1-11-204AF · Dayton, OHDuring arrival, there was a thunderstorm and lighting over the airport, so the aircrew held for about 7 to 10 min. After a Beech baron had landed, they began an ILS approach. An 8 to 10 deg crab was needed to compensate for the wind on final approach. The…NTSB MKC82DA084Accident · No injuriesFinal reportCessna 152 · Ainsworth, NEThe pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots.NTSB DEN82IA090Incident · No injuriesIncident investigationFinal reportGulfstream American G-159C · Gillette, WYDuring arrival, a thunderstorm was located about 6 mi southeast of the airport and another was about 8 to 10 mi northwest. Reportedly, the wind was variable from 090 to 180 deg at 10, gusting 25 KTS. While landing on a 75 ft wide runway, the aircraft began to…NTSB LAX82DA182Accident · Minor injuriesFinal reportBeech 77 · Little River, CAOn the second attempt to make a touch and go landing, the pilot bounced the aircraft hard on the runway immediately followed by a sharp left turn. Full power was applied and the flaps were raised in an attempted go-around. The aircraft failed to clear trees…NTSB ATL82DA137Accident · Minor injuriesFinal reportStinson 108-3 · Hartford, KYDuring flight, the pilot encountered heavy thunderstorm activity. He was unable to circumnavigate the build-ups and elected to land on a gravel road toward the northwest. The pilot reported that during the landing roll, he was just about stopped when the…NTSB LAX82DA173Accident · No injuriesFinal reportAeronca 7EC · Prescott, AZFollowing a wheel landing the aircraft bounced and made a three point landing. After crossing a runway intersection the aircraft developed a left turning tendency which the pilots stated they could not control. The aircraft ran into a ditch.NTSB FTW82DA185Accident · No injuriesFinal reportBoeing A75N1 · Fabens, TXFollowing a left turn on landing roll the pilot applied the brakes to correct for right drift. The braking action resulted in the aircraft nose over. Investigation revealed no mechanical malfunction or failure.