NTSB investigations
1,250 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.\"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."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 GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.NTSB CEN16WA152Accident · Minor injuriesForeign investigationPiper PA32R · Hampshire, United KingdomOn April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…NTSB GAA16CA189Accident · No injuriesData collectionFinal reportTL Ultralight Sro TL-3000 Sirius · South St. Paul, MNThe pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.NTSB GAA16CA158Accident · No injuriesData collectionFinal reportCessna 172 · Frederick, MDThe student pilot's improper pitch control during the landing flare, which resulted in a hard bounced landing.NTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.NTSB WPR16LA073Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Billings, MTThe pilot’s failure to attain a proper flare during landing in gusting wind conditions and low-level wind shear, which resulted in a hard landing and a subsequent loss of directional control.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 GAA16CA104Accident · No injuriesData collectionFinal reportCessna 172 · Dothan, ALThe pilot-rated student's hard landing, which resulted in fuselage damage.NTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.NTSB GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.NTSB ERA16LA055Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Venice, FLThe flight instructor's failure to maintain control of the helicopter during an autorotation, which resulted in a hard landing.NTSB GAA16CA081Accident · No injuriesData collectionFinal reportCessna 182 · Salisbury, NCThe pilot's failure to maintain pitch control during the landing flare, causing the airplane to balloon and land hard.NTSB GAA16CA064Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe student pilot's improper flare during landing, which resulted in a bounced landing, and a runway excursion.NTSB ERA16LA052Accident · No injuriesLimited investigationFinal reportBeech 95 B55 · Albany, NYThe pilot’s failure to maintain a proper flare while landing in gusting crosswind conditions, which resulted in a hard landing, overstress fracture of the nose landing gear trunnion, and a subsequent nose landing gear collapse.NTSB DCA16WA024Accident · No injuriesForeign investigationBoeing 737 · Osh, KyrgyzstanThe government of Kyrgyzstan has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on November 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Kyrgyzstan's investigation under the…NTSB GAA16CA059Accident · No injuriesData collectionFinal reportCessna 172R · Westminster, MDThe student pilot's failure to maintain pitch control during the landing, which resulted in a hard landing.NTSB ERA16WA048Accident · No injuriesForeign investigationRobinson R66 · Sirinhaem Municipality, BrazilOn November 11, 2015, about 1755 coordinated universal time, a Robinson R66, Brazilian registration PR-EDL, was substantially damaged during an emergency autorotation near Sirinhaem, State of Pernambuco, Brazil, when the main rotor blades contacted and…NTSB GAA16CA047Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing.NTSB GAA16CA023Accident · Serious injuriesData collectionFinal reportCessna 140 · Fort Benton, MTA hard landing which resulted in a loss of directional control, main landing gear collapse, and damage to the left wing spar.NTSB GAA16CA014Accident · Serious injuriesData collectionFinal reportKubicek BB · Albuquerque, NMA hard landing which resulted in serious injury to a passenger.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 CEN15LA434Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL69A · Albuquerque, NMThe pilot’s failure to maintain a proper descent rate on approach, which resulted in a hard landing and the pilot sustaining a serious injury. Contributing to the accident was the pilot’s lack of recent experience flying a standard-shaped balloon.NTSB GAA15CA287Accident · No injuriesData collectionFinal reportPiper PA 24 · West Bend, WIThe pilot's failure to maintain his descent rate during the landing, which resulted in a hard landing and runway excursion.NTSB CEN15LA411Accident · No injuriesLimited investigationFinal reportBrown Mark Space Walker · Cahokia, ILThe pilot's failure to maintain a proper descent rate during the attempted landing and the flight instructor's delayed attempt to execute a go-around, which resulted in a hard landing, failure of the left main landing gear, and subsequent loss of directional…NTSB GAA15CA301Accident · No injuriesData collectionFinal reportCessna 182 · Rose Hill, KSThe pilot's improper pitch control during the landing flare, which resulted in a porpoise and subsequent hard landing.NTSB ERA15LA372Accident · No injuriesLimited investigationFinal reportCessna A185F · Miami, FLThe pilot’s improper landing flare, which resulted in a hard landing and separation of the left main landing gear wheel from its strut.NTSB CEN15LA387Accident · Serious injuriesLimited investigationFinal reportRobinson R44 II · Cheyenne, WYThe pilot's improper preflight performance planning, which resulted in a hard landing due to low rotor rpm while operating near maximum gross weight in high density altitude conditions.NTSB GAA15CA237Accident · No injuriesData collectionFinal reportCessna 172 · Springfield, OHThe pilot's improper pitch control during landing, which resulted in a hard landing.NTSB GAA15CA248Accident · No injuriesData collectionFinal reportCessna 177B · Los Angeles, CAThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing.NTSB DCA15WA189Incident · No injuriesForeign investigationBritish Aerospace Civil Aircr BAe 146-200 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a British Aerospace BAe-146, which occurred on August 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB CEN15WA372Accident · No injuriesForeign investigationBeech A100 · Margaree, CanadaOn August 16, 2015, at 1910 UTC, a Beechcraft A100, Canadian registration C-FDOR, was substantially damaged following a hard landing at Margaree, Nova Scotia, Canada (CCZ4). The four people onboard were not injured. The accident investigation is under the…NTSB GAA15CA228Accident · No injuriesData collectionFinal reportCessna 337F · Danbury, CTThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing, nose gear collapse, runway excursion, and collision with terrain.NTSB GAA15CA221Accident · No injuriesData collectionFinal reportBell 47D1 · Clanton, ALThe student pilot's abrupt cyclic and collective inputs during the approach to land which resulted in abnormal runway contact and a subsequent tail boom strike by the main rotor blades.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 CEN15WA438Accident · Minor injuriesForeign investigationHughes 369 · Ramatuelle, France, FranceOn August 4, 2015, a Hughes 369 helicopter, D-HBRM, was substantially damaged after impact with terrain near Ramatuelle, France. The pilot and passenger suffered minor injuries. This investigation is under the jurisdiction and control of the French…NTSB CEN15LA322Accident · No injuriesLimited investigationFinal reportBell 47G 4A · Gilbert, IAThe total loss of engine power due to fuel starvation because the available fuel shifted within the tanks due to an abrupt nose-low maneuver to avoid an obstacle, which resulted in a hard forced landing.NTSB GAA15CA208Accident · No injuriesData collectionFinal reportCessna 172R · North Vernon, INThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.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 GAA15LA195Accident · Serious injuriesLimited investigationFinal reportKubicek BB100Z · Hidden Valley Lake, CAThe balloon pilot’s deliberate hard landing to avoid power lines and trees, which resulted in serious passenger injuries.NTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB ERA15CA267Accident · No injuriesData collectionFinal reportBrandt Leroy E Challenger II · Batavia, NYThe pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB GAA15CA180Accident · No injuriesData collectionFinal reportPietenpol AIR Camper · Burlington, WIThe student pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.NTSB ERA15WA284Accident · Serious injuriesForeign investigationRobinson R66 · Baykalsk, RussiaNTSB GAA15CA176Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar SL · Montgomery, NYThe pilot's improper pitch control which resulted in a hard landing. A factor contributing to the accident was the pilot's improper recovery from a bounced landing.NTSB CEN15LA300Accident · Serious injuriesLimited investigationFinal reportBalony Kubicek Spol BB60Z · Fort Carson, COThe pilot’s improper burner control, which allowed the balloon’s envelope to cool, and the balloon’s subsequent encounter with a drop in wind velocity during a high wind landing approach, both of which resulted in the balloon’s descent rate increasing too…NTSB GAA15CA140Accident · No injuriesData collectionFinal reportCessna 172 - S · Traverse City, MIThe student pilot's failure to maintain pitch control during the landing, resulting in a hard landing.NTSB GAA15CA142Accident · No injuriesData collectionFinal reportCessna 182P · Westminster, MDThe flight instructor's delayed remedial action during the landing flare, which resulted in a hard landing and porpoise.NTSB CEN15LA275Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Pueblo, COThe student pilot’s decision to continue the approach and landing despite recognizing that the wind speed was above the published limit for solo flight, which resulted in a porpoised landing. Contributing to the accident was the failure of the flight…