NTSB investigations
242 cases where NTSB found Descent rate.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 12 |
| 2014 | 10 |
| 2015 | 22 |
| 2016 | 21 |
| 2017 | 15 |
| 2018 | 11 |
| 2019 | 21 |
| 2020 | 21 |
| 2021 | 14 |
| 2022 | 19 |
| 2023 | 9 |
| 2024 | 9 |
| 2025 | 13 |
| 2026 | 2 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062037')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062037')) 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 CEN26LA297Accident · Minor injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Searcy, ARThe flight instructor’s failure to maintain airplane control during landing in gusting wind conditions.NTSB DCA26LA285Accident · No injuriesClass 4 · LimitedFinal reportLeigh Aerosystems E100 · Douglas, AZDegraded engine and propeller performance during hot and high-density altitude operations, which resulted in a high descent rate and subsequent hard landing.NTSB ERA26LA075Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Hawthorne, FLThe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB WPR26LA052Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon landing in increased wind, and the pilot’s inability to maintain the proper descent rate, which resulted in a hard landing.NTSB ERA26LA048Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Cookeville, TNThe pilot’s failure to maintain an appropriate decent rate during approach, resulting in a hard landing.NTSB CEN26LA047Accident · No injuriesClass 4 · LimitedFinal reportEngineering & Research 415 · Sheboygan Falls, WIThe flight instructor’s failure to arrest the airplane’s descent rate during a takeoff simulated engine failure which resulted in a hard landing.NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.NTSB ERA25LA379Accident · No injuriesClass 4 · LimitedFinal reportMccaa Robert T Avid/Kitfox Flyer · Oakland, PAThe pilot/owner’s failure to accurately determine the airplane’s weight and performance limitations before initiating the takeoff. Contributing to the outcome was the flight instructor’s improper engine power management and landing flare, which resulted in a…NTSB ERA25LA341Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Beaver Cove, METhe pilot’s distraction and failure to monitor the airplane’s flight path, which resulted in controlled flight into a lake.NTSB ANC25LA099Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Petersville, AKThe pilot’s exceedance of the helicopter’s available power while landing in a remote confined area, which resulted in rotor droop and a hard landing.NTSB CEN25LA381Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe manufacturer flight instructor’s failure to maintain proper airspeed and a proper descent rate during a demonstrated hover out of ground effect (HOGE) autorotation, which resulted in a hard landing. Contributing to the accident was the manufacturer flight…NTSB WPR25LA189Accident · No injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · San Luis, AZThe pilot receiving instruction’s failure to properly recover the helicopter during an autorotative landing and the instructor pilot’s failure to intervene, which resulted in a hard landing.NTSB ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.NTSB ANC25LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Trapper Creek, AKThe pilot’s improper flare while landing on glassy water, which resulted in a hard landing.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB WPR25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201T · Placerville, CAThe pilot’s failure to maintain an adequate descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.NTSB CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.NTSB ERA24LA387Accident · Minor injuriesClass 3 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Canandaigua, NYThe pilot’s excessive descent rate during the final approach for landing and his delayed recovery attempt, resulting in a hard landing.NTSB CEN24LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Colorado Springs, COThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing.NTSB WPR24LA245Accident · Serious injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26Z · Casper, WYThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in the pilot’s ejection from the basket and serious injury.NTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.NTSB ERA24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Holt, FLThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a hard landing and subsequent nose over of the airplane.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB CEN24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7-15 · Albany, TXThe pilot’s failure to maintain a proper descent rate during the landing approach in a high wind condition.NTSB CEN24FA064Accident · 2 fatalClass 3 · FieldFinal reportPilatus PC-12/45 · Christoval, TXThe instrument-rated pilot and a passenger departed on an instrument flight rules (IFR) flight. After about 4.5 hours, while approaching the first planned fuel stop, the airplane was in instrument meteorological conditions (IMC). According to air traffic…NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB CEN23LA293Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Canandaigua, NYThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing, the passenger’s leg hitting the gas tank, and serious injury.NTSB ERA23LA291Accident · No injuriesClass 4 · LimitedFinal reportVolato 400 · Dublin, GAThe pilot’s improper landing flare which resulted in a runway undershoot and a hard landing, which substantially damaged the airplane’s firewall.NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.NTSB ERA23LA157Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Livonia, NYThe pilot’s delayed action to arrest the high descent rate during a practice autorotation in tailwind conditions which ultimately resulted in loss of control.NTSB ERA23LA146Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Titusville, FLThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing and subsequent rotor blade strike of the tail boom.NTSB ERA23LA140Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Lake Katrine, NYThe pilot’s failure to maintain an appropriate pitch attitude and descent rate during landing, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Mesa, AZThe flight instructor’s failure to maintain control of the helicopter’s rate of descent, resulting in a hard landing.NTSB ERA22LA423Accident · Serious injuriesClass 4 · LimitedFinal reportKumhyr David B Vans RV-8A · Elberta, ALThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a loss of control and subsequent nose over during landing.NTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.NTSB ERA22LA402Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206G · Millinocket, METhe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB CEN22LA404Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Beardsley, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with terrain.NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB WPR22LA300Accident · No injuriesClass 4 · LimitedFinal reportHoffman David J Murphy Elite · Manley Hot Springs, AKThe pilot’s unstable approach to land, which resulted in a hard landing.NTSB ERA22LA357Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Leghighton, PAThe pilot’s improper recovery from a bounced landing on a slope, which resulted in dynamic rollover.NTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.NTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…NTSB WPR22LA261Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA342J · Escalante, UTThe pilot's failure to control the helicopter’s descent rate during landing, which resulted in collision with terrain.NTSB ERA22LA342Accident · No injuriesClass 4 · LimitedFinal reportMesserschmitt-Boelkow-Blohm BO_105S · Daytona Beach, FLThe pilot’s rapid reduction of collective following an in-flight loss of control while lifting from a dolly resulting in a hard landing. Contributing to the loss of control was the pilot’s likely inadequate left anti-torque control pedal input during initial…NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB CEN22LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Yoakum, TXThe pilot's loss of helicopter control on approach to land due to a settling with power condition, which resulted in a hard landing.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.