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 WPR24LA146Accident · Minor injuriesClass 3 · LimitedFinal reportRobert Sterling 4P · Lake Havasu City, AZA loss of engine power during initial climb due to fuel vapor lock. Contributing to the accident was the incorrect installation of the ancillary fuel supply system components.NTSB ERA24LA205Accident · No injuriesClass 3 · LimitedFinal reportAirbus Helicopters AS350B3 · Plant City, FLThe pilot’s inadequate yaw control of the helicopter while maneuvering at a low altitude and airspeed, which resulted in a hard landing.NTSB ERA24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Westminster, MDThe pilot’s failure to attain a proper touchdown point during a simulated loss of engine power approach, which resulted in a hard landing short of the runway. Also causal was the flight instructor’s delayed remedial action during the approach and subsequent…NTSB ERA24LA203Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louisburg, NCThe pilot under instruction’s inadvertent use of the mixture control, which resulted in a total loss of engine power.NTSB CEN24FA167Accident · 2 fatalClass 3 · FieldFinal reportVertical Aviation Technologies Hummingbird · Spring Branch, TXA total loss of engine power for undetermined reasons, which resulted in a forced landing and a subsequent impact with terrain.NTSB WPR24FA132Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Anaconda, MTA total loss of engine power due to a loss of cooling oil to the turbine-to-compressor coupling shaft and subsequent fracture of the shaft at an altitude too low for the pilot to complete a successful autorotation. Contributing to the accident was carbon…NTSB WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB ERA24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Holt, FLThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a hard landing and subsequent nose over of the airplane.NTSB ERA24LA165Accident · Serious injuriesClass 4 · LimitedFinal reportBeech A36 · Cleveland, OHThe pilot’s failure to maintain control of the airplane during landing, resulting in a hard, bounced landing.NTSB CEN24LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna U206B · Chandeluer Islands, LAThe pilot’s improper decision to attempt a landing on rough water conditions, which resulted in an impact with the water.NTSB CEN24LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Baton Rouge, LAThe pilot’s loss of control during takeoff that resulted in a hard landing.NTSB WPR24LA116Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Coolidge, AZThe student pilot’s improper landing flare, which resulted in a hard landing in gusty wind conditions. Contributing, was the failure of the flight instructor to intervene in a timely manner.NTSB ERA24LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech A23 24 · Somerset, PAThe student pilot’s failure to maintain directional control, and the flight instructor’s lack of remedial action during a landing attempt in a gusty wind, which resulted in a loss of directional control and runway excursion.NTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB CEN24LA134Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T182T · Lapeer, MIThe pilot’s failure to maintain aircraft control while landing in a gusting crosswind condition.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB GAA24WA111Accident · No injuriesClass 5 · ForeignMooney M20R · Eschbach, GermanyNTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB CEN24LA105Accident · No injuriesClass 4 · LimitedFinal reportBeech B23 · Blytheville, ARThe pilot’s improper descent path which resulted in a bounced landing and loss of control.NTSB ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.NTSB ERA24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Lakeport, FLThe improper recovery from a bounced landing, which resulted in a hard landing and subsequent noseover.NTSB ERA24LA099Accident · No injuriesClass 3 · LimitedFinal reportSwissdrones Operating SDO 50 V2 · Antioch, GAA partial loss of engine power due to a reduction of fuel flow for undetermined reasons. Contributing to the accident was the UAS manufacturer’s lack of instructions for a partial loss of engine power landing.NTSB CEN24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7-15 · Albany, TXThe pilot’s failure to maintain a proper descent rate during the landing approach in a high wind condition.NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.NTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.NTSB ANC24LA007Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · New Stuyahok, AKThe pilot’s loss of directional control during landing flare resulting in substantial damage to the left wing.NTSB WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB ERA24LA045Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Chesterfield, VAA hard landing, which resulted in a main rotor strike of the left vertical stablizer.NTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB CEN24LA070Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Claremore, OKThe flight instructor’s failure to maintain sufficient rotor speed during a practice autorotation which resulted in a hard landing.NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB ERA24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Tompkinsville, KYThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a hard landing.NTSB WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB WPR24LA019Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Albuquerque, NMThe pilot’s inability to maintain control of the balloon during landing due to unforecasted windshear and turbulent air.NTSB ERA24LA008Accident · Serious injuriesClass 3 · LimitedFinal reportRotorsport UK Mtosport 2017 · Easton, MDThe pilot’s failure to maintain control of the gyroplane on takeoff.NTSB WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB ERA24LA013AccidentClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Chesterfield, VAA hard landing that resulted in substantial damage to the airplane’s right wing.NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.NTSB ERA23LA376Accident · No injuriesClass 2 · LimitedFinal reportEmbraer S A EMB-545 · St. Simons Island, GAThe control laws of the angle of attack limiter protection system, which precluded the system from disengaging during an approach in gusting wind conditions, limiting the flight crew’s ability to control the airplane’s pitch and resulting in a hard landing.NTSB DCA23WA467OccurrenceClass 5 · ForeignBoeing 767 · Beirut, LebanonNTSB ERA23LA373Accident · No injuriesClass 3 · LimitedFinal reportLiore et Oliver Nieuport 28 · Hudson, MAA total loss of engine power for undetermined reasons.NTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.NTSB CEN23LA404Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Arcola, TXThe instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.NTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.NTSB CEN23LA389Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 530FF · Liberty Hill, TXThe pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.NTSB WPR23LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Santa Fe, NMThe pilot’s improper landing flare following an unstable approach, which resulted in a hard landing.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.