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 LAX02LA140Accident · No injuriesLimited investigationFinal reportCessna T206H · Sedona, AZThe pilot's inadequate compensation for the variable, gusty and crosswind conditions, which led to a bounced landing and a subsequent pilot induced porpoise oscillation. A factor in the accident was the pilot's decision to continue the landing in a crosswind…NTSB ATL02LA087Accident · No injuriesLimited investigationFinal reportGreg Grouleff BD-5B · Bessemer, ALThe pilot's improper landing flare that resulted in a hard landing and the fracture of the left main landing gear casting.NTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.NTSB CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB LAX02LA128Accident · No injuriesLimited investigationFinal reportWilson Magnum · Woodland, CAThe pilot's inadequate compensation for the gusty crosswind condition, and his failure to maintain airplane control.NTSB LAX02LA133Accident · No injuriesLimited investigationFinal reportCessna 172S · Phoenix, AZthe pilot flaring the airplane too high above the runway causing a stall and resulting in the hard landing. Factors relating to the accident were the light conditions (dusk) and the pilot's lack of total experience in the type of airplane.NTSB LAX02LA119Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe failure of the flight instructor to properly judge the landing flare and add adequate cyclic, resulting in a hard landing which collapsed the left skid. The wind gusts were a factor.NTSB MIA02LA074Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Coral Springs, FLThe instructor's too high flare during an autorotational landing, resulting in a hard touchdown and rollover. Factors contributing to the accident were the instructor's nonperformance of a preflight brief concerning procedures and techniques for a simulated…NTSB LAX02LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Avalon, CAThe pilot's inadequate bounced landing recovery technique, which resulted in an inadvertent porpoise.NTSB MIA02LA069Accident · No injuriesLimited investigationFinal reportCessna 182F · Pell City, ALthe pilot's failure to properly recover from a bounced landing resulting in exceedance of the design limits and collapse of the nose gear assembly. A factor in the accident was the pilot's decision to continue flight with a known equipment deficiency.NTSB LAX02LA129Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Redlands, CAThe pilot failed to compensate for the wind condtions when he encountered an updraft followed by a downdraft.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB LAX02LA106Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZthe pilot's misjudged landing flare and improper bounced landing recovery.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB LAX02LA150Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 120 A · Moreno Valley, CAThe pilot's inadequate handling of the aircraft. High winds were a contributing factor.NTSB DEN02LA026Accident · No injuriesLimited investigationFinal reportBeech B36TC · Englewood, COThe pilot flaring the airplane prematurely, which resulted in a hard landing.NTSB LAX02LA081Accident · No injuriesLimited investigationFinal reportConrad Pulsar 582 · Prescott, AZThe pilot failed to maintain landing reference speed and aircraft control. A factor was the gusty wind conditions.NTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.NTSB FTW02LA077Accident · No injuriesLimited investigationFinal reportBeech 200 · Camden, ARThe inadvertent stall as the result of the pilot's failure to maintain proper airspeed. A contributing factor was the pilot's use of the approach flaps setting for the landing.NTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…NTSB FTW02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARthe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the sunglare.NTSB CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.NTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.NTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.NTSB NYC02LA050Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Manassas, VAThe pilot's improper autorotation, which resulted in a hard landing and bent airframe support tube. A factor in this accident was previous damage to the airframe support tube.NTSB SEA02LA034Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Baker City, ORThe pilot's excessive descent rate at the time the aircraft came in contact with the runway during a night precautionary landing. Factors include extensive airframe ice accumulation, ice accumulation on the flight compartment windshield, ambient conditions…NTSB CHI02LA061Accident · No injuriesLimited investigationFinal reportRobinson R22 · East Troy, WIThe pilot receiving instruction failed to maintain the proper descent rate.NTSB ATL02TA030Accident · Minor injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper flare during practice autorotation.NTSB NYC02LA045Accident · No injuriesLimited investigationFinal reportCessna 182 · Danbury, CTThe student pilot's improper flare and recovery from a bounced landing.NTSB ATL02LA028Accident · Minor injuriesLimited investigationFinal reportPioneer 85 · Lajas, PRThe pilot's decision to attempt a go-around after a hard landing that resulted in the overload failure of the flight control brackets and the loss of flight control. The airplane collided with a building during the attempted go-around.NTSB LAX02LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Show Low, AZThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.NTSB FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.NTSB NYC02LA041Accident · No injuriesLimited investigationFinal reportCessna 182Q · Norfolk, VAThe pilot's improper recover from a bounced landing which resulted in a propeller strike and hard landing. A factor in this accident were the gusty wind conditions.NTSB LAX02LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Verne, CAThe pilot's failure to maintain directional control following his misjudged landing flare and hard touchdown.NTSB FTW02LA050Accident · Serious injuriesLimited investigationFinal reportHeard RV-6A · Comfort, TXthe pilot's inadequate recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB CHI02LA047Accident · No injuriesLimited investigationFinal reportDassault Falcon 100 · Lawrence, KSThe copilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the copilot's improper in-flight decision not to execute a go-around, the copilot not performing a go-around, the inadequate crew coordination prior…NTSB MIA02LA029Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Hernando, MSThe flight instructor's improper supervision of the dual student during a practice autorotation landing by allowing an excessive aft pitch attitude and low main rotor rpm conditions to develop during the landing/flare touchdown, which resulted in the…NTSB FTW02LA049Accident · No injuriesLimited investigationFinal reportBeech BE-50 · Altus, OKThe pilot's improper flare and his failure to maintain directional control. A contributing factor was the ditch.NTSB ATL02LA011Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Bunnell, FLThe pilot-in-commands (CFI) failure to follow procedures and directives (positive relinquish of flight controls from a dual student and improper flare (too high) during an autorotation) which resulted in a subsequent hard landing. Contributing to the accident…NTSB NYC02LA022Accident · No injuriesLimited investigationFinal reportMooney M20S · Buckhannon, WVThe CFI's improper flare, which resulted in a hard landing.NTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.NTSB IAD02LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Farmingdale, NJthe flight instructor's delayed remedial action to correct the pilot's lack of directional control during landing. A factor was the crosswind.NTSB CHI02LA012Accident · No injuriesLimited investigationFinal reportBeech 200 · Osage Beach, MOThe inadequate planning/decision and the exceeded crosswind component by the pilot. The gusts were a contributing factor.NTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.NTSB IAD02LA011Accident · No injuriesLimited investigationFinal reportCessna 182 · York, PAThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and subsequent nose gear failure.NTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.NTSB IAD02LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PAThe pilot's improper flare, which resulted in a hard landing. A factor was the sun glare.NTSB ATL02LA006Accident · No injuriesLimited investigationFinal reportBeech BE-55-T42A · Raleigh, NCThe pilot's improper flare, and improper recovery from a bounced landing.