NTSB investigations, 2017
53 cases where the defining event was Hard landing.
Cases per year
| 2008 | 111 |
|---|---|
| 2009 | 85 |
| 2010 | 81 |
| 2011 | 79 |
| 2012 | 78 |
| 2013 | 72 |
| 2014 | 61 |
| 2015 | 74 |
| 2016 | 66 |
| 2017 | 53 |
| 2018 | 44 |
| 2019 | 61 |
| 2020 | 52 |
| 2021 | 56 |
| 2022 | 69 |
| 2023 | 60 |
| 2024 | 55 |
| 2025 | 43 |
| 2026 | 46 |
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\") = 2017
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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") = 2017 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.NTSB GAA18CA070Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Santa Rosa, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.NTSB GAA18CA072Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Fort Pierce, FLThe pilot’s improper landing flare, which resulted in a tail strike and hard landing.NTSB WPR18LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Truckee, CAThe flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.NTSB GAA18CA080Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB CEN18LA006Accident · Serious injuriesLimited investigationFinal reportCameron N-105 · Albuquerque, NMThe steep approach and hard landing after the balloon encountered unexpected high wind conditions, which resulted in a serious injury to a passenger.NTSB GAA18CA030Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Las Vegas, NVThe student pilot’s tension on the flight control at a low level during an autorotation, which did not allow sufficient time for the flight instructor to correct and recover control before the hard landing.NTSB GAA17CA553Accident · No injuriesData collectionFinal reportAerotrike Safari · Bridgeton, NJThe pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.NTSB WPR17LA211Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Long Beach, CAThe student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…NTSB GAA17CA540Accident · No injuriesData collectionFinal reportCessna 172 · Lynchburg, VAThe pilot's unstabilized approach, which resulted in an aborted go-around, an aerodynamic stall, and a hard landing.NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB ERA17FA317Accident · 2 fatalField investigationFinal reportSchweizer 269C · Medford, NJThe pilot's early entry into and failure to maintain rotor rpm during a forced landing autorotation after performing an engine shutdown in flight, which resulted in an uncontrolled descent. Contributing to the accident was the failure of maintenance personnel…NTSB ENG17WA035Accident · Minor injuriesForeign investigationSikorsky 300 · Herzelia, IsraelThe Ministry of Transport of the State of Israel, has notified the NTSB of an accident involving a Sikorsky S-300C, registration 4X-BIM, that occurred on August 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the investigation…NTSB ERA17LA301Accident · No injuriesLimited investigationFinal reportPiper PA28R · Monroe, NCA hard landing at an unknown time.NTSB ERA17LA319Accident · No injuriesLimited investigationFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN17LA324Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Sweetwater, TXThe pilot's improper landing flare, which resulted in a hard landing and the overstress failure of the right main landing gear.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA465Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCThe physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.NTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.NTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.NTSB GAA17CA434Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bozeman, MTThe flight instructor’s unstabilized autorotation, which resulted in a hard landing.NTSB DCA17WA160Accident · No injuriesForeign investigationBoeing 737 · Wamena, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…NTSB GAA17CA389Accident · No injuriesData collectionFinal reportCessna 172 · Shreveport, LAThe student’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA357Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Edgewood, NMThe pilot's decision to take off with a gusting tailwind, which resulted in a loss of pitch control during the initial climb and a subsequent hard landing and loss of directional control.NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB GAA17CA345Accident · No injuriesData collectionFinal reportPiper PA28 · Hartford, CTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN17LA219Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Douglas, WYThe pilot's inability to control the helicopter's descent after encountering a sudden wind shift to a tailwind while performing a near maximum gross weight landing at a high density altitude.NTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.NTSB GAA17CA332Accident · No injuriesData collectionFinal reportCessna 208 · Elfin Cove, AKThe pilot’s failure to recognize the magnitude of the swell size during landing, which resulted in a tail-low hard water landing.NTSB GAA17CA272Accident · No injuriesData collectionFinal reportJohn Murphy JSX-2 · Chesterfield, MOThe pilot’s failure to ensure that the canopy was properly secured before takeoff, which resulted in an unstable landing flare and hard landing.NTSB GAA17CA263Accident · No injuriesData collectionFinal reportPiper PA28R · Frankfort, KYThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA17CA259Accident · No injuriesData collectionFinal reportCurtis Lund Vortex · Spanish Fork, UTThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA257Accident · Minor injuriesData collectionFinal reportNelson Sydney Vans Acft RV8A · Englewood, COThe pilot's improper landing flare and inadvertent selection of the mixture control, which resulted in a hard, bounced landing during gusting crosswind wind conditions.NTSB GAA17CA253Accident · No injuriesData collectionFinal reportCirrus SR20 · Lakewood, NJThe student pilot’s failure to adequately compensate for crosswind conditions during a go-around and the flight instructor’s delayed remedial action.NTSB ERA17CA157Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Kingsland, GAThe pilot's improper landing flare, which resulted in a hard landing and subsequent nose-over.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.NTSB GAA17CA213Accident · No injuriesData collectionFinal reportIcon A5 · Key Largo, FLThe pilot’s failure to maintain a proper descent rate during the approach, which resulted in a hard landing.NTSB GAA17CA201Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot’s use of excessive airspeed during the approach, which resulted in a bounced, hard landing and subsequent loss of directional control during an attempted go-around.NTSB GAA17CA333Accident · No injuriesData collectionFinal reportSwearingen SA227 TT · Santa Monica, CAThe pilot’s unstabilized approach after encountering wake turbulence, which resulted in a hard landing.NTSB GAA17CA180Accident · No injuriesData collectionFinal reportCessna 172 · Naples, FLThe pilot’s failure to maintain pitch control, which resulted in a hard landing.NTSB ERA17LA103Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC 135 · Beattyville, KYThe pilot's failure to maintain helicopter control while landing, which resulted in a hard landing and subsequent roll over.NTSB CEN17LA188Accident · No injuriesLimited investigationFinal reportBell 407 · Fort Worth, TXThe flight instructor's failure to prevent the engine/rotor overspeed condition during the demonstration maneuver and the excessive descent rate during the emergency landing, which resulted in a hard landing. Contributing to the engine/rotor overspeed…