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 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 WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB CEN09CA232Accident · No injuriesData collectionFinal reportCessna 150D · Madison, INThe loss of engine power due to the failure of the engine's muffler which melted and grounded the ignition P-lead wire.NTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.NTSB WPR09LA156Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wendover, UTA loss of engine power due to fuel exhaustion, which resulted from an inadequate preflight inspection by both pilots and their failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the flight instructor's…NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ERA09LA210Accident · No injuriesLimited investigationFinal reportCessna 310K · Ocala, FLThe right main landing gear collapse as a result of the pilot's improper flare during a previous landing. Contributing to the accident was the flight instructor's inadequate supervision.NTSB CEN09CA217Accident · No injuriesData collectionFinal reportCessna 172R · Lafayette, INThe pilot's improper flare. Contributing to the accident were the wind gusts.NTSB CEN09LA214Accident · Minor injuriesLimited investigationFinal reportMarlman Stol CH 801 · Fort Morgan, COThe complete loss of engine power, as reported by the pilot, for undetermined reasons.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 WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.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 ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…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 CEN09LA134Accident · Serious injuriesLimited investigationFinal reportInman J D Kolb Mark III · Ozark, ARThe loss of engine power due to fuel contamination. Contributing to the accident was the pilot maintaining a high angle of attack during takeoff, which resulted in an inadvertent stall when the engine failed.NTSB CEN09LA122Accident · No injuriesLimited investigationFinal reportBeech A36TC · Three Rivers, MIThe pilot's decision to continue the flight into an area with conditions that were conducive to icing and the loss of engine power due to induction icing.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 CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.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.