NTSB investigations, TX
79 cases where the defining event was Hard landing.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 6 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 7 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 6 |
| 2026 | 1 |
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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN25LA380Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Decatur, TXThe instructor candidate’s erroneous operation of the throttle during an autorotation from altitude with power recovery, which resulted in 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 CEN25LA227Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob G-103A Twin II Acro · Midlothian, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.NTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.NTSB CEN25LA084Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Lago Vista, TXThe flight instructor’s improper recovery from a practice autorotation which resulted in a hard landing.NTSB CEN24LA377Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Manvel, TXThe pilot’s improper recovery from a practice autorotation which resulted in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.NTSB CEN24LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Whitewright, TXThe pilot’s incomplete flare which resulted a hard, flat landing.NTSB CEN24LA217Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH 750 · Caney, TXThe pilot’s improper landing flare, which resulted in a hard landing,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 CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.NTSB CEN23LA404Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Arcola, TXThe instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.NTSB CEN23LA389Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 530FF · Liberty Hill, TXThe pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.NTSB CEN23LA355Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe solo student pilot’s improper descent path which resulted in a hard landing on the nose wheel and subsequent bounced landing.NTSB DCA23LA384Accident · No injuriesClass 3 · LimitedFinal reportBoeing 767-322 · Houston, TXThe first officer’s improper control inputs after the airplane touched down. Contributing to the severity of the damage was the flight crew’s lack of recognition that the speedbrakes were not armed, which led to their delayed deployment.NTSB WPR23LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206-L4 · Ft Worth, TXThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident, was the flight instructor’s inadequate supervision.NTSB CEN22LA402Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopters 369E · Pearland, TXThe pilot receiving instruction’s failure to maintain aircraft control, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB CEN22LA400Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · San Isidro, TXThe pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.NTSB CEN22LA363Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20B · Waller, TXThe pilot’s failure to maintain the proper descent rate during an off-airport 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 CEN22LA236Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Houston, TXThe pilot’s inability to compensate for a downdraft during the landing flare, which resulted in a hard, bounced landing, and subsequent loss of directional control.NTSB CEN22LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Hebbronville, TXThe pilots improper landing flare which resulted in a hard landing and loss of airplane control.NTSB CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.NTSB CEN20CA395Accident · No injuriesClass 4 · Data collectionFinal reportBell 407 · Fort Worth, TXThe flight instructor’s delay in rolling the throttle to the fly position during a practice autorotation maneuver that resulted in a hard landing.NTSB CEN20LA440Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · San Antonio, TXThe pilot’s failure to fly a stabilized approach which resulted in a hard landing and loss of control.NTSB CEN20CA324Accident · Minor injuriesClass 4 · Data collectionFinal reportGrob G102 · Midlothian, TXThe unstabilized landing approach in gusty wind conditions that resulted in a hard, bounced landing.NTSB WPR20CA209Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lubbock, TXThe pilot's improper approach and descent rate, which resulted in a hard 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 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 CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.NTSB CEN19LA207Accident · Minor injuriesClass 3 · LimitedFinal reportMd Helicopter 369 · Houston, TXThe loss of control upon landing for undetermined reasons.NTSB CEN19CA128Accident · Serious injuriesData collectionFinal reportUltramagic S90 · La Mesa, TXThe pilot's improper decision to launch the balloon in known high wind conditions, and his failure to fully vent the balloon upon landing, which resulted in the balloon landing hard several times, tipping over, being pushed along uneven ground, and a serious…NTSB CEN19LA054Accident · No injuriesLimited investigationFinal reportCanadair CL 600 2A12 · Uvalde, TXThe airplane’s encounter with wind shear on short final approach to the runway, which resulted in a hard landing and fracture of the right main landing gear.NTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, 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 GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.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…NTSB GAA17CA289Accident · No injuriesData collectionFinal reportCessna R182 · Llano, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.NTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.NTSB GAA16CA007Accident · Minor injuriesData collectionFinal reportBogle Absey C Breezy RLU-1 · Bryan, TXThe pilot's excessive descent rate, which resulted in a hard landing and substantial damage.NTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.NTSB CEN15LA314Accident · Serious injuriesLimited investigationFinal reportArbc 69X · Longview, TXThe balloon’s hard landing due to a high surface wind and downdraft, which resulted in the pilot sustaining a serious leg injury.NTSB GAA15CA179Accident · No injuriesData collectionFinal reportCessna 172R · Addison, TXThe student pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.NTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB CEN14CA367Accident · No injuriesData collectionFinal reportAmerican Eurocopter AS350B3 · Grand Praire, TXThe flight instructor's inadequate supervision during a practice autorotation. Contributing to the accident was the pilot's hard landing during a practice autorotation.