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 SEA83LYK02Accident · Serious injuriesFinal reportCessna 210L · North Bend, ORThe aircraft collided with a parked fuel trailer after the engine started when the pilot turned the prop to loosen up the engine oil. The pilot received serious injuries when he was knocked down by the left horizontal stabilizer as he tried to reenter the…NTSB FTW83LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Jefferson, TXReportedly, the plt landed 'long & hot' at dusk, then lost control of the acft while he was trying to stop on the rwy. The acft veered off the right side of the rwy. Subsequently, the nosewheel dropped into a small culvert. The left wing spar & firewall were…NTSB CHI83LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Michigan City, INThe pilot stated that the aircraft bounced during landing and settled on the left side of the runway. During the landing roll, the left main wheel rolled off the pavement and the aircraft pulled further left and went off the runway onto wet sod. It slid on…NTSB SEA83LA085Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Blanchard, IDThe aircraft collided with a fence during landing on a narrow strip in a variable crosswind. The pilot had taken off from the same airstrip earlier without difficulty. He said a strong gust of wind struck his aircraft as it was touching down. This displaced…NTSB FTW83IA193Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63F · Dfw Airport, TXThe captain said he was asked to expedite the takeoff because of traffic on short final so he advanced the throttles to partial power to make a rolling takeoff. The acft's nose wheel crossed the centerline of the runway to the right and the captain corrected…NTSB LAX83LA201Accident · Minor injuriesLimited investigationFinal reportQuickie Q2 · San Carlos, CAThe acft collided with two parked acft during a go-around attempt. The acft had been cleared to land and the approach seemed normal but the 'flare and touchdown was to the left of the rwy centerline' the acft touched down' several times on the left main gear…NTSB NYC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182P · Block Island, RIThe acft veered off the runway during landing and collided with a ditch. The approach to Block Island was normal and thelanding was made about one third down the runway. On touchdown, directional control was lost and the acft veered to the left side of the…NTSB DEN83LA098Accident · No injuriesLimited investigationFinal reportCessna 170A · Plentywood, MTPilot was practicing touch and go landings on runway 30. Pilot stated that on landing roll as he closed the carburetor heat control preparing for another takeoff a gust caught the right wing lifting it up. The pilot corrected by using right aileron and left…NTSB MIA83LA116Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe acft swerved off the runway, collided with a hole and nosed over during landing roll. This was a student training flight. The student pilot was not injured. The wind was reported as a tail wind.NTSB MKC83LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Kaiser, MOThe acft sustained substantial damage when the nose gear collapsed during landing. The weather was VMC but the pilot said he encountered a gusty crosswind during landing. He had checked the wind sock prior to landing and it was hanging limp. The reported wind…NTSB LAX83LA191Accident · Minor injuriesLimited investigationFinal reportWalston Thorp T-18 · Red Bluff, CAThe acft nosed over in a ditch after leaving the runway during landing. The pilot had made 3 landings and was concludinghis flight when he misjudged his turn to exit the runway and lost control of the acft. The acft went off the paved surface rolled into a…NTSB FTW83LA185Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Shreveport, LAAccording to the pilot, the crosswind landing and initial rollout were normal. Shortly after the tailwheel settled a sudden gust of wind of surprising strength caused the airplane to weathervane into the wind and toward a line of parked airplanes. To avoid a…NTSB LAX83LA182Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe acft nosed over during the landing roll while being used on a dual instructional flight. The instructor was demonstrating night landing technique to her student. During the last landing directional control was lost when the nosegear touched down. The acft…NTSB MIA83LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Vero Beach, FLThe student pilot stated that during the takeoff portion of a touch and go landing power was applied, the acft went out of control and ran off the left side of the runway striking trees.NTSB ANC83LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe plt landed on rwy 3 after watching a friend in another another acft land successfully first. The acft then went off the left side of the rwy into large rocks & nosed over. After landing the plt stated he saw no wind sock & thinks the wind was from the sw…NTSB MKC83LA086Accident · No injuriesLimited investigationFinal reportRockwell 500B · Hutchinson, KSThe acft touched down in 2 inches of snow & slush. Braking action was non-existent. The rwy lights were covered with piles of snow & were not visible. The acft veered right into a snowbank collapsing the nose gear. The NWS contract weather observer is not…NTSB ATL83LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Williamsburg, VAThe aircraft ran off the runway after an aborted takeoff. The pilot stated that he elected to abort the takeoff about half way down the runway after failing to obtain an airspeed indication sufficient for takeoff. After cutting the power and lowering the nose…NTSB ATL83LA149Accident · No injuriesLimited investigationFinal reportCessna 172N · Jekyll Island, GAThe instructor, a canadian CFI, reported that the canadian student was operating the rudder peddles while he, the CFI, was handling the remaining acft controls. A second student plt was also on board, observing from a rear seat. After traveling aprx 800 ft on…NTSB ANC83LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe acft ground looped during a full stop landing. The pilot had completed several touch and go landings in this conventional gear acft. The touchdown of this last landing was normal but during rollout the acft veered to the left. The pilot stated that he…NTSB NYC83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe pilot had trouble with maintaining heading during the entire flight due to malfunction of the rudder trim. During landing, directional control was lost and the acft left the runway and collided with trees. An inspection of the rudder sys revealed…NTSB FTW83LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Odessa, TXReportedly, before landing, flt service advised that the wind was from 220 deg. While on an apch to rwy 20, the plt encountered severe buffeting. After touching down in a x-wind condition, the acft rolled aprx 300 ft, then encountered a gust of wind & drifted…NTSB FTW83LA173Accident · No injuriesLimited investigationFinal reportAnderson, Greenwood 51 · Tomball, TXThe plt was taxiing from the ramp & attempted to turn left onto a taxiway. The nose gear steering was not sufficient to make the turn, so he applied left brake. However, the left brake did not operate since the master cylinder was void of brake fluid. The…NTSB ANC83LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt of the ski equipped acft had taken off from an abandonded strip that was in a deteriorating condition with rocks scattered along the landing area. After arriving at his destination, he landed on a well graded rwy with packed snow that was suitable for…NTSB FTW83LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMDuring the landing roll, the plt lost directional control of the acft & it went off the right side of the rwy & hit an irrigation ditch. Reportedly, there was no acft malfunction or failure prior to the mishap.NTSB CHI83LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, OHThe aircraft swerved off the runway during takeoff and nosed down in the dried grass. The student pilot was taking off on the return leg of a cross-country when he lost directional control at a speed of about 40 KTS. The wind was 90 degrees at 9 KTS. The acft…NTSB ATL83LA147Accident · No injuriesLimited investigationFinal reportGrumman G164 A · New Church, VAThe acft swerved from a soft spot on the runway and left the runway. When the acft went into a plowed field the landing gear mired and the acft nosed over. The pilot could not see over the nose of the tailwheel acft to detect the soft spot in the runway. The…NTSB MIA83LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Daytona Beach, FLThe acft groundlooped and left the runway during a landing in strong cross-winds on a student cross-country flight. The student pilot had been endorsed to fly in winds of not greater than 12 KTS velocity but departed lakeland for Daytona Beach with the winds…NTSB LAX83LA156Accident · No injuriesLimited investigationFinal reportCessna 120 · Long Beach, CAAccording to the pilot during rollout after landing he was making a right turn into a taxiway when a ground loop occurred. The left main gear was sheared during the ground looped and the left wing broke at the strut.NTSB CHI83LA146Accident · No injuriesLimited investigationFinal reportStinson 108 · Rochester, INThe acft collided with a snow bank and nosed over during landing. The weather was VMC and the wind was from 210 degrees at 5 KTS. The pilot reported his right foot slipped off the the rudder pedal and 'attributes this to stinsons and many other acft were not…NTSB ATL83LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Mountain City, TNThe acft collided with a fence during landing after groundlooping. The pilot stated that during roll-out he experienced a gust of wind on the acft right side. An effort was made by the pilot to control the acft but it left the runway in spite of his efforts…NTSB NYC83LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Farmingdale, NJWhile taxiing to rwy 32 the plt attempted to stop after completion of a turn, but the brakes would not stop the acft. The plt used right rudder to avoid parked acft but was unable to maintain directional control. The acft went down an embankment, nosed over &…NTSB CHI83LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sandstone, MNThe pilot reported that soon after touchdown, the aircraft began to veer to the left and attempts to correct the situation failed. Subsequently, the aircraft impacted a snowbank and was damaged.NTSB MIA83LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Near Lakeland, FLThe acft swerved off the runway and collided with trees during landing, there were no injuries to the aircraft occupants. The pilot said he made a normal soft field landing on his private grass strip. When he passed the large treesthe wind pushed the acft to…NTSB DEN83FTE08Accident · No injuriesFinal reportMitsubishi MU-2B-40 · Fort Collins, COThe plt stated that the acft drifted left after touchdown. Props were brought to the beta range, & correction was added with right spoiler & right rudder. There was an immediate dropping or turning to the left & the acft hit a snowridge. Both engs were…NTSB FTW83LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Guthrie, OKThe pilot said he was waiting for an acft to clear the rwy. As he started to turn downfield for takeoff he pushed the throttle in, advancing the power instead of retarding it. The aircraft crossed the runway at an angle, became airborne and hit a tree. The…NTSB LAX83LA148Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dos Palos, CAAccording to the operator, the plt landed with a quartering tailwind & directional control was lost. The acft veered offthe rwy into soft mud & flipped over.NTSB LAX83LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Corcoran, CAAccording to the plt, he was taking off in a x-wind condition & allowed the acft to drift off the duster strip. He stated that he decided to continue the takeoff because of soft ground. The acft lifted off, then settled & the gear struck a levee. The plane…NTSB SEA83LA063Accident · No injuriesLimited investigationFinal reportGrumman 164B · Toppenish, WAThe aircraft nosed over in a ditch during a landing on a gravel road after an aerial application flight. The pilot said that he lost directional control during landing rollout and one main gear went into a ditch. The aircraft then nosed over and came to rest…NTSB FTW83LA157Accident · No injuriesLimited investigationFinal reportGulfstream Commander 695 · Houston, TXShortly after beginning the takeoff roll, the acft's right main gear ran off the right edge of the runway into soft wet grass. The soft ground appeared to cause the airplane to continue right and off the runway with takeoff power still applied. The acft…NTSB FTW83FA150Accident · 2 fatalField investigationFinal reportBeech A23-24 · Shawnee, OKThe plt departed his private, 1200 ft airstrip & flew to the Shawnee muni arpt with 1 passenger. During arrival on the return flt, he elected to land toward the south. According to a witness, there was a thunderstorm at that time aprx 1/2 to 1 mi…NTSB ATL83LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Jasper, ALAs the acft was taxiing on rwy 9 for a takeoff on rwy 27 the left main gear dropped off the rwy into soft terrain. The plt attempted to taxi back onto the rwy by turning the nose gear to get a better edge. Nevertheless, both the nose &left gear left the rwy &…NTSB ANC83LA057Accident · No injuriesLimited investigationFinal reportCessna TU206G · Glennallen, AKThe acft collided with a snowbank and ground looped during landing on a snow covered narrow runway. The pilot had been inactive in flying for several years and had recently purchased the accident acft. He had 9 hours dual and 3 hours solo in this acft. He…NTSB ATL83LA137Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Fort Belvoir, VAThe aircraft was being taxied to the runway for takeoff when it was overturned by the wind. Local weather station had issued a 'point warning' of winds at 25 KTS, gusting to 35 KTS. The aircraft was taxied from its protected place behind a hangar to an…NTSB DEN83LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe aircraft piloted by a solo student ran off the runway and nosed over in a snow bank during landing. The pilot was practicing short field landings. The accident occurred during the first touch and go. The landing was good and the pilotretracted flaps to 10…NTSB DEN83LA075Accident · No injuriesLimited investigationFinal reportCessna 170B · Douglas, WYThe plt had recently purchased the plane & had only 6 hrs of flt time in tailwheel equipped acft. He reported that during a landing, the acft bounced once, then touched down just left of the center of the rwy. He stated that the acft veered left, then he…NTSB CHI83LA132Accident · No injuriesLimited investigationFinal reportCessna 210 · Huntley, ILThe pilot stated he was aware of the cross wind so he used only 10 degrees of flaps. The acft began to drift while landing on runway 31. The pilot said he was holding 80 KTS on approach and as he started to flare the acft touched down hard on the rt main gear…NTSB DEN83LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Colorado Spgs, COThe student pilot made a steep and fast approach to land and bounced, landing hard on the right main and nose gear. The aircraft touched down a second time, in a left drift and departed the runway. When the left gear went into a snowbank and the pilot added…NTSB DEN83LA073Accident · No injuriesLimited investigationFinal reportCessna 172M · Leadville, COThe Cessna 172 collided with a snowbank during landing and nosed over. The weather was VMC with light winds from 20 degrees at 3 KTS. One inch of fresh snow was covering the runway. The pilot said he flew the approach to runway 34 with 20 degrees of flaps and…NTSB FTW83FA143Accident · No injuriesField investigationFinal reportRobinson R22 · Grand Prairie, TXThe plt & flt examiner were on an evaluation flt after the plt's flt instructor had recommended him for a CFI check flt. To demonstrate a hovering autorotation, the plt had selected an area of soft turf that slopted downhill. The examiner stated that after…NTSB SEA83LA061Accident · No injuriesLimited investigationFinal reportCessna C-150L · Near Bremerton, WAPilot landed on a wet muddy airstrip and lost directional control during rollout. The aircraft collided with an abandoned auto parked off the side of the runway. The pilot reported the field was wet/muddy and that an unexpected tailwind increased his landing…