NTSB investigations
261 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 13 |
| 2012 | 18 |
| 2013 | 12 |
| 2014 | 19 |
| 2015 | 19 |
| 2016 | 13 |
| 2017 | 17 |
| 2018 | 34 |
| 2019 | 20 |
| 2020 | 7 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 6 |
| 2025 | 6 |
| 2026 | 8 |
Where
Open the mapLatest cases
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN27LA026Accident · No injuriesClass 4 · LimitedInvestigation openPiper J3C-65 · Eagle Harbor, MINTSB CEN26LA238Accident · 1 fatalClass 3 · LimitedPreliminary reportAirborne Windsports PTY Edge XT-912-L · Winona, MNOn June 25, 2026, about 2000 central daylight time, an Airborne Windsports Pty Ltd Edge Xt-912-L weight-shift-control light sport aircraft, N912CV was substantially damaged when it was involved in an accident at Winona Municipal Airport (ONA) Winona,…NTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR26LA175Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Prineville, ORThe pilot's inability to maintain directional control during the landing roll due to a flat tire.NTSB CEN26LA168Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mount Blanco, TXThe pilot’s failure to maintain proper main rotor rpm during a low-level turn, which resulted in the main rotor rpm drooping, a loss of control at an altitude too low for recovery, and a subsequent impact with terrain.NTSB WPR26LA137Accident · No injuriesClass 4 · LimitedFinal reportSalt Lake Gyrocopters Calidus · Fairfield, UTThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was nose wheel misalignment at touchdown.NTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB ERA26LA094Accident · Minor injuriesClass 4 · LimitedFinal reportSled Thomas Helicycle · Mobile, ALThe pilot’s failure to maintain yaw control during a crosswind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, hard landing, and subsequent rollover.NTSB CEN26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe flight instructor’s inadequate supervision during the approach and delayed remedial action, which resulted in a loss of control.NTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB WPR25LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon pilot’s improper landing, which resulted in serious injury to a passenger. Contributing to the accident was the pilot’s failure to brief the proper landing procedure.NTSB WPR25LA222Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Rotorsport UK Cavalon · Hurricane, UTThe pilot’s failure to maintain pitch control during takeoff, which resulted in an unintended liftoff from the runway and a subsequent loss of control.NTSB ANC25LA034Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182B · Girdwood, AKThe pilot's decision to land on an unsuitable landing surface, which resulted in a nose-over.NTSB ENG25WA033Accident · Serious injuriesClass 5 · ForeignBell 505 · Petersgrat Mountain, SwitzerlandNTSB CEN25LA046Accident · Serious injuriesClass 4 · LimitedFinal reportRotor Flight Dynamics Dominator · Gilbert, MNA total loss of engine power and subsequent autorotation to a swamp, that resulted in a rollover. Contributing to the pilot’s delayed egression from the gyroplane, was the lack of a restraint system cutting device.NTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaNTSB CEN24LA303Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Bryant, IAA loss of engine power during takeoff for reasons that could not be determined, resulting in impact with terrain.NTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.NTSB ERA24LA236Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Gilbertsville, KYThe pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.NTSB CEN24LA184Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22 · Enderlin, NDThe pilot’s failure to properly inspect and sump the fuel system before the flight and the maintenance personnel’s inadequate maintenance of the fuel system which resulted in fuel starvation and the subsequent loss of engine power due to the contamination of…NTSB CEN24LA066Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Searcy, ARThe pilot-rated passenger’s reported failure to maintain control during the landing.NTSB CEN24LA038Accident · Minor injuriesClass 3 · LimitedFinal reportBede BD-4 · Lowell, INFatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…NTSB ERA23LA287Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCThe pilot’s failure to maintain control of the helicopter during a hover taxi, which resulted in a rollover.NTSB WPR23LA269Accident · Minor injuriesClass 3 · LimitedFinal reportCSP Leasing MTO Sport · Gardiner, MTFailure of the rudder/nosewheel steering system for reasons that could not be determined, which resulted in loss of yaw control and a subsequent rollover.NTSB ERA23LA233Accident · Minor injuriesClass 4 · LimitedFinal reportRotorway Exec · Akron, OHThe non-certificated pilot’s failure to maintain control of the unregistered helicopter during landing.NTSB WPR23LA147Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Midway, UTThe pilot’s failure to maintain aircraft control during a pinnacle landing that resulted in a hard landing and subsequent roll over.NTSB CEN23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Wade, OKThe total loss of engine power due to fuel contamination.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA048Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Oxford, COThe designated pilot examiner’s failure to maintain a proper descent during a practice 180° autorotation which resulted in a hard landing.NTSB ERA23LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe pilot’s misjudged landing point which resulted in a loss of control and collision with terrain.NTSB WPR22LA329Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Clipper 1 · Deadhorse, AKThe pilot's failure to maintain helicopter control during a descent, which resulted in a collision with terrain.NTSB ANC22LA023Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 BA · Valdez, AKThe pilot's failure to maintain a proper approach path in flat light conditions, which resulted in landing short of the intended landing spot and impact with terrain.NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.NTSB ANC21LA080Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pelican, AKThe pilot’s loss of control while landing on a remote helipad.NTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.NTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.NTSB GAA21WA098Accident · No injuriesClass 5 · ForeignRobinson R44 · Región de Ñuble, ChileNTSB CEN21LA169Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Pottsboro, TXThe pilot failure to maintain directional control of the helicopter when it encountered an unanticipated wind allowing it to drift into a fence and subsequently roll over and impact terrain.NTSB GAA21WA069Accident · No injuriesClass 5 · ForeignRotorway Exec · Ledbury, Herefordshire, United KingdomNTSB ERA21LA121Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Knoxville, TNThe pilot’s failure to maintain directional control of the helicopter, which resulted in rear portion of the right skid contacting the ground and a subsequent dynamic rollover.NTSB ERA21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportEnstrom 480 · Woodstock, CTThe pilot’s failure to maintain control of the helicopter while attempting to land on a trailer in gusting wind conditions, which resulted in a dynamic rollover.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB ERA20CA104Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.NTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.NTSB CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…NTSB WPR20LA007Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH 12E · Susanville, CAA partial loss of engine power due to multiple overtemperature events and a hot start event, which resulted in thermally damaged internal components of the engine. Contributing to the accident was the lack of suitable terrain on which to perform the forced…