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 MIA88LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · Titusville, FLThe plt stated that on approach for landing the acft developed a high sink rate. The acft landed hard and bounced. The pilot said she had pushed the nose of the acft down to prevent it from stalling and did not apply power. The nose gear collapsed and the…NTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…NTSB ANC88LA077Accident · No injuriesLimited investigationFinal reportHelio H-295 · Clear, AKThe commercially certificated 8,000 hour pilot was attempting to land his Helio courier airplane at a remote, private airstrip in Alaska to pick up a non-revenue passenger. He reported that he landed hard, and that the left main gear collapsed. He said that…NTSB ATL88LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Andrews, NCThe pilot failed to establish a proper apch profile and experienced a hard landing. The hard landing caused the main landing gear to collapse, and the airplane veered off of the left side of the runway. A witness located near the runway confirmed that the…NTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MINTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…NTSB MIA88IA196Incident · No injuriesIncident investigationFinal reportLearjet 24 · W. Palm Beach, FLThe acft departed fort lauderdale executive arpt on a 14 CFR part 91 positioning flight to pick up a patient in west Palm Beach FL, for a 14 CFR part 135 air ambulance flight to rochester new york. The plt stated that on landing the acft floated aprx 4000…NTSB ATL88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccormick, SCThe student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to…NTSB NYC88LA159Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Erwinna, PAAccident was a loss of directional control during landing which followed a hard landing. Contributing was the improper use of spoiler control by the private pilot and the failure of the flight instructor to adequately supervise the actions of the private…NTSB MKC88LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Dewitt, ARThe pilot was attempting to land on his personal grass strip, which had trees at both ends. The acft hit hard, bounced, then slid to a stop. The nose gear was separated.NTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILNTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…NTSB DEN88LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe student pilot was returning from a cross country training flight. At touchdown the acft bounced and began to porpoise. The nose gear collapsed and the plane nosed down. The FBO reported calm winds and dry rnwy conditions.NTSB LAX88LA219Accident · No injuriesLimited investigationFinal reportCessna 182M · Flagstaff, AZAt the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising…NTSB LAX88LA198Accident · No injuriesLimited investigationFinal reportEnstrom F28A · La Verne, CAThe helicopter landed hard during a practice touchdown autorotation (auto). The helo remained in closed traffic for the purpose of practicing touchdown autos to a landing area adjacent to the aprt's rwy. There was also another helo in closed traffic using the…NTSB FTW88LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Graham, TXThe student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident.NTSB MIA88LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt stated that upon touchdown, the aircraft landed hard, bounced twice and ran off the side of the runway into the grass.NTSB NYC88FA143Accident · Minor injuriesField investigationFinal reportBell 206B · Farmingdale, NYThe Bell 206B was being flown on a helicopter rating ride with the PIC in the right seat and an FAA inspector in the left seat. The oral was satisfactory and the flight check progressed to autorotations. The first one was long, the second short. On the third…NTSB SEA88LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Yamhill, OROn short final for landing onto a 2100 foot airstrip at about 12 feet AGL, the aircraft encountered adverse winds and struck the ground in a three point attitude breaking off the nose gear. The aircraft then nosed over inverted striking a barbed wire fence.…NTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INNTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…NTSB DEN88LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Great Falls, MTThe private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot…NTSB ANC88LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot stated that he made a hard landing and at that time he lost directional control of the aircraft. The plt stated that the acft bounced and when he tried to correct the bounce the acft yawed left. The rt main gear collapsed and the acft groundlooped.NTSB MKC88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Red Cloud, NEAfter a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the…NTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…NTSB NYC88LA123Accident · No injuriesLimited investigationFinal reportCessna 185 · Hopedale, MAThe pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report.NTSB ATL88LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, SCThe student plt rptd that the airplane was low on final appch, and that he applied pwr to maintain altitude. After crossing the rwy threshold, he reduced the pwr to idle & lowered the nose to maintain airspeed. He initiated a flare prior to touchdown, but the…NTSB MIA88LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student plt completed 5 touch & go's with his instructor before dropping her off for first supervised solo flight. On the first touch & go landing , the acft bounced after touchdown on the main landing gear. The student plt added power, lowered the nose…NTSB NYC88LA116Accident · No injuriesLimited investigationFinal reportBell 206L · Allentown, PADuring an FAA flight check an autorotational descent was made with a planned power recovery, the helicopter fell through the maneuver and collided with the ground. The main rotor blades flexed downward, striking the horizontal fin winglets and the tail boom.NTSB LAX88LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbia, CAAt the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down…NTSB MKC88LA066Accident · No injuriesLimited investigationFinal reportBeech 23 · Fulton, MOWhile attempting a crosswind landing, the acft began to porpoise and veered off the runway. The left ldg gear failed and the wheel struck the aft section of the fuselage, then the horizontal stabilator. The PIC then applied full power, became airborne and…NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…NTSB LAX88LA132Accident · No injuriesLimited investigationFinal reportCessna 172Q · Prescott, AZNTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMNTSB DEN88LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Aurora, CONTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.NTSB NYC88LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck…NTSB BFO88LA019Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roanoke, VAThis was the stu plt fifth training session where he did solo touch & go landings. During this session he made ten landings without incident. Six landings were made with his instr aboard followed by four solo landings. According to the stu during the flare…NTSB NYC88LA085Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Philadelphia, PAThe Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing…NTSB FTW88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Oklahoma City, OKThe airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt…NTSB MIA88LA098Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Clearwater, FLPlt stated acft stalled during landing flare resulting in a hard landing. After the hard landing the acft bounced into the air and veered to the left. Before a go-around could be completed the acft collided with a dirt mound between the runway and taxiway…NTSB LAX88LA096Accident · No injuriesLimited investigationFinal reportCessna 402C · Prescott, AZNTSB FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.NTSB LAX88LA086Accident · No injuriesLimited investigationFinal reportCessna 195 · Sonoma, CADuring a local pilot check flight, upon touchdown, a loud bang was heard. The acft gradually veered to the right then ground looped. A local mechanic was unable to identify a failure. The plt reported that the brakes were operating normally prior to and…NTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…NTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…NTSB MIA88NA070Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Pensacola, FLNTSB ATL88LA058Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Marlboro, OHThe student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees.NTSB ANC88DAG01Accident · No injuriesFinal reportCessna 207A · Atmautluak, AKThe aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway.NTSB MIA88LA053Accident · No injuriesLimited investigationFinal reportBeech C-45H · Miami, FLWhile practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy.