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 DEN99LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Junction, COA hard landing when the pilot failed to sufficiently flare the aircraft for touch down. Factors were high-density altitude, and the pilot's lack of total flight experience.NTSB CHI99LA181Accident · Minor injuriesLimited investigationFinal reportRobbins Verieze · Odessa, MOThe pilot's misjudgment of altitude during landing.NTSB ANC99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to compensate for the wind conditions and maintain a proper rate of descent during the approach for landing, which resulted in a hard landing, and the subsequent collapse of the right main landing gear strut.NTSB ANC99FA070Accident · 1 fatalField investigationFinal reportCessna A185F · Soldotna, AKThe improper recovery from a bounced water landing by the pilot. Factors associated with this accident were the pilot's failure to release his seatbelt due to the obstructed location of the pilot's seatbelt buckle.NTSB MIA99LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150M · La Fayette, GAThe improper flare by the student pilot and the inadequate supervision by the pilot in command.NTSB NYC99LA132Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jaffrey, NHThe pilot's failure to maintain sufficient rotor rpm. A factor in this accident was the crosswind condition.NTSB LAX99FA207Accident · No injuriesField investigationFinal reportBoeing 757-232 · Phoenix, AZThe pilot's excessive and rapid forward control column movement in response to a bounced landing, which resulted in the hard touchdown of the nose wheel.NTSB ANC99LA066Accident · No injuriesLimited investigationFinal reportde Havilland DHC 2 MK III · Anchorage, AKThe certificated flight instructor's inadequate supervision of the duel student. Factors associated with the accident were the student's inadvertent stall, and a surging turboshaft engine.NTSB NYC99LA129Accident · No injuriesLimited investigationFinal reportMooney M20R · Ravenna, OHThe pilot's improper flare which resulted in a hard landing, and his failure to maintain directional control after touchdown.NTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.NTSB LAX99LA189Accident · Serious injuriesLimited investigationFinal reportCameron A-250 · Windsor, CAThe pilot did not obtain the most current weather briefing available, which forecast high winds about his actual landing time. The balloon encountered high winds and collided with an embankment in a field during a precautionary hard landing. Factors in the…NTSB DEN99LA084Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Baggs, WYThe pilot not maintaining the main rotor's RPM. Factor's were the high density altitude, and the mountainous/hilly terrain.NTSB SEA99LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · Buhl, IDAn inadequate recovery from a bounced landing. Gusting wind conditions were a factor.NTSB LAX99LA185Accident · No injuriesLimited investigationFinal reportCessna 172R · Imperial, CAThe pilot's misjudged landing flare, which led to an inadvertent porpoise condition.NTSB CHI99LA153Accident · No injuriesLimited investigationFinal reportBell 222UT · Rockton, ILThe pilot's misjudged flare during landing. A factor to the accident was the dark night lighting condition.NTSB SEA99LA061Accident · No injuriesLimited investigationFinal reportEugene Hughes Lancair IV · Butte, MTThe pilot's improper flare.NTSB ANC99LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Galena, AKThe pilot-in-command's inadvertent stall during the flare for landing. A factor associated with the accident was the pilot-in-command's obstructed view of the airspeed indicator.NTSB IAD99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Manassas, VAThe student pilot's failure to maintain the proper rate of descend on final approach followed by an improper flare which resulted on a hard landing.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB FTW99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cleburne, TXThe pilot's improper flare which resulted in a hard landing and his improper recovery procedures from a bounced landing.NTSB IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.NTSB SEA99LA052Accident · No injuriesLimited investigationFinal reportCessna 177 · Auburn, WAThe pilot's improper flare. Contributing factors were gusty, crosswind conditions, and the student's minimal overall experience.NTSB NYC99LA090Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Jefferson, NYthe lack of supervision by the flight instructor which resulted in a low rotor condition and subsequent hard landing.NTSB LAX99LA139Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Ramona, CAThe pilot's failure to maintain an adequate airspeed margin to compensate for the variable wind conditions existing at the time of the landing.NTSB NYC99LA086Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrence, MAThe student pilot's improper flare, and his improper recover from a bounced landing.NTSB DEN99LA059Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Elbert, COThe pilot's failure to maintain a proper descent rate during touchdown, resulting in a hard landing. A factor was the passenger's failure to properly position herself for the landing.NTSB DEN99LA058Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COThe flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.NTSB ATL99LA058Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB LAX99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Chico, CAThe CFI's inadequate supervision and delayed remedial action to rectify his student's bounced landing. Contributing factors were the short runway and obstructing trees.NTSB LAX99LA100Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe pilot's misjudged landing flare resulting in a hard touchdown, and, his failure to adequately compensate for the existing crosswind condition and to maintain directional control during rollout on the wet runway.NTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.NTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.NTSB MIA99LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and subsequent impact with the runway.NTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.NTSB LAX99LA110Accident · No injuriesLimited investigationFinal reportHelio Jergins H 800 · Prescott, AZThe malfunction of the propeller for undetermined reasons at an altitude too low for the pilot to take effective remedial action.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB MIA99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Sanford, FLthe pilot misjudged the flare resulting in a hard landing and damage to the airplane.NTSB FTW99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Denton, TXThe hard landing as a result of the pilot's failure to maintain the proper descent rate during the landing flare.NTSB LAX99TA088Accident · No injuriesFinal reportMcDonnell Douglas 369D · Las Vegas, NVThe pilot's failure to properly judge the landing flare maneuver during a practice autorotative landing resulting in a hard landing.NTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.NTSB CHI99LA064Accident · No injuriesLimited investigationFinal reportGulfstream 695A · Wheeling, ILThe pilot-in-command (CFI)'s poor in-flight planning and decision making, and his inadequate supervision of the dual student. Factors were the tailwind condition, icing conditions, and the dual student's improper flare.NTSB NYC99LA048Accident · No injuriesLimited investigationFinal reportCessna 310R · Allentown, PAThe pilot's improper decision to reduce too much power during the landing flare.NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.NTSB CHI99LA061Accident · No injuriesLimited investigationFinal reportBeech BE-V35B · Olathe, KSThe pilot's continued flight into adverse weather that resulted in structural icing and subsequently an aerodynamic stall on landing flare. A factor was the pilot's inadequate weather evaluation .NTSB ATL99LA036Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Murfreesboro, TNThe pilot's inadequate flare and his diverted attention, which resulted in a hard landing.NTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB SEA99LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bellingham, WAA hard landing due to the pilot's failure to maintain a proper descent rate. Factors include gusts and turbulence.NTSB LAX99LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Bear, CAThe pilot's misjudged landing flare, which lead to an inadvertent stall/mush 10 feet above the ground.NTSB FTW99LA053Accident · Serious injuriesLimited investigationFinal reportDennis Pointer KR-2 · Denton, TXThe pilot's loss of control as result of his improper recovery from a bounced landing.