NTSB investigations, 2002

123 cases where the first occurrence was “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\") = 2002
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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 SEA02LA129Accident · No injuriesLimited investigationFinal reportRockwell International 690A · Crescent Lake, ORThe pilot's failure to maintain proper rate of descent resulting in a hard landing and subsequent nose gear separation. Contributing factors were the turbulent crosswind conditions the pilot encountered just before touchdown.Jul 15, 2002 · N690RE · Substantial damageNTSB NYC02LA145Accident · No injuriesLimited investigationFinal reportCessna 172N · Middletown, RIThe pilot's improper flare. A factor was the shifting wind.Jul 14, 2002 · N733NQ · Substantial damageNTSB ATL02LA142Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Atlanta, GAThe pilot's improper flare which resulted in a hard landing.Jul 14, 2002 · N6630D · Substantial damageNTSB ATL02LA141Accident · No injuriesLimited investigationFinal reportHughes HU-269-A · Hamilton, ALThe pilot's improper use of flight controls that resulted in an improper flare and a hard landing during a practice autorotation. A factor was the loss of rotor rpm.Jul 12, 2002 · N911LH · Substantial damageNTSB ATL02LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Merritt Island, FLThe pilot's improper recovery after a bounced landing and improper landing flare which resulted in the airplane colliding with the runway.Jul 12, 2002 · N54119 · Substantial damageNTSB ANC02LA076Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Juneau, AKThe pilot's improper flare resulting in a hard landing. Factors contributing to the accident were the quartering tailwind, and the inadvertent water loop.Jul 12, 2002 · N93AK · Substantial damageNTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.Jul 11, 2002 · N1502E · Substantial damageNTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.Jul 10, 2002 · N812D · Substantial damageNTSB MIA02LA129Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F21B · Somerville, TNThe pilot's improper landing flare resulting in a hard landing and damage to the airplane.Jul 6, 2002 · N4418F · Substantial damageNTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.Jul 4, 2002 · N6338F · Substantial damageNTSB CHI02CA182Accident · No injuriesData collectionFinal reportBeech A-23-23 · Monroe, MIThe pilot misjudging the flare, and his loss of directional control during landing. The soft terrain was a factor.Jul 4, 2002 · N3545R · Substantial damageNTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.Jun 30, 2002 · N1419 · Substantial damageNTSB SEA02LA115Accident · No injuriesLimited investigationFinal reportSeattle Aerotech Helipower 2500 · Arlington, WAAircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.Jun 27, 2002 · N13RM · DestroyedNTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.Jun 26, 2002 · N42505 · DestroyedNTSB ANC02LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nikiski, AKThe pilot's excessive rate of descent resulting in a hard landing on water.Jun 24, 2002 · N211AW · Substantial damageNTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.Jun 21, 2002 · N5327N · Substantial damageNTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…Jun 19, 2002 · N9089H · Substantial damageNTSB CHI02LA171Accident · No injuriesLimited investigationFinal reportHulle Horizon 1 · Niles, MIThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of experience in tailwheel airplanes.Jun 19, 2002 · N816DJ · Substantial damageNTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.Jun 18, 2002 · N2182C · Substantial damageNTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.Jun 17, 2002 · N675MP · Substantial damageNTSB CHI02LA170Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Kansas City, MOThe inadequate flare by the flying pilot and the remedial action not performed by the company check airman.Jun 17, 2002 · N140NJ · Substantial damageNTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.Jun 15, 2002 · N4833N · Substantial damageNTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.Jun 14, 2002 · N757FY · Substantial damageNTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.Jun 14, 2002 · N333AJ · Substantial damageNTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.Jun 9, 2002 · N2282Y · Substantial damageNTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.Jun 6, 2002 · N94986 · Substantial damageNTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.Jun 6, 2002 · N7196W · Substantial damageNTSB CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.Jun 6, 2002 · N7821Z · DestroyedNTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.Jun 4, 2002 · N2044X · Substantial damageNTSB NYC02LA108Accident · No injuriesLimited investigationFinal reportCessna 182B · Littlestown, PAThe pilot's improper flair, which resulted in a hard landing. A factor in this accident was the crosswind condition.Jun 2, 2002 · N2555G · Substantial damageNTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.May 31, 2002 · N16PG · Substantial damageNTSB NYC02LA105Accident · No injuriesLimited investigationFinal reportBell 206 · Columbus, OHThe flight instructor's delay in applying remedial action. A factor in the accident was the pilot allowing the rotor rpm to become too low during the deceleration and touchdown phase of the autorotation.May 30, 2002 · N820H · Substantial damageNTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.May 26, 2002 · N69AG · Substantial damageNTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.May 20, 2002 · N3547H · Substantial damageNTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.May 19, 2002 · N4338B · Substantial damageNTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.May 9, 2002 · N48819 · Substantial damageNTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.May 8, 2002 · N63123 · Substantial damageNTSB LAX02LA153Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Green Valley, AZThe pilot's failure to identify the wind direction, which led to an attempted downwind landing approach that resulted in a hard landing and severe bounce. Also causal was the pilot's failure to promptly retract the flaps during the rejected landing after…May 8, 2002 · N754LT · Substantial damageNTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.May 1, 2002 · N4468N · Substantial damageNTSB ATL02LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Locust Grove, GAThe pilot improper flare during an aborted takeoff, followed by an subsequent hard landing.Apr 29, 2002 · N2809X · Substantial damageNTSB MIA02LA091Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLthe pilot misjudged the landing flare, resulting in a hard landing, and damage to the airplane.Apr 28, 2002 · N786SP · Substantial damageNTSB FTW02LA131Accident · No injuriesLimited investigationFinal reportCessna 210 · Albuquerque, NMthe pilot's inadequate compensation for the wind conditions resulting in a hard landing. A contributing factor was the gusty winds.Apr 27, 2002 · N6394B · Substantial damageNTSB CHI02LA119Accident · No injuriesLimited investigationFinal reportCessna 560 · Lake In The Hil, ILThe flightcrew's delay in executing a go-around..Apr 25, 2002 · N560RP · Substantial damageNTSB LAX02LA140Accident · No injuriesLimited investigationFinal reportCessna T206H · Sedona, AZThe pilot's inadequate compensation for the variable, gusty and crosswind conditions, which led to a bounced landing and a subsequent pilot induced porpoise oscillation. A factor in the accident was the pilot's decision to continue the landing in a crosswind…Apr 19, 2002 · N377ME · Substantial damageNTSB ATL02LA087Accident · No injuriesLimited investigationFinal reportGreg Grouleff BD-5B · Bessemer, ALThe pilot's improper landing flare that resulted in a hard landing and the fracture of the left main landing gear casting.Apr 17, 2002 · N727BD · Substantial damageNTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.Apr 16, 2002 · N355BH · Substantial damageNTSB CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.Apr 16, 2002 · N752AA · Substantial damageNTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.Apr 8, 2002 · N99341 · Substantial damageNTSB LAX02LA128Accident · No injuriesLimited investigationFinal reportWilson Magnum · Woodland, CAThe pilot's inadequate compensation for the gusty crosswind condition, and his failure to maintain airplane control.Apr 6, 2002 · N229JW · Substantial damageNTSB LAX02LA133Accident · No injuriesLimited investigationFinal reportCessna 172S · Phoenix, AZthe pilot flaring the airplane too high above the runway causing a stall and resulting in the hard landing. Factors relating to the accident were the light conditions (dusk) and the pilot's lack of total experience in the type of airplane.Apr 5, 2002 · N3512T · Substantial damage