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 CHI86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Webster, WIDuring an attempted go-around after a bounced crosswind landing, pilot failed to maintain a proper ground track and the aircraft collided with trees.NTSB FTW86LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Tyler, TXThe pilot failed to flare the aircraft before touchdown, causing the aircraft to bounce and assume a nose down attitude, before it impacted the ground, although the pilot states he lost directional control due to locked controls, investigation did not reveal…NTSB DEN86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAccording to the student plt, he flared too high during landing & landed hard, collapsing the nose gear.NTSB CHI86LA128Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Pickney, MIThe balloonest had briefed and positioned his two pax for a anticipated hard/drag landing in a 9 kt wind. He stated the balloon touched and bounced then touched and bounced again before it entered the drag sequence of the landing. The female pax suffered a…NTSB MKC86LA096Accident · No injuriesLimited investigationFinal reportCessna 182M · Mountain Home, ARThe acft nose gear collapsed during a hard landing. The plt stated that his original destination was gastons arpt, lakeview, AR, which has a turf rwy. There are three other arpts in close proximity to gastons, but all have paved rwys. He further stated that…NTSB NYC86LA110Accident · No injuriesLimited investigationFinal reportCessna C-310R · Buffalo, NYThe pilot of the C-310R stated upon landing flare he heard a loud noise on the right side. His speed was such that he became airborne again on relanding right propeller blades struck runway. Aircraft suffered major wing and structural damage.NTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…NTSB FTW86LA071Accident · No injuriesLimited investigationFinal reportCessna TU206G · Tomball, TXThe pilot reported that he failed to flare the aircraft when he touched down during landing at Tomball, TX. The aircraft bounced twice and the nosewheel dug into the dirt strip causing the aircraft to noseover.NTSB MIA86LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Augustine, FLThe private pilot with a total of 36.2 hours of logged flight time, stated that she landed hard on the nose wheel and the nose strut failed during a full stop landing.NTSB MKC86LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Omaha, NEThe plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of…NTSB CHI86LA124Accident · No injuriesLimited investigationFinal reportHughes 269A · Lowell, MIThe pilot had just completed two autorotations when he landed hard on the third. The main rotor flexed down severing the tailboom and tailrotor. Although the pilot had logged over 6000 hours flight time, he had only 51 hours total rotorcraft time. He had…NTSB MIA86LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Umatilla, FLThe plt reported that he flared the acft too high while landing. The acft stalled too soon and a hard landing resulted.NTSB CHI86LA116Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Seneca, ILThe plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft…NTSB CHI86LA118Accident · No injuriesLimited investigationFinal reportCessna 411 · Bloomington, INThe plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an…NTSB MKC86LA076Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St.Charles, MOThe PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which…NTSB ATL86FEI03Accident · Minor injuriesFinal reportCessna 170B · Columbia Stat., OHThe acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft.NTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.NTSB MIA86LA105Accident · No injuriesLimited investigationFinal reportCessna 150L · St. ThomasThe student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft…NTSB LAX86LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAWitnesses reported that they observed the plt make 2 approaches and landings prior to the accident. On the landing just before the accident, they observed an 'extremely hard landing on the nose gear.' They reported that the plt then taxied back to takeoff…NTSB NYC86IA109Incident · No injuriesIncident investigationFinal reportSikorsky S-76 · Atlantic City, NJDuring a preflight examination of a Sikorsky S76 the instructor and student discovered a hole in the leading edge of the pylon above the intermediate gear box and scuff mark on the main rotor blade caps. The instructor and student had just completed a 2.1 hr…NTSB SEA86LA101Accident · No injuriesLimited investigationFinal reportBeech 76 · Troutdale, ORThe acft was substantially damaged during a hard landing performed by the multi-enging student during a dual instructional flt.NTSB ATL86FMG05Accident · No injuriesFinal reportCessna 150 · Yadkinville, NCThe acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail.NTSB LAX86LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · San Luis Obispo, CAOn March 4, 1986 a Cessna 152 collided with the runway surface after the nose wheel collapsed. The student pilot was on his third consecutive solo flight since his solo endorsement. On his third approach the aircraft bounced on landing and became airborne…NTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…NTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…NTSB FTW86LRG13Accident · No injuriesFinal reportRobinson R-22 · Austin, TXAcft was substantially damaged when it experienced a hard landing and severed the tailboom. Plt initially stated that the eng had 'missed' during pwr application at the bottom of a norm approach. Later he stated that he had been practicing touchdown…NTSB FTW86LRD07Accident · No injuriesFinal reportMBB BO-105-CBS · Lake Charles, LAThe helicopter was simulating a single eng landing on an area marked to the size of an offshore helideck. The acft touched down hard enough to attract the attention of several witnesses. The crew continued with the training but later on post flt exam they…NTSB DEN86LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Alameda, NMThe student plt stated that during the landing, the aircraft bounced twice before it's nose gear collapsed. The student pilot said the aircraft nosed over onto its back following the nose gear collapse.NTSB NYC86LA075Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Indiana, PACessna 182 landed in deep snow off the right side of the runway. The aircraft touched down hard broke the nose wheel and the Cessna flipped over and received substantial damage. There was no fire. There were no injuries to the pilot and one passenger.. The…NTSB LAX86LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Rancho Murieta, CAOn February 8, 1986 at 1530 PST a Cessna 140 landed hard and nosed over on the runway. VMC prevailed at the time. The pilot indicated that on landing he flared too high and landed hard. His feet slipped on the pedals and inadvertently applied the brakes which…NTSB LAX86LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAA Cessna 152 collided with the runway surface after the nose gear separated. The aircraft flared too high and bounced on landing. On the second bounce the nose gear separated. The flight instructor took over the controls and landed the aircraft on the nose…NTSB MIA86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Folkston, GAThe plt stated that while on a flight from tampa, to jacksonville FL, he made an unauthorized deviation & landed at davis field Folkston ga, where the left main landing gear collapsed. Post crash examination of the acft revealed that the gear collapsed due to…NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.NTSB CHI86LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Anderson, INThe acft touched down hard on the nose gear during a x-wind landing. The plt reported the acft dropped to the rwy from an alt of aprx 10 ft AGL. Reported winds at the time of the accident were from 240 degs at 15 KTS gusting to 23 KTS.NTSB CHI86LA057Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Indianapolis, INOn the second approach to rwy 22R the private pilot (in the left seat) attempted to land. The right main gear hit hard and the acft bounced coming down on the left wing tip. The acft then hit on its right main gear, then the left main gear. The right main…NTSB NYC86LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Marlboro, NJThe acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,…NTSB ATL86LA047Accident · No injuriesLimited investigationFinal reportCessna 177RG · Atlanta, GAThe aircraft landed hard resulting in substantial damage to the aircraft. This was following a final approach which was flown high and fast. The aircraft was observed to stall approximatel 10 ft above the runway and land on the nose gear.NTSB FTW86FPA10Accident · No injuriesFinal reportBell BH206L-1 · Hurst, TXThe instructor plt was demonstrating an autorotation from the 'top of the height-velocity' curve. The CFI zeroed the airspeed and entered the autorotation at an alt of aprx 400 ft AGL. The acft touched down hard, spreading the skids, severing the tail boom…NTSB ATL86LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Stone Mountain, GAAfter an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down…NTSB CHI86LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Carbondale, ILAccording to the student pilot flying the plane, after he touched down on his main wheels he lowered the nose and he heard a crack. The nose wheel then collapsed andthe aircraft slid to a stop. According to the operator of the aircraft no preexisting…NTSB NYC86LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Atlantic City, NJThe acft experienced a collapse of the nose gear during the landing roll after what the plt said was a normal landing. The right main gear was further damaged during removal of the acft from the rwy.NTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…NTSB CHI86LA016Accident · Minor injuriesLimited investigationFinal reportBeech A23.19 · Decatur, INThe student pilot on an unauthorized xcountry flt was attempting to ld on a 2600'-115' sod strip. On his fifth approach the 90 deg xwind drifted him into a tree line on the downwind side of the strip.NTSB CHI86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILThe student pilot was practicing touch and go landings in preparation for a solo cross country. The pilot was compensating for a crosswind when he landed the aircraft on its nose resulting in substantial damage to the aircraft.NTSB CHI86LA014Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHThe acft touched down hard and bounced during the student plts second solo landing of the day. Recovery was made by initiating a go around. The acft touched down hard and bounced again on the third landing. Directional control of the acft was lost and it…NTSB ATL86LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Atlanta, GADuring a practice autorotation the acft experienced a hard ldg when the plt failed to arrest the sink rate prior to contacting the ground.NTSB BFO86LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAccording to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear…NTSB LAX86LA009Accident · No injuriesLimited investigationFinal reportCessna 182N · Palm Springs, CADuring arrival, the plt entered the traffic pattern behind other acft to land on rwy 12. At that time, a Boeing 727 was waiting to takeoff on the same rwy. At 1914:52, the plt (of N92259) was instructed to start a left turn to the base leg. At 1915:04, the…NTSB MKC86LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Guilford, MOThe plt reports that he landed hard, bounced and came down on the nose gear. The nose gear broke and the acft went over on its back.NTSB FTW86LA003Accident · No injuriesLimited investigationFinal reportCessna 182N · Odessa, TXDuring touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left…