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.
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
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 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB GAA23WA079Accident · No injuriesClass 5 · ForeignAMD CH2000 · La Isabela, Dominican RepublicNTSB 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.NTSB 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.NTSB GAA23WA070Accident · No injuriesClass 5 · ForeignLearjet 60 · North Eleuthera, BahamasNTSB 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.NTSB 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.NTSB 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.NTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.NTSB 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.