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 MKC83LA010Accident · No injuriesLimited investigationFinal reportBeech E17L · Mcconnell Afb, KSAs the aircraft accelerated through 40 mph during the takeoff roll, a passenger advised the pilot that the cabin door was unlocked. The pilot reduced the engine power to idle, reached back and closed the door. While latching the door, the aircraft swerved to…NTSB LAX83LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Oceanside, CAWhile attempting a touch and go from a wheel landing the pilot lost directional control and collided with a parked aircraft and a chain fence, finally nosing over. The pilot said he did not use enough right rudder during the roll. The parked aircraft, N5515B,…NTSB LAX83LUG03Accident · No injuriesFinal reportPiper PA-28-161 · Redlands, CAThe student pilot reported that he landed in a crosswind with gust up to 15 KTS and overcorrected for a swerve. The aircraft swerved off the runway and was damaged when it encountered mounds of dirt and rocks where construction was underway on the airfield.NTSB FTW83LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXWhile practicing touch & go landings the student plt lost directional control, ran off the side of the rwy into a ditch collapsing the nose gear & turning over.NTSB CHI83LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Port Huron, MIOn touchdown a gust of wind hit the aircraft, the pilot lost directional control, swerved to the right and nosed over. The pilot reported wind gusts to 30 KTS.NTSB SEA83LA012Accident · No injuriesLimited investigationFinal reportCessna 206 · 40 Nm Wnw Salmo, IDThe pilot began a takeoff from a runway covered with about six inches of wet snow and slush in calm wind conditions. He reported that during the takeoff, the right main wheel settled back to the runway and encountered an area of soft snow and slush. The…NTSB DEN83LA005Accident · No injuriesLimited investigationFinal reportHelio H-395 · Gillette, WYDuring a landing roll-out on runway 15, the aircraft ground looped to the right and the left gear failed. The pilot said he was following a twin Cessna that was about 1/4 mile ahead, and when he raised the flaps from full down to 3/4 down, the plane suddenly…NTSB ANC83FAA01Accident · No injuriesFinal reportPiper PA-20-A · Phillips Field, AKThe pilot reported that during a landing, the aircraft bounced a little. Reportedly, he recovered from the bounce, then the plane started to veer off the runway toward parked aircraft. While corecting with brakes, the aircraft nosed over.NTSB DEN83LA004Accident · No injuriesLimited investigationFinal reportLuscombe 8A · La Junta, COThe student pilot elected to practice touch-and-go landings on runway 12. He reported that after landing, he began to set the trim and prepare to takeoff, when the tail popped up and he could hear the wind whistling. Reportedly, he applied full power, but the…NTSB LAX83FVG01Accident · No injuriesFinal reportFairchild 24 · Marysville, CAThe aircraft groundlooped during landing. The pilot said the right brake grabbed and swerved the aircraft. An investigaiton revealed no malfunction.NTSB LAX83LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Wickenburg, AZThe pilot stated the aircraft touched the runway then ballooned during a wheels-first landing. After the pilot decided to execute a go-around and the aircraft became airborne, it became apparent that the aircraft could not clear rising terrain. The pilot cut…NTSB FTW83LA006Accident · No injuriesLimited investigationFinal reportCessna 180K II · Pineville, LADuring landing the acft veered right & the left main gear collapsed.NTSB FTW83LA010Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon landed in high winds and was dragged by the envelope for about 150 yards. While the gondola was being dragged a passengers boot got caught and twisted his leg so that both bones were broken. The weather was VMC and no flight plan was filed. The…NTSB ANC83LA002Accident · No injuriesLimited investigationFinal reportRockwell International Stinson 108 · Near Sparrevohn, AKThe pilot stated that after shooting a moose in the morning, quartering the animal and carrying the meat to the an unimproved landing/takeoff area he walked back to his cabin for his aircraft. Upon his return, he landed and loaded 2 quarters into the back…NTSB SEA83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Mattawa, WAWhile landing on a farm road to pick up seed, the left main gear encountered a soft area on the left side of the roadway. The aircraft began drifting to the left and would not respond to the use of right rudder and brake. It traversed a recently-filled ditch.…NTSB MKC83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Olathe, KSThe pilot stated that during the landing roll the aircraft swerved left, ran off the runway crossing a grassy area and a parallel taxiway. He said that the nose seemed to remain higher than normal, as if the nose gear had not fully retracted into its upper…NTSB SEA83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Salmon, IDThe plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard…NTSB FTW82DRG38Accident · No injuriesFinal reportCessna 170B · San Marcos, TXAcft swerved off rwy during takeoff. Ex-military plt retired in 1965, check out in aero club tricycle gear acft on 8/28/82 with subsequent 72 hrs all in tricycle gear acft. Plt stated he had not flown conventional gear acft since the 1950'S. There was no…NTSB LAX82DA355Accident · No injuriesFinal reportPiper PA-18 · Visalia, CAAccording to the pilot, he was landing on runway 28 with a crosswind from the north at 10-12 KTS. He reported that during touchdown, the wind blew the aircraft to the left. The left main gear encountered soft dirt which diverted the plane onto bumpy ground.…NTSB LAX82DA350Accident · Minor injuriesFinal reportLuscombe 8E · Ramona, CAThe pilot stated that during takeoff, the aircraft tail was raised too soon and that the aircraft torqued left. The aircraft was subsequently lifted off the runway prematurely and stalled.NTSB FTW82DA388Accident · No injuriesFinal reportCessna 140 · Friendswood, TXDuring the landing roll, the flight crew lost directional control while landing with a right quartering head wind. Subsequently, the aircraft veered off the left side of the runway, went into a drainage ditch, and was damaged. An investigation revealed that…NTSB FTW82DA384Accident · No injuriesFinal reportNorth American AT-6D · Houston, TXThe aircraft began to drift left during takeoff. The pilot decided to lift off and correct the drift in the air. He corrected with right bank and the wing dragged on the ground the aircraft cartwheeled in the grass adjacent to the runway and came to rest…NTSB CHI82DA360Accident · No injuriesFinal reportNavy N3N-3 · Danville, ILUpon arriving at an air show the plt was given advisories for a downwind landing. The acft subsequently ground-looped. Subsequent inspection revealed that the tailwheel lock had also malfunctioned. The centering spring was not strong enough to consistently…NTSB ATL82DA279Accident · No injuriesFinal reportCessna 150L · Front Royal, VAPilot lost control during landing and in attempting to correct left turn went off runway to right.NTSB CHI82DA354Accident · Minor injuriesFinal reportCessna 172N · Bucyrus, OHStudent pilot made landing and aircraft veered left off runway. Pilot made go-around during which he collided with a fence but continued flight. During later landing left landing gear collapsed. ELT was activated by fence. Left tire was found to have a flat…NTSB NYC82DA233Accident · Serious injuriesFinal reportCessna 205A · Augusta, MEOn landing, a severe drag on the left landing gear overcame pilot's attempted corrections. The aircraft went off the runway, down an embankment and overturned. The left brake locked, due to corrosion of carrier pins.NTSB ATL82DA274Accident · No injuriesFinal reportPiper PA-25 · Baxley, GAPrior to landing, the pilot noticed that the left brake would not pump up. The pilot landed and during the landing rollout the left brake failed completely. The aircraft groundlooped and one landing gear collapsed.NTSB ATL82DA271Accident · No injuriesFinal reportGrumman AA-5B · Moulton, ALAccording to the pilot, after touchdown he applied brakes and the right brake seemed to lock intermittently during the roll out. Black marks on the landing surface reveal the aircraft departed the right side and impacted an embankment and steel post. This was…NTSB CHI82DA352Accident · Minor injuriesFinal reportBreezy RLU-1 · Marshall, MIAfter landing, the pilot lost directional control of the aircraft. Subsequently, it departed the right side of the runway and turned over. An examination of the wheel brakes revealed no mechanical failure or malfunction. Reportedly, there was a crosswind from…NTSB LAX82DA339Accident · Minor injuriesFinal reportMooney M20B · Scottsdale, AZThe plt reported he encountered a small amount of turbulence & a fairly strong crosswing on final. Touchdown was smooth & on the left side of the rwy. The acft then veered to the right. The plt saw a ditch ahead & applied full power before becoming airborne.…NTSB DEN82DA186Accident · No injuriesFinal reportPiper PA-31T · Delta, UTAfter landing, the aircraft departed the right side of the runway. The pilot stated that left rudder and brake did not keep the aircraft on the runway. He believed that the right brake locked or the left reverser did not activate. An examination of the…NTSB ANC82DA086Accident · No injuriesFinal reportCessna 170 · Near Anchorage, AKPilot tried stop landing on sandbar he had done touch and go landings on. Sand was soft and flying speed not attained before curve in sandbar during takeoff attempt. Pilot could not negotiate turn and continued into river.NTSB SEA82DA158Accident · No injuriesFinal reportStinson 108-1 · Twin Falls, IDPilot ground looped while doing touch and go landings. Wind 5 KTS.NTSB NYC82DA218Accident · No injuriesFinal reportCessna 180J · Frankfort, NYReportedly, the aircraft encountered a crosswind during the landing which raised the left wing and caused the right wing to contact the runway. The aircraft then veered left and departed the runway. The right tire blew out and the aircraft came to rest on the…NTSB LAX82DA334Accident · Minor injuriesFinal reportCessna 182P · Reno, NVAccording to the pilot, he realized the aircraft was too low when he was on final approach. He reported that he added insufficient power and the aircraft swerved to the left during touchdown. Subsequently, the plane hit a ditch and went over on its back.NTSB LAX82DA338Accident · No injuriesFinal reportCessna 206 · Perris Valley, CAThe pilot stated that the aircraft touched down slightly left of runway centerline. The pilot attempted to manuever the aircraft back to center, when the aircraft veered sharply to the right. When he saw a ditch ahead and applied full power. The aircraft…NTSB CHI82DA338Accident · Serious injuriesFinal reportPiper PA-28140C · Medina, OHAfter touchdown, the aircraft began a gentle veer to the right and departed the runway surface approximately midway down the runway. The pilot decided to execute a go-around. A witness stated that N5692U began a right turn "within 10 seconds of being…NTSB FTW82DA363Accident · No injuriesFinal reportCessna 172M · Mccook, TXWhile the pilot was landing with a right crosswind condition, the aircraft drifted off the left side of the runway and collided with a concrete stand pipe. This resulted in damage to the wing, wing strut and propeller. A go-around was attempted, but the…NTSB DEN82DA180Accident · No injuriesFinal reportCessna 180 · Philip, SDPilot lost directional control during landing and groundlooped. Pilot stated he encountered a strong crosswind gust froma thunderstorm in the area.NTSB CHI82DA316Accident · No injuriesFinal reportBeech G18S · Chicago, ILDuring takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they…NTSB NYC82DA212Accident · No injuriesFinal reportPiper PA-28-140 · Norwood, MAThe student pilot was on a local flight and returned to the airport to practice landings. Just prior to touchdown on his second touch-and-go, the nose went to the right. Left rudder was applied to re-align the aircraft to the centerline of the runway. At…NTSB NYC82DA211Accident · No injuriesFinal reportCessna 180G · Dubois, PADuring arrival, the pilot entered the pattern to land on runway 25 with the wind from 330 degrees at 18 KTS. To compensate for the crosswind, he prepared himself for a right wing low landing. However, the pilot stated that when he started to round out, the…NTSB LAX82DA323Accident · No injuriesFinal reportCessna 152 · Chandler, AZStudent pilot during solo flight applied right brake to correct veer and aircraft veered right off runway. Aircraft collided with bushes and nosed over alongside runway. The right brake was locked after accident.NTSB LAX82DA322Accident · No injuriesFinal reportCessna A185F · Monterey, CAPilot used brake to straighten veering aircraft and left wing dragged.NTSB ANC82DA077Accident · No injuriesFinal reportAeronca 11AC · Soldotna, AKThe student pilot was practicing takeoffs and landings. He stated that during a landing, the aircraft ground looped to the left, went off the runway and went into soft dirt. When the soft dirt was encountered, the landing gear and propeller were damage.NTSB MIA82DA173Accident · Minor injuriesFinal reportAir & Space 18A · Orlando, FLDuring takeoff, the gyrocopter lifted off to only about 3 ft, instead of the usual 10 to 15 ft. it then settled back to the runway and encountered a ground resonant condition. The pilot stated that once the wheels were carrying the weight, the blades would…NTSB ATL82FKG16Accident · No injuriesFinal reportCessna 150M · Madison, GAAfter touchdown the tailwheel equipped C-150 veered off the rwy into a gully breaking off the tailwheel. The acft then struck an embankment.NTSB CHI82DA334Accident · No injuriesFinal reportCessna 210 · Holland, MIDuring landing, the aircraft swerved to the left and went off the runway. The left gear struck a runway light fixture and failed. Also, the horizontal stabilizer hit a runway light and was damaged. An inspection of the wheel assembly revealed no mechanical…NTSB FTW82DA343Accident · No injuriesFinal reportCessna A185F · Grand Chenier, LAThe pilot landed the float plane on the water beside an oil drilling rig. As soon as the aircraft touched down, it water looped. The pilot stated that the tips of the floats had mud on them after the accident. He believed that the aircraft must have hit a…NTSB DEN82DA165Accident · No injuriesFinal reportBellanca 7GCBC · Yuma, COThe pilot stated that as he touched down the aircraft porpoised "a couple of times." When the aircraft had slowed to approximately 25-30 mph it ran off the runway into soft dirt and nosed over.