NTSB investigations
2,102 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 ERA12CA553Accident · No injuriesData collectionFinal reportCessna 182T · Marion, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA12CA569Accident · No injuriesData collectionFinal reportCessna 172S · Farmingdale, NYThe student pilot's improper landing flare, which resulted in a hard landing.NTSB WPR12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe flight instructor’s delayed response in correcting the student pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN12CA671Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Goldsby, OKThe commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.NTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12TA515Accident · No injuriesFinal reportBell 206B · San Juan, PRThe crew’s inadequate preflight inspection and failure to monitor the fuel state during flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR12LA362Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Spanish Fork, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a hard landing and rollover.NTSB ERA12LA518Accident · No injuriesLimited investigationFinal reportMeyers OTW-160 · Worton, MDThe student pilot's improper landing flare and the flight instructor's inadequate remedial action, which resulted in a hard landing.NTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12LA573Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Belgium, WIThe pilot’s failure to maintain control of the helicopter while landing in gusting wind conditions, which resulted in a hard landing.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 CEN12FA561Accident · No injuriesField investigationFinal reportSavage Air Epic LT · San Saba, TXThe improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation.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 WPR12LA341Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Cody, WYThe failure of a tail rotor driveshaft coupling due to fatigue.NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.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 WPR12CA320Accident · No injuriesData collectionFinal reportPiper PA-30 · Yelm, WAThe pilot's failure to maintain an adequate airspeed on approach and his inadequate flare, which resulted in a hard landing.NTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…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 WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…NTSB WPR12CA294Accident · No injuriesData collectionFinal reportOmlin Robert G Exec 162F Rotorway · Quincy, WAThe pilot’s failure to ensure that a flag attached to the landing skid was properly secured, which resulted in its in-flight separation and contact with the tail rotor.NTSB ERA12CA443Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.NTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…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 WPR12LA267Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Scottsdale, AZThe flight instructor’s failure to maintain adequate rotor rpm during a practice autorotation, which resulted in a loss of helicopter control and subsequent hard landing.NTSB ERA12CA439Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN12LA379Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeview, ARThe pilot's improper flare and recovery from a bounced 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 ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.NTSB CEN12LA371Accident · No injuriesLimited investigationFinal reportAmen Star Lite · San Antonio, TXThe separation of the fuel tank sealant coating, which traveled into the fuel pump, blocked the fuel flow, and resulted in fuel starvation to the engine.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 ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ANC12CA050Accident · No injuriesData collectionFinal reportWalls Craig C Snowyriver Special · Chugiak, AKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB ERA12LA380Accident · Minor injuriesLimited investigationFinal reportPittman Eddie G CGS Hawk Arrow II · Monroe, VAThe pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.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.