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 NYC83LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Duanesburg, NYThe plt landed the tailwheel equipped acft in a 15 kt, left x-wind. During the landing, the acft veered to the left into a rough area, ground looped & came to rest in a ditch. The plt stated that the right brake failed.NTSB ATL83LA276Accident · No injuriesLimited investigationFinal reportPiper L-21B · Vernon, ALThe acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.NTSB NYC83LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Factoryville, PAAfter touchdown on a full stop landing, the student plt was instucted to apply brakes. When he failed to respond, the instructor (CFI) applied the brakes to stop the acft. As the brakes were engaged, the acft veered to the left. The CFI corrected with full…NTSB MKC83LA144Accident · No injuriesLimited investigationFinal reportBeech C-23 · Osage Beach, MOThe acft ran off the side of the runway and continued to overrun the departure end of the runway where collision with a ditch occurred. There was evidence that the brakes were used but were not effective in stopping the acft. An FAA inspector inspected the…NTSB LAX83LA315Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hayward, CAThe plt stated that during the takeoff roll he attempted to lift the acft off at about 65-75 KTS indicated airspeed. The plt said that he thought the acft was not responding properly so he cut the power and tried to land on the rwy. The acft kept bouncing, so…NTSB ANC83LA112Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKThe pilot stated that the runway at dry creek strip curved to the left. The runway used was runway 9 and the wind was gusting to 30 KTS. The acft went off the right side of the runway and the nosewheel hit a rut which nosed the acft over.NTSB ANC83FA110Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe pilot stated that he lost directional control possibly due to a windshear. Just at touchdown he said he felt the winds were squirrely. Late in a telephone interview he stated that he was 'too complacent at the wrong time-should have positive control all…NTSB SEA83LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Waitsburg, WAThe acft groundlooped into soft dirt and nosed over after a brake malfunction. The pilot stated that upon landing the left brake locked. The pilot tried to maintain directional control with rudder and power. The acft veered right into soft dirt and came rest…NTSB SEA83LA138Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bliss, IDAccording to the plt, he was returning to a road to land & reload chemicals for aerial application. He stated that the right main tire went flat during flt due to a puncture. During the landing roll-out, the acft veered to the right & nosed over.NTSB LAX83LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Camarillo, CAThe acft groundlooped and collided with a rwy light during landing. The acft had been converted to a taildragger.NTSB FTW83LA306Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · El Paso, TXThe plt was practicing touch-&-go landings & stated that he had been flying with the mixture leaned. After a landing, he applied full throttle, but the eng coughed & sputtered. He then advance the mixture to rich to correct the situation. At about the same…NTSB DEN83LTG02Accident · No injuriesFinal reportAleson Quickie Q2 · Williston, NDThe acft groundlooped and collided with a rwy light following an inadvertant takeoff and landing during what was supposed to be a high speed taxi test. During the landing roll the acft swerved to the left, departed the rwy and collided with a rwy light. This…NTSB FTW83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Franklinton, LAThe acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…NTSB FTW83LA298Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Grubbs, ARThe agricultural acft nosed over during landing. The plt said he was attemping to steer the acft around standing puddlesof water on a wet private airstrip when directional control was lost and the acft nosed over in a ditch.NTSB CHI83LA283Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Alma, MIThe acft collided with the VASI lights during landing. The pilot was landing on rwy 27 with winds from 210 degrees at 12 KTS. He reported gusty winds but gave no estimated velocity of the gusts. He said he touched down on the right main gear with the left…NTSB ANC83LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe acft collided with trees alongside the runway during takeoff. The runway was a dirt strip 1200 feet long and 30 feetwide. The pilot stated after the accident that he lost control of the acft and ran off the runway into the wooded area. The wind was from…NTSB ATL83LA243Accident · No injuriesLimited investigationFinal reportSchleicher AS-K13 · Tullahoma, TNThe pilot stated that his approach was too fast and he bounced the acft during the landing. The glider drifted left and collided with a hayroll. The collision caused another swerve and a subsequent collision with another hayroll.NTSB MKC83LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Denton, NEThe acft went off the runway during takeoff. The pilot said the acft drifted to the left after the tailwheel was raised. He said he brought the acft back to the centerline but it drifted left again and entered tall grass beside the runway. As the pilot…NTSB LAX83LA300Accident · No injuriesLimited investigationFinal reportCessna 172M · Big Bear, CAAfter a slight change in the wind, rwy 7 became more favorable & the UNICOM operator advise that it was recommended for use. The student maneuver the acft to make his apch to rwy 7. During the landing, the acft bounced twice, then veered left into a grassy…NTSB FTW83LA301Accident · No injuriesLimited investigationFinal reportCessna T188C · Waxahachie, TXThe acft collided with a ditch and cartwheeled to a stop during landing. The plt stated that a downdraft was encounteredover the threshold and the acft touched down left of the centerline. The wing and spray room caught in tall grass and the acft veered into…NTSB ATL83LA239Accident · No injuriesLimited investigationFinal reportCessna 150M · Ashland, VAThe acft bounced, went off the runway and nosed over during landing. The student pilot was on a supervised solo flight and was practicing touch and go landings. During this landing he made a hard landing and bounced back into the air. The student attempted to…NTSB LAX83LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jackson, CAThe acft went off the rwy and collided with a ditch during landing. The tailwheel acft touched down on rwy 19 about 200 ft past the threshold and bounced. The pilot applied power to recover and lost control of the acft. The acft veered off the rwy to the…NTSB ATL83LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Berlin, MDThe acft veered off the rwy and nosed over during landing. The plt reported that the acft started to drift into the softplowed field on the right of the rwy and full left rudder and brakes would not stop the turn. The reported wind about 18 miles away was…NTSB MKC83LA132Accident · No injuriesLimited investigationFinal reportCessna 182F · Dows, IAThe acft nosed over during takeoff. The rwy used was 090 and the wind was from 170 degrees at 17 KTS. The plt said the acfts right wing raised followed by the tail and then the left wing dropped impacting the sod rwy before the acft nosed over.NTSB LAX83LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wickenburg, AZThe acft left the runway during landing and collided with a ditch which collapsed the right main gear and nose gear. Thepilot noted during final approach that the windsock did not indicate a cross-wind. The landing was made with 10 degrees of flaps. According…NTSB FTW83LA286Accident · No injuriesLimited investigationFinal reportCessna 210 NII · El Paso, TXThe acft went off the right side of the rwy during landing. The winds were reported to be from 290 degrees at 10 KTS during the approach to rwy 22 the plt noted no crosswind corrections but after landing the acft turned right and the plt could not correct…NTSB FTW83LA284Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Abilene, TXThe agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…NTSB DEN83LA146Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Burlington, WYThe acft departed the rwy in an evasive maneuver to avoid a deer. The acft contacted small trees and brush off the rwy and collapsed the landing gear. The pilot said he was about 150 yards down the rwy with the tail of the acft up when thedeer ran onto the…NTSB MKC83LA229Accident · No injuriesLimited investigationFinal reportCessna 172G · La Porte City, IAScattered rain showers in the area had just made the turf rwy wet. The pilot reported that as he turned off the rwy the acft skidded and went sideways into a ditch.NTSB DEN83LA141Accident · No injuriesLimited investigationFinal reportCessna A188 · Leola, SDThe plt was using a gravel road, aprx 20 ft wide, for an aerial application operation. During takeoff, the acft swerved to the right, went into the ditch beside the road & was substantially damaged. The plt believed that the right wheel had become locked.…NTSB SEA83LA124Accident · No injuriesLimited investigationFinal reportCessna 185 FII · Ryegrass Pass, WAThe acft collided with sagebrush and groundlooped while landing on an abandoned country road. The weather was VMC. The acft was damaged but the pilot was not injured. According to the pilot gusting winds caused him to contact the sage brush and ground loop…NTSB NYC83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Latrobe, PAThe acft ran off the runway when the student pilot attempted to close a window during the takeoff roll. As the acft left the runway the nose wheel collapsed rearward and the prop, main gear and fuselage were damaged. The pilot received minor injuries.NTSB CHI83LA259Accident · No injuriesLimited investigationFinal reportCessna 172 · Gaylord, MIThe plt initially departed grayling, MI with intermediate stops in alba, Gaylord, alba again, & finally terminating at grayling. The plt stated he landed short at alba. He also stated that while practicing landings at Gaylord he ran off the side of the rwy.…NTSB CHI83LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Milwaukee, WIDuring landing the pax had her legs positioned in such a manner that they interfered with the movement of the yoke. When the plt requested she clear the yoke, she put her left foot on the rudder pedal/brake causing the acft to veer off the left side of the…NTSB FTW83LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · League City, TXAfter returning from a solo x-country, the student plt was landing. Shortly after flaring to land, a gust of wind 'deflected' the plane. The student decided to abort the landing & applied full throttle, but was not able to avoid touching down in a right crab.…NTSB MKC83LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Ottumwa, IADuring arrival, the plt canceled his VFR flt plan when he was about 3 mi from the arpt. At that time, fss personnel advised him that the wind was from 190 deg at 14 KTS & that the wind favored rwy 22. There was a tetrahedron wind indicator north of the…NTSB MKC83LA124Accident · Minor injuriesLimited investigationFinal reportQuickie Q2 · Grain Valley, MOThe acft ran off the right side of the rwy and nosed over during landing. The plt stated that after a wheel landing he lowered the tail wheel to the rwy and applied the hand brake lever. The right brake grabbed and the acft turned right, rolling and skidding…NTSB ANC83FA094Accident · No injuriesField investigationFinal reportCessna C-180 · Willow, AKThe acft nosed over during landing while on a dual instructional flt. The CFI stated the student applied too much brake on the first landing and almost nosed over. During the 2nd landing the student again applied excessive braking and the acft nosed over. The…NTSB CHI83LA257Accident · Minor injuriesLimited investigationFinal reportMooney M20J · St. Paul, MNThe CFI stated that the student (private pilot) was informed of a crosswind condition after the acft was established on the base leg. The CFI stated that after touchdown the acft yawed sharply to the left and proceeded toward the grass area adjacent to the…NTSB ATL83LA221Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Jackson, KYThe pilot reported that when he exited the helicopter for the purpose of retrieveing a map from below the plt's seat, the acft began to lift and move laterally. The acft then tipped over trapping his leg and hip beneath it. He stated that he had not fully…NTSB ATL83FKG09Accident · No injuriesFinal reportGrumman American AA-5A · Dobbins Afb, GAThe student plt was taxiing for takeoff when she applied right brake where a right turn was needed, however, the acft did not turn as it should. The instructor plt then took control of the acft. He applied right brake, then both brakes, but had negative…NTSB CHI83LA242Accident · No injuriesLimited investigationFinal reportCessna 206A · St. Cloud, MNThe acft bounced during a hard landing and nosed over. The weather was VMC but there was a crosswind on rwy 31 which wasthe active rwy. The wind was 290 degrees at 11 KTS with gusts to 19 KTS. After 2 bounces during which the acft moved about 20-25 ft to the…NTSB NYC83LA135Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 109 · Finleyville, PAThe motorized glider collided with trees and the terrain during an emergency landing after the prop had struck the ground during takeoff. During the takeoff roll the propeller 1st collided with high grass and then a bump in the ground after the pilot lost…NTSB LAX83LA284Accident · No injuriesLimited investigationFinal reportCessna 172A · Carmel Valley, CAAccording to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…NTSB ATL83LA216Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Mitchellville, MDThe plt reported that when he was on final apch to land, his speed was a little fast. After touching down, the acft bounced & began drifting to the right. Once the right wheel went off the rwy, the right turn increased & the acft struck a rwy edge light. Full…NTSB FTW83LA265Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tulsa, OKThe acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.NTSB NYC83LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Chatham, MAThe acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…NTSB NYC83LA129Accident · No injuriesLimited investigationFinal reportCessna 182N · Newport, RIThe acft went off the wet runway onto the wet grass down an embankment and into some rocks. The instructor was making this final landing. Braking was poor from a light rain. As a turn was started onto a taxiway at the end of runway 22 the acft went onto the…NTSB MKC83LA120Accident · No injuriesLimited investigationFinal reportAeronca 65CA · St Louis, MOThe plt stated that during his 4th full stop landing the acft veered left off the rwy into a flooded area & nosed over.NTSB ANC83LA087Accident · No injuriesLimited investigationFinal reportMaule 5-235C · Fairbanks, AKThe pilot lost directional control of the acft during landing. The acft cartwheeled several times and came to rest on the left side of the runway about 500 feet from the approach end of the runway. The weather was VMC but the wind was from 260 degrees at 18…