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 FTW84LA320Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe acft nosed down after a bounced landing. The student plt had 1 hour PIC total. She said the acft ballooned and bounced during landing. She said she should have added power during the ballooning to reflare or completed a go-around.NTSB ATL84LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Morrison, TNThe plt was giving free rides to his friends. He was attempting to land on rwy 27 when the 'aircraft lost lift at 15 feet above the rwy.' The acft dropped to the rwy in a three point attitude, the plt added power to regain control. The left wing tip and the…NTSB CHI84LA302Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Munising, MIThe acft nosed over during landing on a solo instructional flt. The students instructor said the approach seemed normal. When the acft flared the nose struck the ground first. The student said he 'did not remember pushing the wheel forward but apparently I…NTSB LAX84LA388Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chandler, AZThe student plt was on his 1st solo flt. He reported that the acft bounced during a landing, then 'started to head off to the left.' He reported that he 'came in with power & rudder' but the acft went off the rwy & hit a mound of dirt & a fence.NTSB MKC84LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · East Lynne, MODuring landing, plt stated, a gust of wind caught the acft resulting in a hard landing before a recovery could be initiated. The plt reported winds were variable at 20 KTS with gusts to 30 KTS.NTSB LAX84LA385Accident · No injuriesLimited investigationFinal reportCessna 500 · Gualala, CAOn an air taxi flt to a privately owned, public use arpt, the transport category acft touched down hard, 7 ft beyond the beginning of the 2500-FT-long rwy. The hard surfaced rwy's strength was inadequate to support the acft's 9500 lb ldg weight & the acft's…NTSB SEA84LA167Accident · No injuriesLimited investigationFinal reportCessna 172N · Roache Harbor, WAThe acft bounced and drifted during a landing in a gusty x-wind. The plt tried applying power and reducing flaps but ended up off the rwy in a ditch and fence. His total time in this model acft was 3 hours.NTSB CHI84LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHNose gear collapsed during hard, flat landing.NTSB LAX84LA381Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe acft was landed hard on the third landing of the student pilot's first solo. During the ensuing bounce the nose gear collapsed & the acft sustained substantial damage.NTSB NYC84LA231Accident · No injuriesLimited investigationFinal reportBell 206B · Somers, CTThe acft made a hard touchdown with the left side low. One side of the rotor came off and the other hit the engine according to one of the passengers aboard the acft. The plt said that the approach was normal and he brought the acft toa hover. However…NTSB NYC84FNC05Accident · Serious injuriesFinal reportRaven RX 6 · North Lebannon, MEStudent balloon pilot was on third supervised solo flt with his flt instructor acting as member of the chase crew. Plt was controlling descent with short bursts of propane burner. Ground contact was hard enough to cause the balloon skirt to continue downward…NTSB SEA84LA157Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Quincy, WAThe acft nosed over during landing. The plt said vibration caused the parking brake to be set in the 'on' position priorto landing. At about 20 mph he used the brakes and the acft nosed over.NTSB MKC84LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · No Little Rock, ARThe pilot-in-command was hired by the student pilot/aircraft owner to perform the passenger flight. No experience or currency records are available on the PIC as he had not held an airman's medical certificate for the last four years. On landing at…NTSB CHI84LA275Accident · No injuriesLimited investigationFinal reportNorth American P-51 Mustang X · Indianapolis, INA bounced landing occured during which the left main gear collapsed followed by a ground loop.NTSB NYC84DNC04Accident · No injuriesFinal reportMaule M-5-235C · Millinocket Lke, METhe acft was landed hard on the glassy smooth surface of a lake. The plt admitted that the landing was hard and that after the touchdown the left float split open and the acft sank in 40 ft of water. Witnesses stated that the lake surface was calm and smooth…NTSB CHI84LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Wayne, INDuring a landing, the acft bounced & landed on the nose wheel, collapsing the nose gear.NTSB SEA84LA144Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes AX-8 · Monroe, WADuring the ballon descent, the plt said he briefed the passengers to bend their knees & hold onto something inside the basket. According to the plt , the descent became more rapid due to a downdraft. The passengers were again warned to 'hang on' because it…NTSB FTW84LA284Accident · No injuriesLimited investigationFinal reportGriffin Trane Starduster TOO · Oklahoma City, OKAcft touched down hard after 4 unsuccessful landing attempts at stroud, OK. Plt added full pwr and returned to Oklahoma City suspecting gear damage. Visual check by another acft revealed no apparent gear damage. Upon touchdown at expressway airpark, the main…NTSB FTW84LA283Accident · No injuriesLimited investigationFinal reportHughes 369HS · Oklahoma City, OKWhile performing a practice autorotation plt failed to bring in power in time to arrest the high rate of descent. The helicopter touched down hard and the main rotor blades flexed downward striking the tail boom and severing it. The plt stated his failure to…NTSB DEN84LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Greeley, COThe student plt stated that during a landing, the acft either ballooned or was caught in an updraft. She reacted by pushing forward on the control wheel. The nosewheel hit the rwy first, the acft bounced in the air & again landed on thenosewheel. The firewall…NTSB CHI84LA253Accident · No injuriesLimited investigationFinal reportBeech B-19 · Oshkosh, WIThe student pilot stated that he rounded out a little high, while landing on rwy 09, stalled & contacted the runway in a crabbed position. A hard landing resulted which substantially damaged the aircraft.NTSB DEN84LA189Accident · No injuriesLimited investigationFinal reportCessna 182K · Las Cruces, NMDuring landing the acft ballooned, stalled and contacted the rwy hard enough to break off the nose gear. The plt added pwr and aborted the landing. Acft was then landed in a sandy area along the left side of the rwy where it nosed over.NTSB LAX84LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe student plt was on his 5th landing when he encountered unfavorable wind & bounced hard. He stated that the wind got under the upwind wing & subsequently the acft pivoted nose down to the ground & was damaged. The student reported that the wind was from…NTSB CHI84LA251Accident · No injuriesLimited investigationFinal reportHalfpap Varieze · Quincy, ILThe acft experienced a collapse of the main landing gear after a hard landing. The plt reported initially that he made ahard landing and stated that when he applied the brakes the landing gear collapsed. The plt was given two NTSB 6120.1 forms by the FAA.…NTSB NYC84LA213Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Monongahela, PAThe certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal…NTSB FTW84LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cleburne, TXLanding apch too high. Plt flared too high above ground resulting in an excessive sink rate on initial touchdown. Acft bounced back into air in a nose high attitude and 'a very low rate of speed.' Plt lost control of acft as rt quartering headwind blew acft…NTSB CHI84LU004Accident · Serious injuriesFinal reportUltralight Flight Phantom · St. Joseph, ILThe plt was practicing power-off landings, during which he reportedly cut-off the engine at about 50 ft AGL. During the 5th landing of this type, the Ultralight lost speed, then entered a descent & touched down hard in a nose low attitude.NTSB CHI84LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Marine City, MIThe student plt reached down to adjust the trim after touchdown & the acft became airborne again. The acft then bounced hard, 2 times, & the student made a go-around. He did not realize the extent of the nose gear damage until after the next landing. During…NTSB NYC84LA191Accident · No injuriesLimited investigationFinal reportCessna 182R II · Fulton, NYWhen the acft bounced into the air on a hard landing at night, the plt applied back pressure on the yoke. Acft stalled back to the runway, damaging nose gear/firewall structure and left wing tip. Plt stated most of his experience was in acft configured with…NTSB LAX84LA347Accident · No injuriesLimited investigationFinal reportCessna R172E · Payson, AZThe purpose of the flight was to give the pvt plt a recurrency checkride as required by the civil air patrol. The commercial rated check plt is not a CFI. According to the check plt the pvt plt was attempting a touch and go landing. The pvt plt flared too…NTSB CHI84LA236Accident · No injuriesLimited investigationFinal reportMaule M-4 · Middletown, OHPlt was attempting to make a 3 point stall landing when a gust of wind was encountered, resulting in a hard landing. Plt reported the wind was gusting to 20 KTS.NTSB SEA84LA131Accident · No injuriesLimited investigationFinal reportCessna 172D · Toledo, WADuring a hard landing the acft bounced and the nose gear collapsed.NTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…NTSB MKC84LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Fremont, NEThe pilot selected a downwind rwy for landing. Touchdown was nose gear first, followed by a porpoise and a go-around. On the second approach to the same runway, touchdown was again nose first and the aircraft porpoised twice before landing was completed. The…NTSB LAX84LA334Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Lancaster, CAAfter making a hard landing the plt applied power & went around, landing okay the 2nd time. After shut down, the plt found buckling of the fuselage & a cracked exhaust pipe.NTSB LAX84LA335Accident · No injuriesLimited investigationFinal reportCessna 172M · San Fernando, CAWhen the plt made his 1st apch to land, the acft was too high on final, so he made a go-around. He reported that on the 2nd apch, the acft was traveling too fast & floated for a long period prior to touching down. During the landing, the acft bounced &…NTSB FTW84LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Odessa, TXDuring the takeoff ground roll the plt noticed the inop airspeed indicator but continued the takeoff. The acft bounced during the long fast landing and traveled off the right side of the rwy. The plt corrected back to the left and the acft touchdown hard off…NTSB NYC84LA187Accident · No injuriesLimited investigationFinal reportCessna 177 · Annville, PAThe plt stated that during an aborted landing while trying to recover from a bounced touchdown he misused the flaps. Once airborne the acft settled into a wheat field. The plt stated excessive airspeed was gained during the steep landing apch.NTSB NYC84LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Williamsport, PAThe aircraft was engaged in student flight training; the student was performing touch and go landing in shifting, gusty wind conditions. A gust hit the aircraft on short final and the student was unable to recover control before a hard landing and bounce…NTSB NYC84FA184Accident · 1 fatalField investigationFinal reportCessna T210M · Bloomsburg, PAThe acft collided with pwr lines during an attempted go-around. Witnesses stated the acft was nose low until just prior to touchdown when it pitched up. The acft bounced into the air and touched down on the nose gear. The acft 'rocked side to side' on the rwy…NTSB DEN84LA158Accident · No injuriesLimited investigationFinal reportPitts S-2A · Boulder, COThe acft was observed in a high, power-on apch. According to a professional plt, who was a witness, the acft appeared asif it would land long. He reported that power was reduced at about 50 ft AGL & the acft stalled, then it landed hard, bounced high &…NTSB CHI84LA205Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontic, MIThe plt stated that during the flare in a cross-wind landing, the acft ballooned & drifted to the right. The acft then touched down at an angle & the landing gear collapsed. The wind was gusting to 20 KTS.NTSB DEN84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Englewood, COAccording to the plt, the acft touched down during a landing, then became airborne again in unfavorable wind conditions. He reported that the plane then slammed back onto the rwy & was damaged.NTSB LAX84LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe acft landed hard and porpoised down the rwy. The plt made a go-around and reported to the tower that he had control problems. He performed a tower fly-by and no damage was apparent to the controllers. The plt was cleared for landing anddid so without…NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB LAX84LA306Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAThe acft nose gear collapsed during landing. Witnesses described the bounced landing as a 'porpoise'.NTSB NYC84LA197Accident · No injuriesLimited investigationFinal reportCessna C172 · Mansfield, MAStudent plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing.NTSB NYC84LA173Accident · No injuriesLimited investigationFinal reportBeech B19 · Danbury, CTThe plt stated while performing the last landing of the day a gust of wind blew the left wing up as the acft was being flared. The acft landed hard and bounced back into the air. A go-around was initiated but when another taxing acft was viewed in the…NTSB CHI84LA190Accident · No injuriesLimited investigationFinal reportBeech V35B · West Chicago, ILThe acft bounced during landing and lost the nose gear in the process. The plt stated he touched down on all three gear, ballooning back into the air nose high. He stated he pushed the nose down to gain airspeed when the nose hit the runway breaking off the…NTSB LAX84LA307Accident · No injuriesLimited investigationFinal reportDe Havilland DHC 6-300 · Tau, Manu'A, HIAccording to the pilot, upon arrival in the vicinity of the arpt it was determined that the windsock indicated southeasterly winds at 15 to 20 KTS. This, plus light to moderate turbulence encountered in the traffic pattern led the crew to fly a slightly…