NTSB investigations, 2021
96 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 year(c.\"eventDate\") = 2021
AND 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 year(c."eventDate") = 2021 AND 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 ERA21LA279Accident · No injuriesClass 4 · LimitedFinal reportTextron T206 · Statesville, NCThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and collision with terrain.NTSB ERA21LA275Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rome, NYThe pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.NTSB GAA21WA157Accident · No injuriesClass 5 · ForeignRobinson R44 · Yalta, RussiaNTSB GAA21WA148AccidentClass 5 · ForeignGulfstream GULFSTREAM200 · Geneva, SwitzerlandNTSB ERA21LA264Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Tampa, FLThe pilot’s improper landing flare while making a power off practice autorotative landing. Contributing was the decreased visual cues provided by the recently paved runway during the night landing conducted with the aid of night vision goggles.NTSB WPR21LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Moose Creek Ranger Station, IDThe pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.NTSB ERA21LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sylva, NCThe pilot’s intentional departure from the procedures published in the manufacturer’s flight training guide, and his subsequent loss of engine rpm, rotor rpm, and aircraft control.NTSB ERA21LA248Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Nellysford, VAThe student pilot's failure to maintain an appropriate glide path to the runway.NTSB WPR21LA282Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J230-SP · Oceano, CAThe pilot’s failure to maintain directional control after landing fast and hard which damaged the right main landing gear wheel pant which lodged under the wheel.NTSB CEN21LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Alexandria, MNThe pilot did not maintain aircraft and directional control during the landing in variable wind conditions resulting in abnormal contact with the terrain.NTSB CEN21LA253Accident · No injuriesClass 4 · LimitedFinal reportSchweizer TH55A/269A · Monroe, LAThe pilot’s failure to maintain yaw control during landing which resulted in a loss of tail rotor effectiveness.NTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.NTSB WPR21LA225Accident · Serious injuriesClass 4 · LimitedFinal reportLindstrand Balloons 90A · Dayton, NVThe pilot’s failure to maintain control of the balloon due to an unexpected high surface wind and downdraft, which resulted in a hard landing.NTSB CEN21LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Indianapolis, INThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.NTSB WPR21LA198Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Paris, IDThe pilot's improper flare which resulted in a bounced landing, loss of directional control and collision with terrain.NTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB ERA21LA255Accident · No injuriesClass 4 · LimitedFinal reportPage Joseph E Vans RV-4 · Martinsburg, WVThe pilot’s improper landing flare in variable crosswind conditions, which resulted in a hard landing.NTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.NTSB WPR21LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Tucson, AZThe student pilot’s improper pitch control and landing flare, which resulted in a hard bounce and subsequent porpoised landing.NTSB ERA21LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · Hyannis, MAThe flight instructor’s failure to confirm the position of the left engine’s auxiliary fuel boost pump switch during a simulated engine out procedure, which resulted in an excess amount of fuel in the engine and subsequent partial loss of power during a…NTSB CEN21LA210Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons 2010 Firefly 12B-010 · Pagosa Springs, COThe pilot’s failure to properly control the balloon during a steep approach that resulted in a hard landing and a serious passenger injury.NTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.NTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…NTSB ERA21LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Orangeburg, SCThe student pilot’s improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.NTSB WPR21LA164Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Fairbanks, AKA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA21LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Flemingsburg, KYThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing.NTSB CEN21LA170Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Boerne, TXThe pilot’s failure to maintain control of the airplane during a full stop landing and the subsequent attempted go-around in turbulent conditions.NTSB WPR21LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Marana, AZThe student pilot’s improper flare which resulted in a bounced, hard landing and loss of control in a gusting crosswind.NTSB ERA21LA179Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Tampa, FLThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing and a nose landing gear collapse.NTSB CEN21LA171Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Wanatah, INThe pilots’ fuel mismanagement, which resulted in fuel starvation and a total loss of engine power to both engines.NTSB ERA21LA151Accident · No injuriesClass 4 · LimitedFinal reportBeech Sierra · Augusta, METhe pilot’s improper landing flare, which resulted in a bounced landing, and a subsequent runway excursion. Also causal was the flight instructor’s delayed remedial action.NTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.NTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.NTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.NTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.NTSB ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.NTSB ERA21LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orange, VAThe student pilot’s improper recovery from a bounced landing.NTSB ERA21LA117Accident · No injuriesClass 4 · LimitedFinal reportRobinson R22 · West Palm Beach, FLThe examiner’s failure to arrest the helicopter descent during a simulated engine failure maneuver and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB WPR21LA158Accident · 1 fatalClass 3 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and fatal passenger injury when the passenger fell out of the basket.NTSB ERA21LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Rockingham, NCThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing and a runway excursion.NTSB ERA21LA106Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA5 · Leesburg, VAThe weakened structure of the left horizontal stabilizer, which resulted in elevator flutter and subsequent partial separation of the left elevator in flight. Contributing to the accident were the lack of elevator authority while landing due to the damaged…NTSB DCA21WA068AccidentClass 5 · ForeignBoeing 737 · Exeter, United KingdomNTSB CEN21LA109Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Albany, TXThe pilot’s inadequate pretakeoff checks which resulted in the magneto switch (key) remaining in the OFF position during the takeoff sequence and initial climb and the right magneto grounding intermittently.