NTSB investigations
3,083 cases where the first occurrence 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) 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 ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB IAD03LA037Accident · No injuriesLimited investigationFinal reportBeech 23 · Cincinnati, OHThe second pilot's inadequate flare and the pilot/owner's lack of remedial action, which resulted in a hard landing. A factor was the wind gusts.NTSB ATL03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rogersville, TNThe pilot's improper landing flare which resulted in a hard landing.NTSB CHI03LA062Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOThe excessive descent rate that required an abrupt flare, resulting in the main rotor severing the tailboom.NTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…NTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.NTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.NTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.NTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.NTSB SEA03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Pasco, WAIcing conditions and the pilot's failure to maintain adequate airspeed during the landing. An inadvertent stall was a factor.NTSB MIA03LA022Accident · No injuriesLimited investigationFinal reportLet L-23 · Groveland, FLthe pilot's failure to extend the dive brakes during approach and his excessive airspeed and improper landing flare which resulted in the airplane nosing down and impacting with the runway.NTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB IAD03LA014Accident · No injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe student pilot's improper power management during the short-field landing procedure, and the flight instructor's delayed remedial action.NTSB LAX03LA046Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the gusty wind.NTSB MIA03LA014Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · Foxworth, MSThe pilots failure to properly recover from a stalled/mush/high sink rate condition during an approach and attempted aborted landing into a gusting crosswind, resulting in a hard touchdown, bounced landing, loss of directional control and in-flight collision…NTSB LAX03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Corona, CAThe pilot's misjudged landing flare. Also causal were the pilot's improper bounced landing recovery procedures and inadvertent swerve, resulting in the landing gear collapsing from overload.NTSB LAX03LA010Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hayward, CAThe flight instructor's inadequate supervision and delayed remedial action, which resulted in a hard landing.NTSB SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.NTSB FTW03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.NTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.NTSB FTW03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Norman, OKThe pilot's failure to maintain directional control. A factor was the inadequate flare.NTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.NTSB LAX02LA301Accident · No injuriesLimited investigationFinal reportCessna 182G · Paradise, CAthe pilot's improper flare resulting in a hard landing.NTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.NTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.NTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…NTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.NTSB LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.NTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.NTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.NTSB FTW02LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKthe pilot's improper recovery from a bounced landing, which resulted in a hard landing.NTSB ATL02LA166Accident · No injuriesLimited investigationFinal reportCessna 172S · Immokalee, FLThe student pilot's improper flare at touchdown resulted in a hard landing while performing an off-airport precautionary landing after the inadvertent activation of the autopilot.NTSB FTW02LA240Accident · Serious injuriesLimited investigationFinal reportBalloon Works FireFly 7B-15 · Oklahoma City, OKthe pilot's inadvertent flight into adverse weather conditions resulting in a hard landing. A contributing factor was the high wind.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB NYC02FA171Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Andover, NJThe flight instructor's delayed remedial action to correct the low rotor condition. A factor was the student pilot's improper use of the collective, which created the low rotor condition.NTSB MIA02LA155Accident · Serious injuriesLimited investigationFinal reportBarnes Vans RV-6 · Chesnee, SCthe pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.NTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.NTSB SEA02LA153Accident · Serious injuriesLimited investigationFinal reportMooney M20L · Newberg, ORThe pilot's inadequate flare and his delay in executing an aborted landing. A contributing factor was the dark night conditions.NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.NTSB DEN02LA093Accident · No injuriesLimited investigationFinal reportCessna 310N · Grand Junction, COThe dual student's inadequate aircraft control resulting in a hard landing. Contributing factors include, the dual student's inadequate airspeed and high flare, the inadequate supervision by the instructor, the in-flight separation of the right main landing…NTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.NTSB ANC02LA124Accident · No injuriesLimited investigationFinal reportWilliamson GlaStar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors in the accident were the pilot's inadequate compensation for the crosswind condition, and the misjudged landing flare.NTSB IAD02LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Mount Pocono, PAThe pilot's improper flare, which resulted in a hard landing.NTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.NTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.