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 ATL93LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Myrtle Beach, SCThe pilot's improper compensation for wind conditions during the approach and landing. Factors were the gusts, turbulence, and tailwind conditions at the landing site.NTSB DEN93LA046Accident · No injuriesLimited investigationFinal reportCessna 172M · Meeker, COThe pilot's improper compensation for wind conditions. A factor was: gusty crosswinds.NTSB NYC93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe improper flare by the pilot allowing the airplane to balloon and land hard. A factor in this accident was pilot's lack of recent flying experience.NTSB ANC93LA053Accident · No injuriesLimited investigationFinal reportCessna A185F · Goose Bay, AKThe instructor pilot's delay of remedial action during the simulated forced landing. Factors were the dual student's failure to maintain the proper descent rate, and his failure to attain proper alignment with the runway prior to touchdown.NTSB LAX93LA188Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 · Calistoga, CAThe balloon's encounter with higher than forecast winds which resulted in a hard landing. A factor in the accident was the design of the balloon basket with a recessed area which prevented any lateral movement of the injured passenger's foot during the…NTSB NYC93LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees. The adverse wind was a related factor.NTSB FTW93LA130Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Searcy, ARThe pilot's improper flare and his improper recovery for a bounced landing. The crosswind and the pilot's improper compensation for the wind were factors.NTSB MIA93LA101Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Iuka, MSThe pilot's improper recovery from a bounced landing and the subsequent loss of control due to a stall/mush condition. Contributing to the accident was the pilot's lack of total experience.NTSB FTW93LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Forrest City, ARThe pilot's improper landing flare. Factors were the wind conditions and pilot's failure to maintain directional control.NTSB NYC93LA073Accident · No injuriesLimited investigationFinal reportBeech B19 · Old Bridge, NJThe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.NTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.NTSB LAX93LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Folsom, CAThe student pilot's excessive rate of descent during a approach for landing, improper remedial action to arrest the rate of descent, and a failure to maintain proper main rotor RPM. The student pilot's lack of total aeronautical experience was a factor in…NTSB FTW93LA098Accident · No injuriesLimited investigationFinal reportCessna 177 · Overbrook, OKThe pilot's improper compensation for wind conditions and his failure to recover from a bounced landing. A factor was turbulenceNTSB MIA93LA081Accident · No injuriesLimited investigationFinal reportRoot, Arthur T. Delta Dyke JD-2 · Sebastian, FLThe pilot-in-command's improper flare and recovery from a bounced landing, resulting in a hard landing which caused landing gear failure. Contributing to the accident was the pilot's lack of total flight time and flight time in the make and model.NTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.NTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.NTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.NTSB LAX93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe overload failure of the right main landing gear strut attach bolts due to a hard landing. The hard landing was the result of the student misjudging the landing flare, and, the inadequate supervision of the flight by the flight instructor.NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.NTSB LAX93LA296Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 160A · Chandler, AZThe pilot's failure to adequately evaluate the weather conditions and subsequent uncontrolled touchdown resulting in a hard landing. Gusty wind conditions were a factor in the accident.NTSB LAX93LA106Accident · Serious injuriesLimited investigationFinal reportEagle C-7 · San Juan Bautis, CAThe pilot's inadequate inflight planning and the unfavorable winds.NTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.NTSB CHI93MA061Accident · No injuriesMajor investigationFinal reportSaab-Scania 340A · Hibbing, MNThe first officer's failure to maintain a proper descent rate during the landing, and the captain's inadequate supervision by not taking timely action to ensure a safe landing. Factors which contributed to the accident were: the company's failure to provide…NTSB MIA93IA052Incident · Minor injuriesIncident investigationFinal reportBalloon Works Firefly 7-15 · Orlando, FLPoor in-flight planning/decision by the pilot, and excessive descent resulting in a hard landing.NTSB LAX93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Herald, CAThe failure of the pilot to maintain a proper descent rate and his failure to take timely remedial action to correct a high sink rate prior to colliding with the ground.NTSB DEN93LA020Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft Collins, COFailure by the pilot to follow IFR procedures in not executing a missed approach when he arrived at the runway threshold with improper alignment and improper descent rate for landing. A factor was: marginal weather conditions.NTSB LAX93LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Peoria, AZThe balloon's encounter with a gusty wind shear condition during the final descent for landing at an altitude insufficient for the pilot to take corrective action to prevent a hard landing.NTSB MIA93LA032Accident · No injuriesLimited investigationFinal reportHiller UH-12C · New Smyrna Bch, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing.NTSB NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.NTSB MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.NTSB CHI93LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Shell Knob, MOThe pilot's misjudging of the landing flare.NTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.NTSB MIA93LA023Accident · No injuriesLimited investigationFinal reportCessna 182 · Macon, GAThe pilot in command's failure to stabilize his approach to landing, resulting in the aircraft making a hard landing halfway down the runway.NTSB LAX93LA049Accident · No injuriesLimited investigationFinal reportMooney M20J · Santa Ana, CAThe pilot's improper landing flare, his improper bounced landing recovery technique, and his inadvertent entry into a stall mush condition.NTSB FTW93LA040Accident · No injuriesLimited investigationFinal reportBeech B100 · Uvalde, TXThe pilots failure to go around. A factor was his resultant long landing and delayed flare.NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.NTSB DEN93LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Englewood, COUndetermined.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB FTW93LA021Accident · No injuriesLimited investigationFinal reportCessna 177B · Las Cruces, NMThe pilot's delayed landing flare and the improper bounced landing recovery. A factor was the dark night.NTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.NTSB MIA93LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLThe pilot in command's improper flare which resulted in the aircraft ballooning during landing, followed by his improper recovery from the ballooned landing which resulted in the aircraft touching down hard on the nose landing gear causing it to collapse.NTSB LAX93LA010Accident · No injuriesLimited investigationFinal reportBell 47-D1 · El Monte, CAThe pilot's failure to maintain the rotor RPM.NTSB CHI93LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Madison, WIWas the pilot's inadequate compensation for wind conditions which resulted in an improper flare. A factor related was the gusty wind condition.NTSB NYC93LA004Accident · 1 fatalLimited investigationFinal reportLake LA-250 · Franklin, NHThe pilot's misjudged touchdown on the water which resulted in a porpoised landing. Also causal to the accident was his improper recovery from the porpoise, resulting in a loss of airplane control and collision with the water. Factors related to the accident…NTSB CHI92LA294Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Grand Forks, NDThe pilot's premature flare.NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.NTSB CHI92LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOThe pilot's failure to recover from the bounced landing.NTSB DEN92LA095Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Littleton, COUndetermined.NTSB CHI92LA289Accident · No injuriesLimited investigationFinal reportLearjet LR-60 · Hutchinson, KSInadequate flight test methods by the manufacturer and the FAA which did not permit safe operating clearances.NTSB LAX92LA394Accident · No injuriesLimited investigationFinal reportCessna 180 · Avalon, CAThe pilot's improper landing flare which resulted in a hard landing and a collapse of the left main landing gear.