NTSB investigations, 2023

91 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 year(c.\"eventDate\") = 2023
    AND 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.

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.Jun 18, 2023 · N463HP · Substantial damageNTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.Jun 17, 2023 · N28034 · Substantial damageNTSB 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.Jun 17, 2023 · N7509X · Substantial damageNTSB 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.Jun 15, 2023 · N23679 · Substantial damageNTSB 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.Jun 11, 2023 · N60605 · Substantial damageNTSB 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.Jun 8, 2023 · N7318Y · Substantial damageNTSB ERA23LA269Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Orlando, FLThe pilot’s improper landing flare during a practice autorotation, which resulted in a hard landing.Jun 5, 2023 · N27UK · Substantial damageNTSB 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.Jun 5, 2023 · N42220 · Substantial damageNTSB 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.Jun 1, 2023 · N827LC · Substantial damageNTSB 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.May 30, 2023 · N69PV · Substantial damageNTSB 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.May 25, 2023 · N6PK · Substantial damageNTSB 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.May 23, 2023 · N674MA · Substantial damageNTSB 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.May 23, 2023 · N165CT · Substantial damageNTSB 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…May 23, 2023 · N451PH · Substantial damageNTSB 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.May 22, 2023 · N745RH · Substantial damageNTSB 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.May 20, 2023 · N586SB · Substantial damageNTSB 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.May 15, 2023 · N227WM · Substantial damageNTSB 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.Apr 27, 2023 · N76GX · Substantial damageNTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.Apr 22, 2023 · N789LH · Substantial damageNTSB GAA23WA131Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Bankstown, AustraliaApr 17, 2023 · VH-XGR · Substantial damageNTSB 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.Apr 17, 2023 · N478SP · Substantial damageNTSB 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.Apr 16, 2023 · N38C · Substantial damageNTSB 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.Apr 13, 2023 · N544TH · Substantial damageNTSB CEN23LA152Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Goldsby, OKThe engine electronic ignition system became disconnected, which resulted in a partial loss of engine power.Apr 8, 2023 · N48PS · Substantial damageNTSB 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.Apr 2, 2023 · N774JP · Substantial damageNTSB 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.Mar 31, 2023 · N306ER · Substantial damageNTSB 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.Mar 27, 2023 · N50133 · Substantial damageNTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…Mar 27, 2023 · N550DW · Substantial damageNTSB WPR23LA134Accident · No injuriesClass 3 · LimitedFinal reportHarris Robert W Zenith CH 801 · Brigham City, UTThe pilot’s improper flare, which resulted in a hard landing following a reported loss of engine thrust for undetermined reasons.Mar 11, 2023 · N639BH · Substantial damageNTSB ERA23LA146Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Titusville, FLThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing and subsequent rotor blade strike of the tail boom.Mar 9, 2023 · N8911F · Substantial damageNTSB ANC23LA024Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F-28C · Anchorage, AKThe pilot’s failure to maintain main rotor rpm on takeoff, which resulted in a forced run-on landing.Mar 5, 2023 · N5688R · Substantial damageNTSB ERA23LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Slaughters, KYMaintenance personnel’s failure to secure the fuel strainer bowl with safety wire, which resulted in the fuel strainer bowl leaking and starving the engine of fuel. Also causal was the obstruction of two fuel injector nozzles.Mar 2, 2023 · N9420N · Substantial damageNTSB GAA23WA079Accident · No injuriesClass 5 · ForeignAMD CH2000 · La Isabela, Dominican RepublicFeb 16, 2023 · N515DF · Substantial damageNTSB ERA23LA126Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 55 · Rochester, NYThe pilots’ failure to attain a proper landing flare and touchdown point, which resulted in a hard landing short of the runway.Feb 11, 2023 · N600C · Substantial damageNTSB ERA23LA140Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Lake Katrine, NYThe pilot’s failure to maintain an appropriate pitch attitude and descent rate during landing, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate remedial action.Feb 6, 2023 · N871LA · Substantial damageNTSB GAA23WA070Accident · No injuriesClass 5 · ForeignLearjet 60 · North Eleuthera, BahamasFeb 5, 2023 · N357WP · Substantial damageNTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.Jan 31, 2023 · N4811E · Substantial damageNTSB CEN23LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Eden Prairie, MNThe student pilot exceeded the airplane's critical angle of attack, resulting in an aerodynamic stall and ground impact.Jan 23, 2023 · N7114C · Substantial damageNTSB ERA23LA114Accident · Minor injuriesClass 4 · LimitedFinal reportDegraw Richard R Summit 23 · Wauchula, FLThe pilot’s improper landing flare, which resulted in a hard landing and dynamic rollover.Jan 20, 2023 · N40DG · Substantial damageNTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.Jan 20, 2023 · N71SN · Substantial damageNTSB CEN23LA083Accident · No injuriesClass 3 · LimitedFinal reportCheek Carroll Hatz/Cheek · Brashear, TXA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude and the subsequent hard forced landing.Jan 15, 2023 · N1957P · Substantial damage