Final NTSB investigations
1,162 cases where the defining event was Hard landing.
Cases, newest first
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 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."completionStatus" = 'Completed' 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 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 ANC25LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Trapper Creek, AKThe pilot’s improper flare while landing on glassy water, which resulted in a hard landing.NTSB CEN25LA189Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Luverne, MNThe pilot’s improper landing flare which resulted in a hard landing.NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB ANC25LA032Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Redding, CAThe pilot's failure to maintain a stabilized approach and his delayed action to perform a go-around, resulting in a collision with the runway surface.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 ERA25LA208Accident · No injuriesClass 4 · LimitedFinal reportWagoner Richard Searey · Zellwood, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing.NTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.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 ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.NTSB ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB ERA25LA055Accident · No injuriesClass 4 · LimitedFinal reportBrunner-Winkle Bird A · Senoia, GAThe pilot’s improper flare, which resulted in a hard landing, and landing gear collapse.NTSB ERA25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during landing in a gusting crosswind, which resulted in a hard landing and runway excursion.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 WPR25LA028Accident · No injuriesClass 4 · LimitedFinal reportDierenfield Devin RV-6A · Lancaster, CAThe pilot’s failure to maintain a stablized approach, which resulted in a hard landing.NTSB WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB ERA25LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisville, KYThe pilot’s improper landing flare and control inputs, which resulted in a hard landing. Contributing was the flight instructor’s delayed remedial action.NTSB ANC25LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Kasilof, AKThe right main landing gear’s inadvertent contact with uneven terrain, which resulted in a hard landing. Contributing was the pilot’s failure to adequately assess the landing environment prior to touchdown.NTSB ANC25LA031Accident · No injuriesClass 4 · LimitedFinal reportLawrence M Zubel Loehle 5151 Mustang · Vernal, UTThe pilot’s improper landing flare, which resulted in a hard, bounced landing which result in the left landing gear collapsing.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 CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.NTSB WPR24LA310Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Redlands, CAThe pilot’s failure to maintain airplane control during final approach, which resulted in a collision with rocky terrain.NTSB ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.NTSB WPR24LA312Accident · No injuriesClass 4 · LimitedFinal reportConner Michael A Vans Acft RV-9 · Yellow Pine, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an impact with a fence.NTSB ERA24LA387Accident · Minor injuriesClass 3 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Canandaigua, NYThe pilot’s excessive descent rate during the final approach for landing and his delayed recovery attempt, resulting in a hard landing.NTSB ERA24LA381Accident · Minor injuriesClass 4 · LimitedFinal reportWalden Robert Vans Aircraft RV-7A · Williamsburg, VAThe pilot’s decision to continue with an unstabilized approach which resulted in a hard landing and loss of directional control during a subsequent landing.NTSB WPR24LA303Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Big Bend-Gold Bar, WAThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA24LA360Accident · No injuriesClass 4 · LimitedFinal reportBeech B100 · Jesup, GAA hard landing short of the runway threshold, which resulted in a collapse of the left main landing gear and subsequent runway excursion during landing.NTSB ERA24LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisa, VAThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN24LA322Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Chetek, WIThe pilot’s improper landing flare and hard landing.NTSB CEN24LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Whitewright, TXThe pilot’s incomplete flare which resulted a hard, flat landing.NTSB WPR24LA277Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Sequim, WAAn encounter with a downdraft, which resulted in a hard landing.NTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB CEN24LA310Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Crystal, MNThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN24LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Colorado Springs, COThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing.NTSB ERA24LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Moultonborough, NHThe student pilot’s improper remedial response to a bounced landing, which resulted in a hard landing.NTSB WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.NTSB CEN24LA282Accident · No injuriesClass 3 · LimitedFinal reportJust Highlander · Oshkosh, WIThe reported uncommanded retraction of the flaps while on short final for unknown reasons, which resulted in a hard landing.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA24LA317Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Montauk, NYThe pilot’s failure to maintain an appropriate glide path during the landing approach in terrain induced turbulence, resulting in a hard landing and subsequent runway excursion.NTSB WPR24LA245Accident · Serious injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26Z · Casper, WYThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in the pilot’s ejection from the basket and serious injury.NTSB ANC24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Cordova, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.NTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.NTSB CEN24LA349Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Hooper, NEThe solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landingNTSB ERA24LA281Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Chesapeake, VAThe pilot’s improper recovery from a bounced landing.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB CEN24LA217Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH 750 · Caney, TXThe pilot’s improper landing flare, which resulted in a hard landing,NTSB WPR24LA183Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Maricopa, AZThe flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.NTSB ERA24LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Greensboro, NCThe pilot's improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.