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 FTW99LA264Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXThe pilot's hard landing as result of his improper landing flare and his improper recovery from a bounced landing. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB LAX99TA308Accident · No injuriesFinal reportCessna A185F · Daggett, CAthe pilot's failure to recognize an excessive rate of descent and his subsequent delayed flare, which resulted in a hard landing.NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.NTSB MIA99IA249Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Nashville, TNA preexisting crack on the left main landing gear outer cylinder housing and the first officer's failure to maintain the proper rate of descent resulting in a hard landing on touchdown, and subsequent total failure and separation of the left main landing gear…NTSB LAX99LA300Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-BETA · Piute, NVthe failure of the pilot to maintain rotor rpm while practicing autorotations, resulting in a hard landing and roll over.NTSB ANC99LA148Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Sleetmute, AKThe pilot's selection of an unsuitable landing area. A factor in this accident was the rough and uneven gravel bar.NTSB SEA99LA156Accident · No injuriesLimited investigationFinal reportCessna 182M · Sandpoint, IDThe pilot's improper flare. Factors include a runway that sloped uphill, and the pilot's failure to familiarize himself with the destination airstrip prior to departure.NTSB IAD99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Nantucket, MAthe pilot's inadequate recovery from a bounced landing which resulted in a hard landing and the fracture and collapse of the right main landing gear.NTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB NYC99LA217Accident · No injuriesLimited investigationFinal reportHughes 269C · Utica, NYThe pilot's failure to maintain control of the helicopter while maneuvering, which resulted in a hard landing. A factor in this accident was the pilot's lack of total experience in helicopters.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.NTSB ANC99LA125Accident · No injuriesLimited investigationFinal reportLearjet 35 · Glennallen, AKThe pilot-in-command's delay in applying remedial action. A factor associated with the accident was the second-in-command's failure to maintain proper airspeed during final approach.NTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.NTSB ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB MIA99LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Ocala, FLA misjudged flare and the failure of the student pilot to use the proper recovery technique for a bounced landing, allowing the airplane to commence a porpoise, and the eventual collapse of the nose landing gear.NTSB DEN99LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tooele, UTAn inadequate flare during landing touchdown, resulting in a fracture of the right main landing gear strut. A factor was the flight instructor's failure to properly supervise the student.NTSB DEN99LA143Accident · No injuriesLimited investigationFinal reportMoore Q-200 · Cortez, COThe pilot's improper recovery from a bounced landing and his failure to maintain directional control. Related factors were the soft wet terrain.NTSB NYC99LA195Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chatham, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC99LA228Accident · No injuriesLimited investigationFinal reportPiper PA-601P · West Dover, VTwas the diverted attention of the pilot, which resulted in his failure to maintain airspeed, and his failure to lower the landing gear prior to landing.NTSB LAX99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Coalinga, CAThe flight instructor's failure to maintain a sufficient airspeed to compensate for the known wind shear condition, which resulted in a failure to maintain runway alignment and a hard landing. The flight instructor's inadequate supervision of the flight was…NTSB NYC99LA190Accident · Minor injuriesLimited investigationFinal reportRobinson R-22A · Shirley, NYThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.NTSB DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.NTSB NYC99LA188Accident · No injuriesLimited investigationFinal reportCessna 172R · Cheswold, DEThe pilot's improper flare and improper recovery from a bounced landing.NTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.NTSB CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.NTSB CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.NTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.NTSB CHI99LA244Accident · No injuriesLimited investigationFinal reportCessna 182N · Green Bay, WIThe pilot's delayed flare and his improper recovery from a bounced landing.NTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.NTSB FTW99LA193Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaumont, TXThe student pilot's excessive rate of descent resulting in the hard landing and his improper recovery from a bounced landing.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind was a factor.NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.NTSB FTW99TA190Accident · Minor injuriesFinal reportHughes 269C · Houston, TXThe hard landing as a result of the flight instructor's failure to attain the proper airspeed before simulating an engine failure, which resulted in the development of a high sink rate. Factors were the night illumination and the soft ground.NTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.NTSB LAX99LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Fresno, CAThe pilot's misjudged landing flare and inadequate recovery procedures from the subsequent bounced landing.NTSB NYC99LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHWas the failure of the flight instructor to recognize the high sink rate and apply corrective action in a timely manner.NTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.NTSB LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.NTSB DEN99LA108Accident · No injuriesLimited investigationFinal reportBeech B90 · Creede, COOverload failure of the right main landing gear scissors torque link precipitated by preexisting fatigue fractures. A factor was wind shear.NTSB SEA99LA092Accident · No injuriesLimited investigationFinal reportHughes 369D · Shelton, WAThe pilot's failure to maintain rotor RPM during an autorotation.NTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.NTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.NTSB LAX99LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Monica, CAThe pilot's misjudged landing flare which resulted in a hard landing and the subsequent porpoising of the airplane; and his failure to maintain directional control that resulted in a ground loop and substantial damage to the airplane.NTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.NTSB NYC99LA142Accident · No injuriesLimited investigationFinal reportMorrow RV-6 · Bradford, PAThe pilot's improper flare which resulted in a hard landing, and subsequent collapse of the nose gear.NTSB FTW99LA167Accident · No injuriesLimited investigationFinal reportCessna 172D · Jonesboro, ARThe pilot's inadequate preflight planning and preparation, and her delayed aborted takeoff. Factors were the high density altitude and the tall grass on the airstrip.