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 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.NTSB WPR15LA096Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Calexico, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15CA125Accident · Minor injuriesData collectionFinal reportCessna 182C · Fort Morgan, COThe pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.NTSB WPR15CA093Accident · No injuriesData collectionFinal reportFlight Design Ctls · Hanford, CAThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN15CA121Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper landing technique which resulted in a hard landing and subsequent nose landing gear collapse.NTSB WPR15LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Flagstaff, AZThe pilot's improper landing flare and loss of airplane control, which resulted in a hard landing and the subsequent failure of the nose landing gear.NTSB CEN15WA110Incident · No injuriesForeign investigationGulfstream G200 · Luton, United Kingdom, United KingdomOn January 14, 2015, about 2127 universal time (UTC), a Spanish registered Gulfstream G200, EC-KRN, sustained minor damage during landing at London Luton Airport, Luton, United Kingdom. The pilot, copilot, and six passengers were not injured. The four main…NTSB ERA15CA116Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Deland, FLThe pilot's inadequate preflight weather planning and decision to land in an area with known convective wind gusts, which resulted in a loss of control and subsequent hard landing.NTSB DCA15WA049Accident · Minor injuriesForeign investigationBoeing 737 · Accra, GhanaNTSB CEN15LA103Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons USA 120A · Peru, INThe hard landing due to a higher-than-forecast surface wind, which resulted in a serious neck injury to the pilot.NTSB ERA15FA085Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Lake Worth, FLA main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA15CA080Accident · No injuriesData collectionFinal reportBauer Thomas G Kitfox III · Bumpass, VAThe pilot's improper flare during a water landing.NTSB CEN15LA084Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Fort Lupton, COThe loss of engine power during cruise flight for reasons that could not be determined based on the available information.NTSB ERA15CA069Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Wachula, FLThe pilot's improper recovery from a bounced landing during gusty crosswind conditions.NTSB ERA15LA062Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Hampton, SCThe pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…NTSB WPR15CA068Accident · No injuriesData collectionFinal reportCessna E162 · Santa Rosa, CAThe student pilot's improper flare which resulted in a hard landing and subsequent nose gear collapse.NTSB WPR15CA043Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe certified flight instructor's failure to maintain helicopter control during the autorotation which resulted in a hard landing and subsequent roll over.NTSB ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.NTSB ERA15LA060Accident · No injuriesLimited investigationFinal reportBell 206B · West Palm Beach, FLA hard landing for reasons that could not be determined based on the available evidence.NTSB ERA15CA035Accident · Serious injuriesData collectionFinal reportHead AX8 88B · Montevallo, ALThe pilot's decision to conduct a landing to a confined area in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB ERA15CA018Accident · No injuriesData collectionFinal reportBell 206B · Prattville, ALThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15LA015Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Granville, MADeformation of the No. 1 cylinder's intake valve, which resulted in a partial loss of engine power and a subsequent off-airport precautionary landing.NTSB CEN15CA010Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesville, OHThe pilot's inadequate flare, which resulted in a hard landing.