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 LAX85LA009Accident · No injuriesLimited investigationFinal reportCessna 172H · Long Beach, CAThe plt said that after he returned to the arpt for a night landing, he applied back pressure during the flare, then heard the stall warning horn. Subsequently, the acft was damaged when it landed hard & bounced. However, the plt was able to taxi to the…NTSB CHI85LA012Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Cincinnati, OHThe plt reported that during a landing, he flared too high, the acft entered a high rate of descent & touched down hard. He reported that the nose gear became bent, the acft went off the left side of the rwy & struck a culvert.NTSB DEN85LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Silver City, NMThe plt stated after the accident that he was attempting to land on rwy 33. He continued to state that immediately prior to the landing flare, a 'terrific downdraft' forced the acft down on the rwy. The acft landed hard and the plt attempted a go-around. He…NTSB LAX85LA020Accident · No injuriesLimited investigationFinal reportCessna 180 · El Monte, CAA low time pvt plt flared the acft which touched down hard and bounced. On the second touchdown, the acft entered a ground loop to the right. Application of right brake and rudder did not correct the situation. The left wing and nose went down & the acft went…NTSB NYC85LA024Accident · No injuriesLimited investigationFinal reportRaven S-66A · Little Compton, RIPlt brushed basket against tree tops and bushes to slow the balloons forward speed. Plt pulled deflation port aprx 10 ft AGL over a mown hay field with an 8-10 mph horizontal, 100 fpm vertical speed. Basket bounced and gust of wind caught deflating envelope…NTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB LAX84LA502Accident · No injuriesLimited investigationFinal reportCanadair T-33 · Palm Springs, CAThe plt stated that 'as I crossed over the field boundry, landing was assured so I closed the throttle. The acft then pitched nose up (slightly), left wing dropped & acft sank out of control to touchdown on the overrun just short of the threshold.' The acft…NTSB DEN84LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTPlt flared abruptly and acft floated before it touched down hard on the rwy collapsing the nose gear. Acft traveled 20 ft off the right side of the rwy before coming to rest.NTSB SEA84LA235Accident · No injuriesLimited investigationFinal reportGarre Leo J Glasair · Aurora, ORPlt was attempting a no flap landing. The acft developed a high rate of sink, struck the rwy and bounced. The acft ground looped and nosed over.NTSB DEN84LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Salt Lake City, UTAccording to the plt the southerly wind was gusting to an unknown intensity and wind shear was encountered during landing. Ground contact occurred in a nose down attitude on the nose landing gear.NTSB CHI84LA400Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Valparaiso, INThe acft dragged a wing and flipped over after the plt made a hard landing and lost control. The plt attempted a go-around in an uncontrolled situation. The acft was destroyed.NTSB CHI84LA395Accident · No injuriesLimited investigationFinal reportCessna 182P · Chicago, ILThe plt reported to gnd control after the accident that he had a flat tire. Several witnesses stated the pilot made a hard landing after which he lost directional control. The plt did not complete an NTSB pilot/operator aircraft accident report.NTSB NYC84LA315Accident · No injuriesLimited investigationFinal reportCessna 182Q · Laurel, MDWith the northerly wind gusting to 22 KTS the acft landed aprx 4/10 the way down the rwy and bounced 3 times. An abort was initiated with power but the acft rolled off the end of the strip across a grass field and into a growth of small trees, nosing over…NTSB MIA84LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe pilot stated to the chief of the FAA control tower at Key West int'l arpt after the accident that she 'porpoised' on landing, striking the nose gear and causing it to collapse.NTSB NYC84LA311Accident · No injuriesLimited investigationFinal reportCessna 172P · White Plaines, NYThe solo student plt stated that she was up set by a request from the tower to do a 360 deg turn on downwind and another acft in the pattern transmitting that the turn would put the 2 acft on a collision course. The turn was not completed and the plt…NTSB FTW84LA390Accident · No injuriesLimited investigationFinal reportFairchild M-62A (PT-19) · Melville, LAThe student plt stated that the acft touched down long and bounced. He applied power to go-around and lost directional control colliding with a fence on the left side of the rwy. The wind was clam.NTSB FTW84LA386Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Altus, OKAccording to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before…NTSB SEA84LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Deeth, NVWhen the aircraft descended below tree top height on final approach, the headwind vector was lost and the aircraft settled to a hard landing. During bounce recovery, the pilot added power but raised the flaps. The aircraft stalled and impacted the ground nose…NTSB LAX84LA475Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Show Low, AZThe acft porpoised during landing after the plt pushed the nose down as noted by a witness. The student plt was making alanding 1/2 way down the rwy after a go-around maneuver and pushed the nose down until the prop struck the rwy and the acft bounced. The…NTSB NYC84LA328Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Providence, RIThe acft landed hard. A 6120.1 plt/oper report was not filed by the plt. The plt was not injured in this accident but was fatally injured in an accident later the same month 09/84.NTSB FTW84LA375Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Midland, TXBoth plts were practicing 180 degree power off 'spot' landings after hiatus from flying activity. Plt in left seat was at controls, undershot slightly and acft bounced on touchdown. Plt applied power for recovery from the bounced lndg but right seat plt also…NTSB CHI84LA381Accident · No injuriesLimited investigationFinal reportUngerecht Q-2 · Appleton, WIAfter takeoff on the third flight of the new homebuilt aircraft the pilot smelled 'something hot' and noted a high cylinder head temp. During the subsequent precautionary landing the plt flared the acft 3-4 ft above the rwy resulting in a hard landing and…NTSB NYC84LA300Accident · No injuriesLimited investigationFinal reportPiper PA-24-260C · Montauk, NYAccording to the plt, after clearing sand dunes short of the rwy power was reduced for landing. The acft decelerated and descended, landing hard on the rwy. As the co-plt initiated an abort, the acft veered off the rwy to the right and collided with a tree.…NTSB DEN84FA275Accident · 2 fatalField investigationFinal reportCessna 182F · Rock Springs, WYThe acft was being operated on the return leg of flt from California to Wisconsin. A landing apch was made to rwy 27 at Rock Springs (elev 6747), temp was 76 degrees, wind 220 at 23 KTS. Acft was observed to bounce back into the air after touchdown and then…NTSB ANC84LA163Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Montague Island, AKThe acft was landed hard and the main landing gear collapsed. According to the plt the landing gear bunger cords broke and there was no safety cable to keep the gear from collapsing. The landing area was a narrow gravel strip running northand south, 1600 ft…NTSB LAX84LA462Accident · No injuriesLimited investigationFinal reportBell 47G-2 · El Cajon, CAThe helicopter made a hard landing during a test flt. The plt reported that the collective was very stiff and he was notable to stop the descent during landing. FAA inspected the helicopter after the accident and found no discrepancies in the control system…NTSB DEN84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirtland Afb, NMUpon touchdown a hard landing was made after which the acft bounced and became airborne. The acft contacted the rwy hard at which time the nose gear collapsed.NTSB MIA84LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gainesville, FLThe nose gear tire blew out on landing. Directional control was lost and the acft traveled off the left side of the rwy.NTSB FTW84LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKPlt lost control after a hard, right-wind-down landing. Acft porpoised, collapsing the nose gear and came to rest nose down.NTSB FTW84LA368Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · The Colony, TXThe plt reported that after takeoff, the wind picked up to about 12 to 15 KTS. She stated she made a normal high wind landing, but due to the angle of landing & position of the passenger's foot, her ankle broke during touchdown.NTSB DEN84LA267Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Aurora, COPlt stated that following a hard landing, directional control was lost. Acft departed runway and collided with dirt berm.NTSB CHI84LA375Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INPlt stated the acft was 1/2 way down the rwy and had not touched down so back pressure on the yoke was released. The acft then bounced three times on the rwy. On the third bounce the nose gear collapsed and the acft nosed over. Plt stated airspeed was…NTSB ATL84LA267Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston-Salem, NCFollowing a high and slow apch, the plt decided to discontinue the landing. Power was added for a go-around, but the power response was not sufficient and the plt elected to continue the landing. Power was reduced and the nose lowered but, the acft stalled…NTSB LAX84LA458Accident · No injuriesLimited investigationFinal reportCessna P172D · Livermore, CAAccording to the plt, the acft landed hard and porpoised several times before the landing was aborted. The second landing was uneventful. Subsequent inspection of the acft revealed that both wings and the fuselage were buckled and the lower engine mounts were…NTSB MIA84LA232Accident · No injuriesLimited investigationFinal reportBrown KR-2 · Naples, FLWhile on the first flt of the acft a hard landing was made and directional control was lost. The acft traveled off the left side of the rwy. Substantial damage was sustained during the hard landing.NTSB MKC84LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt elected to practice touch-&-go landings. On her 1st landing of that flt, the acft bounced & began to porpoise. She started to apply power for a go-around on the 3rd bounce, but the nose came down hard & the nose gear collapsed.NTSB ANC84LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Burgress Strip, AKThe plt stated that when the acft was on short final apch to land on an airstrip, it stalled. During impact, the gear box, right wing tip, prop, eng mounts, eng cowling & right elevator were damaged. The plt recommended receiving training before attempting…NTSB MKC84LA241Accident · No injuriesLimited investigationFinal reportCessna 177B · Winterset, IAThe plt had diverted & was making a precautionary landing due to an approaching storm. At about 50 ft over the rwy, the acft stalled & landed hard. It then bounced 3 times, damaging the nose gear, forward fuselage & right wing.NTSB DEN84LA255Accident · No injuriesLimited investigationFinal reportCessna 188A · Jamestown, NDPlt stated, 'landing at dusk into sun. Landed into hill. Hard landing knocking feet (right) off rudder. Airplane groundlooped to left, hit ditch and flipped on its top.' Plt also stated fatigue from flying 4 hours on the day of the accident was a contributing…NTSB DEN84LA254Accident · No injuriesLimited investigationFinal reportCessna R172K · Los Alamos, NMThe pilot stated that he attempted a landing on rwy 27. The wind was reported to be from 090 degrees at 8 KTS. The plt stated that he touched down on the rwy and the acft skipped to the left. He applied power to go-around but determined that the airspeed was…NTSB NYC84LA264Accident · No injuriesLimited investigationFinal reportCessna 310L · Manahawkin, NJNose wheel tire blew out on lndg. Investigation revealed structual damage to airframe. Inspection of runway showed tire rim contact with the surface and prop blade strikes. Plt did not make a statement.NTSB ATL84FA241Accident · Serious injuriesField investigationFinal reportCessna 337A · Ocean Springs, MSThe acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…NTSB CHI84LA328Accident · No injuriesLimited investigationFinal reportViking Dragon FLY · Eau Claire, WIWitnesses observed acft touchdown left main gear first and bounce twice before remaining on the rwy. The left conard collapsed during the landing. The landing gear is attached at canard tip on this make/model.NTSB CHI84LA324Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Dodgeville, WIThe student solo plt flared the acft over the rwy, the acft bounced and hit the nose gear which collapsed. The acft became airborne again and went off the rwy about 100 ft to the right side. The arpt directory cautions of a steep downgrade to the rwy. The…NTSB DEN84LA244Accident · No injuriesLimited investigationFinal reportCessna 182 · Pagosa Springs, COWhile turning the base leg, the plt viewed a hot air balloon near the final apch corridor. The plt elected to make a short final to avoid the balloon. The acft bounced during touchdown. The plt added power to recover and the acft veered off the left side of…NTSB DEN84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Santa Fe, NMThe acft bounced several times on landing following an excessively high fast approach. The plt added power to recover by aborting the landing. The plt stated the failure to use right rudder resulted in the acft veering to the left and the failure to retract…NTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…NTSB LAX84LA425Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 8-24 · Yountville, CAThe initial landing was in an area of limited access and the pilot elected to continue the flight over a tree line to a nearby more suitable field. In order to avoid being carried into a second downwind tree line, the plt descended the Balloon into the field…NTSB CHI84FA319Accident · No injuriesField investigationFinal reportCessna 182N · Oshkosh, WIThe plt was on a flt to an eaa meet at Oshkosh, WI. During arrival, there were numerous acft in the traffic pattern for landing. While the acft was on final approach, just before landing, the tower controller instruncted the plt to 'land long.' The plt stated…NTSB LAX84LA413Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Pacoima, CAThe student plt reported that when he landed, 'the nose hit 1st & a bit hard causing a balloon. Then the plane again came down hard & ballooned. This happened about 3 times before the plane stopped & went on the nose.' The nose gear collapsed during the…