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 ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB WPR10LA452Accident · No injuriesLimited investigationFinal reportAerospatiale SA315 · Winters, CAA 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 CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.NTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.NTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.NTSB WPR10CA442Accident · No injuriesData collectionFinal reportSchweizer 269C · Caldwell, IDThe failure of both pilots to maintain adequate main rotor RPM, the flight instructor's delayed remedial actions, and inadequate supervision of the flight.NTSB ERA10CA452Accident · No injuriesData collectionFinal reportKilishek George T RV-8 · Yadkinville, NCThe pilot's inadequate flare, which resulted in a hard landing.NTSB ERA10CA468Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDUndetermined.NTSB WPR10LA426Accident · No injuriesLimited investigationFinal reportGrob-Werke G 120A · Buckeye, AZThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA10CA432Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe instructor's delayed remedial action, which resulted in a loss of rotor rpm and a hard landing.NTSB DCA10RA085Accident · 1 fatalForeign investigationBoeing 737 · San Andres Island, ColombiaOn August 16, 2010, at 0150 UTC, an Aires B737-700, registration HK4682, crashed on approach to the San Andres Island Airport in San Andres Island, Colombia. Of the 121 passengers and 6 crew on board, preliminary reports indicate that there was one fatality…NTSB CEN10CA528Accident · No injuriesData collectionFinal reportClem William B III Dominator Gyrocopter · Brighton, COThe pilot's failure to maintain control of the gyroplane during landing.NTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.NTSB CEN10CA485Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Mack, COThe flight instructor's failure to maintain control of the helicopter during a practice autorotation, which resulted in a hard landing.NTSB WPR10CA401Accident · Minor injuriesData collectionFinal reportCessna 180D · Hillsboro, ORA loss of engine power due to fuel starvation resulting from unporting when the pilot entered into a slip during the turn to the final approach leg.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.NTSB ERA10CA412Accident · No injuriesData collectionFinal reportMooney M20M · Poughkeepsie, NYThe pilot's improper flare which resulted in a hard landing, loss of directional control and runway excursion.NTSB ERA10LA405Accident · No injuriesLimited investigationFinal reportGlines Sportsman GS-2 · Morrisville, VTThe pilot's improper flare during a forced landing. Contributing to the accident was a loss of fuel pressure for undetermined reasons.NTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.NTSB CEN11CA018Accident · Minor injuriesData collectionFinal reportCessna 172M · Newton, KSThe pilot’s inadequate flare, which resulted in a hard landing.NTSB WPR10LA370Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Walla Walla, WAThe pilot's partial incapacitation during cruise flight and his subsequent inadequate fuel management, which resulted in fuel starvation.NTSB WPR10CA475Accident · No injuriesData collectionFinal reportCessna 172S · Santa Maria, CAThe pilot's inadequate flare which resulted in a bounce and hard landing.NTSB ERA10CA398Accident · No injuriesData collectionFinal reportCessna 172 · White Plains, NYThe student pilot's improper landing flare and the flight instructor's delayed remedial action resulting in a bounced landing.NTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.NTSB ERA10CA372Accident · No injuriesData collectionFinal reportCessna 150M · Knoxville, TNThe student pilot's improper recovery from a bounced landing.NTSB CEN10LA408Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Minden, NEThe pilot's inadequate flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.NTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.NTSB CEN10LA414Accident · No injuriesLimited investigationFinal reportWogenstahl Wallace L Wogenstahl 281 MR · Mount Cory, OHThe improper installation of the rivets at the aft fuselage bulkhead which resulted in the pilot not having full elevator control on landing.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB WPR10LA336Accident · Minor injuriesLimited investigationFinal reportJohnson Helicycle · Arlington, WAAn undetermined airframe vibration which led to precautionary autorotation and hard landing.NTSB WPR10CA332Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garfield, WAA loss of engine power due to fuel exhaustion.NTSB ERA10FA347Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Fairfield, NJThe pilot's failure to maintain aircraft control during the go-around following a hard landing. Contributing to the accident was the pilot's continuance of an unstabilized final approach and the improper use of flaps during the go-around.NTSB ERA10CA355Accident · No injuriesData collectionFinal reportPiper J3C-65 · Warrenton, VAThe pilot's improper flare during a precautionary landing, which resulted in a hard landing.NTSB CEN10LA383Accident · No injuriesLimited investigationFinal reportCessna 182M · Alamagordo, NMThe pilot's loss of airplane control during landing, which resulted in a hard/bounced landing.NTSB ERA10CA363Accident · No injuriesData collectionFinal reportCessna 172S · Chesapeake, VAA hard landing by person(s)unknown.NTSB ERA10CA336Accident · No injuriesData collectionFinal reportSchooley Sonex · Punta Gorda, FLThe pilot's improper flare, resulting in a hard landing.NTSB CEN10CA352Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Lake Charles, LAThe flight instructor’s inadvertent entry into ground resonance when demonstrating a hydraulic failure running landing, which resulted in substantial damage to the helicopter. Contributing to the accident was the pilot's and instructor pilot's failure to…NTSB CEN10LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Fremont, NEThe pilot’s loss of control for undetermined reasons.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB CEN10CA336Accident · No injuriesData collectionFinal reportCessna 172N · Maryland Heights, MOThe pilot's improper flare, which resulted in a hard landing.NTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.NTSB ERA10LA314Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sandersville, GAA total loss of engine power for undetermined reasons.NTSB ERA10CA326Accident · No injuriesData collectionFinal reportCessna 172 · New Smyrna Beach, FLThe student pilot’s improper landing flare, and the flight instructor's delayed remedial action.NTSB CEN10LA312Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Ankeny, IAThe failure of the stabilator control cable due to wear. Contributing to the accident was the inadequate maintenance inspection of the stabilator control cable.NTSB CEN10LA303Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Kingfisher, OKThe pilot's inadequate airspeed while landing, which led to an aerodynamic stall and a hard landing.