NTSB investigations, 2019
108 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
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 year(c.\"eventDate\") = 2019
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") = 2019 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 ERA20CA078Accident · No injuriesData collectionFinal reportCessna 172 · Ormond Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA20CA090Accident · No injuriesClass 4 · Data collectionFinal reportPitts A · Hickory Valley, TNThe pilot’s improper fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20CA138Accident · Serious injuriesData collectionFinal reportLindstrand 180A · Davenport, FLThe pilot’s failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injury to a passenger.NTSB WPR20TA039Accident · Minor injuriesClass 3Final reportEnstrom F28 · Riverton, UTThe noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.NTSB ERA20LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe pilot’s improper flare to land, which resulted in a hard landing and the nose landing gear collapsing.NTSB ERA20LA045Accident · Minor injuriesClass 3 · LimitedFinal reportYakovlev YAK 52 · Wrightsville, GAA total loss of engine power due to the failure of the No. 5 cylinder exhaust valve, which resulted in an forced off-airport landing.NTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.NTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…NTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.NTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.NTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.NTSB GAA20CA068Accident · No injuriesData collectionFinal reportIcon A5 · Chester, CTThe pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20CA052Accident · No injuriesData collectionFinal reportRobinson R66 · Alexandria, LAThe pilot's fixation on the instrument panel, which resulted in a hard landing.NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.NTSB GAA20CA079Accident · No injuriesData collectionFinal reportPiper PA28 · Quakertown, PAThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and collision with a drainage culvert.NTSB GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.NTSB GAA20CA034Accident · Minor injuriesData collectionFinal reportBell 47G · King City, CAThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing and the main rotor blades striking the tailboom.NTSB GAA20CA035Accident · No injuriesData collectionFinal reportRobinson R22 · Overton, NVThe pilot’s failure to maintain a proper approach and the flight instructor's subsequent failure to maintain an adequate climb rate during an attempted go-around in gusting tailwind conditions, which resulted in a hard landing and dynamic rollover.NTSB GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneNTSB GAA20CA012Accident · Minor injuriesData collectionFinal reportAerostar International RX 7 · Rio Rancho, NMThe pilot's failure to maintain an adequate descent rate during landing, which resulted in a hard landing and a postaccident fire.NTSB GAA20CA005Accident · No injuriesData collectionFinal reportPavel Vagner Tango · Dublin, TXThe pilot's improper landing flare and failure to maintain lateral control, which resulted in a hard landing, loss of directional control, and subsequent roll-over.NTSB GAA19CA590Accident · No injuriesData collectionFinal reportCessna 172 · St. Augustine, FLThe student pilot's improper landing flare, which resulted in a bounced, hard landing.NTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB GAA19CA591Accident · Serious injuriesData collectionFinal reportCessna 182 · Elizabethtown, NCThe pilot's improper landing flare, which resulted in a hard landing and postaccident fire. Contributing to the accident was the pilot’s distraction during short final.NTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.NTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.NTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.NTSB WPR19LA257Accident · Serious injuriesClass 3 · LimitedFinal reportKubicek BB60 · Goodsprings, NVThe pilot's failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injuries to the pilot and two passengers.NTSB GAA19CA581Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, which resulted in a hard landing and a collapsed nose landing gear.NTSB ERA19TA276Accident · No injuriesClass 3Final reportBeech 23 · Panama City, FLA total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.NTSB CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.NTSB GAA19CA538Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.NTSB CEN19TA327Accident · No injuriesClass 3Final reportPiper PA60 · Tulsa, OKThe pilot's improper landing flare, which resulted in an aerodynamic stall and hard landing.NTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.NTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.NTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.NTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.NTSB GAA19CA514Accident · No injuriesData collectionFinal reportHughes 269A · Shamokin, PAThe pilot's improper landing flare during an autorotation, which resulted in a hard landing. Contributing to the accident was a loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of any…NTSB CEN19TA330Accident · No injuriesClass 3Final reportCirrus SR22 · Glenwood Springs, COThe pilot’s failure to maintain control of the airplane while landing with a tail wind, which resulted in an aerodynamic stall and a subsequent hard landing..NTSB CEN19TA328Accident · Serious injuriesClass 3Final reportLindstrand 105A · Lawton, OKA hard landing, which resulted the basket tipping over and a passenger sustaining a serious injury.NTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.NTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…NTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA19CA503Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe student pilot's improper landing flare with a tailwind, which resulted in a hard, bounced landing.