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 CEN23LA377Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Great Bend, NDThe pilot’s hard landing on a road and subsequent loss of control, resulting in the airplane impacting a ditch.NTSB CEN23LA358Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor’s improper flight control inputs during the practice hovering autorotation that resulted in a loss of control and impact with terrain.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN23LA355Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe solo student pilot’s improper descent path which resulted in a hard landing on the nose wheel and subsequent bounced landing.NTSB CEN23LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Clewiston, FLThe student pilot’s improper landing flare, which resulted in a hard landing on the nose landing gear. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot.NTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.NTSB ERA23LA356Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA337Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CCX-2000 · Winsted, MNA total loss of engine power on approach for undetermined reasons.NTSB DCA23LA384Accident · No injuriesClass 3 · LimitedFinal reportBoeing 767-322 · Houston, TXThe first officer’s improper control inputs after the airplane touched down. Contributing to the severity of the damage was the flight crew’s lack of recognition that the speedbrakes were not armed, which led to their delayed deployment.NTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB CEN23LA326Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Charles City, IAThe pilot’s improper preflight of the helicopter to ensure that it was within the loading and performance limitations that resulted in settling and impact with terrain during initial climb.NTSB CEN23LA323Accident · No injuriesClass 4 · LimitedFinal reportVans RV-10 · Oshkosh, WIThe pilot’s improper landing flare which resulted in a hard landing.NTSB GAA23WA219Accident · Serious injuriesClass 5 · ForeignCessna 206 · Tuzla, RomaniaNTSB CEN23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-210 · Erie, COA hard landing due to the high wind conditions which resulted in two passengers sustaining serious injuries.NTSB CEN23LA306Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Pocahontas, ILA reported loss of engine power for undetermined reasons.NTSB CEN23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon AB · Lafayette, COAn inadvertent hard landing in high wind conditions resulting in serious injury of two passengers. Contributing to the accident was the increase in prevailing winds prior to the forecast.NTSB CEN23LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe pilot’s weather encounter that resulted in a high speed landing, the balloon tipping over, and serious injury to a passenger.NTSB WPR23LA265Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Emmett, IDThe instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.NTSB CEN23LA293Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Canandaigua, NYThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing, the passenger’s leg hitting the gas tank, and serious injury.NTSB ERA23LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Richmond, VAThe pilot’s delay in performing a go-around after a likely encounter with low-level wind shear, resulting in a hard landing. Contributing to the accident were the pilot’s failure to recognize the severity of the actual and forecasted weather near the airport…NTSB CEN23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Burlington, VTThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and the flight instructor’s delayed remedial action.NTSB WPR23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna R172E · Alamogordo, NMFailure of the pilot to maintain control of the airplane during the landing.NTSB WPR23LA239Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Alturas, CAA loss of engine power due to the failure of the right magneto distributor gear and the pilot’s decision to conduct a test flight with known mechanical issues.NTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.NTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.NTSB CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.NTSB CEN23LA240Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC-65 · Sibley, IAThe pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.NTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.NTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.NTSB ERA23LA269Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Orlando, FLThe pilot’s improper landing flare during a practice autorotation, which resulted in a hard landing.NTSB CEN23LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Salem, WIThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear collapse.NTSB CEN23LA215Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Forest Lake, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with the runway.NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB CEN23LA256Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Romeoville, ILThe student pilot’s failure to attain/maintain a proper landing flare and failure to perform a go-around that resulted in an impact with the runway.NTSB CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB CEN23LA199Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Abbeville, LAThe pilot’s failure to maintain proper helicopter control during autorotation that resulted in an abnormal ground contact which caused the subsequent main rotor strike on the tail boom that severed the tail rotor driveshaft. Contributing to the accident was…NTSB ANC23LA038Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS350B2 · Honolulu, HIThe instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.NTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB WPR23LA191Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Spanish Fork, UTThe instructor pilot’s improper landing flare during a straight-in autorotation, which resulted in a hard landing.NTSB WPR23LA169Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe student pilot’s improper landing flare, which resulted in a hard landing and the flight instructor’s delayed remedial action.NTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.NTSB GAA23WA131Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Bankstown, AustraliaNTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.NTSB ERA23LA213Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · West Mifflin, PAThe student pilot’s improper landing flare, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB CEN23LA152Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Goldsby, OKThe engine electronic ignition system became disconnected, which resulted in a partial loss of engine power.NTSB WPR23LA182Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Marana, AZThe pilot’s improper landing flare, which resulted in a hard bounced landing in a dust devil.NTSB ERA23LA177Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Leesburg, FLThe flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.