NTSB investigations
181 cases where the first occurrence was “Roll over”.
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\" = 380) 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" = 380) 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 MIA84LA248Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Palm Bch, FLThe plt stated that he had flown the acft from one fixed base operator on the arpt to another to position the acft. He stated that he put friction on the cyclic control but not the collective control, reduced throttle to flt idle, and exited the acft. He was…NTSB MIA84LA238Accident · Minor injuriesLimited investigationFinal reportBell 206B · Ocoee, FLThe acft rolled over during an attempted takeoff when one skid became stuck in the soft terrain. The plt had landed to deplane a passenger and upon attempting to takeoff the plt found one skid was stuck. The plt continued to apply takeoff power and the acft…NTSB FTW84LA308Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Henderson, TXThe instructor plt stated that the student plt landed the helicopter. As the helicopter touched down and was still light on its skids the student applied left cyclic control and the helicopter started to roll towards the left. The student plt froze on the…NTSB ANC84LA087Accident · No injuriesLimited investigationFinal reportCessna A188B · Kantishna, AKThe acft encountered uneven terrain during landing & rolled over. There were no acft malfunctions according to the plt. The plt to date has not filed an accident report. In a telephonic interview he said he encountered the uneven terrain during landing…NTSB CHI84LA211Accident · Serious injuriesLimited investigationFinal reportBell 47G · Drummond Island, MIThe plt had previously made 2 local flts, during which, he practiced water landings & takeoffs as well as other maneuvers. On the 3rd flt, he made several water takeoffs & landings. Then while on a landing, the helicopter began to roll quickly to the right.…NTSB SEA84LA091Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Buxton, ORThe helicopter entered an uncontrolled right roll while lifting off from a trailer & struck the ground with the m/r. the plt reported the trailer was not level.NTSB DEN84LA110Accident · No injuriesLimited investigationFinal reportHiller FH 1100 · Provo, UTThe acft was landed in soggy terrain and the right skid sank into the surface. One of the occupants of the helicopter deplaned to'lighten the load'and the plt overcorrected in an attempt to takeoff. The acrt rolled over onto its left side.NTSB NYC84LA093Accident · No injuriesLimited investigationFinal reportBell 206B · Tarentum, PADuring a practice flt the plt tried to lift off but the right skid seemed to stick. The acrt rolled to the right and although the plt stated he took corrective action the acft rolled over onto its right side.NTSB DEN84FA102Accident · 1 fatalField investigationFinal reportBell 206B-III · Coalville, UTThe helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…NTSB LAX84LA173Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Riverside, CAThe acc occurred when the prospective buyer plt started to pick up the rotorcraft with too much aft cyclic. The rt rear skid dug into the ground and the acft rolled over.NTSB NYC84LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashua, NHThe helicopter left skid hooked on the guard rail as takeoff began from a trailer. As the plt continued to increase power to lift, the acft rolled over and the main rotor hit the hood of the tractor.NTSB ATL84LA046Accident · No injuriesLimited investigationFinal reportBell 47-G · Middle River, MDWhile practicing hovering about 2 ft AGL the student allowed the helicoper to start drifting aft & right. The right skid heel contacted the ground & the helicopter roll onto its right side.NTSB MKC83FA196Accident · Serious injuriesField investigationFinal reportBell 47G-3B · Paxton, NEThe plt stated that after landing on a truck platform, he did not decrease rotor RPM & did not lower collective to flat pitch as he was attempting to recover a piece of paper that had fallen to the floor on the right side of the cockpit. As he released the…NTSB NYC83LA206Accident · No injuriesLimited investigationFinal reportHughes 269C · Spring House, PAThe helicopter rolled over during a practice demonstration autorotation landing. The CFI was at the controls with the student following through. According to the instructor the student overrode the controls just prior to touchdown with too much cyclic. The…NTSB SEA83LA083Accident · No injuriesLimited investigationFinal reportHiller 12-E · Near Nordm, IDThe aircraft broke through crusted snow on a county road during landing and rolled over. The helicopter was on a business flight and the pilot did not claim any mechanical discrepancies. The weather was VMC and none of the 3 occupants were injured. The snow…NTSB DEN83LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Belfield, NDThe helicopter rolled over on a slight slope in an open field during a landing. The pilot stated that the acft touched down on the left skid, the acft started to tip to the left and he over corrected so that the acft rolled over to the right.NTSB SEA83LA153Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2 · Rogue River, ORThe helicopter rolled over during lift off with pilot and one passenger and a full load of fuel. On a previous flt with one passenger and 8 gallons of fuel the pilot had noticed the left skid was about 8 inches lower than the right during lift off. On the day…NTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…NTSB SEA83LA069Accident · No injuriesLimited investigationFinal reportContinental Copters Mkiii · Pasco, WAWhile repositioning the helicopter from the ground onto a trailer the acft rolled over when the right skid caught onto the trailer.NTSB FTW83LA099Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Isle B43qDue to the location of a gas separator, the plt started to takeoff from an oil rig platform with a left cross- wind at aprx 30 KTS, gusting 35 to 40 KTS. After lifting off to a hover, wind gusts were encountered. The plt reported that the acft turned 10 to 15…NTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…NTSB FTW82DA381Accident · Minor injuriesFinal reportRobinson R-22 · Austin, TXDuring practice autorotation with power recovery student was late in applying power and aircraft touched down and rolled over. Instructor tried to recover but was also too late in application of remedial action.NTSB MKC83LA012Accident · No injuriesLimited investigationFinal reportCessna 150 · Nichols, IAThe pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over.NTSB LAX82FA343Accident · Serious injuriesField investigationFinal reportHughes 269C · North Highlands, CAThe purpose of the flight was to conduct a rotorcraft/helicopter certified flight instructor (CFI) check ride for the pilot-in-command (PIC). The check pilot was an FAA inspector with no previous flight time in this make and model; however, he had 1816 hrs…NTSB MIA82DA167Accident · Minor injuriesFinal reportBell 206B · Miami, FLThis was an instructional flight for recurrent training and involved an external load operation with a 10 ft line. While preparing to pick up an 800 lb load, the helicopter was maneuvered over the object with slack in the line. The instructor observed that…NTSB MIA82DA125Accident · No injuriesFinal reportBell 47J-2A · Marathon, FLThe pilot reported that an intermittent vibration was felt during the magneto check before takeoff. During a second magneto check at high power, the nose of the helicopter came up, a loud explosive noise was heard, and a fire erupted near the left fuel tank.…NTSB FTW82DA192Accident · Minor injuriesFinal reportRobinson R22 · Ada, OKThis was a commercial certification check flight for the pilot-in-command. After completing normal hovering maneuvers, the examiner instructed the pilot to execute a hovering autorotation over a level area of grass. The pilot rolled the throttle off on a…NTSB LAX82DA133Accident · No injuriesFinal reportRobinson R-22 · Mesa, AZAfter landing in a practice area the instructor told the student to pick the helicopter up to a hover. The aircraft lifted off the ground to approximately 5 feet and yawed to the right 45 degrees. As the instructor applied left pedal and lowered collective…NTSB ATL82DA091Accident · No injuriesFinal reportCessna 172 · Chantilly, VAThe pilot flew into an area of high forecast winds and altered his destination as a precaution. However, he failed to ask for or take precautionary measures after landing and the aircraft was blown over while taxiing.NTSB SEA82DA077Accident · No injuriesFinal reportRobinson R-22 · Hillsboro, ORThe instructor pilot was demonstrating a hovering autorotation to the student from approximately an 18 inch altitude. Shortly after touchdown, which was level and without movement in any direction, the aircraft started to roll to the left. The pilot reported…NTSB FTW82DA073Accident · No injuriesFinal reportBell 47G · Dallas, TXThe pilot attempted to land on a narrow flatbed trailer. He stated that he encountered some buffeting from the wind funneling between two hangars. On his third attempt to position the helicopter on the trailer, the right skid slipped off. The main rotor…