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 NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.NTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.NTSB CHI91LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Wichita, KSRemedial action was delayed by the instructor pilot. A factor related to the accident was an excessive rate of descent.NTSB LAX91LA152Accident · No injuriesLimited investigationFinal reportHughes 269C · Honolulu, HIThe instructor's improperly planned approach. A factor was the pilot's failure to observe performance data for the helicopter.NTSB ANC91LA041Accident · No injuriesLimited investigationFinal reportBell 47 · Thompson Pass, AKThe pilot's failure to maintain aircraft control and improper flare during landing.NTSB CHI91LA113Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Augusta, KSAn improper autorotation was performed by the dual student and remedial action was delayed by the CFI. Factors related to the accident were: inadequate airspeed and rotor RPM.NTSB CHI91LA119Accident · No injuriesLimited investigationFinal reportCessna 182P · Loup City, NEThe pilot's improper landing/touchdown. A related factor was the pilot's lack of total flight experience.NTSB LAX91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Eloy, AZThe student pilot's improper recovery from a bounced landing and the inadvertent entry into a porpoise condition.NTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.NTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.NTSB FTW91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Leander, TXThe pilot's failure to maintain a proper descent rate during the final approach.NTSB CHI91LA103Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Chicago, ILAn excessive landing flare by the copilot. Factors associated with the accident are the inoperative wing flaps and the captain's inadequate supervison.NTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.NTSB LAX91LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · San Carlos, CAThe pilot's improper flare landing.NTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.NTSB MIA91LA080Accident · No injuriesLimited investigationFinal reportBeech 58 · St. ThomasExcessive descent rate by the pilot, improper recovery from the bounced landing, and failure to recover from the porpoise condition.NTSB LAX91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe student pilot's improper bounced landing recovery technique. A factor in the accident was the pilot's limited flight experience.NTSB DEN91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe inadequate supervision of the student by the flight instructor. A factor was: the student's failure to flare the aircraft.NTSB CHI91LA067Accident · No injuriesLimited investigationFinal reportBeech 200 · Vichy, MOA restricted visual outlook and go-around was not performed by the pilot. Factors related to the accident were a dark night, fog and glare, ice covered runway and whiteout conditions.NTSB LAX91LA070Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZThe instructor pilot's delay in executing a recovery flare from the autorotative descent, and the helicopter's inadequate altitude during flare. A contributing factor was related to the instructor pilot being inattentive to his student's performance.NTSB CHI91LA056Accident · No injuriesLimited investigationFinal reportCessna 340 · Chesterfield, MOFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident are a foggy windshield, misjudgement of altitude, premature landing flare, and slush on the runway.NTSB MIA91LA060Accident · No injuriesLimited investigationFinal reportHughes 269C · Deland, FLFailure of the commercial pilot applicant to pull collective pitch and delay by the check airman to pull collective and apply power to recover, resulting in a hard landing.NTSB LAX91LA064Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Truckee, CA1) The pilots improper flare maneuver; 2) his failure to perform a bounced landing recovery; and 3) his failure to maintain directional control of the aircraft.NTSB CHI91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pinconning, MIInadequate airspeed, wind shear and a stall.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB CHI91LA044Accident · No injuriesLimited investigationFinal reportCessna 182RG · Lansing, ILExcessive lowering of flaps resulted in aircraft control not being maintained by the pilot..inadequate airspeed resulted in a stall/mush and subsequent collision with the terrain. Factors related to the accident were: a gusty crosswind and a delayed go-around…NTSB BFO91LA017Accident · No injuriesLimited investigationFinal reportRockwell 690C · Summerville, WVPilot's failure to maintain adequate aircraft control during the landing flare/touchdown. The turbulent weather was a related factor.NTSB MIA91LA038Accident · No injuriesLimited investigationFinal reportCessna 172N · Vero Beach, FLThe failure of the pilot to perfrom a proper landing flare and touchdown resulting in a hard landing.NTSB CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.NTSB DEN91LA021Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Erie, COImproper flare by the pilot, which resulted in a hard landing. A realted factor was: low light condition at dusk.NTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.NTSB NYC91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHAircraft control was not maintained by the student pilot.NTSB NYC91DFA01Accident · No injuriesFinal reportLowe/Law Glasair SH-3 · Kingston, NYA hard landing that collapsed the left main gear due to overload failure of the trunion.NTSB NYC91LA032Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103A · Erwinna, PAThe student pilot's improper landing technique and the instructor's inadequate supervision.NTSB CHI91LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's improper recovery from a bounced landing, resulting inadvertent porpoising.NTSB LAX91LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Paso Robles, CAThe pilot's delay in taking appropriate remedial action. A factor in the accident was the flight's encounter with a tailwind during the termination phase of the auto rotation.NTSB ATL91LA012Accident · No injuriesLimited investigationFinal reportCessna 150M · Williamston, NCThe student pilot's failure to properly flare the airplane during the night landing attempt. The pilot's failure to maintain geographic orientation and the subsequent flight into night conditions were factors in the accident. The pilot's lack of night flying…NTSB NYC91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bally, PAThe pilot's improper recovery from a bounced landing and his failiure to maintain directional control.NTSB DEN91LA011Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, COThe failure of the pilot to flare properly during landing. The pilot's total lack of experience is a factor.NTSB CHI91LA013Accident · No injuriesLimited investigationFinal reportMooney M20/231 · Stockton, MOThe pilot's failure to maintain vso (minimum controllable airspeed) in a landing configuration. An associated factor is the pilot's inadequate remedial action.NTSB LAX91LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Riverside, CAThe pilot misjudged the airplane's altitude and the improper bounced landing recovery procedure. Contributing to this accident was the student pilot's total lack of expereince.NTSB NYC91LA008Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Moscow, PAA hard landing due to the failure of the pilot to properly arrest his descent rate and the failure of the flight instructor to adequately monitor the actions of the pilot.NTSB NYC91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Emlenton, PAThe pilot's failure to maintain adequate airspeed during the landing. The turbulence contributed to the accident.NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.NTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.NTSB LAX90LA341Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Cloverdale, CAThe improper procedure employed by the student pilot. Contributing to the accident was failure of the CFI to adequately guard the flight controls to apply timely corrective actions.NTSB ANC90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe improper use of elevator controls by the pilot.NTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.NTSB LAX90LA337Accident · No injuriesLimited investigationFinal reportCessna 172 · Fresno, CAThe pilot misjudged the flare altitude and failed to properly recover from a bounced landing.