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 FTW84LA008Accident · No injuriesLimited investigationFinal reportCessna 150G · Forrest City, ARDuring a landing, the acft touched down hard, then bounced & touched down hard, 2 more times. On the 3rd impact, the nose gear collapsed. Subsequently, the acft slid to a stop with damage to the propeller & firewall.NTSB FTW84LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXThe pilot, accompanied by three passengers, landed hard, bounced and last control of the acft, which continued into a stock tank/pond. Examination revealed all three main gear assemblies were collapsed and both left and right wing assemblies were damaged.NTSB ATL84FA005Accident · Serious injuriesField investigationFinal reportCessna T210F · Glasgow, VAThe acft crashed during an attempted go-around after a hard landing on a 1200 ft private strip in mountainous terrain. The two pilots had landed at this arpt in landings described as fast. Then two passengers were invited to ride along one more landing was…NTSB CHI84LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Neenah, WIThe plt was not lined up with the rwy during final & executed a go-around. He applied full power, retracted flaps, & theacft dropped onto the rwy nose gear first. The student plt had 5 hrs of dual & was no endorsed for solo flt.NTSB ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.NTSB NYC83FU012Accident · Serious injuriesFinal reportRobertson Bird · Milan, NHAccording to the plt, he had just purchased the ultralight on the previous day & had no previous training in ultralights. On his 2nd flt in the vehicle, he landed hard, the tubular structure to the right gear collapsed & the lower seat support contacted the…NTSB MKC83LA228Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6 · Fort Madison, IAThe Balloon was one of 25 balloons participating in an event. The plts had received a collective briefing from the Balloon master at 0630 who stated that current winds at nearby reporting facilities were 8-10 KTS. The 0600 observation at burlington, IA,…NTSB SEA83LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · La Grande, ORThe acft made a hard landing during an aborted takeoff. The pilot stated that after takeoff he thought he could not clear the trees at the departure end of the rwy. He closed the throttle and attempted to re-land his acft. During touchdown on the rough dirt…NTSB CHI83LA435Accident · No injuriesLimited investigationFinal reportCessna 172 · Plymouth, MIThe plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…NTSB CHI83LA426Accident · No injuriesLimited investigationFinal reportBrandt Pitts S-1C · Hamilton, OHThe acft went off the rwy and nosed over during landing. The weather was VMC and the wind was from 010 degrees at 7 KTS.the landing was on rwy 29. The pilot stated that during the landing the acft bounced about a ft into the air and that heapplied forward…NTSB FTW83LA427Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student plt's apch to land was high & he extended 20 deg of flaps & retarded the power to idle. Realizing he was about to land too long, he initiated a go-around. He applied power & retracted the flaps to full up. The student stated that the acft began…NTSB CHI83LA427Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe instructor plt (CFI) was providing a dual check-out for a private plt in the Cessna 172. After flying in the local area, they returned to the arpt to practice touch-and-go landings on rwy 18. The winds were reported from 190 deg at 20, gusting 25 KTS. On…NTSB ATL83LA351Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Griffin, GAThe plt stated his airspeed was low on final & lift was lost on the canard due to the rain. He stated he had full aft stick trying to get the nose up, but couldn't. the acft landed hard, bounced several times hard & the canard broke.NTSB LAX83LA426Accident · No injuriesLimited investigationFinal reportCessna 182L · Santa Paula, CAThe plt reported that during the landing, he 'came in too fast & sharp, bounced 5 times, did a go-around & landed.' After the landing, he taxied to a fuel pump, then found that the acft was damaged. The acft had porpoised to such an extent that both propeller…NTSB ATL83LA344Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Blairsville, GAThe plt reported that during the run-up before takeoff, he noted that the right brake was not firm, but he elected to continue the flt. While cruising, he checked the brake & reportedly, no pressure was available. The remainder of the flt was routine until…NTSB FTW83LA401Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Sheridan, ARThe acft was damaged in a ground loop after a hard landing. After a high bounce the acft settled to the rwy and veered sharply to the left running off the rwy. Examination by an a & p mechanic revealed a fatigue crack in the left landing gear leg.NTSB DEN83LA198Accident · No injuriesLimited investigationFinal reportBeech 23 · Rocky Ford, COThe acft landed hard & bounced. The impact wrinkled the right wing at the fuel cell position.NTSB LAX83LA406Accident · No injuriesLimited investigationFinal reportBeech F33A · San Carlos, CAThe plt stated that during the final approach sequence he encountered a gust of wind followed by immediate sinking of the acft, causing the acft to bounce. During the recovery from the bounced landing, the nose gear struck the rwy & collapsed.NTSB NYC83LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Islip, NYDuring landing the acft bounced several times, skidded and nosed over.NTSB MKC83LA198Accident · No injuriesLimited investigationFinal reportCessna C-152 · Kansas City, MOThe student pilot had made 3 solo touch and go landings. On the 4th landing the aircraft floated and then landed nose gear first. The nose gear collapsed.NTSB NYC83LA219Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wakefield, NHThe plt reported that he taxied out of a protected cove to takeoff on the main part of balch lake. After lift-off, he realized the wind was too gusty to be flying, & aborted from aprx 30 to 40 ft AGL. He saw telephone wires ahead that crossed the lake &…NTSB NYC83LA217Accident · No injuriesLimited investigationFinal reportCessna 172M · Somerville, NJAccording to the pilot, as the flight neared the runway it was flared for touchdown. However, the aircraft bounced and the pilot immediately applied full power, pushed the nose forward and raised the electric flap lever. The aircraft did not seem to climb and…NTSB MIA83LA204Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sarasota, FLThe student plt was on her lst solo x-country & was landing after completing the 2nd leg of the flt. She stated that she flared high, the acft bounced twice, then the nose gear failed. An eng mount, the firewall & the propeller were also damaged.NTSB DEN83LA192Accident · No injuriesLimited investigationFinal reportCessna 152 · Akron, COThe acft nose gear collapsed during landing. The plt said he made a normal landing and when the nose was lowered the gear shook violently and collapsed. A witness, who is a CFI said the acft landed and bounce about 3 times and came down hard on the nose gear.…NTSB NYC83LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Medina, NYThe acft made a hard landing and collapsed the nose gear before nosing over. The pilot was making a practice landing on a grass airstrip. The approach was too high so the pilot made a steep descent. The airspeed increased but the pilot elected to land. The…NTSB MIA83IA206Incident · No injuriesIncident investigationFinal reportCASA 212-200 (Casa 212) · St. ThomasThe acft was landed hard damaging the right main landing and acft structure.NTSB ATL83FIA04Accident · No injuriesFinal reportCessna 152 · Front Royal, VAThe student pilot was on his first solo cross country flt. During the approach to Front Royal the student was advised by UNICOM that a deer was on the rwy. The UNICOM operator suggested that he buzz the arpt to chase the deer away. The student heard only that…NTSB ATL83LA324Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Manasses, VAThe plt reported that during the landing, the nosewheel touched down 1st & the acft bounced. On the 3rd bounce, the nose gear collapsed. After exiting the acft, the plt saw a small fire under the cowling which resulted in further damage before it could be…NTSB CHI83LA377Accident · No injuriesLimited investigationFinal reportCessna T310R · Shelbyville, INThe plt made a VOR approach to rwy 18, then circled to land on rwy 36. He reported that the wind was from the northwest at 12, gusting to 15 KTS. He stated that after he made a hard landing, the right main tire blew out & he was unable to maintain directional…NTSB MKC83LA181Accident · No injuriesLimited investigationFinal reportCessna 172 · Camdenton, MOThe plt reported that during the landing, the acft veered to the left, went off the rwy into grass, then the nose gear collapsed & the acft nosed oer. Marks on the rwy indicated that the acft was landed long, bounced & then touched down with the nose pointed…NTSB SEA83LA171Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Blakely Island, WAThe plt reported that when he was on a short final approach to rwy 01, he encountered windshear at about 100 ft AGL. A rapid sink rate was encountered & he was unable to fully recover. Subsequently, the acft touched down hard in a level attitude. The gear was…NTSB CHI83LA355Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Alexandria, INThe acft nosed over while landing after the acft stalled and dragged the right wing. The pilot stated he made a normal approach, heard the stall warning as he leveled off and lost control as the right wing struck the ground. When the nose gear came down it…NTSB MKC83LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOOn landing the aircraft touched down hard, bounced and the right main landing gear broke off. A go around was executed and the flight proceeded to Kansas City where an emergency landing was made. During landing the aircraft swerved off the runway to the right.NTSB CHI83FA353Accident · No injuriesField investigationFinal reportGulfstream AA-5B · West Chicago, ILThe plt reported that during a night landing, the acft began to porpoise. He applied power to go around, but the plane went off the left side of the rwy. Subsequently, it collided with brush & a chain link fence & came to rest on residential property. The plt…NTSB MKC83LA168Accident · No injuriesLimited investigationFinal reportBeech A100 · Valley, NEWhile landing at night, the acft touched down hard, then swerved off the left side of the rwy. An exam of the acft revealed that the left landing gear down plate, pn 99810022, had failed. An exam of the plate revealed that it had failed from overload.NTSB MKC83FA172Accident · No injuriesField investigationFinal reportRotec Engineering Rally 3 · Council Bluffs, IAOwner/pilot stated that he was giving 'flight time and ground instruction to another ultralight owner.' The instructor allowed the student to co-operate the controls and did three takeoffs and landings. On the third landing a dead stick landing was initiated.…NTSB LAX83LA370Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Tehachapi, CAThe plt reported that during the landing approach, the rotor RPM decreased & the helicopter landed hard. After touchdown, the helicopter skidded into an unoccupied pickup truck. An exam of the helicopter did not reveal any preimpact discrepancies which would…NTSB CHI84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILThe student plt stated that when approaching over wires she 'powered up and ended up coming in too fast.' The acft made initial contact on the nose wheel. Subst damage to the eng mount area and the left wing.NTSB ATL83LA303Accident · No injuriesLimited investigationFinal reportCessna 170 · Ft. Bragg, NCThe acft's right landing gear collapsed during landing. The plt had just purchased this acft and was on his first x-country. During his first approach at Ft. Bragg he had made a go-around because of gusty winds and turbulence. During the 2nd attempt the wind…NTSB LAX83LA364Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Ely, NVThe plt said that he apchd the 6000 ft rwy with 40 deg of flaps. The acft bounced twice during the landing, then the plt initiated a full power go-around. The plt reported that the acft did not climb, but was 'wallowing' in ground effect. To reduce the drag,…NTSB LAX83LA361Accident · No injuriesLimited investigationFinal reportCessna 180K · Las Vegas, NVThe plt reported that during touchdown, he heard a loud squeal from a tire & felt the aircraft pull to the left. He stated that he applied right aileron & rudder to keep the acft going straight. However, as the acft slowed, it began to veer left again. He…NTSB CHI83LEE01Accident · No injuriesFinal reportQuickie Q-2 · Chicago, ILThe plt reported that during an en route stop, the acft landed hard, then bounced & was damaged in the area of the tailwheel. Reportedly, the tailwheel spring separated, the rudder pedals flopped forward & control of the rudder was lost. Subsequently, the…NTSB NYC83LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Millinocket, MEAfter a solo x-country flt, the plt misjudged the landing flare & landed on the nose wheel. The acft bounced at least twice. The prop, nosewheel & crankshaft was damaged.NTSB CHI83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe acft bounced during landing and collapsed the nose gear. The student pilot was practicing landings and had been successful on 4. The fifth in the series was intended to be the last one. The pilots recommendation for prevention was to go around as soon as…NTSB LAX83LA356Accident · No injuriesLimited investigationFinal reportCessna 172M · Santa Monica, CAThe plt reported that during the flare the acft began to 'porpoise.' Reportedly, it bounced during the landing, but the plt did not add power to go around or to reland the acft. The acft bounced several times. The nose gear, eng mounts & firewall were bent,…NTSB NYC83LA184Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Antrim, NHThe helicopter made a steep approach, settled with power and made a hard landing. This was a dual instructional flt. Thestudents total time amounted to 4 hours, all in type. According to the CFI, while on the fourth approach on short final at 75 ft AGL, the…NTSB MIA83LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe student stated that while performing a touch-and-go landing, the acft bounced 2 times. On the 3rd touchdown, the nose gear collapsed & the acft came to rest on its nose.NTSB NYC83FNC08Accident · Minor injuriesFinal reportCessna 172L · Moose River, METhe plt reported that he encountered wind shear & stalled on final approach, which resulted in a bounced landing, then the plane settled and bounced again. He reported that he attempted to go around, but could not get the acft to accelerate to climb speed.…NTSB CHI83LA322Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIDuring a landing, the student plt did not use the flaps as he was taught. As a result, the landing occurred further down the rwy & at a higher speed. During the landing, the acft bounced, then touched down nose 1st & bounced 2 more times. The student found…NTSB MKC83LA149Accident · No injuriesLimited investigationFinal reportHughes 369HS · Springfield, MOThe plt reported that he had made a practice autorotation with a full power recovery & was landing when the accident occurred. He said the helicopter touched down hard, tail 1st, and rocked forward. The helicopter remained upright, but the main rotors struck…