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 ERA22LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kissimmee, FLThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nose landing gear impacting the runway.NTSB GAA22WA260Accident · No injuriesClass 5 · ForeignCessna 172 · Malloca, SpainNTSB 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 CEN22LA391Accident · No injuriesClass 3 · LimitedFinal reportBeech F33A · Baton Rouge, LAThe sudden and total loss of fuel flow to the engine for undetermined reasons.NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB WPR22LA307Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Bountiful, UTThe pilot’s improper landing flare and subsequent loss of airplane control during a go-around when the airplane stalled and collided with the ground.NTSB WPR22LA374Accident · No injuriesClass 4 · LimitedFinal reportIca Brasov IS-28B2 · Deer Park, WAThe pilot’s improper landing flare which resulted in a hard landing.NTSB WPR22LA302Accident · Minor injuriesClass 3 · LimitedFinal reportGoddard Dick Sim Bensen B-8M · Corona, CAThe fatigue failure of the engine mount resulting in a loss of engine power and directional control while maneuvering.NTSB WPR22LA299Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot’s failure to maintain lateral control during an off-field landing, which resulted in loss of control and an impact with terrain.NTSB WPR22LA300Accident · No injuriesClass 4 · LimitedFinal reportHoffman David J Murphy Elite · Manley Hot Springs, AKThe pilot’s unstable approach to land, which resulted in a hard landing.NTSB WPR22LA296Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Corona, CAThe airplane’s partial loss of engine power during the landing for reasons that could not be determined based on the available evidence, which resulted in an off airport landing and subsequent fire.NTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.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 CEN22LA381Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Port Alsworth, AKA hard landing that occurred at an unknown time and date, which resulted in substantial damage.NTSB CEN22LA379Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Joliet, ILThe pilot’s inadequate landing flare, which resulted in a hard, bounced landing.NTSB ERA22LA353Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Columbus, OHThe pilot’s improper landing flare, which resulted in a bounced landing and a collapse of the left main landing gear.NTSB CEN22LA369Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Evansville, INThe pilot’s improper landing flare in gusting winds, which resulted in a hard landing and the nose gear collapsing.NTSB WPR22LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Cedar City, UTThe student pilot’s failure to maintain rotor rpm and airspeed and the flight instructor's inadequate remedial action to regain helicopter control during the straight-in autorotation which resulted in a hard landing.NTSB CEN22LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna T310R · Oshkosh, WIThe pilot’s loss of control while landing.NTSB ERA22LA339Accident · No injuriesClass 4 · LimitedFinal reportVulcanair V1 · Salisbury, MDThe student pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Hanson, MAThe pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.NTSB ERA22LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, OHThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB CEN22LA313Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Rapid City, SDA total loss of engine power for reasons that could not be determined because the airplane was unavailable for examination.NTSB CEN22LA310Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Wyoming, ILThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Portland, ORThe pilot under instruction’s improper landing flare, and the flight instructor’s delayed remedial action.NTSB ERA22LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172M · South Portland, METhe student pilot’s improper landing flare, which resulted in a hard landing. Also causal was the flight instructor’s inadequate remedial action.NTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.NTSB GAA22WA224Accident · No injuriesClass 5 · ForeignRobinson R44 · Novy township, RussiaNTSB ERA22LA342Accident · No injuriesClass 4 · LimitedFinal reportMesserschmitt-Boelkow-Blohm BO_105S · Daytona Beach, FLThe pilot’s rapid reduction of collective following an in-flight loss of control while lifting from a dolly resulting in a hard landing. Contributing to the loss of control was the pilot’s likely inadequate left anti-torque control pedal input during initial…NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB CEN22LA292Accident · No injuriesClass 4 · LimitedFinal reportMagnaghi Aeronautica SKY Arrow LSA · West Lafayette, INThe pilot’s failure to maintain proper airspeed while landing in gusting winds, which resulted in a hard landing and a runway excursion.NTSB ERA22LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Manassas, VAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB ERA22LA286Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Gaithersburg, MDThe pilot’s failure to maintain control during the landing flare in gusting wind conditions.NTSB CEN22LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fargo, NDThe flight instructor’s failure to adequately monitor the pilot flying, which resulted in a nose-wheel first hard landing.NTSB ERA22LA337Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Pelion, SCThe pilot’s improper landing flare during a practice autorotation.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 WPR22LA211Accident · Minor injuriesClass 3 · LimitedFinal reportRans S21 · Fairfield, UTThe owner’s (pilot) failure to properly torque a fuel filter b-nut fitting, which likely introduced air into the fuel system and resulted in a loss of engine power. Contributing to the loss of power was a missing restricted bypass line and a header tank vent…NTSB CEN22LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 337G · Greenbrier, ARThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN22LA242Accident · No injuriesClass 4 · LimitedFinal reportAMD CH2000 · Gladewater, TXThe student pilot’s failure to maintain/attain aircraft control during a go-around from a bounced landing that resulted in an aerodynamic stall and impact with terrain.NTSB ANC22LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Anchorage, AKThe pilot’s improper landing flare which resulted in a hard landing.NTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.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 ERA22LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Pemberton Township, NJThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of control.NTSB ERA22LA248Accident · No injuriesClass 4 · LimitedFinal reportFoster William D Elite · Winter Haven, FLThe pilot’s improper flare and inadequate application of power during landing, resulting in a hard landing and substantial damage to the airplane.NTSB ANC22LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Big Lake, AKA hard landing for an unknown reason, resulting in substantial damage to the airplane.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB ERA22LA232Accident · Minor injuriesClass 4 · LimitedFinal reportJustice Frank K Vans RV-6A · Hendersonville, NCThe pilot’s failure to go-around during an unstable approach, which resulted in a hard landing, runway excursion, and nose over.NTSB ERA22LA222Accident · No injuriesClass 4 · LimitedFinal reportCharles R Kyle Zenith Stol CH 701 · Culpepper, VAThe pilot’s failure to maintain the proper glidepath, which resulted in a hard landing and landing gear collapse.NTSB CEN22LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Terre Haute, INA hard landing, which resulted in the failure of the right main landing gear outer bearing and collapse of the landing gear.