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 ANC94LA064Accident · No injuriesLimited investigationFinal reportHiller FH1100 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing which resulted in a dynamic rollover. A factor was the soft landing area selected.NTSB MIA94LA049Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dorado, PRThe flight instructor's inadequate supervision of the student and failing to follow the procedures in the flight training guide.NTSB BFO94LA020Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Rockland, ME1) The pilot's failure to maintain adequate rotor RPM, 2) the pilot's failure to maintain directional control on landing, resulting in a dynamic rollover.NTSB LAX94LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sacramento, CAImproper remedial action by the student pilot. Lack of total experience is a factor.NTSB ATL94LA009Accident · No injuriesLimited investigationFinal reportBell 47G2 · Billingsley, ALThe pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.NTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerNTSB MIA93LA050Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Lantana, FLThe pilot-in-command's failure to assure that the helicopter was properly positioned on the landing platform.NTSB LAX92LA333Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Pacific Ocean (Pacific Ocean)The pilot's inadequate preflight inspection by failing to untie the front skid tiedown rope.NTSB LAX92LA254Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Waikoloa, HIFailure of the rear landing gear cross tube due to corrosion.NTSB LAX92LA245Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Hanford, CAThe pilot's failure to maintain rotor RPM during the takeoff. Contributing factors were: the pilot's lack of familiarity with the aircraft and unfavorable winds that existed at the time of takeoff.NTSB BFO92LA062Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Middleboro, MAThe pilot's failure to release a tie down strap from the helicopter's skid during the preflight.NTSB ANC92LA065Accident · Minor injuriesLimited investigationFinal reportBell B206 II · Valdez, AKThe pilot's failure to follow the company procedures and directives. Factor was the whiteout conditions.NTSB NYC92LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Columbus, OHThe pilot's improper preflight of the helicopter, which resulted in a tie down strap not being removed prior to attempted flight, and the subsequent roll over and collision with the ramp.NTSB LAX92LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe pilot's inadequate compensation for wind conditions, his failure to arrest the descent rate in a timely fashion, and the selection of unsuitable terrain on which to practice autorotations.NTSB LAX92LA114Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · San Ardo, CAThe pilot's decision to land in a plowed field made soft from winter rain shower activity.NTSB LAX92LA030Accident · 1 fatalLimited investigationFinal reportBell 47-G5A · KosraeThe pilot-in-command's improper preflight inspection of the helicopter resulting in a tiedown strap not being removed from the right skid and subsequent roll over on takeoff.NTSB LAX91LA407Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Livermore, CA1) Incorrect control input by the student pilot and 2) the flight instructor's inadequate supervision of his student. A contributing factor in this accident was the unfavorable wind conditions.NTSB LAX91LA307Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · El Cerrito, CAThe instructor pilot's improper slope takeoff technique.NTSB ANC91FA001Accident · Serious injuriesField investigationFinal reportHughes 500D · Kennsington, AKThe loss of control during takeoff due to dynamic rollover. Contributing to the accident was the pilot-in-command's selection of an uneven landing area.NTSB LAX90LA335Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Beatty, NVThe pilot's selection of unsuitable terrain on which to land. Loose shale rock and sloping downhill terrain were factors in the accident.NTSB LAX90LA303Accident · No injuriesLimited investigationFinal reportHughes 369D · Santa Monica, CAThe pilot's decision to exit the helicopter with the engine running and no one at the controls.NTSB ANC90LA119Accident · No injuriesLimited investigationFinal reportBell 206B · Goodnews Bay, AKThe pilot selected unsuitable terrain. The wet & soft tundra was a factor.NTSB LAX90LA210Accident · No injuriesLimited investigationFinal reportHughes 269B · Paso Robles, CAThis accident was dynamic rollover due to the terrain slope exceeding the capability of the helicopter.NTSB LAX90LA186Accident · Minor injuriesLimited investigationFinal reportHughes 269A · La Verne, CAGround resonance due to an inadequately maintained strut.NTSB MKC90LA117Accident · Serious injuriesLimited investigationFinal reportBell 47G · Wynne, ARLanding gear skid entangled with a fuel hose. A factor was the pilot's inadequate preflight inspection.NTSB ATL90LA112Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Chamblee, GAFailure of the student (rated) pilot to maintain control of the helicopter, and insufficient supervision by the instructor pilot (CFI).NTSB FTW90LA107Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaplan, LARestricted movement of the right skid assembly causing the lateral center of gravity to be exceeded during the attempted take off.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB LAX90LA091Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corona, CAHelicopter rolling over in a dirt field after the pilot was demonstrating an engine faiure and autorotation maneuver.NTSB FTW90LA061Accident · No injuriesLimited investigationFinal reportRobinson R22 · San Angelo, TXInadequate preflight by the pilot by not identifying and removing the tie-down.NTSB FTW90LA007Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · High Island 474 (Gulf of Mexico)The pilot's attempted takeoff with one tie-down strap still attached to the helicopter which resulted from an inadequatepreflight inspection of the aircraft.NTSB MKC89LA178Accident · No injuriesLimited investigationFinal reportBell 206B · Marys Home, MOThe failure of the pilot to maintain control of the helicopter.NTSB FTW89LA079Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Padre Island, TXThe pilot's decision to fly in adverse weather condition. The adverse weather was a related factor.NTSB FTW89LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Chalmette, LAThe rated pilot's inadequate takeoff technique the the instructor pilot's momentary lack of judgement in having the pilot attempt a hydraulics off takeoff.NTSB NYC88LA204Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Teterboro, NJThe S-76 helicopter was taxiing on its company ramp when the copilot taxied onto a grass area. During a left turn the right main wheel stuck in a soft spot and the helicopter rolled over on its right side receiving substantial damage. The ground maneuver that…NTSB SEA88LA127Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot purchased the helicopter with an undocumented modification designed to restrain the collective. Reportedly, hereceived no guidance regarding the use of the collective hold-down device. According to the aircraft manufacturer there existed no Enstrom…NTSB ANC88LA086Accident · No injuriesLimited investigationFinal reportHughes 369D · Kitoi Bay, AKThe helicopter landed with the left skid against a survey stake which protruded from the ground about 6 inches. Upon liftoff the skid did not clear the metal stake before the helicopter started moving laterally to the left. The left skid remained against the…NTSB SEA88LA064Accident · Serious injuriesLimited investigationFinal reportMarlow Hilyard Executive · Elko, NVThe pilot made a landing on sloping terrain. The gyrocopter rolled to the left with the main rotor striking sage brush. The engine was twisted from its mounts rupturing a fuel line. A fire resulted consuming the gyrocopter. The pilot did not hold a pilot or…NTSB FTW88LA073Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Decatur, TXThe non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…NTSB LAX88FA085Accident · 1 fatalField investigationFinal reportBell 47G-2A1 · San Diego, CAPilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.NTSB DEN87LA189Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Red Lodge, MTThe plt said he was getting ready to take off from a 9400-FT MSL landing zone a top a mountain 7 mi ssw of Red Lodge, MT. The plat said the helicopter was positioned on a slight north-south slope and pointed towards the west. The wind was from the south…NTSB ATL87DEI05Accident · Minor injuriesFinal reportBell 47G-2 · Lisbon, OHThe helicopter rolled over as it was lifting off from a transport trailer. A post-crash exam revealed that the left rear tie-down strap on the trailer was wrapped around one of the helicopter skids. The ground crewman believed he had removed all of the straps…NTSB LAX87DUJ05Accident · No injuriesFinal reportHiller UH-12E · Tolleson, AZThe plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with…NTSB ANC86LA096Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Alexander Creek, AKWhile landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over.NTSB MIA86LA147Accident · No injuriesLimited investigationFinal reportHughes 269C · Jacksonville, FLThe plt stated that as he was landing on a dolly, the helicopter experienced ground resonance & began to shake violently. It then rolled over on its side, causing the main rotor blades to strike the tail boom & the ground.NTSB LAX86FUG04Accident · No injuriesFinal reportRotorway Scorpion 133 · Corona, CAThe plt stated he was 'running up the engine' after making some adjustments. The helicopter was tied down when the plt lifted off to a 5 to 6 ft hover. The helicopter tipped to the right, the main rotor blades contacted the terrain and the helicopter rolled…NTSB DEN86LA082Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Meeker, CODuring the lift off the right skid toe of the helicopter caught a seismic cable which was covered by aprx 2 ft of snow. The plt stated he brought the acft to a hover after off loading 2 pax & started a right sideward hover. When the slack was out of the…NTSB NYC85LA221Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ronkonkoma, NYDuring a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an…NTSB CHI85LA254Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Lakeville, MNThe acft was being landed on a trailer for transportation. Upon touchdown the right skid hooked on the landing guides and the helicopter rolled to the right side. The main rotor blades struck the ground, the left fuel tank ruptured and an explosion and fire…NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.