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 CHI02LA230Accident · No injuriesLimited investigationFinal reportErcoupe G · Palmyra, WIFailure by the pilot-in-command to properly compensate for the wind conditions, as well as an improper landing flare. Contibuting factors were the inadequate supervision by the flight instructor and the wind gusts.NTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.NTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.NTSB MIA02LA138Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Trenton, GAThe failure of the pilot to clear the engine during a prolonged approach at idle power resulting in the engine hesitating during application of power to arrest the descent for landing touchdown resulting in a hard landing and separation of the left main…NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB CHI02CA214Accident · No injuriesData collectionFinal reportCessna 182A · Laretto, MNThe pilot's improper flare.NTSB IAD02LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Port Clinton, OHThe pilot's improper flare, and his failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA02LA129Accident · No injuriesLimited investigationFinal reportRockwell International 690A · Crescent Lake, ORThe pilot's failure to maintain proper rate of descent resulting in a hard landing and subsequent nose gear separation. Contributing factors were the turbulent crosswind conditions the pilot encountered just before touchdown.NTSB NYC02LA145Accident · No injuriesLimited investigationFinal reportCessna 172N · Middletown, RIThe pilot's improper flare. A factor was the shifting wind.NTSB ATL02LA142Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Atlanta, GAThe pilot's improper flare which resulted in a hard landing.NTSB ATL02LA141Accident · No injuriesLimited investigationFinal reportHughes HU-269-A · Hamilton, ALThe pilot's improper use of flight controls that resulted in an improper flare and a hard landing during a practice autorotation. A factor was the loss of rotor rpm.NTSB ATL02LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Merritt Island, FLThe pilot's improper recovery after a bounced landing and improper landing flare which resulted in the airplane colliding with the runway.NTSB ANC02LA076Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Juneau, AKThe pilot's improper flare resulting in a hard landing. Factors contributing to the accident were the quartering tailwind, and the inadvertent water loop.NTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.NTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.NTSB MIA02LA129Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F21B · Somerville, TNThe pilot's improper landing flare resulting in a hard landing and damage to the airplane.NTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.NTSB CHI02CA182Accident · No injuriesData collectionFinal reportBeech A-23-23 · Monroe, MIThe pilot misjudging the flare, and his loss of directional control during landing. The soft terrain was a factor.NTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.NTSB SEA02LA115Accident · No injuriesLimited investigationFinal reportSeattle Aerotech Helipower 2500 · Arlington, WAAircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.NTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.NTSB ANC02LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nikiski, AKThe pilot's excessive rate of descent resulting in a hard landing on water.NTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…NTSB CHI02LA171Accident · No injuriesLimited investigationFinal reportHulle Horizon 1 · Niles, MIThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of experience in tailwheel airplanes.NTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.NTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.NTSB CHI02LA170Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Kansas City, MOThe inadequate flare by the flying pilot and the remedial action not performed by the company check airman.NTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.NTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.NTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.NTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.NTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.NTSB CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.NTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.NTSB NYC02LA108Accident · No injuriesLimited investigationFinal reportCessna 182B · Littlestown, PAThe pilot's improper flair, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.NTSB NYC02LA105Accident · No injuriesLimited investigationFinal reportBell 206 · Columbus, OHThe flight instructor's delay in applying remedial action. A factor in the accident was the pilot allowing the rotor rpm to become too low during the deceleration and touchdown phase of the autorotation.NTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.NTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.NTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.NTSB LAX02LA153Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Green Valley, AZThe pilot's failure to identify the wind direction, which led to an attempted downwind landing approach that resulted in a hard landing and severe bounce. Also causal was the pilot's failure to promptly retract the flaps during the rejected landing after…NTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB ATL02LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Locust Grove, GAThe pilot improper flare during an aborted takeoff, followed by an subsequent hard landing.NTSB MIA02LA091Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLthe pilot misjudged the landing flare, resulting in a hard landing, and damage to the airplane.NTSB FTW02LA131Accident · No injuriesLimited investigationFinal reportCessna 210 · Albuquerque, NMthe pilot's inadequate compensation for the wind conditions resulting in a hard landing. A contributing factor was the gusty winds.NTSB CHI02LA119Accident · No injuriesLimited investigationFinal reportCessna 560 · Lake In The Hil, ILThe flightcrew's delay in executing a go-around..