Final NTSB investigations
2,003 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 166 |
|---|---|
| 2009 | 134 |
| 2010 | 125 |
| 2011 | 131 |
| 2012 | 127 |
| 2013 | 112 |
| 2014 | 106 |
| 2015 | 98 |
| 2016 | 121 |
| 2017 | 125 |
| 2018 | 115 |
| 2019 | 108 |
| 2020 | 81 |
| 2021 | 88 |
| 2022 | 99 |
| 2023 | 86 |
| 2024 | 93 |
| 2025 | 58 |
| 2026 | 30 |
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\" = '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 c."completionStatus" = 'Completed' 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 ERA26LA330Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Leesburg, FLThe instructor’s delayed remedial action during an aborted landing, which resulted in a loss of airplane control.NTSB ERA26LA327Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · McMinnville, TNThe flight instructor’s delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB ERA26LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mooresville, NCThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot’s improper landing flare which resulted in a stall and a hard bounced landing.NTSB ERA26LA261Accident · No injuriesClass 4 · LimitedFinal reportKodiak Kodiak 100 · New York, NYAn inadvertent collision with a large wave during touchdown on a river, which resulted in a subsequent bounce and hard landing.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 CEN26LA229Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Carbondale, ILThe flight instructor’s delayed remedial action during the student pilot’s miscalculated landing flare which resulted in a hard landing and the nose landing gear collapsing.NTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.NTSB ERA26LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Chesapeake, VAThe pilot’s improper decision to continue with an unstabilized approach, which resulted in a hard landing, loss of directional control, and collision with a runway marker light and sign.NTSB CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.NTSB ERA26LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Fitchburg, MAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.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 CEN26LA183Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Bennett, COThe pilot’s improper flare during landing that resulted in a hard landing.NTSB CEN26LA181Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Durango, COThe flight instructor’s inadequate supervision of the pilot receiving the instruction and the pilot’s improper recovery from a practice autorotation in shifting wind conditions, which resulted in a hard landing.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 ERA26LA176Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Levittown, PRAn oil line separation at a barbed fitting in an experimental airplane, which resulted in a total loss of engine power due to oil starvation.NTSB ERA26LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · The Rock, GAThe pilot’s improper landing flare, which resulted in a hard, porpoised landing.NTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.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 CEN26LA151Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCB · Colorado Springs, COThe pilot’s failure to maintain directional control of the airplane during takeoff in gusty wind conditions, which resulted in a hard landing.NTSB WPR26LA143Accident · No injuriesClass 4 · LimitedFinal reportPaul D Cannon Kitfox Light Squared · Lincoln, CAThe pilot's failure to properly flare the airplane during landing, which resulted in a hard landing and separation of the main landing gear. Contributing to the accident was the improper installation and over torquing of the landing gear attachment hardware,…NTSB WPR26LA148Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Chula Vista, CAThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent runway excursion.NTSB CEN26LA127Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B36TC · Durango, COThe pilot’s improper landing flare and subsequent loss of directional control while attempting to land during high crosswind conditions.NTSB CEN26LA113Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Des Moines, IAThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA26LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe student pilot’s improper landing flare which resulted in a hard landing.NTSB WPR26LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Lewiston, IDThe pilot’s improper landing flare, which resulted in hard, bounced landing and subsequent tail strike.NTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.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 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 WPR26LA056Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Lake Havasu City, AZThe pilot’s improper securing hardware installation, which resulted in a loss of throttle control and a loss of engine power.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 WPR26LA049Accident · Minor injuriesClass 4 · LimitedFinal reportZenair Stol CH 701 · Shady Cove, ORThe pilot’s improper throttle input during an approach, which resulted in a rapid descent, hard landing and runway excursion.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 WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB ERA26LA026Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS350 · Wetumpka, ALThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.NTSB WPR26LA024Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Paris, IDThe pilot receiving instruction’s failure to maintain directional control during landing and the flight instructor’s delayed remedial action, which resulted in a runway excursion.NTSB ERA26LA018Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cynthiana, KYThe pilot's inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing. Contributing to the accident was the impact with powerlines during final approach.NTSB CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA26LA009Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Smithfield, RIMaintenance personnel’s improper rigging of the elevator trim system, which resulted in a hard landing. Contributing was the maintenance personnel and pilot’s failure to perform adequate post maintenance/preflight inspections.NTSB ERA26LA016Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · North La Junta, COThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB CEN25LA404Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR20 · Watertown, WIThe flight instructor’s failure to maintain control of the airplane following the student pilot’s bounced landing. Contributing to the accident was the flight instructor’s delayed remedial action which resulted in diminished airplane performance during the…NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB ERA25LA376Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · West Milford, NJThe pilot’s improper landing flare and subsequent failure to recover from a hard bounced landing, which resulted in a loss of directional control and runway excursion.NTSB ERA25LA349Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Virus 912 LSA · Lincoln Park, NJThe pilot’s inadequate compensation for variable wind conditions, which resulted in a hard landing and loss of directional control.