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 CHI83LA311Accident · No injuriesLimited investigationFinal reportViking Dragonfly · Flying Cloud, MNThe pilot was initiating a high speed taxi run when the acft became airborne for 500-1000 ft. when a landing was attempted the aircraft bounced.NTSB CHI83LA307Accident · No injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Leslie, MIThe acft landed hard and bounced. The acft drifted left off the rwy and nosed over in a plowed area. The landing was on rwy 18 and the wind was from 270 degrees at 8 KTS. The student pilot said he needed more dual time in crosswind landings. He had 11 hours…NTSB CHI83LA289Accident · No injuriesLimited investigationFinal reportCessna 182 · Anderson, INThe plt stated that during the landing, he encountered winds that were variable & gusty. Subsequently, while landing with 1 notch of flaps, the acft was landed hard & directional control was lost. After departing the rwy, the nose gear mired in muddy terrain…NTSB MKC83LA148Accident · No injuriesLimited investigationFinal reportCessna 177B · Lee'S Summit, MODuring her initial solo flt, the student had made 2 landings. After a short briefing by her instructor, she took off for a 3rd landing. As she approached the rwy touchdown zone, an arpt grass-mowing vehicle was mowing along the approach end of the rwy. The…NTSB SEA83LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Salmon, IDThe pilot said he encountered a high sink rate during the approach. Directional control was lost after the pilot failed to arrest the sink rate and made a hard landing. The acft left the runway and collided with a fence before coming to rest.NTSB NYC83LA170Accident · No injuriesLimited investigationFinal reportCessna 182F · New Paltz, NYAccording to the plt, just prior to landing, the acft encountered wind shear, and subsequently, a hard landing occurred. The firewall, cowling, propeller & belly skin were damaged during the landing.NTSB CHI83LA293Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Kentland, INDuring arrival, the plt landed on rwy 27 with a left x-wind from the south. He stated that he had no indication of excessive x-winds or gusts until the acft was about to touch down. He stated that at that time, the plane encountered heavy gusts & a downdraft.…NTSB ATL83LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Gulfport, MSThe acft made a hard landing, collapsing the nose gear after which a fire started. The pilot had approached the arpt toohigh. The tower recognized this and asked the pilot if he needed to make a 360 degree turn. The pilot did a 360 but was still too high so…NTSB NYC83LA162Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Toughkenamon, PAThe plt was practicing stop & go landings on rwy 24. He stated that the acft was in a normal landing configuration at 68 mph, aprx 8 ft AGL, when it encountered a downdraft. According to him, the downdraft resulted from wind blowing over trees paralleling the…NTSB NYC83FHD03Accident · No injuriesFinal reportThorpe T-18 · Philadelphia, PAAccording to the plt, the acft ballooned after touchdown, he recovered, then after the next touchdonw, it ballooned again. He initiated a go-around, but with the application of power, the acft banked aprx 90 deg to the left. The plt reported that aileron…NTSB MKC83LA139Accident · No injuriesLimited investigationFinal reportBowlin Quickie · Grain Valley, MOThe acft made a landing during its first test flight. The plt stated that he had slowed the acft to below 65 mph at about 10 ft above the rwy. At this point the canard stalled & the nose pitched down. There was no damage on the first rwy contact. On the…NTSB MIA83LA171Accident · No injuriesLimited investigationFinal reportCessna 172P · Clearwater, FLThe plt reported that during the landing, the acft bounced twice, then on the 3rd touchdown, the nose gear collapsed. An investigation revealed the acft was loaded beyond its max limited by an estimated 246 lbs.NTSB MIA83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Daytona Beach, FLBefore the student plt took off, the winds were reported from 080 to 090 deg at 8 to 9 KTS. After takeoff, he stayed in a closed pattern & made 3 touch-and-go landings. Initially, he used 30 deg of flaps for landing. However, he noted varying x-wind…NTSB SEA83LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172PII · Richmond Beach, CAThe float plane overturned during a glassy water landing. The acft was damaged but the pilot and passenger were not injured. The weather was VMC and no flt plan was filed. According to the pilot while attempting to land,the acft contacted the water in a nose…NTSB LAX83FVM08Accident · No injuriesFinal reportBeech C23 · Monterey, CAThe student pilot was on his first solo cross-country. The pilot stated that his approach was too high and too fast. The acft landed hard and bounced. As the acft hit a 2nd time the nose gear collapsed and became jammed between fuselage and runway. The…NTSB DEN83LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student plt reported that after he returned from a x-country plt, he 'scooped' the acft during the flare, it stalled, then bounced on the rwy. He then made a go-around, and subsequently, landed from a normal apch. An exam of the acft revealed that the…NTSB MIA83LA172Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · St. Augustine, FLThe plt was practicing spot landings. On the 9th apch, he was high & slipped the acft with the left wing low. Prior to touchdown, he leveled the wings, but failed to arrest the rate of descent. The plt stated that he applied power to go around, but the acft…NTSB LAX83LA292Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Morgan Hill, CAThe acft made a hard landing during a student training flt. The student pilot had made one landing and one go-around. He attempted another landing but landed hard without enough of a flare. The nose gear bent, the prop curled and the engine mounts were…NTSB NYC83LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe student plt reported that she had made a go-around & two landings in calm wind conditions. She reported her 3rd approach was lower & slower, under 60 KTS. When she realized that she did not have the flaps full down, she added the last increment of flaps…NTSB LAX83LA283Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Prescott, AZThe cross country flt was made later than the pilot intended. The pilot had never landed this model acft on a dark night at a high density alt arpt. The pilot reported that things were happening a lot faster than he was accustomed to. By the time he saw the…NTSB CHI83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Waukegan, ILThe student was receiving a high performance checkout. During the third landing the acft landed hard.NTSB ATL83LA228Accident · No injuriesLimited investigationFinal reportCessna 182-M · St. Simons Is., GAThe acft made a hard landing and collapsed the nose gear. The pilot recalled that a touchdown was accomplished after which the acft balloned and re-landed hard followed by several bounces until the acft came to rest. Examination showed that the nose gear had…NTSB CHI83LA335Accident · No injuriesLimited investigationFinal reportCessna T210L · Indianapolis, INDuring landing the acft reportedly porpoised two times on the nose gear. The flange on the nose gear tire rim had piecesbroken off of the flange in several places. The landing was also made with full tip tanks. The fuel selector is placarded prohibiting this…NTSB ANC83LA093Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe acft was landed on a road mistaken for the runway by a student pilot. The pilot realized his mistake when he saw people and kids on bikes but in attempting to go-around he lost control and damaged the acft. The weather was VMC. The student pilot received…NTSB MIA83LA162Accident · No injuriesLimited investigationFinal reportCessna 150K · Boynton Bch., FLThe acft was involved in a hard landing, collapsing the nose gear, followed by a nose over. The pilot stated he added power which made the nose collapse a little slower. The acft nosed over about 400 feet from touchdown.NTSB LAX83LA264Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe pilot reported that during the approach to rwy 17 he used 30 deg of flaps and maintained an airspeed of 55 KTS. When he was about ten feet AGL over the rwy threshold a strong gust of wind upset the aircraft. He lost control and tried to go around. The…NTSB CHI83LA246Accident · No injuriesLimited investigationFinal reportCessna 172H · Dayton, OHThe plt stated he was aware of the displaced threshold due to barriers across the approach end of the rwy. After clearing the last barrier he felt the acft start to fall. He nosed over & added power but the nose gear struck the rwy first. The firewall &…NTSB ATL83LA218Accident · No injuriesLimited investigationFinal reportRotec Engineering Rally 3 · Newport, MDThe acft nosed over onto its wings during landing on a soft muddy field. The weather was VMC and no flt plan was filed. The pilot stated he was making a soft field landing on the muddy field. The acft touched down hard in a nosedown attitude. The rt side…NTSB DCA83IA027Incident · No injuriesIncident investigationFinal reportGrumman AA-5 · Clinton, MDThe student pilot ballooned during the flare, then landed hared on runway. The nosegear failed and the acft slid down the runway.NTSB CHI83LA235Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Rockford, ILThe pilot was alone in the basket and was practicing a steep approach to land. The pilot said the reason for his injuries was not the hard landing but lack of preparation for it.NTSB ATL83LA200Accident · No injuriesLimited investigationFinal reportCessna 172N · Pikeville, KYThe acft made a hard landing, bounced, landed on the nose gear and repeated this sequence twice. Then the acft veered off the runways right side and careened down an embankment. The pilots reports stated that the acft was landed on the nose gear twice. The…NTSB ATL83LA196Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Augusta, GAThe acft landed hard, boundced several times and collapsed the nose gear. An ATC specialist on duty said he observed theacft bounce and each time it bounced it seemed to bounce higher. On the fourth bounce the nose gear collapsed. The acft skidded 200 feet on…NTSB ANC83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Kenai, AKThe pilot stated that on a short final approach he encountered a windshear. The pilot only had 5 hours in this type acftand had little experience landing at the location of the accident. This field has no facilities except a windsock. It isbordered by trees…NTSB NYC83LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Collegeville, PAThe acft made a hard landing after which it swerved off the runway and collided with trees. The pilot was on a solo instructional flight and was landing on runway 27. As the acft touched down hard it bounced and left the confines of therunway. The acft…NTSB NYC83FHA04Accident · Minor injuriesFinal reportHomebuilt E.A.A. P-2 · Pottstown, PAThe pilot said he had just purchased the acft and this was his first flight. Since this was a single seat home built acft the student pilot believed he could not get an instructor to check him out or sign him out for solo. Prior to the accident several…NTSB CHI83LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · New Richmond, WIThe student pilot on his 2nd solo flt made a hard landing which collapsed the nose gear. This was the 1st landing of theflight and the pilot touched down nose gear first. The nose gear collapsed and folded backward. The underside of the cowling was bent, the…NTSB LAX83LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Redding, CAThe plt had traveled from Alaska to purchase the acft. After purchase, and some minor repairs by a local mechanic, the plt received a one hr checkout prior to departing on the first leq of the return trip. When the acft arrived at Redding it was observed to…NTSB LAX83FA226Accident · No injuriesField investigationFinal reportRobinson R22 · Torrance, CAThe helicopter was on an FAA certification test flt with a part-time company employee in the left seat as pilot- in-command (PIC). An FAA test plt was in the right seat. The purpose of the flt was to establish new data for the helicopter's height-velocity…NTSB CHI83LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Chicago, ILThe student plt took off from midway arpt, flew to another arpt to practice landings, then returned to midway to land. While he was on an approach to land on rwy 22R, the tower controller requested that the student make a short approach due to other traffic.…NTSB ATL83LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lynchburg, VAThe acft landed hard and bounced several times before collapsing the landing gear. The student pilot was on her first solo flight after 31 hours of dual instruction in the PA-38 acft. The student reported the accident was student induced and that there were…NTSB MKC83LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Fredonia, KSThe acft bounced during landing & then landed hard on the nose gear which collapsed. The plt stated there was low-level turbulence. The plt was not entered into any formal training program nor did he have an instructor. He had accumulated about 12 hrs of dual…NTSB MKC83LA106Accident · Serious injuriesLimited investigationFinal reportSkypower GBN-41-1000 · Denver, MOThe plt stated that the gondola bounced during a hard landing & was lifted by turbulent winds. After the gondola had rebounded to about 50 ft AGL, someone pulled the balloon's rip panel dumping the gas resulting in a severe hard landing.NTSB MKC83LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Moundridge, KSThe acft bounced during landing and groundlooped to the right before departing the rwy. This was the plts first solo in an acft with conventional landing gear.NTSB LAX83LA225Accident · No injuriesLimited investigationFinal reportCessna R172K · Huntington Bch, CAAfter returning from a sight-seeing flt to catalina island, the plt made an apch to rwy 19. The apch was high, so he went around. He landed on the 2nd apch, but the acft bounced, so he went around again. On the 3rd apch, he used 30 deg of flaps & had an…NTSB SEA83LA091Accident · No injuriesLimited investigationFinal reportSwift GC-1B · Everett, WAThe acfts left main landing gear sheared and the acft came to rest off the runway in the grass. The pilot said that eventhough the landing gear light indicated down and locked he does not believe the rt main gear was down and locked. Duringan attempted…NTSB CHI83LA193Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Schaumburg, ILThe rated student was on an instructional flt to become a helicopter instructor plt. During an autorotative landing in a farmer's field, the helicopter landed hard & the main rotor hit the tail cone.NTSB ATL83LA190Accident · No injuriesLimited investigationFinal reportCessna 414 · Irvine, KYDuring arrival, the pilot made his landing approach to rwy 14 with a x-wind from 230 deg, gusting from 6 to 22 KTS. The airport was on a knoll & the terrain sloped downward from the approach end of the runway. The plt stated that as the acft was flying over…NTSB MKC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182H · Keosauqua, IAThe right main landing gear collapsed during the landing and ran off the runway. The flight originated about 30 minutes before the accident. The pilot said he was landing on runway 24 using 30 degrees of flaps. There was a wind of 18 KTS gusting to 25 KTS…NTSB LAX83LA203Accident · No injuriesLimited investigationFinal reportCessna A152 · Chino, CAThe student plt was on a local solo flt to practice touch & go landings. After making an apch to rwy 26, the acft landed hard on the main gear & bounced. After the 3rd bounce, the nose gear collapsed & a fire erupted. The plt exited the acft without…NTSB CHI83LA185Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Ashtabula, OHThe student plt was practicing touch & go landings on his 1st solo flt. He had performed one touch & go and was on the 2nd landing when the acft bounced. He applied power & the acft veered off the right side of rwy 08. The acft became airborne, crossed a…