NTSB investigations
1,250 cases where the defining event 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 WPR12CA346Accident · No injuriesData collectionFinal reportCessna 208 · Chula Vista, CAThe pilot's failure to arrest the aircraft's sink rate on short final, which resulted in a hard landing.NTSB CEN12LA591Accident · Serious injuriesLimited investigationFinal reportArbc Inc DBA Lindstrand 180A · Prairie du Sac, WIThe pilot's loss of control of the balloon during a landing in higher-than-expected wind conditions, which resulted in a hard landing.NTSB CEN12CA511Accident · Serious injuriesData collectionFinal reportAerostar International S81A · Colorado Springs, COThe pilot's encounter with an unexpected shift of wind direction and velocity, which resulted in a hard landing and passenger injury.NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR12CA345Accident · No injuriesData collectionFinal reportCessna 172N · Ashland, ORThe student pilot's improper flare, which resulted in a hard landing.NTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.NTSB CEN12CA486Accident · No injuriesData collectionFinal reportMooney M20M · Heber Springs, ARThe pilot's improper flare, which led to a bounced landing and a subsequent loss of control.NTSB WPR12CA307Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bountiful, UTThe student’s failure to maintain adequate rotor rpm and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB CEN12CA426Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate landing flare, which resulted in a hard landing.NTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB ERA12CA437Accident · No injuriesData collectionFinal reportCessna TR182 · Meridianville, ALThe pilot's inadequate landing flare, which resulted in a hard, bounced landing.NTSB DCA12WA097Accident · No injuriesForeign investigationBoeing 767 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767-300 that occurred on June 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB ERA12CA407Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lake Wales, FLThe flight instructor’s inadequate supervision of the student pilot’s power management, which resulted in a hard landing. Contributing to the accident was the student pilot's premature power reduction during the landing flare.NTSB ERA12CA439Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN12CA393Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Pierce, NEThe balloon pilot’s encounter with increased wind during landing, which resulted in a hard landing and a passenger’s injury.NTSB WPR12CA266Accident · No injuriesData collectionFinal reportCessna 182H · Meadow Creek, MTThe pilot's misjudged approach and improper landing flare, which resulted in a hard landing.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN12CA392Accident · No injuriesData collectionFinal reportCessna P210N · Detroit, MIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12CA363Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · New Douglas, ILThe pilot’s improper landing flare and inadequate recovery from a bounced landing.NTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.NTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.NTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.NTSB WPR12CA204Accident · No injuriesData collectionFinal reportCessna 172P · Spokane, WAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.NTSB CEN12CA281Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Houston, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN12CA277Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.NTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA242Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · New Smyrna, FLThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB ERA12CA228Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Charleston, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12CA194Accident · No injuriesData collectionFinal reportCessna 177B · New Orleans, LAThe pilot’s improper flare, which resulted in a hard landing.NTSB CEN12LA187Accident · 1 fatalLimited investigationFinal reportBrice Ron Glastar Sportsman 2+ · Kimberling, MOThe pilot’s inadequate flare, which resulted in the airplane impacting into the water.NTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.NTSB WPR12TA120Accident · No injuriesFinal reportEurocopter AS 350 B3 · Napa, CAThe flight instructor’s improper use of the collective control during a practice hovering autorotation, which resulted in a hard landing.NTSB ERA12CA199Accident · No injuriesData collectionFinal reportBell OH-58A · Eufaula, ALThe pilot's inadequate compensation for the gusting wind, which resulted in an excessive descent rate and hard landing.NTSB WPR12CA118Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Poway, CAThe pilot's inadequate compensation for wind conditions during landing, which resulted in a hard landing.NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.NTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.NTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.NTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ERA12CA128Accident · No injuriesData collectionFinal reportMitsubishi MU-2B-20 · Picayune, MSThe pilot's excessive rate of descent during the landing flare/touchdown, which resulted in a hard landing.NTSB CEN12LA113Accident · No injuriesLimited investigationFinal reportCessna 182J · St. Paul, MNThe pilot's decision to land on a runway with a gusting, quartering tailwind and his inadequate compensation for the wind, which resulted in a hard landing.NTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB CEN12CA104Accident · No injuriesData collectionFinal reportCessna 421B · Pampa, TXThe pilot's inadequate aircraft control during landing, which resulted in a hard landing.NTSB WPR12CA056Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Waipahu, HIThe certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.