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 NYC82DHD14Accident · Serious injuriesFinal reportRaven S-66A · Washington Town, NJThe pilot reported that moments after initial ground contact (during landing), a passenger reported that he thought his leg had fractured. The passenger reported that the fracture occurred after initial impact, when another passenger leaned or stepped on his…NTSB SEA82DA091Accident · No injuriesFinal reportCessna 170A · Oregon City, ORThe pilot had just completed his bfr. On a return flight to his original departure point, he entered the traffic pattern for a landing in calm wind conditions. He stated that when he was about 25 ft above the runway on final approach, he entered an area of…NTSB MKC82DA106Accident · No injuriesFinal reportCessna T303 · Kingman, KSThe owner/pilot was receiving a multi-engine flight check with a designated flight examiner on board. The examiner reported that during an approach for a short field landing, the pilot allowed the airspeed to decay below the recommended approach speed. He…NTSB SEA82DA089Accident · No injuriesFinal reportPiper PA-28-180 · Roche Harbor, WAThe aircraft touched down hard on landing, bounced and directional control was lost. The aircraft then groundlooped and went through the airport fence. The pilot and his two passengers were not injured.NTSB FTW82DA224Accident · No injuriesFinal reportCessna 172 · Duncan, OKThe student pilot was practicing touch-and-go landings in winds from the southeast at 10 gusting 15 KTS. Just prior to landing, the aircraft encountered a gust of wind, then touched down hard. The engine fire wall was buckled and two tires blew out.NTSB FTW82DA222Accident · Minor injuriesFinal reportBeech C-35 · Ryan, OKOn arrival at the destination airport the pilot determined the grass strip was too wet for a landing. The pilot selecteda farm road and stated that a gust of wind struck the aircraft at about 10 to 12 feet above the road. The aircraft landed hard and swerved…NTSB NYC82FHD13Accident · No injuriesFinal reportMidget Mustang · Millville, NJThe pilot performed several high speed taxi tests with the tail up. During a high speed taxi, when the aircraft began to weather cock, the pilot attempted flight rather than risk groundlooping the aircraft. After several minutes of flight the pilot set up for…NTSB NYC82DA119Accident · No injuriesFinal reportCessna 150M · Perkasie, PADuring a local flight, the student pilot elected to proceed to Perkasie, PA to practice landings. The pilot reported that when he flared for a landing, he brought the nose up too high and then overcompensated. When he lowered the nose, the aircraft touched…NTSB ATL82FKW07Accident · Serious injuriesFinal reportPiper PA-28 · Hohenwald, TNOriginally, the pilot departed on a flight from olive branch, ms to lawrenceburg, TN. While en route, he became disoriented and landed at lafayette, TN. From there he proceeded to lawrenceburg via lebanon, TN. After departing lebanon, he became disoriented…NTSB LAX82DVM14Accident · Serious injuriesFinal reportCessna 152 · San Carlos, CAThe student pilot was practicing short field landings. On final the pilot lowered the nose of the aircraft and leveled the wings, the nose wheel struck the runway callapsing the nose gear.NTSB LAX82DA197Accident · No injuriesFinal reportCessna 172 · Fresno, CAThe acft landed hard, bounced, veered left & collided with a parked acft. The CFI recognized that the approach speed wastoo slow & waited too long before taking over. A deliberate turn was made to avoid residences.NTSB NYC82DA108Accident · No injuriesFinal reportCessna 152 · Burlington, CTThe student pilot was on her second supervised solo flight. While landing, she flared high and subsequently landed hard, collapsing the nose gear. The pilot reported that she did not have a good mental attitude since her children had been involved in a car…NTSB DEN82DA097Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDDuring landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.NTSB LAX82DA191Accident · No injuriesFinal reportCessna 182 · Huron, CAWhile attempting to extend glide over a flooded portion of the runway the aircraft lost airspeed. After dropping onto the runway the aircraft bounced and the pilot added power. The aircraft was then flown back to king city, CA where the gear collapsed upon…NTSB LAX82DA192Accident · No injuriesFinal reportBeech C23 · California City, CAThe pilot stated that on short final the airspeed decreased quickly from 60 to 40 knots and the aircraft stalled over the runway dropping approximately 30 feet.NTSB FTW82DA191Accident · Minor injuriesFinal reportErco 415-C · Sand Springs, OKThe pilot stated that on his second approach for a touch and go landing, the aircraft was a little high on final. He reduced power to complete a short field landing on the sod strip. The aircraft landed moderately hard in a flat attitude and the nose gear…NTSB SEA82DA073Accident · No injuriesFinal reportCessna 182QII · Cove, ORThe pilot stated that he landed heavy and was not quite straight. When the aircraft bounced the pilot attempted a go-around but the nose gear contacted a fence and the aircraft nosed over.NTSB DEN82DA095Accident · No injuriesFinal reportCessna 150 · Dillon, MTWhile the student pilot was landing, the aircraft bounced and nosed over. The pilot had only 4 hours of solo time.NTSB NYC82DA101Accident · No injuriesFinal reportCessna 152 · Monongahela, PADuring a practice landing the aircraft landed hard and bounced back into the air. The student pilot applied excessive forward pressure on the yoke causing the aircraft to land hard a second time in a nose low condition. The instructor pilot tried to salvage…NTSB MKC82DA091Accident · No injuriesFinal reportHomebuilt Quickie 2 · Kansas City, MODuring landing/touchdown the aircraft bounced back into the air. The pilot elected to decrease power and the aircraft landed hard and ground looped.NTSB FTW82DA184Accident · No injuriesFinal reportCessna 172P · Las Cruces, NMThe student pilot reported that during landing, the airspeed was too high. Reportedly, the aircraft touched down hard on all three gear, propoised, and subsequently, the plane was damaged. The wind was reported as light and variable.NTSB CHI82DA175Accident · No injuriesFinal reportCessna R182 · Cahokia, ILThe pilot was making touch and go landings on runway 30 with a wind from about 180 degrees at 11 KTS. On the fourth landing, the aircraft bounced two or three times. The plane slid sideways, went off the runway, and the nose gear failed.NTSB NYC82DA092Accident · No injuriesFinal reportPiper PA-28-140 · North Andover, MADuring landing the aircraft bounced and touched down on the center of runway 05. When the nosewheel was lowered the aircraft swerved to the right. According to the pilot, manipulation of the rudder pedals failed to change the direction or rate of turn of the…NTSB CHI82DA165Accident · No injuriesFinal reportPiper PA-28R · Stow, OHThe instructor pilot and his student, a rated private pilot, were on a flight to provide dual instruction for a commercial pilot certificate. A landing approach was made to a runway with a slight downslope in the touchdown area. The instructor estimated that…NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB MIA82DA119Accident · No injuriesFinal reportCessna 172K · Geneva, FLThe pilot stated that while on short final a gust of wind raised the right wing of the aircraft. Upon making a correction some airspeed was lost and the nose was lowered. During landing the nose gear collapsed and the aircraft turned over.NTSB CHI82DA153Accident · No injuriesFinal reportCessna 152 · Peoria, ILThe pilot departed mt hawley airport for greater Peoria airport to practice touch and go landings. His first approach was high and he made a go-around. He reported that his second approach was a bit too high, but he elected to continue since the runway was…NTSB MKC82FA069Accident · 1 fatalField investigationFinal reportStarfire JRF · Adel, IAThe owner/pilot of the home built aircraft was practicing touch-and-go landings. While climbing after the second touch-and-go, the left wing separated and the aircraft crashed about 3/4 mile south of the airport. A witness reported that on one of the…NTSB SEA82DA063Accident · No injuriesFinal reportGrumman AA-5B · Salmon, IDThe pilot stated the landing appeared normal until round out or flare when the aircraft bounced from 4-5 feet. A second somewhat higher bounce followed after which the pilot applied power and raised the flaps for a go-around. The aircraft settled to the…NTSB NYC82DA088Accident · No injuriesFinal reportPiper PA-24-250 · Farmingdale, NYThe pilot stated that a gust of wind caught the left wing of the aircraft during landing. This resulted in a hard landing and the collapse of the right main and nose gear.NTSB LAX82DA156Accident · Minor injuriesFinal reportRobinson R-22HP · North Las Vegas, NVThe passenger stated that during the approach to the landing area he noticed a decrease in rpm's and that the pilot was having difficulty in stabilizing the aircraft. He also noted that the helicopter was descending faster than the prior approach. Damage…NTSB MKC82DA065Accident · No injuriesFinal reportCessna 182P · Osceola, IAThe pilot reported that the aircraft landed heavy on the nose during a full flap landing at night on a soft grass runway. He reported that the nosewheel traveled about 15 ft while penetrating the ground, and then the nose gear collapsed and the plane flipped…NTSB MKC82DA064Accident · No injuriesFinal reportPiper PA-28-180 · Estherville, IAThe pilot had not flown for over 90 days and was flying for practice and to become current. During landing, the aircraft bounced back in the air about 20 to 30 feet and then came down hard on the nose gear. The nose gear failed and the plane slid to a stop on…NTSB LAX82DA166Accident · No injuriesFinal reportCessna 177B · Modesto, CAThe pilot was practicing touch and go landings with a right quartering headwind that was gusting to 20 KTS. On the second landing, the aircraft ballooned and began to porpoise. On the third touchdown, the aircraft stopped porpoising, but the tip of one…NTSB SEA82DA060Accident · No injuriesFinal reportCessna 150G · Camas, WAAfter receiving 2.9 hrs of dual instruction in this make and model of aircraft, the student proceeded on a supervised solo flight. The first approach and landing were observed by the instructor to be normal. The second approach was made with 20 degrees of…NTSB CHI82DA142Accident · No injuriesFinal reportPiper PA-22-150 · Lancaster, OHThe pilot was practicing takeoffs and landings on runway 10. On the second landing the aircraft bounced and drifted. The aircraft touched down on the runway a second time collapsing the nose gear. The wind was reported as 010 degrees at 13 KTS. Gusts to 15…NTSB LAX82DA148Accident · No injuriesFinal reportBell 206A · Huntington Beac, CAThe pilot stated that he was on a ferry flight from Huntington beach, CA to an offshore platform. A hard landing was made on the platform. This resulted in damage to the skids, tail rotor, tail boom, and fuel tank.NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…NTSB DEN82FTE18Accident · Serious injuriesFinal reportAvian Balloon Skyhawk · Longmont, COThe pilot tookoff in the balloon with three passengers on a sight-seeing flight. The wind was from 200 degrees at 5 gusting 7 knots. A large field was selected for landing. While using a high wind landing procedure, the gondola tipped over during touchdown.…NTSB CHI82DA132Accident · No injuriesFinal reportBeech BE-23 · West Chicago, ILThe pilot stated that during landing flare the aircraft dropped rapidly striking the runway on the main gear. It then bounced back into the air and landed on the nose gear which collapsed.NTSB NYC82FNC07Accident · No injuriesFinal reportAerotek-Pitts S-2A · Warren, VTThe pilot reported that before landing, he noticed heavy wind shear while on downwind and base. Reportedly, he encountered a severe sink after turning from base to final approach. He added full power, but was unable to stop the descent before contacting the…NTSB ATL82DA113Accident · No injuriesFinal reportPiper PA-38-112 · Montgomery, ALThe student pilot was on his second supervised solo flight. After a 30 minute local flight, he returned to the airport to practice full-flap, touch and go landings on runway 9. The wind was from 100 degrees at 11 knots. During his first landing, the student…NTSB MIA82DA107Accident · No injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot reported that she landed with 30 degrees of flaps on runway 23. She reported that the wind was gusting from 15 to 20 knots and the wind sock seemed to fluctuate from westerly to northwesterly. The pilot related that the aircraftbounced twice upon…NTSB NYC82DA076Accident · No injuriesFinal reportPiper PA-28-140 · White Plains, NYAfter returning from a local flight, the pilot landed in winds that were gusting to 20 knots. At about the flare point, he felt the aircraft drop. He added power and pulled back on the yoke, but the aircraft bounced on the nose. The porpeller, nose gear,…NTSB ATL82DA111Accident · No injuriesFinal reportCessna 320A · Paintsville, KYThe pilot reported encountering wind shear at about 300 ft from the approach end of runway 31. He stated that the aircraft crabbed to the left and right rudder was applied. Also, he reported that the plane stalled about six to ten feet above the runway and…NTSB LAX82FUG10Accident · No injuriesFinal reportPiper PA-38-112 · El Monte, CAOn his first approach for landing, the pilot decided that he was too high and made a go-around. He reported that his second approach was normal until the aircraft was about 5 ft AGL at the runway numbers. According to the pilot, the left wing lifted as if…NTSB LAX82DA143Accident · No injuriesFinal reportCessna 177 · N.W. Of Page, AZWhile on final approach for landing, the plane encountered a downdraft. The pilot applied full power to clear an embankment and then selected 10 degrees of flaps. He stated that the wind caused the plane to drift left as it crossed the embankment. The plane…NTSB FTW82DA140Accident · No injuriesFinal reportCessna 172M · Breckenridge, TXThe accident occurred at an en route airport while the student pilot was on a cross-country flight. Upon arrival at the en route airport, he entered traffic for a landing on runway 03 in winds from 010 degrees at 10 KTS gusting to 27 KTS. The student reported…NTSB MKC82DA056Accident · No injuriesFinal reportCessna 177 · Wentzville, MODuring a landing on a dual instructional flight, the aircraft bounced to a nose high attitude. The instructor initiated a recovery. However, he stated that he was too late to effect a normal recovery. During the recovery, the aircraft drifted off of the…NTSB LAX82DA145Accident · No injuriesFinal reportPiper PA-38-112 · Santa Monica, CADuring landing, the student pilot allowed the aircraft to bounce. After about the third bounce, the nose gear buckled and the aircraft skidded off the runway.