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 CEN09CA357Accident · No injuriesData collectionFinal reportAviat A1 · Garrison, MNThe pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.NTSB ERA09CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · West Chester, PAThe student pilot’s improper recovery from a bounced landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR09CA279Accident · No injuriesData collectionFinal reportCessna 182T · Shafter, CAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR09TA277Accident · No injuriesFinal reportHughes OH-6A · Benson, AZThe pilot under instruction's inadequate autorotation technique and the instructor pilot’s delayed remedial action to arrest the rate of descent of the helicopter while in an autorotation flare.NTSB WPR09LA261Accident · No injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Ogden, UTThe pilot's improper use of the helicopter's collective both during the takeoff sequence and while attempting remedial action in response to an engine over-boost condition, which resulted in a hard precautionary landing.NTSB CEN09LA318Accident · Serious injuriesLimited investigationFinal reportAerostar International S-60A · Albuquerque, NMThe pilot's excessive descent rate.NTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.NTSB WPR09CA271Accident · No injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 235 · Ontario, ORThe pilot's misjudged landing flare. Contributing to the accident was the pilot's lack of any experience in the make and model airplane.NTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.NTSB ERA09CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Montgomery, NYThe student pilot's failure to maintain aircraft control on landing. Contributing to the accident was the flight instructor's lack of total experience as an instructor and delayed corrective action.NTSB ERA09CA265Accident · Minor injuriesData collectionFinal reportCessna 172E · Como, MSThe pilot's inadequate recovery from a bounced landing.NTSB ERA09CA278Accident · No injuriesData collectionFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper landing flare.NTSB WPR09CA206Accident · No injuriesData collectionFinal reportCessna 172M · Corona, CAThe pilot's improper landing flare.NTSB WPR09CA209Accident · No injuriesData collectionFinal reportCessna 172P · Livermore, CAThe student pilot’s improper recovery from a bounced landing.NTSB DCA09FA045Accident · No injuriesField investigationFinal reportBoeing 767 · New York, NYThe first officer’s input of full nose down elevator at touchdown. Contributing to the accident was the gusty wind conditions.NTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09CA217Accident · No injuriesData collectionFinal reportCessna 172R · Lafayette, INThe pilot's improper flare. Contributing to the accident were the wind gusts.NTSB CEN09CA213Accident · No injuriesData collectionFinal reportBeech 58 · Durango, COThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB CEN09LA206Accident · No injuriesLimited investigationFinal reportCessna 402B · Aberdeen, SDThe pilot's continued flight into adverse weather and icing conditions, and his failure to maintain aircraft control resulting in a hard landing. Contributing to the accident was the accumulation of airframe ice and the strong, gusting crosswinds.NTSB CEN09CA199Accident · No injuriesData collectionFinal reportRoach Neil Glasair SU · Tulsa, OKThe pilot's improper flare, and the flight instructor's delayed remedial action.NTSB CEN09CA187Accident · No injuriesData collectionFinal reportCessna 172N · Carlisle, ARThe student pilot's improper recovery from a bounced landing.NTSB CEN09CA203Accident · No injuriesData collectionFinal reportBell 407 · Lancaster, TXThe failure of the pilot to maintain adequate main rotor rpm and the failure of the CFI to provide appropriate instruction during the maneuver.NTSB ERA11LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's inadequate crosswind landing technique and the certified flight instructor's delayed remedial action, which resulted in a hard landing.NTSB ERA09LA176Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ridgeland, SCThe pilot's failure to maintain control of the airplane during a precautionary landing. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB WPR09CA129Accident · No injuriesData collectionFinal reportCessna T210 · Twentynine Palms, CAThe pilot's inadequate compensation for the gusting wind conditions.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB WPR09LA125Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Cave Creek, AZThe pilot's misjudged landing flare. Contributing to the accident was the brownout condition created by the dust cloud that interfered with the pilot's perception of proximity to the ground, and the glare interference from the parked fire vehicles headlights…NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.NTSB WPR09CA126Accident · No injuriesData collectionFinal reportErcoupe 415-E · Camas, WAThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB DCA09FA028Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe student pilot's improper flare while landing with a tailwind and the instructor pilot's delayed response.NTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.NTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.NTSB WPR09CA106Accident · No injuriesData collectionFinal reportGrumman AA-5 · Payson, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control. Contributing to the accident was the crosswind condition.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB CEN09CA120Accident · No injuriesData collectionFinal reportBeech 58 · Brainerd, MNThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the unforcasted freezing rain that obscured the windscreen and hindered the pilot's ability to judge the height of the airplane above the runway.NTSB ERA09CA127Accident · No injuriesData collectionFinal reportCessna 180K · Port Orange, FLThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident were the gusting wind conditions and the pilot's lack of experience in the make and model airplane.NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB WPR09CA058Accident · No injuriesData collectionFinal reportCessna 140 · Preston, IDThe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.NTSB ERA09CA121Accident · No injuriesData collectionFinal reportLake LA-4-200 · Apopka, FLThe pilot's improper flare.NTSB CEN09LA088Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Gary, INThe pilot's excessive airspeed and improper flare while landing in gusting winds.NTSB WPR09CA055Accident · No injuriesData collectionFinal reportCessna 172RG · Truckee, CAThe pilot misjudged the landing flare resulting in a hard landing.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB CEN09CA068Accident · No injuriesData collectionFinal reportBrantly B-2B · Cedar Hill, TXThe pilot's improper decision to takeoff downwind. A contributing factor was the gusty conditions.NTSB CEN09CA067Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Erie, COthe pilot's improper flare during the practice autorotation which resulted in a hard landing. Contributing factors were the flight instructor's delayed remedial action and inadequate supervision.