NTSB investigations, 2009
137 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 166 |
|---|---|
| 2009 | 137 |
| 2010 | 128 |
| 2011 | 133 |
| 2012 | 128 |
| 2013 | 115 |
| 2014 | 109 |
| 2015 | 109 |
| 2016 | 128 |
| 2017 | 127 |
| 2018 | 116 |
| 2019 | 108 |
| 2020 | 86 |
| 2021 | 96 |
| 2022 | 102 |
| 2023 | 91 |
| 2024 | 95 |
| 2025 | 70 |
| 2026 | 58 |
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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' 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 year(c."eventDate") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' 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 CEN10LA078Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron Canada 407 · Decatur, TXThe pilot's inadequate preflight inspection and the momentary loss of engine power due to snow or ice ingestion.NTSB ANC10CA010Accident · No injuriesData collectionFinal reportStinson 108-1 · Selawik, AKThe pilot's failure to maintain a proper descent rate during landing, resulting in a hard landing.NTSB WPR10WA148Accident · Serious injuriesForeign investigationRobinson R-44 · Montreal, Canada, CanadaOn December 16, 2009, at 0720 eastern standard time, a Robinson R-44, Canadian registered C-GDSF, executed an emergency landing near the Bonaventure Highway, in Montreal, Canada. The pilot and passenger were seriously injured, and the helicopter was…NTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…NTSB WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR10CA086Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Nogales, AZThe student's improper landing flare and the flight instructor's inadequate remedial action.NTSB WPR10CA077Accident · No injuriesData collectionFinal reportPilatus Britten-Norman BN-2B-26 · Pago Pago, AntarcticaThe pilot's action to maneuver the airplane to avoid a collision with a flock of birds while on final approach, resulting in a hard landing. Contributing to the accident were the birds.NTSB ERA10CA075Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lebanon, PAThe pilot’s failure to arrest the helicopter descent during the simulated engine out maneuver resulting in a hard landing.NTSB ERA10CA069Accident · No injuriesData collectionFinal reportParadise USA Paradise P-1 Slsa LW · Plant City, FLThe pilot's improper flare while landing, which resulted in a hard landing.NTSB WPR10CA058Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-250 · Napa, CAThe pilot's encounter with variable winds which resulted in a hard landing and passenger injury.NTSB WPR10CA054Accident · No injuriesData collectionFinal reportCirrus SR20 · Santa Barbara, CAThe pilot's improper flare, which resulted in a hard landing and porpoise pilot induced oscillation.NTSB WPR10CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Marsing, IDThe pilot's failure to maintain adequate main rotor rpm during the approach and subsequent go-around and the certified flight instructor's inadequate supervision of the flight.NTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.NTSB WPR10CA037Accident · No injuriesData collectionFinal reportSocata TB200 · Edwards, CAThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the sunglare.NTSB WPR10FA029Accident · No injuriesField investigationFinal reportAgusta A119 · Blythe, CAThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10CA028Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Marana, AZThe improper use of the throttle by the pilot receiving instruction, and the check pilot's inadequate supervision and delayed remedial action, which resulted in the collision with terrain.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB ERA10LA023Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Winnsboro, SCThe flight instructor's failure to monitor the simulated emergency procedure, resulting in a hard landing. Contributing to the accident was the intentional throttle application by one of the flightcrew.NTSB CEN10CA022Accident · Serious injuriesData collectionFinal reportGottelt Herbert R Kitfox IV/ · Crystal Falls, MIThe pilot's inability to maintain control due to an undetermined problem affecting lateral control of the airplane.NTSB WPR10TA025Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 500N · Los Alamitos, CAThe flight instructor's delayed remedial action during the instructional autorotative landing, which resulted in a failure to maintain an adequate rotor rpm to avoid a hard landing.NTSB WPR10TA016Accident · Minor injuriesFinal reportMD Helicopter 600 · San Diego, CAThe pilot's failure to maintain adequate main rotor rpm during an autorotation, which resulted in a hard landing.NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.NTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.NTSB CEN10CA017Accident · Serious injuriesData collectionFinal reportCameron Z77 · Albuquerque, NMThe pilot’s failure to maintain control of the balloon during the approach and landing.NTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…NTSB ANC09LA110Accident · No injuriesLimited investigationFinal reportHughes 369A (OH-6A) · Palmer, AKA partial loss of engine power after take off for an undetermined reason, which resulted in a hard landing.NTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.NTSB WPR09FA464Accident · No injuriesField investigationFinal reportEurocopter AS 350 B3 · Tucson, AZThe loss of directional control for undetermined reasons.NTSB DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB WPR09CA462Accident · No injuriesData collectionFinal reportAgusta A109 · Page, AZA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning and his decision to continue flight with a known low fuel level state.NTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.NTSB WPR09CA448Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Irvine, CAThe flight instructor's failure to maintain an adequate airspeed and his delayed recovery action during the practice autorotation, which resulted in a hard landing.NTSB WPR09LA445Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Chemehuevi Valley, CAThe pilot's improper flare while landing with a tailwind, resulting in a bounced landing.NTSB ANC09CA093Accident · No injuriesData collectionFinal reportAeronca 15AC · Kotzebue, AKThe pilot's delay in aborting the off-airport landing resulting in a hard landing.NTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB WPR09CA441Accident · No injuriesData collectionFinal reportCessna T210H · Avalon, CAThe pilot's failure to maintain airspeed during approach to landing, which resulted in a hard landing.NTSB WPR09CA439Accident · No injuriesData collectionFinal reportBellanca 17-30A · La Grande, ORThe pilot's improper flare, which resulted in a bounced landing.NTSB CEN09CA554Accident · No injuriesData collectionFinal reportSocata TBM 700 · Ann Arbor, MIThe pilot's hard landing during gusty wind conditions.NTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.NTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR09GA397Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Lancaster, CAThe pilots’ decision to conduct a practice autorotation at low altitude in high density altitude conditions and their failure to attain and maintain an appropriate descent rate. Contributing to the accident was the high density altitude and the pilots’…NTSB CEN09CA485Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Flushing, MIThe pilot's failure to maintain adequate descent rate and airspeed on final resulting in a hard landing.NTSB CEN09CA478Accident · Minor injuriesData collectionFinal reportP&M Quik GT450 · Oshkosh, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB WPR09CA375Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe flight instructor's failure to maintain adequate main rotor RPM.NTSB WPR09CA377Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe student pilot's improper use of the collective control and the flight instructor’s delayed reaction to the student pilot’s incorrect control inputs.NTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.NTSB ERA09FA414Accident · 1 fatalField investigationFinal reportHughes 369 · Franklin, PAA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB WPR09CA360Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Jerome, AZThe pilot’s failure to maintain adequate main rotor rpm's, and the certified flight instructor’s inadequate supervision of the flight.NTSB WPR09CA359Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Truckee, CAThe student pilot's failure to maintain adequate airspeed to avoid a stall during final approach to land. Contributing to the accident was the pilot’s lack of experience.