NTSB investigations
3,083 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 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.
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 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
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 LAX84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phoenix, AZThe plt had just purchased the acft & had flown it only 3 hrs. The purpose of this flt was to ferry it to deer valley for a paint job. He reported that when he landed, the wind was from 150 deg at 6 gusting 12 KTS. During the landing, the nose wheel touched…NTSB NYC84LA171Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Spencer, MAAccording to the plt, the purpose of the flt was to practice autorotations. During practice, the acft touched down hard & was substantially damaged.NTSB LAX84LA292Accident · No injuriesLimited investigationFinal reportCessna 182RG · Palo Alto, CAAcft touched down on the nose gear, porpoised and finally impacted the rwy on the nose gear.NTSB ANC84FA063Accident · No injuriesField investigationFinal reportMaule M-6-235 · Anchorage, AKThe acft bounced and the plt gave it full throttle to recover. The acft nose came up, the left wing dropped, and the acft veered off the rwy into two tied down acft. The acft had just had large tires put on to replace wheel skis. The plthad made only 4 wheel…NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.NTSB LAX84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Hawthorne, CADuring the first ground supervised solo flight, the tower controller noticed a tone change in the student pilot's voice while on down wind leg of the traffic pattern. On base leg the student did not extend the second increment of flaps as routinely…NTSB ANC84LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe student plt was observed to land nose wheel first, bounce to a considerable altitude, nose over and contact the runway on the nose wheel.NTSB NYC84IA164Incident · Minor injuriesIncident investigationFinal reportBarnes Firefly 7 · Gorham, MEDuring touch and go landings the balloon encountered increased winds. The balloon touched down hard tilting the basket onto its side. A passengers arm became caught between the basket and the ground.NTSB CHI84LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Porte, INThe pilot stated that he initiated the landing flare 'too late,' and the acft landed hard. There was subst damage to theto the landing gear and left wing.NTSB CHI84LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot landed with excess airspeed & bounced. The second landing was harder than the first & collapsed the nose wheel. The acft nose over as it slid off the right side of the rwy. Investigation revealed that the tower had advised the plt to hold…NTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…NTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…NTSB ATL84LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student reported that he flared too high & the acft bounced about 4 times after which it left the rwy. The nose gear collapsed as it contacted mud beside the rwy.NTSB CHI84LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Minneapolis, MNThe acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare.NTSB LAX84LA274Accident · No injuriesLimited investigationFinal reportHall-Cavalier SA-102.5 · Palo Alto, CADuring a landing, the acft bounced & porpoised several times and the nose gear failed. Subsequently, the acft skidded to a stop on the rwy & a fire erupted in the eng compartment. The occupant exited the plane, but moments later, it was consumed by the fire.NTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…NTSB LAX84LA271Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Vacaville, CAThe flight was conducted for a sales demonstration. Both occupants were pilots. Two landings were performed by the acft owner. The third landing was performed by the prospective buyer and during touchdown the acft bounced. The owner applied power to recover.…NTSB CHI84LA171Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Marion, INThe student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing.NTSB CHI84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHThe student plt was landing on rwy 1 with a gusty x-wind condition. On final apch, he crabbed to compensate for the x-wind. He stated that at about 10 ft AGL, the acft encountered a gust of wind & stalled onto the rwy. It then bounced, touched down nosewheel…NTSB SEA84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Boulder City, NVThe acft nosed over after a loss of control following a bounced landing.NTSB LAX84LA268Accident · No injuriesLimited investigationFinal reportCessna 182L · San Carlos, CAThe plt made four unsuccessful landing attempts followed each time by a go-around. The first attempt the acft bounced onlanding. The second attempt the acft bounced several times. The third attempt the plt stated that the wind pushed the acft from over the…NTSB LAX84LA266Accident · No injuriesLimited investigationFinal reportCessna 185 · Nogales, AZThe acft landed hard bounced and swerved on and off the rwy. When the acft stopped the left main gear had collapsed. Theplt reported that the wind blew him but the manager of the arpt said the plt flared too high.NTSB LAX84LA264Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe student plt made a hard bouncing landing which broke the nose gear. The FAA inspector said neither the flying club nor the student's instructor had authorized the flt. The student said he received a slight concussion & could not recall the accident.NTSB NYC84LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its…NTSB LAX84LA260Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Mesa, AZThe acft landed hard during an autorotation demonstration by a CFI. During landing the rotor blades severed the tail andthe acft went into ground resonance. The CFI said he thought the acft lost transitional lift. He recommended not practicing autorotations…NTSB DEN84LA130Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ruidoso, NMThe plt stated that a combination of high ground speed, turbulence and a downdraft caused the aircraft the rwy. The plt said he thought it better to land as he did than to attempt a go-around because of high terrain to the north.NTSB SEA84LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Driggs, IDDuring a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in…NTSB SEA84LA089Accident · No injuriesLimited investigationFinal reportFornaire F-1 · Everett, WAThe acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage.NTSB SEA84LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Challis, IDThe student plt on a supervised solo flt made a hard landing and during the bouncing the acft hit nose gear first. The nose gear collapsed and the acft slid to a stop in a nose down attitude.NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB CHI84LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe student pilot, with an instructor pilot, were practicing touch & go landings. On the approach, the student allowed the speed to decrease, the acft stalled and landed hard and bounced back in the air. The student pilot added power to go around but did not…NTSB ANC84FA052Accident · Minor injuriesField investigationFinal reportBellanca 7GCBC · Anchorage, AKThe student plt reported that when he was on final apch to land, the acft encountered turbulence at about 40 ft AGL, then bounced on the rwy. He applied power to go around, but lost directional control. The acft yawed left, veered off the rwy, knocked over a…NTSB MIA84LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Ormond Beach, FLDuring a hard landing, the prop, nose gear, eng mounts & firewall were damaged. The winds were gusting to 21 KTS.NTSB LAX84LA246Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Prescott Valley, AZWhen the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers…NTSB MKC84LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38 · St. Joseph, MOThe acft was landed in a gusty crosswind. The acft ballooned and landed hard which collapsed the nose gear.NTSB SEA84LA076Accident · No injuriesLimited investigationFinal reportLake LA-4 · Alderwood Manor, WAAccording to a witness, he observed the acft from taxi to takeoff, then from base throughout the landing. He observed the acft with the gear down on base leg & said the plt flew a low & short final apch. He stated the plt cut power short of the rwy & the acft…NTSB CHI84LA144Accident · No injuriesLimited investigationFinal reportCessna 150 · Delaware, OHThe student plt made a hard landing and during the resulting bounces made incorrect control inputs according to the CFI who was aboard the acft. By the time the CFI took corrective action the acft stalled and dragged a wing.NTSB MIA84LA123Accident · No injuriesLimited investigationFinal reportCessna 210M · Marathon, FLThe plt reported that while he was landing in gusty x-wind conditions, the acft landed hard on its nose gear & the nose gear collapsed. He reported that the wind was from 300 deg gusting to 32 KTS. About 40 mi wsw at key west, FL, the wind was from 310 deg at…NTSB LAX84LA234Accident · No injuriesLimited investigationFinal reportCessna 210 · Novato, CAThe acft landed hard and bounced. After several bounces directional control was lost and the acft colided with a ditch alongside the rwy.NTSB NYC84LA119Accident · No injuriesLimited investigationFinal reportCessna C172 · Corry, PAThe pilot stated that he landing on runway 32 and on initial touchdown the nosewheel contacted the runway after the right main gear, causing the aircraft to ascend back into the air. The aircraft 'porpoised', the left wing tip dipped and collided with a…NTSB LAX84LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 8-24 · Phoenix, AZThe plt took off on a sight-seeing Balloon flt with 5 passengers whose ages were reportedly from 65 to 83 yrs old. About 1 hr & 15 mins later, he landed on desert terrain in winds that he estimated were aprx 10 KTS gusting to 15 KTS. During touchdown, the…NTSB CHI84LA135Accident · No injuriesLimited investigationFinal reportCessna 421C · Joliet, ILThe acft picked up moderate to severe icing which the pilot thought he had shaken off as he cycled the deice boots. He saw the ice come off of the wings but could not see the horizontal stabilizer. On short final at 100 KTS the control yoke began vibrating.…NTSB MIA84LA125Accident · No injuriesLimited investigationFinal reportCessna 310R · Palm Beach, FLThe acft landed hard, blew the left main tire and ran off the runway. A witness stated 'the pilot came in high on final, chopped power off and landed hard.'NTSB MKC84LA099Accident · No injuriesLimited investigationFinal reportCessna 182J · Minden, NEThe plt had returned from dropping skydivers & was landing on rwy 29 at sunset. He reported that during the flare to land, he was temporarily blinded by the sun. The acft landed hard & bounced back into the air. It then settled, veered off the rwy, hit piles…NTSB ATL84LA131Accident · No injuriesLimited investigationFinal reportPitts Special S2A · Apex, NCThe acft made a hard landing and damaged a brake. During the second landing the brakes were found to be malfunctioning and as the rudder became ineffectual the acft left the rwy and collided with a hanger. The owner of the acft was improperly acting as an…NTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.NTSB DEN84LA104Accident · No injuriesLimited investigationFinal reportGates Learjet 25D · Denver, COAbout 1 mi from the arpt while established on the glide slope, the plt was advised by the controller to go around due totraffic on the ground. Just after the plt advanced the throttles & retracted the landing gear, the controller again cleared the plt for…NTSB ATL84IA117Incident · No injuriesIncident investigationFinal reportBeech 19A Sport III · Atlanta, GAThe student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright.NTSB ATL85LA048Accident · No injuriesLimited investigationFinal reportAero Commander 1121 · Salisbury, NCIn March, 1984, N454SR reportedly sustained substantial damage during a hard landing. The accident was reported by a former FAA inspector on 11/29/84.NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.