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 WPR11CA314Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Spanish Fork, UTThe pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control.NTSB ERA11LA380Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Lakewood, NJThe pilot’s inadequate yaw control of the helicopter while hovering.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB ERA11LA386Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Louisville, KYThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a landing gear collapse.NTSB CEN11LA455Accident · No injuriesLimited investigationFinal reportCouvillion S-17 · Toledo, OHThe loss of control during initial climb for undetermined reasons, which resulted in a hard landing.NTSB CEN11LA448Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Burlington, WIThe improper installation of the fuel selector indicator handle, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN11LA430Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Barron, WIThe loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB WPR11LA283Accident · No injuriesLimited investigationFinal reportBeech A36 · El Monte, CAThe pilot's failure to maintain adequate airspeed during the forced landing, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the loss of engine power due to fuel starvation as a result of the pilot's improper fuel…NTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.NTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.NTSB WPR11WA285Accident · Serious injuriesForeign investigationBell 407 · Ladpur, India, IndiaOn June 19, 2011, at 0854 universal coordinated time, a Bell 407, VT-SWA, crashed during landing at Ladpur, Dehradun, India. The pilot and passenger were seriously injured and the helicopter was substantially damaged. The helicopter was operated by M/s Swajas…NTSB WPR11LA267Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lost Hills, CAThe failure of the engine-driven fuel pump, resulting in the loss of all engine power and the pilot's failure to correctly execute an autorotational landing.NTSB CEN11CA409Accident · No injuriesData collectionFinal reportCessna 172N · Santa Teresa, NMThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB CEN11CA403Accident · No injuriesData collectionFinal reportBell 47G-4A · Montgomery City, MOA loss of control during the precautionary landing, which resulted in inadvertent contact between the main rotor and the tailboom. Contributing to the accident was the overloaded condition.NTSB WPR11LA276Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.3 · Jefferson, ORThe pilot's failure to maintain airplane control while on short final after experiencing a downdraft, which resulted in a subsequent hard landing.NTSB WPR11CA261Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAThe pilot's failure to maintain clearance from power lines while maneuvering.NTSB WPR11CA296Accident · Minor injuriesData collectionFinal reportCessna 188 · Glasgow, MTThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.NTSB WPR11CA262Accident · No injuriesData collectionFinal reportCessna 152 · Idaho Falls, IDThe pilot's inadequate landing flare and improper bounced landing recovery.NTSB CEN11LA372Accident · Minor injuriesLimited investigationFinal reportMooney M20J · North Canton, OHThe pilot’s improper landing flare and recovery from a bounced landing, which resulted in a loss of control.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB ERA11LA325Accident · Minor injuriesLimited investigationFinal reportClamar Floats CA-4 · Merritt Island, FLThe loss of engine power during takeoff for reasons that could not be determined because a postaccident examination could not be performed before the airplane was disassembled.NTSB ERA11TA318Accident · Minor injuriesFinal reportBell OH-58A · Ft. Pierce, FLThe pilot's failure to recognize and avoid a loss of tail rotor effectiveness, which resulted in a loss of control and hard landing.NTSB WPR11CA243Accident · No injuriesData collectionFinal reportBell 206B3 · Glendale, AZThe certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.NTSB WPR11LA234Accident · Minor injuriesLimited investigationFinal reportHoskins Zenith · Puyallup, WAThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the accident airplane.NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB WPR11CA251Accident · No injuriesData collectionFinal reportBoeing B75N1 · Torrance, CAThe pilot's inadequate compensation for wind conditions.NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB ERA11LA297Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mobile Block 114CCThe pilot’s operation of the helicopter with a left, quartering headwind, resulting in conditions conducive to a loss of tail rotor effectiveness.NTSB WPR11CA489Accident · No injuriesData collectionFinal reportCessna 172C · Grants Pass, ORThe student pilot's failure to maintain an adequate airspeed on approach, which resulted in a hard landing.NTSB ERA11CA304Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Stevensville, MDThe student pilot's improper flare which resulted in a hard landing, and the flight instructor's lack of remedial action.NTSB ERA11LA278Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B2 · Camden, SCThe instructor pilot did not maintain adequate helicopter control while maneuvering, which resulted in a hard landing.NTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB CEN11CA291Accident · No injuriesData collectionFinal reportCessna A185F · Hot Springs, ARThe pilot’s improper recovery from a bounced landing.NTSB WPR11LA209Accident · No injuriesLimited investigationFinal reportCessna 182B · Colville, WAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.NTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB DCA11WA079Accident · No injuriesForeign investigationAirbus Airbus A330 · Caracas, VenezuelaOn April 13, 2011, about 1855 UTC, an Airbus A330-200, F-GZCB, experienced a hard landing at Simon Bolivar International Airport (CCS), Caracas, Venezuela. No injuries occurred. The flight was registered to and operated by Air France. Visual meteorological…NTSB WPR11CA189Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Salt Lake City, UTThe student pilot's inadvertent action of pulling out the engine's mixture control lever to idle cutoff that resulted in a complete loss of engine power.NTSB ERA11CA333Accident · No injuriesData collectionFinal reportCessna 172K · Bar Harbor, METhe pilot's inadequate landing flare while landing with a gusting wind, which resulted in a hard landing.NTSB ERA11CA227Accident · No injuriesData collectionFinal reportCessna 150A · Factoryville, PAThe pilot's inadequate flare during the gusty crosswind landing, which resulted in a hard landing.NTSB ERA11CA226Accident · No injuriesData collectionFinal reportCessna U206C · Bridgeport, CTThe pilot's delayed decision to perform a go-around which resulted in a hard landing.NTSB ERA11CA223Accident · No injuriesData collectionFinal reportCessna 177 · Columbia, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11LA216Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Culpeper, VAMechanical failure of the transmission for reasons that could not be determined because the transmission could not be torn down.NTSB DCA11FA035Accident · No injuriesField investigationFinal reportAirbus F4-622R · Albuquerque, NMThe captain's failure to control the airplane pitch-up induced by ground spoiler deployment during the go-around.NTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.