NTSB investigations
2,102 cases where the sequence of events included 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.\"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."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 WPR19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Kukuihaele, HIThe partial loss of engine power due to corrosion in the engine bleed valve due to wash solution intrusion. Contributing to the accident was the installation of a bushing manufactured to incorrect dimensions in the bleed valve, and the uneven terrain at the…NTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.NTSB GAA19CA105Accident · Minor injuriesData collectionFinal reportRobert R. Reiland Rans · Reidsville, NCThe pilot's improper pitch control during a go-around, which resulted in a hard landing.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 CEN19LA067Accident · No injuriesLimited investigationFinal reportBell 47G · Belen, NMThe pilot's failure to maintain adequate main rotor speed while the helicopter was in an out-of-ground effect hover.NTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.NTSB WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.NTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB ERA19LA073Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · Key West, FLThe flight crew’s encounter with windshear during the landing flare, which resulted in a hard landing.NTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.NTSB GAA19CA094Accident · No injuriesData collectionFinal reportCirrus SR22 · Greenville, SCThe pilot's improper landing flare with a gusting, right quartering headwind, which resulted in a hard landing.NTSB WPR19LA029Accident · No injuriesClass 3 · LimitedFinal reportBKF Backcountry Supercub · Casper, WYThe seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.NTSB GAA19CA064Accident · No injuriesData collectionFinal reportCessna 182 · Charlotte, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA049Accident · No injuriesData collectionFinal reportFlight Design Ctls · Elyria, OHThe pilot's failure to maintain adequate airspeed during landing in variable gusting crosswind conditions, which resulted in a hard landing and runway excursion.NTSB WPR19LA019Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G · Wichita Falls, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA042Accident · No injuriesData collectionFinal reportCessna 172 · Salina, KSThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB GAA19CA036Accident · No injuriesData collectionFinal reportAirplane Factory Sport Light · Carson City, NVThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR19LA013Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Kaneohe, HIThe pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.NTSB GAA19CA020Accident · No injuriesData collectionFinal reportCessna 172 · Lawrenceville, GAThe student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.NTSB GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB ERA19TA005Accident · No injuriesFinal reportEnstrom F28 · Bridgeville, DEThe pilot's mismanagement of collective pitch control during takeoff from an area with numerous obstacles, which resulted in the helicopter entering a low rotor rpm state and a forced hard landing.NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB ERA19LA008Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Stonewall, MSThe fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a fractured camshaft and a total loss of engine power.NTSB ANC19CA002Accident · No injuriesData collectionFinal reportBeech 1900 · Gambell, AKThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard landing.NTSB GAA19CA025Accident · No injuriesData collectionFinal reportCessna 152 · Lakeland, FLThe pilot's improper landing flare, which resulted in a hard, bounced landing and the nose gear collapsing.NTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…NTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…NTSB ERA18TA267Accident · Serious injuriesClass 3Final reportGrob G103 Twin Astir · Groveland, FLThe student pilot's failure to relinquish the flight controls during landing when the flight instructor told him to do so, and the instructor’s subsequent inability to properly control the glider, which led to a hard landing.NTSB GAA18CA562Accident · No injuriesData collectionFinal reportRutan Rutan Long EZ · Independence, ORThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.NTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB WPR18LA265Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 300CBi 269C1 · Granada Hills, CAA partial loss of engine power that was the result of a loss of compression in the No. 1 and 4 cylinders due to damage and material separation from the exhaust valve heads, which resulted in a subsequent forced, hard landing. Contributing to the accident was…NTSB GAA18CA558Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent loss of directional control on an unimproved airstrip.NTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN18LA364Accident · Serious injuriesLimited investigationFinal reportLindstrand 77A · Brookfield, MOThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB CEN18LA362Accident · Serious injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Carlisle, OHA total loss of engine power shortly after takeoff due to carburetor ice.NTSB CEN18WA379Accident · No injuriesForeign investigationPiper PA32 · Belize City, BelizeOn August 29, about 1804 local time (LCL), a Piper PA32 300 airplane, N3073W, operated by Wings of Hope, had a hard landing at the Sir Barry Bowen Municipal Airport, in Belize City, Belize. The airplane originated from the San Pedro Airport.This investigation…NTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.NTSB CEN18LA354Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bowman, NDThe loss of engine power due to fuel starvation.NTSB GAA18CA554Accident · No injuriesData collectionFinal reportAirborne Edge X Classic · Lake Wales, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB GAA18CA508Accident · Minor injuriesData collectionFinal reportRobinson R22 · Corvallis, ORThe student helicopter pilot’s inadequate torque pedal application during practice approaches with a tailwind, which resulted in a loss of yaw control and a subsequent hard landing.NTSB CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.NTSB GAA18CA518Accident · Minor injuriesData collectionFinal reportRans Rans S6S · Painton, MOThe pilot's failure to maintain the proper pitch attitude during landing, which resulted in a bounced, hard landing.NTSB WPR18LA226Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369 · Riverside, CAThe instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.NTSB GAA18CA482Accident · No injuriesData collectionFinal reportQac Quickie · helena, MTThe pilot's failure to maintain yaw control and a proper descent rate during an aborted takeoff.NTSB GAA18CA478Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.NTSB DCA18CA252Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 767 · Portsmouth, NHan improper landing flare technique and the lack of the appropriate bounced landing recovery procedure.