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 FTW84LA367Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Arlington, TXAfter two unsuccessful landing attempts the acft touched down on the rwy, veered to the right and off the side of the rwy, colliding with a concrete structure. Rwy 16 was used.NTSB DEN84LA265Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Poplar, MTPlt stated, 'river current 12-15 mph, landing area 100 yards wide, curving to right, wind gusting to 20 knots from right rear quarter. Approach was fast, and upon landing, aircraft remained on step, unresponsive to aileron and rudder for turning. Quartering…NTSB LAX84LA449Accident · No injuriesLimited investigationFinal reportCessna 206 · Sacramento, CAWhile taxiing for takeoff the pilot's seat slid aft causing the loss of directional control and subsequent collision with other acft. The plt stated that when she entered the acft she moved the seat full forward and that the seat lockingmechanism was not…NTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…NTSB FTW84LA357Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXDue to acft parked in close proximity to the right side of the narrow (25 ft) runway and a crosswind from the left, the plt favored the left side of the runway on landing line-up. During the landing roll, he was unable to arrest a left drift before the acft…NTSB CHI84LA353Accident · No injuriesLimited investigationFinal reportCessna 172N · Magnolia, OHThe pilot attempted to land with a 10 knot left quartering tailwind. The pilot stated that she could not get the acft to settle on the runway during the landing. The acft went into the brush at the end of the runway and nosed over. The pilot stated that a…NTSB DEN84LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Durango, COThe acft collided with a rwy light during takeoff. The plt said the acft got to about 6 ft AGL for about 100 ft and whenthe plt pushed foward on the control column the acft settled back on the rwy. During the roll the horizontal stabilizer hit a rwy light.…NTSB CHI84LA357Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Rice, MNPilot stated that during the takeoff roll the acft suddenly began to pull to the left. The pilot reduced power and applied right brake and rudder to correct but the left wing struck corn stalks. Examination of the acft after the accident revealed the left…NTSB ANC84FA140Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt stated that he was taking off to the southeast & the acft was on the step when a x-wind hit, lifting the right wing. He said the left wing then hit the water, spinning the acft to the left & the nose hit the water. The acft went over on its back &…NTSB FTW84LA351Accident · No injuriesLimited investigationFinal reportCessna 150 · Pecos, TXThe pilot stated that he got lost while on a x-country from big springs, TX, to van horn, TX. The pilot made a landing at a ranch strip to ask directions. After touchdown, the acft veered to the left in a crosswind. One main landing gear and both wings were…NTSB MIA84LA230Accident · Minor injuriesLimited investigationFinal reportMooney 20E · St. Simon, GAOn landing roll, acft swerved to left & departed rwy surface into grass. Plt applied full pwr and attempted go-around, headed aprx 20 degrees left of runway alignment. Acft became airborne, angling toward ramp and hangar complex. Witnessesobserved acft assume…NTSB NYC84LA273Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAThe certified flt instructor (CFI) stated that he was instructing a 10 hour student pilot. He continued to state that they were doing touch and go's and had applied power for the second takeoff when the aircraft began to veer to the right side of the rwy. The…NTSB LAX84FA439Accident · 1 fatalField investigationFinal reportCessna 182RG · Prescott, AZAs the acft proceeded on takeoff down the rwy, it exited the rwy on the left side over a berm into a wide shallow ditch area, then about 122 feet later the acft traveled back over the berm onto the rwy and took off. The nose then pitched up, the acft banked…NTSB FTW84LA346Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fulshear, TXOn the takeoff roll, a 'short duration cross control condition occurred' between the student and instructor pilots, resulting in the acft departing the right side of the runway, power was reduced but the acft rolled into a dirt bank and mud holes, collapsing…NTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…NTSB DEN84LQA02Accident · No injuriesFinal reportLighthizer, Richard E. Lighthizer Special · Gallup, NMThe pilot/builder of this ultra-light had flown from oshkosh, WI to Gallup, NM without incident. During his attempted take-off from Gallup he allowed the acft to veer off the rwy to the left. After the acft rolled into the grasshe regained directional control…NTSB DEN84LA252Accident · No injuriesLimited investigationFinal reportCessna 188 · Holyoke, COThe pilot lost directional control after landing with a rear right quartering crosswind reported at 5 KTS. Use of opposite rudder and braking was ineffective in regaining directional control. The pilot reported no response from the left brake and stated…NTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…NTSB MIA84LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carrabelle, FLAcft swerved off the rwy after the plt heard a loud pop sound. Examination of the aircraft disclosed that the a main landing gear attach bolt had sheared.NTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…NTSB ANC84LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Anchorage, AKThe pilot lost control during landing, the acft ground looped and both main landing gear collapsed.NTSB MIA84LA219Accident · No injuriesLimited investigationFinal reportCessna 188 · Bunnell, FLThe acft departed the side of the rwy during takeoff. The acft was being ferried by the plt to his home base in FL. The NTSB did not receive an accident report from the plt although he said that one was mailed. Requests for a duplicate werenot responded to. A…NTSB LAX84LA414Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Jackson, CADuring arrival, the plt observed the wind sock indicating a wind from the west at about 15 KTS. He entered the traffic pattern & landed on rwy 19. After touchdown, the acft encountered a gust of wind, ground looped & went off the right side of the rwy,…NTSB SEA84LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORDuring a precautionary landing the aircraft encountered a 180 degree windshift during rollout. The aircraft nosed over as a result of the resulting tailwind.NTSB LAX84LA409Accident · Minor injuriesLimited investigationFinal reportVance-Hamm Glasair · Scottsdale, AZWhen the plt was cleared for takeoff, the tower was reporting a wind from 260 deg at 11 KTS. The takeoff was initiated & the acft accelerated normally. When the tailwheel was raised, the plane began drifting left. The plt said she applied rudder until she had…NTSB FTW84LA322Accident · No injuriesLimited investigationFinal reportCessna 152 · Friendswood, TXDuring a touch-&-go landing, the plt lost directional control of the acft after he applied power to takeoff again. The acft went off the left side of the rwy, hit a ditch & nosed over.NTSB ATL84LA232Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Harlan, KYAs the acft accelerated for takeoff the pilot's seat slid aft and he was unable to maintain directional control. The acft went off the left side of the rwy and nosed over when it rolled through high grass. According to the pilot the seat was locked in place…NTSB SEA84LA179Accident · No injuriesLimited investigationFinal reportCessna 152II · Reno, NVAccording to the CFI, when he & his student were on approach for landing on rwy 16R, he received a report of wind shear. The CFI stated that he was instructing his student in the 'wing down' method for x-wind landings & the acft touched-downon its right wheel…NTSB FTW84LA317Accident · No injuriesLimited investigationFinal reportBeech D-18S · Mcallen, TXThe PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main…NTSB LAX84LA404Accident · No injuriesLimited investigationFinal reportCessna 170B · Huntington Bch, CAThe acft departed the rwy to the left during landing. Upon contacting soft dirt the right main gear collapsed and separated from the acft. According to the plt the acft hit a rough spot and bounced. Other damages were done to the fuselage, the wings and the…NTSB ANC84LA117Accident · No injuriesLimited investigationFinal reportCessna 180 · King Salmon, AKThe plt was making his fourth landing for a full stop in the tailwheel acft. After the tailwheel contacted the rwy, the upwind wing was raised by a crosswind. The other wing then dragged the surface & the acft partially ground looped & nosed over.NTSB LAX84LA398Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Tracy, CADuring the landing roll, the acft ran off the side of the rwy. The plt stated that he landed with a slight tailwind.NTSB MIA84LA202Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Springs, FLThe pilot stated that after recovering from a bounced landing, he started to lose directional control. He stated that he over compensated for the turn & added power to takeoff again. However, the acft veered left & subsequently nosed over.NTSB LAX84LA368Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Tucson, AZThe student pilot lost directional control during the landing roll. The instructor pilot was unable to regain control to prevent a ground loop. Subsequently, the acft veered off the rwy & was damaged on rough terrain.NTSB DEN84LA220Accident · No injuriesLimited investigationFinal reportBeech F33A · Glen Canyon, UTAccording to the plt, a slightly higher than normal apch speed with partial flap extension was used for the apch due to the turbulance and wind gusts to 25 KTS. After crossing the threshold at 20 to 30 ft AGL the flare resulted in what the pilot described as…NTSB NYC84LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Ocean City, NJDuring landing in a x-wind the plt said the acft was pushed to the right side of the rwy by the shifting wind. The nose wheel was broken off and the right wing damaged. The plt reported that the wind shifted from the southwest to the southeast and was gusting…NTSB CHI84LA285Accident · No injuriesLimited investigationFinal reportCessna 170B · Edgerton, WIThe plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn…NTSB LAX84LA387Accident · No injuriesLimited investigationFinal reportHelio H-295 · Santa Ana, CAAs the tailwheel settled to the rwy the acft veered right and ground looped collapsing the left main ldg gear. The left main gear oleo strut failed due to tensile overload.NTSB MKC84LA203Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Topeka, KSDuring flt, the plt decided to divert to Topeka, KS. While landing on rwy 13, the acft veered to the right. Subsequently, it went off the side of the rwy, encountered soft, muddy terrain & nosed over. The wind was from 210 degs at 14 gusting 22 KTS.NTSB DEN84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Bryce, UTThe plt said that the wind was calm. The arpt mgr said that the wind was 5-10 KTS from about 180 degrees. The acft according to him went off the left side of the rwy into dirt at full pwr. The acft went back to the rwy heading still atfull power. The plt…NTSB LAX84LA383Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Marysville, CADue to a rough running eng, which was remedied by applying carburetor heat, the plt elected to make a precautionary landing on a private airstrip. Directional control was lost during the landing roll and the acft ground looped, damaging the left landing gear…NTSB ANC84LA112Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Curry, AKThe acft swerved on the over grown rwy and when the plt partially corrected the swerving the acft went off the rwys end and nosed over. The plt said he had checked the airstrip out on a solo flt and had no problems. When he returned to the unmaintained strip…NTSB SEA84LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Moscow, IDThe acft ran off the rwy into tall wet weeds during a landing on a private agricultural airstrip. The plt said a x-wind caused the swerve. A weather reporting station 6 NM away reported the wind as 7 KTS with no gusts. The plt landed to thenorth and the…NTSB SEA84LA160Accident · Minor injuriesLimited investigationFinal reportRearwin Rearwin 8125 · The Dalles, ORThe plt inadvertantly taxied the acft to the wrong rwy for takeoff. The plt did say he saw acft departing from another rwy. Takeoff was attempted with a 19 kt x-wind. The acft ran off the side of the rwy before becoming airborne. The arpt manager has since…NTSB DEN84IA209Incident · No injuriesIncident investigationFinal reportBoeing 727-23 · Denver, COThe acft went off the rwy during landing. The excursion was to the left & was not corrected before the acft made an exit from the rwy. The captain, in a written statement, said that he was anticipating a right x-wind because he was landing on rwy 26L & the…NTSB FTW84LA298Accident · No injuriesLimited investigationFinal reportCessna 172N · Blanco, TXDue to the tatum ranch private airstrip being incorrectly marked on the sectional chart the plt was using, he inadvertantly landed at the wrong arpt lost control of the acft & was unable to go around or stop. The acft continued off the end of the gravel…NTSB LAX84LA376Accident · No injuriesLimited investigationFinal reportCessna 206 · Marysville, CAThe plt stated he lost control of the acft & it veered off the rwy. The left wing hit the ground & the plane was damaged.NTSB FTW84FA296Accident · No injuriesField investigationFinal reportCessna 421B · El Paso, TXFirst evidence of landing gear tire marks were found aprx 4,000 ft down the rwy, right of centerline and continued until the acft rolled off the right side of the rwy. All 3 landing gear collapsed in the soft dirt and gravel. According to the plt, when the…NTSB MKC84LA196Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Wynne, ARShortly after landing on rwy 16 the pilot noticed an aerial application acft lined up to land on rwy 34. Heavy braking was applied. The acft struck a rwy light, nosed over and came to rest inverted. The aerial application acft did not have a radio. It…NTSB MKC84IA184Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Grand Island, NEThe capt started the rt eng at the gate & the lt eng while taxiing for takeoff. At this time the f/o was briefing the passengers on takeoff & en route procedures. The f/o then initiated the takeoff roll & the acft proceeded to the lt, striking a rwy light.…