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 DEN89LA006Accident · No injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Rawlins, WYThe pvt plt in command and his atp-rated pax were ferrying the newly-purchased acft from FL to WA. They departed scottsbluff, NE, and were enroute to rock springs, WY, when the pax advised the plt insufficient VFR fuel reserves precluded continuing to rks.…NTSB DEN89LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally II · Rio Rancho, NMThe commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was…NTSB DEN89LA002Accident · Minor injuriesLimited investigationFinal reportCessna TP206B · Durango, COThe private plt was practicing landings in his acft. During takeoff ground run, while making a touch and go landing, the plt reported experiencing vibrations from both main gear and his acft departed the 5,000 x 50 ft rwy to the left. The plane traveled 100…NTSB BFO88LA087Accident · No injuriesLimited investigationFinal reportBeech B23 · Roanoke, VAThe plt said the acft bounced twice during the landing. The apch speed was 75 to 80 KTS. The left main gear collapsed on the second bounce. The nose gear collapsed on the final touchdown. The acft slid off the left side of he rwy. The plt reported no…NTSB SEA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Renton, WAThe student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to…NTSB MIA88LA275Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Belleview, FLAfter clearing transmission wires at the apch end of the rwy, the plt stated the acft was low & slow. Prior to touchdown she stated the acft stalled, then landed hard. The nose wheel collapsed during the touchdown.NTSB FTW88DPA10Accident · No injuriesFinal reportBell 206L-1 · Fort Worth, TXThe rated helicopter pilot was undergoing recurrent training with an instructor at a training field. During a practice autorotation to a landing, the helicopter went into a high sink rate with a low main rotor RPM. The helicopter touched down hard in a tail…NTSB ANC88LA144Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Porcupine Butte, AKThe plt rprtd he landed harder than he intended from about 3 to 5 ft above the ground. The right main gear collapsed & the acft veered to the right. Subsequently, the left main gear collapsed & the acft came to rest off the airstrip.NTSB SEA88LA173Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Priest River, IDOn approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing.NTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…NTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…NTSB BFO88LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe student pilot reported that he allowed the airspeed to deteriorate on final apch. The acft touched down nosewheel first and began to porpoise on the runway. The acft porpoised 3 or 4 times before the propeller and right wing contacted the runway.NTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…NTSB NYC88LA230Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Manville, NJAfter completing six landings with an instructor the student plt was released by the instructor for his first solo flt to be conducted as a series of closed pattern touch-and-go landings. On his first solo landing the student plt landed nose wheel first with…NTSB SEA88LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the…NTSB NYC88LA226Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJThe CFI was demonstrating a departure autorotation to a prospective student. A high rate of descent with low airspeed and low rotor RPM developed and the CFI attempted a power recovery with no results. The acft touched down hard, the skids collapsed and the…NTSB SEA88LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Tyge Valley, ORThe pilot reported that late in the apch, the acft developed a high sink rate. However, he used elevator only to correct the sink rate. The aircraft impacted the runway and bounced. On the third bounce, the nose gear failed and the aircraft nosed over. The…NTSB DEN88LA187Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leadville, COThe student plt was lost during a solo cross country instructional flight. After landing and refueling at Leadville, Colorado, he attempted to fly through a mountain pass towards his destination. He climbed the acft to 12,000 and tried to continue the climb.…NTSB CHI88DEC06Accident · Minor injuriesFinal reportSackett J2 · Deckerville, MIThe pilot's poor judgement and misjudged perceptions while practicing takeoffs and landings in an unfamiliar aircraft. The pilot executed a hard landing, touching down short of the runway and collapsing the landing gear. The aircraft skidded to a stop on the…NTSB DEN88LA190Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COThe commercial plt was practicing short field landings from the right seat on a 7,498 x 100 ft asphalt rwy. The plt said he encountered a thermal at 10 ft AGL and stalled the airplane. He reported that the acft hit harder than he expected and bounced twice.…NTSB MIA88IA255Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe CFI & his pvt plt-rated multi eng student were conducting touch & go ldgs in preparation for the multi-eng rating. The CFI stated that one of the ldgs was harder than usual, but not overly hard. On the next aprch, they noticed the rt gear indicator was…NTSB CHI88LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Eden Prairie, MNOn landing the aircraft bounced resulting in a porpoise. The nose gear collapsed rendering substantial damage to the aircraft.NTSB SEA88LA146Accident · No injuriesLimited investigationFinal reportCessna 182 · Veradale, WAThe pilot stated a high sink rate developed on final approach which he was unable to arrest with power. Acft landed hard and short, contacting a 3-FT berm at end of grass strip. During roll-out, flames were noted in aft cabin area. Occupants exited and acft…NTSB MIA88FA248Accident · Serious injuriesField investigationFinal reportMooney M20G · Lantana, FLPlt attempted to land with a left quartering tail wind. The aircraft landed hard and bounced several times. The plt initiated a go-around and during climbout from the go-around the pilot initiated a steep left turn with 30 to 40 degrees of bank and with a…NTSB CHI88LA194Accident · No injuriesLimited investigationFinal reportCessna 150K · Detroit, MIHard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back.NTSB BFO88LA072Accident · No injuriesLimited investigationFinal reportPiper PA-30-160R · Chantilly, VAThe instr & stu plt were doing a practice landing on rwy 27 at the front royal airport when the acft landed hard and bounced about 20 ft high. A go around was made, however, the landing gear would not retract. After two flyovers of the arpt it was confirmed…NTSB MIA88FA244Accident · Serious injuriesField investigationFinal reportCessna 150M · Pahokee, FLThe acft crashed while the plt was attempting a touch and go landing at Pahokee airport, Pahokee FL. The plt stated that when he landed on runway 17, the acft bounced. As he was attempting a go around, he lost control. The acft stalled, broke left, and…NTSB CHI88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WINTSB ANC88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.…NTSB CHI88LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Flint, MIWhile on a solo instructional flight for the purpose of practicing takeoffs and landings, the student pilot executed a hard landing. The aircraft bounced; when it touched down again, the nose gear collapsed and the aircraft skidded to a stop on the runway.NTSB CHI88LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Belleville, MIDuring a solo instructional flight for the purpose of practicing touch and gos, the student pilot experienced a loss of control when the aircraft bounced after a hard landing. The pilot failed to perform remedial action as the aircraft continued to porpoise…NTSB SEA88LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lewis, WAThe pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire…NTSB CHI88FA177Accident · No injuriesField investigationFinal reportQuickie Q-2 · Oshkosh, WIThe plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the…NTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…NTSB LAX88LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CAThe student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed.NTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…NTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…NTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…NTSB NYC88LA172Accident · No injuriesLimited investigationFinal reportCessna 150 · Massena, NYThe student pilot on a crosscountry flight to Massena, new york stated that during the landing approach he felt that he was too low and when he tried to correct, the aircraft bounced. On the second touchdown the nose gear collapsed and the aircraft slid off…NTSB ANC88DAG06Accident · No injuriesFinal reportAir Command 532 Elite · Palmer, AKDuring landing approach an excessive rate of descent developed very near the runway. The gyroplane landed hard. After the hard landing the pilot reported that he pulled the control column to its aft position abruptly. The small tail wheel struck the runway…NTSB MIA88LA222Accident · No injuriesLimited investigationFinal reportCessna 150G · Keystone Height, FLWhile on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over…NTSB BFO88LA066Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8 · Purcellville, VAThe pilot landed the hot air Balloon at an excessive descent rate which resulted in a hard landing. Wind gust are a contributing factor.NTSB SEA88LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Roche Harbor, WAPlt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover.NTSB CHI88LA154Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Thief Rvr Falls, MNNTSB BFO88LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Clarksburg, WVThe student and instructor practiced several maneuvers. At the time of the accident they were doing straight-in landings. The student did one landing after a demo by the instructor. The student was doing his second landing which the instructor described as…NTSB NYC88LA176Accident · No injuriesLimited investigationFinal reportLake LA-4 · Linden, NJHard landing due to improper level off of the student and the flight instructor's inadequate supervision. The left wing partially failed because of overload and the aircraft made a forced landing in a swamp.NTSB CHI88LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Breckenridge, MIThe student pilot was attempting to land on the private airstrip when the aircraft touched down hard on the runway. The aircraft bounced back up into the air. The pilot was unable to maintain control of the aircraft and upon impacting back onto the runway the…NTSB DEN88LA144Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe plt and pax departed st. louis and stopped twice enroute due to wx. The plt was given landing clearance on rwy 17 at Colorado springs and the wind was reported to be from 190 degrees at 12 KTS. Witnesses at the arpt stated N4878S 'porpoised' several times…NTSB CHI88DEC04Accident · No injuriesFinal reportPerkins Dragonfly · Fowlerville, MIThe pilot failed to maintain positive control of his homebuilt aircraft by taking appropriate actions for recovery from the bounced landing. The aircraft contacted the ground abruptly on the third bounce and the upper wing spar failed. The pilot's lack of…NTSB ANC88LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Hooper Bay, AKThe commercially certificated pilot was attempting to land in winds estimated as 30 knots gusting to 40. He reportedly hit a downdraft just piror to landing and had a harder than normal touchdown. During the later stages of the landing roll-out, he applied…