NTSB investigations, 2015
109 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 year(c.\"eventDate\") = 2015
AND 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 year(c."eventDate") = 2015 AND 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 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 ERA15CA264Accident · Minor injuriesData collectionFinal reportHaphey Bruce Frederic Mustang II · Palatka, FLThe pilot's failure to maintain airplane control during a balked landing and attempted go-around in dark night conditions and without a landing light, which resulted in collision with terrain.NTSB WPR15LA209Accident · No injuriesLimited investigationFinal reportMooney M 20G · Phoenix, AZThe pilots' failure to apply carburetor heat during the approach for landing, which resulted in a total loss of engine power due to carburetor icing.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 WPR15FA205Accident · 2 fatalField investigationFinal reportSchweizer 269C · Newberg, ORThe loss of translation/rotational power between the engine and the transmission due to the severe wear of the forward spline portion of the lower coupling drive shaft. The reason for the severe wear of the forward spline could not be definitively determined…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 CEN15LA284Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Casper, WYThe improper repair of the carburetor heat cable sheath to clamp joint, which prevented the proper operation of the carburetor heat and resulted in the loss of engine power.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…NTSB CEN15LA265Accident · No injuriesLimited investigationFinal reportBell 407 · Pecan Island, LAThe fatigue fracture of the tail rotor gearbox attachment studs, which resulted in a loss of tail rotor control and a subsequent hard landing.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 GAA15CA111Accident · No injuriesData collectionFinal reportCessna 177 · Clewiston, FLThe pilot's improper level off and flare in crosswind conditions, which resulted in a loss of control and hard landing.NTSB CEN15CA261Accident · Minor injuriesData collectionFinal reportBrewer Sportcopter Votex M · Sikeston, MOThe pilot inadvertently reducing engine power to the idle position while maneuvering at a low altitude.NTSB GAA15CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Palm Springs, CAThe pilot's improper landing flare which resulted in a hard landing and substantial damage to the firewall.NTSB WPR15LA178Accident · No injuriesLimited investigationFinal reportGarlick Helicopters UH 1H · Cove, ORThe failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.NTSB GAA15CA119Accident · No injuriesData collectionFinal reportCessna 172R · Beaver Falls, PAThe student pilot's failure to maintain airplane attitude control during the landing, resulting in a hard landing.NTSB GAA15CA099Accident · No injuriesData collectionFinal reportCessna 172 - R · State College, PAThe student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.NTSB ANC15CA031Accident · No injuriesData collectionFinal reportAeronca 7EC · Palmer, AKThe instructor's delayed remedial actions, and the student pilot's failure to maintain adequate airspeed, which resulted in a stall just above the ground and the subsequent hard landing.NTSB GAA15CA094Accident · No injuriesData collectionFinal reportCessna 182E · Galion, OHThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an in-flight loss of control and hard landing.NTSB ERA15CA226Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · LaGrangeville, NYThe pilot's decision to conduct a landing to a field in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.NTSB ERA15LA218Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kearny, NJThe deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.NTSB CEN15LA228Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Ranger, TXA total loss of engine power during cruise flight due to piston fatigue cracking for reasons that could not be determined due to postfracture smearing damage.NTSB ANC15LA076Accident · No injuriesClass 3 · LimitedFinal reportAirbus AS-350 · Hamilton, MTThe pilot's excessive collective application during an autorotation. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.NTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.NTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.NTSB ERA15WA211Accident · Minor injuriesForeign investigationBell 430 · Aydin, TürkiyeOn April 26, 2015, at 1322 coordinated universal time, a Bell 430, Turkish-registered TC-HSZ, was substantially damaged following a hard landing near Aydin, Turkey. The pilot and co-pilot were not injured. Two passengers sustained minor injuries, and three…NTSB GAA15CA054Accident · No injuriesData collectionFinal reportBellanca 1730 - A · Campbellsville, KYThe pilot's improper landing flare which resulted in a hard landing.NTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.NTSB GAA15CA046Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain airplane control, resulting in a hard landing.NTSB GAA15CA044Accident · No injuriesData collectionFinal reportCessna 150M · Slate Hill, NYThe pilot's failure to maintain an adequate descent rate, resulting in a hard landing.NTSB GAA15CA058Accident · No injuriesData collectionFinal reportCessna 172P · TamuningThe student pilot's failure to maintain pitch control, resulting in a hard landing.NTSB DCA15WA107Accident · No injuriesForeign investigationBoeing 737 - 804 · Khajuraho, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a BOEING 737 that occurred on April 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB GAA15CA038Accident · Minor injuriesData collectionFinal reportUltramagic M90 - NO Series · Sherwood, ORThe pilot's failure to maintain the descent rate, resulting in a hard landing.NTSB GAA15CA035Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot's improper flare which resulted in a loss of control and subsequent hard landing.NTSB GAA15CA041Accident · No injuriesData collectionFinal reportCessna 182R · Fort Myers, FLThe pilot's excessive descent rate during approach, which resulted in a hard landing.NTSB WPR15WA171Accident · Serious injuriesForeign investigationSikorsky S76 - C · East Kalimantan, IndonesiaOn March 21, 2015, about 1030 local time, a Sikorsky S-76C+ helicopter, registration PK-FUP, sustained substantial damage following an emergency landing near East Kalimantan, Indonesia. Reports indicate that the two pilots received serious injuries and five…NTSB GAA15CA016Accident · No injuriesData collectionFinal reportFlight Design Ctls · Mount Vernon, OHThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB GAA15LA015Accident · Serious injuriesLimited investigationFinal reportUltramagic N210 · Peoria, AZThe pilot's selection of unsuitable terrain for landing after noting a higher-than-anticipated wind speed and the balloon's high descent rate, which resulted in a hard landing.NTSB GAA15CA005Accident · No injuriesData collectionFinal reportCessna 208B · Muskegon, MIThe pilot's improper decision to continue the landing when the airplane was not in a safe position to land, resulting in the collision with ground-based approach lighting.NTSB ERA15CA153Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe student pilot's failure to maintain aircraft control during landing, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB GAA15CA003Accident · No injuriesData collectionFinal reportSchupp Edward W SKY Ranger II · San Manuel, AZThe pilot's failure to maintain directional control during landing.NTSB ERA15CA150Accident · No injuriesData collectionFinal reportCessna 172S · Richmond, VAThe student pilot's inadequate landing flare which resulted in a hard landing and substantial damage to the airplane.NTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.NTSB ERA15CA117Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Valdosta, GAThe pilot's failure to compensate for gusty wind conditions during the landing flare, which resulted in a hard landing and subsequent nose landing gear collapse.