Final NTSB investigations
4,370 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 329 |
|---|---|
| 2009 | 294 |
| 2010 | 256 |
| 2011 | 302 |
| 2012 | 303 |
| 2013 | 257 |
| 2014 | 287 |
| 2015 | 262 |
| 2016 | 246 |
| 2017 | 254 |
| 2018 | 226 |
| 2019 | 225 |
| 2020 | 224 |
| 2021 | 223 |
| 2022 | 200 |
| 2023 | 181 |
| 2024 | 173 |
| 2025 | 91 |
| 2026 | 37 |
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' 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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' 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 ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB CEN26LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Algona, IAThe pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall.NTSB WPR26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRans S7 · Kemmerer, WYThe pilot’s decision to perform a take-off in high-density-altitude, gusting-crosswind conditions, which resulted in an aerodynamic stall, hard landing and subsequent nose-over.NTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…NTSB WPR26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportBell 47G · Springtown, TXThe pilot’s failure to maintain clearance from trees while in a low hover.NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB ERA26LA236Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC19-215 · Plymouth, NHThe pilot’s failure to maintain control of the airplane during an aborted landing attempt which resulted in an aerodynamic stall.NTSB ERA26LA240Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Westminster, MDThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA209Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Jonesboro, ARThe student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an…NTSB WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.NTSB CEN26LA201Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172H · Berryville, ARThe pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.NTSB WPR26LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206-L4 · Cedar City, UTThe flight instructor's failure to maintain helicopter control while manipulating the engine governor reference rpm adjustment during hover operations, which resulted in a loss of control and impact with the ground.NTSB CEN26LA198Accident · No injuriesClass 4 · LimitedFinal reportCommander 114TC · Woodruff, WIThe pilot’s failure to maintain airplane control during the go-around.NTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.NTSB CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB ANC26LA031Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Lapeer, MIThe flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…NTSB CEN26LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sherman, TXThe pilot's failure to maintain airplane control during recovery from a bounced landing.NTSB ANC26LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Centennial, COThe student pilot’s failure to maintain adequate airspeed during the flare which resulted in the airplane exceeding its critical angle of attack and aerodynamic stall at a low altitude and loss of airplane control.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 WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.NTSB CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.NTSB CEN26LA154Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28F · Oelwein, IAThe pilot's failure to maintain directional control during the hover taxi with a quartering tailwind.NTSB ERA26LA147Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA24-180 · Leonardtown, MDThe pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.NTSB CEN26LA134Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Sonora, TXThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.NTSB ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Monroe, NCThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA26LA119Accident · No injuriesClass 4 · LimitedFinal reportTabor W Coates AR-1 · Kissimmee, FLThe pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control.NTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.NTSB WPR26LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206L-3 · Logsden, ORThe inadvertent entanglement of a long line with the skid, which resulted in a loss of flight control. Contributing to the accident was the use of nylon lines instead of steel cables to secure the bucket.NTSB CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.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 CEN26LA063Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20E · Gonzales, LAThe pilot’s improper pitch control that resulted in a hard landing, and his improper recovery from multiple bounced landings. Contributing to the accident was the safety pilot’s delayed response to the initial bounced landing which led to the runway excursion.NTSB WPR26LA055Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Eureka, MTThe pilot’s failure to maintain directional control during landing in crosswind conditions. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA26LA060Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters Carbon Cub FX2 · Okeechobee, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB CEN26LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Downers Grove, ILThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB ERA26LA044Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Eastpoint, FLThe pilot’s loss of airplane control during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper recovery from an aerodynamic stall.NTSB ERA26LA047Accident · Minor injuriesClass 4 · LimitedFinal reportTorres Ruben Aventura II · Culebrita Beach, PRThe pilot's failure to maintain directional control during the initial climb, which resulted in abnormal contact with the water and a subsequent collision with vegetation.NTSB WPR26LA053Accident · Serious injuriesClass 4 · LimitedFinal reportTecnam P2008 · Blackfoot, IDThe student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night.NTSB ERA26LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxford, CTThe pilot’s failure to compensate for gusty crosswind conditions, which resulted in a loss of control of the airplane and subsequent collision with terrain.NTSB ERA26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · St. Augustine, FLThe student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.NTSB DCA26FA019Accident · No injuriesClass 4 · FieldFinal reportAir Vev AIR ZERO2 · Indiantown, FLA cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.