NTSB investigations
2,104 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.NTSB CHI08CA136Accident · Serious injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's failure to adequately secure his handheld radio prior to takeoff, which resulted in a restriction of the flight control stick and loss of control. Contributing to the accident was the stall/mush flight condition encountered after the glider…NTSB DFW08TA137Accident · No injuriesFinal reportSchweizer 269D · San Antonio, TXThe pilot's failure to compensate for the excessive rate of descent on final approach. A contributing factor was the reported down draft.NTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB NYC08CA177Accident · No injuriesData collectionFinal reportBeech 65-A90 · Titusville, FLThe pilot's improper flare which resulted in a hard landing.NTSB SEA08CA121Accident · No injuriesData collectionFinal reportExtra Flugzeugbau EA300/L · Great Falls, MTThe pilot's misjudged landing flare. A contributing factor was the glare from the sun.NTSB SEA08LA119Accident · Serious injuriesLimited investigationFinal reportCameron Balloons C-100 · Phoenix, AZThe pilot's inadequate weather evaluation during the landing approach. Contributing to the accident were windshear and rocky terrain.NTSB SEA08CA124Accident · No injuriesData collectionFinal reportBell 206B · Murietta, CAThe flight instructor's inadequate supervision and delayed remedial action. A contributing factor to the accident was the dual student's improper flare.NTSB LAX08CA123Accident · Minor injuriesData collectionFinal reportErvin SHA Glasair · Elk Creek, CAThe pilot's misjudged landing flare, inadequate bounced landing recovery technique, and failure to attain and maintain an adquate airspeed during an aborted landing. Contributing to the accident was the short runway.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB DFW08CA114Accident · No injuriesData collectionFinal reportHughes 269A · Killeen, TXThe pilot's failure to maintain main rotor RPM and a safe rate of descent during the autorotation. A contributing factor was the gusty winds.NTSB NYC08CA169Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Chapel Hill, NCThe pilot's improper recovery from a bounced landing. Contributing to the accident was the gusty wind conditions.NTSB LAX08LA121Accident · No injuriesLimited investigationFinal reportCessna 172R · S. Lake Tahoe, CAThe pilot's improper flare and subsequent hard landing. Contributing to the accident were the gusty winds and the high density altitude.NTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.NTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.NTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.NTSB LAX08CA112Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Buckeye, AZThe passenger's failure to hear and follow the pilot's instructions to get down in the bottom of the balloon basket before the high wind landing. A contributing factor was the high wind condition.NTSB LAX08LA097Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Denio, NVThe pilot's inadvertent hard landing induced by a perceived loss of power and a main transmission anomaly while maneuvering at low altitude.NTSB LAX08CA124Accident · No injuriesData collectionFinal reportCessna 172S · San Luis Obispo, CAThe pilot's inadequate landing flare, resulting in a hard landing. Contributing to the accident was the gusty wind condition.NTSB ANC08CA057Accident · No injuriesData collectionFinal reportFairchild Swearingen SA 227-AC · Anchorage, AKThe flightcrew's misjudged flare while landing.NTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…NTSB LAX08CA090Accident · No injuriesData collectionFinal reportCessna 152 · El Cajon, CAthe student pilot's inadequate compensation for gusty, crosswind conditions, and failure to maintain an adequate airspeed.NTSB DFW08LA088Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Questa, NMThe balloon's encounter with a wind gust/downdraft during landing, which resulted in a hard landing.NTSB CHI08CA098Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 600N · Waverly, OHThe pilot's improper flare.NTSB LAX08CA084Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and his subsequent failure to maintain an adequate airspeed during landing. A contributing factor was the weather windshear condition.NTSB NYC08CA190Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Inverness, FLThe student pilot's improper landing flare and the flight examiner's inadequate remedial action.NTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.NTSB DEN08LA066Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Las Vegas, NMAn inadvertent settling with power, and the instructor's failure to maintain control of the helicopter, resulting in a hard landing. Contributing to the accident was the downdraft.NTSB DFW08CA083Accident · No injuriesData collectionFinal reportCessna 150 · Idabell, OKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident are high and gusting winds.NTSB DFW08CA082Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Horseshoe Bay, TXThe certified flight instructor's delay in taking remedial action which resulted in an unsuccessful autorotation.NTSB LAX08CA075Accident · No injuriesData collectionFinal reportBeech C23 · Marble Canyon, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed during the flare. Contributing to the accident were wind gusts and a crosswind.NTSB NYC08CA135Accident · No injuriesData collectionFinal reportCessna 172R · Richmond, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB NYC08CA132Accident · No injuriesData collectionFinal reportRotorway 162F · Cartersville, GAThe owner/builder's improper installation of the foot pedal scissor beam, which resulted in its failure during hover flight.NTSB NYC08CA123Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Leonardtown, MDThe pilot's inadequate recovery from a bounced landing.NTSB DFW08CA077Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · San Antonio, TXThe pilot's failure to maintain airspeed during the landing flare which resulted in a hard landing.NTSB MIA08CA057Accident · No injuriesData collectionFinal reportCessna 172N · Centre, ALThe pilot's improper landing flare, resulting in a hard landing.NTSB NYC08CA120Accident · No injuriesData collectionFinal reportCessna 140 · Dayton, TNThe pilot's improper flare, which resulted in a hard landing.NTSB NYC08CA122Accident · No injuriesData collectionFinal reportBeech B-55 · Brookhaven, MSThe pilot's improper flare, which resulted in a hard landing during the first attempt, and subsequent collapse of the nose landing gear during the second landing attempt. Contributing to the accident was the wind gusts.NTSB NYC08CA110Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's inadequate compensation for wind conditions during landing. Contributing to the accident were the gusting winds.NTSB MIA08CA056Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilot's inadequate recovery from a bounced landing.NTSB NYC08CA103Accident · No injuriesData collectionFinal reportCessna 172P · Gainesville, FLThe pilot's improper flare.NTSB DEN08LA065Accident · No injuriesLimited investigationFinal reportPlocher SHA-Glasair · Telluride, COThe pilot's improper flare and his failure to maintain aircraft control, resulting in the design stress limits of the nose gear being exceeded. Contributing factors in this accident was the excessive airspeed, the pilot-induced porpoise of the airplane, and…NTSB DFW08CA093Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe student pilot's improper landing flare resulting in a hard landing. Contributing to the accident were the gusty surface winds and the student pilot's inadequate preflight planning.NTSB LAX08LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CALoss of engine power during the takeoff initial climb due to lack of compression to a cylinder.NTSB MIA08CA050Accident · No injuriesData collectionFinal reportAirIndus Thorpedo T211 · Stafford, VAThe student's improper landing flare and the flight examiner's improper supervision of the student.NTSB DFW08CA063Accident · No injuriesData collectionFinal reportCessna 177 · Picayune, MSThe pilot's misjudgement of the landing flare resulting in a hard landing.NTSB CHI08CA072Accident · No injuriesData collectionFinal reportAvid MK-IV · Boswell, INThe pilot's inadequate compensation for the crosswind condition which resulted in a loss of directional control during a bounced landing. Factors associated with the accident were the improper flare, the crosswind, and the trees which the airplane contacted.NTSB MIA08CA068Accident · No injuriesData collectionFinal reportCessna 172S · Westiminster, MDThe student pilot's improper flare.