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 FTW82DA326Accident · No injuriesFinal reportCessna 337D · Gladewater, TXThe pilot made a night landing, nose high and dragged the rear propeller. In attempting a go-around, he dragged a wing and decided to abort. During the aborted go-around, he ran off the end of the runway and damaged the aircraft on rough, brushy terrain. The…NTSB NYC82DA194Accident · No injuriesFinal reportCessna 172M · Marlboro, MAThe solo student was practicing landings, flared the aircraft too high, then stalled and made a hard landing. The nose gear collapsed and the aircraft nosed over.NTSB DEN82FTC10Accident · Serious injuriesFinal reportQuickie · Rawlins, WYThe plt returned to the arpt since he couldn't gain enough altitude to climb over surrounding terrain. He stated he also had trouble holding altitude on the downwind leg. During the landing the left wheel struck the ground & the momentum of impact put the…NTSB MKC82DA144Accident · No injuriesFinal reportPiper PA-28-235 · Springfield, MOAfter passing over an imaginary obstacle during a short field landing, the student flared high without adding sufficientpower causing the acft to increase the descent rate. The CFI took control but was too late resulting in a hard landing.NTSB NYC82DA232Accident · No injuriesFinal reportCessna 185F · Lake George, NYWitnesses to the accident described a nose up pitch attitude of between thirty and forty-five degrees during the initial climb after departing Lake George. At several hundred feet above the ground, the aircraft was observed to make a desending left turn to…NTSB FTW82DA317Accident · No injuriesFinal reportBeech C23 · Afton, OKDuring arrival, the pilot landed on runway 36 with a reported tail wind of 10 KTS to 12 KTS. He stated that during the landing, his airspeed was a little too fast and the aircraft bounced. On the second bounce, the aircraft landed on its nose gear and the…NTSB MKC82DA157Accident · No injuriesFinal reportCessna T337C · Garden City, KSDuring arrival, the pilot landed on runway 17 with a tail wind of about 10 knots. According to the pilot, the touchdown was normal, but after rolling a short distance, the aircraft began to shake and then swerved off the right side of the runway. After…NTSB DEN82DA153Accident · No injuriesFinal reportBeech 90 · Billings, MTThe plt misjudged altitude & airspeed resulting in a hard landng. The right main gear assembly broke through the upper surface of the wing. The rwy is about 3-6 inches higher than the preceding terrain.NTSB CHI82DA296Accident · No injuriesFinal reportBeech B19 · Le Suer, MNThe aircraft landed short of the runway collapsing the nose gear and damaging the propeller.NTSB ANC82DA068Accident · No injuriesFinal reportCessna 170B · Fairbanks, AKWhile landing with a light crosswind from the left, the aircraft bounced. The pilot reported that the nose became canted to the left before the second touchdown. He then lost control. The aircraft skidded sideways and the right main gear collapsed.NTSB LAX82DA288Accident · No injuriesFinal reportCessna U206B · Grass Valley, CADuring arrival, the pilot entered the traffic pattern to land on runway 25 with a reported wind from the southwest at 10 KTS. On his first approach, the pilot experienced a rough ride with fluctuating airspeed and rate of descent. He was overshooting so he…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB DEN82DA149Accident · No injuriesFinal reportPiper PA-28-181 · Marion, MTThe pilot and her husband, who was also a rated pilot, were at the controls. During arrival, the wind sock was checked, but no wind was noticed. Reportedly, the pilot's husband landed the plane from the right front seat. The pilot reported that the flare was…NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB CHI82DA313Accident · No injuriesFinal reportCessna 152 · Chatfield, MNThe pilot reported that he was landing on runway 36 at a private airport with a crosswind from 300 deg at 17, gusting 26 KTS. The wind was blowing over tall trees along the left side of the runway, near the approach end. The pilot stated that this resulted in…NTSB CHI82DA273Accident · No injuriesFinal reportCessna 120 · Niles, MIThe student was on his second solo flight in evening hours. Reportedly, after he had completed 4 landings, dusk was approaching and the instructor told him to make only 2 more landings. When the student was about ready to takeoff on his 6th pattern, a king…NTSB LAX82DA277Accident · No injuriesFinal reportCessna 180 · Goodyear, AZThe left main landing gear of the aircraft broke off during a touch and go landing and the aircraft was damaged further on a subsequent landing. The weather was VMC and no flight plan was filed. The landing gear bolts failed in overload and showed no evidence…NTSB ATL82DA215Accident · No injuriesFinal reportCessna 172N · Somerset, KYThe student piot was on a controlled cross-country flight. While landing at the first en route airport, the aircraft veered off the runway and the nose gear collapsed. A witness stated that the aircraft bounced during the landing and the nose gear collapsed…NTSB NYC82DA165Accident · No injuriesFinal reportCessna 305A · Sagaponack, NYThe pilot reported that he was landing to the southeast on an 1800 ft grass strip with a crosswind from the northeast at 10 to 15 KTS. He stated that when he was on final approach with full flaps, he was distracted by four people with model aircraft near the…NTSB CHI82DA271Accident · No injuriesFinal reportCessna 206G · Warren, OHThe pilot was landing on runway 09 at a private strip with the wind from 020 at 12 to 15 KTS. He stated that when he was passing over a tree line on a short final approach, he encountered a downdraft and was unable to flare before contacting the runway. The…NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…NTSB CHI82DA263Accident · No injuriesFinal reportBeech B19 · Berrien Springs, MIDuring landing, the aircraft bounced and the pilot lost directional control. Subsequently, the aircraft departed the left side of the runway, went into a muddy area, and was substantially damaged.NTSB SEA82DA119Accident · No injuriesFinal reportHughes 369D · Creswell, ORThe pilot was practicing hovering autorotations and quick stops. He stated that after about six good quick stops, he made a tail low landing and the main rotor blades flexed into the tail boom.NTSB NYC82DA157Accident · No injuriesFinal reportBeech C23 · Pittsburgh, PAThe pilot misjudged his flare and made a hard landing. Sebsequently, the aircraft bounced and came down on right gear which broke off and the aircraft then skidded to a stop on the runway.NTSB NYC82DA158Accident · No injuriesFinal reportBeech C23 · Millbrook, NYWhile on final approach for landing, the student lowered the flaps from 25 degrees to full down, then told the instructor that he as using an unusual amount of back pressure. The instructor checked the trim, it was full nose up at 75 KTS. The instructor then…NTSB SEA82DA109Accident · No injuriesFinal reportPiper PA-12 · Eugene, ORThe pilot was high and fast on approach and bounced on the first touchdown. On the second touchdown the aircraft swerved and the left main landing gear collapsed.NTSB MKC82DA124Accident · No injuriesFinal reportCessna 305A · Ft. Leavenworth, KSThe aircraft bounced on landing during a dual instructional flight. The student pilot applied full power and the aircraft swerved on the second touchdown. Witnesses stated that the aircraft rotated 45 degrees left and touched down inthat position. The right…NTSB MKC82DA122Accident · Minor injuriesFinal reportBeech 95-A55 · Laurens, IAThe pilot had no current medical certificate or FAA pilot license. He stated that most of the time, he had a pilot in the company, but on this day, he was unable to obtain a pilot and conducted the flight himself. He stated that during his landing approach at…NTSB LAX82DA257Accident · No injuriesFinal reportBeech C23 · Little River, CAWhile on a solo cross-country, the student attempted to land in a 16 kt, 70 deg crosswind at ukiah, CA. The plane bounced 3 times and drifted off the runway into the dirt knocking out a runway edge light. The student made a go-around and proceeded to Little…NTSB LAX82DA253Accident · No injuriesFinal reportPiper PA-12 · Flagstaff, AZThe acft landed hard on the right main landing gear causing it to collapse. The x-wind component was 60 deg from the right varying 12-19K.NTSB MIA82DA158Accident · No injuriesFinal reportGlobe GC-1B · St. Augustine, FLThe purpose of the flight was to practice spot landings for a competitive event at a later time. The pilot reported that he made an approach to runway 13 on a hot morning with up and downdrafts. He estimated that the wind was variable from 130 to 220 deg at…NTSB FTW82FRG23Accident · Minor injuriesFinal reportCessna 180 · San Antonio, TXThe pilot stated that during the touchdown the aircraft bounced and made a second touchdown approximately 200 feet beyond the first. Corrective action was attempted but the left wing contacted the ground and the aircraft nosed over. The wind was reported to…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…NTSB LAX82DA249Accident · No injuriesFinal reportCessna 152 · Prescott, AZThe student pilot was on his second supervised solo flight. During his first landing on this flight, the aircraft touched down on the nosewheel first. It then began to porpoise. As the aircraft continued to bounce, the nose gear collapsed. According to the…NTSB MIA82DA149Accident · No injuriesFinal reportAeronca Champion 7AC · St. Petersburg, FLWhen the pilot tookoff to practice touch and go landings, he noticed a storm across the bay over tampa. He changed from runway 24 to runway 18 when he noticed a change in the wind direction. After completing three more touch and go landings, he elected to…NTSB ATL82DA207Accident · No injuriesFinal reportCessna 150 · Ft Eustis, VAThe student pilot was practicing landings in preparation for his private pilot check. There was a 70 degree right crosswind at 4 KTS. The pilot stated that he had landed hard due to a bad flare and the plane bounced. He thought that the aircraft would settle…NTSB MKC82DA118Accident · No injuriesFinal reportCessna 172 · Point Lookout, MOThe aircraft bounced several times during landing and the nose wheel tire blewout. There was substantial damage to the nose strut, firewall and propeller.NTSB LAX82DA246Accident · No injuriesFinal reportCessna T210L · South Lake Taho, CAThe pilot reported that during a landing, the aircraft bounced, came down, bounced again and ballooned. At that moment, he elected to go around. He stated that he advanced the throttle and retracted the gear to reduce drag, but the engine died and the plane…NTSB FTW82FQA21Accident · Serious injuriesFinal reportBarnes AX-7 · Albuquerque, NMThe pilot stated she made a practice landing near a large hill and had no problems landing. She continued flight for approximately 20 minutes and prepared to land on a road. The balloon impacted a road embankment at touchdown and the pilot broke her leg. She…NTSB NYC82DA144Accident · Minor injuriesFinal reportErcoupe 415-C · Mansfield, MAWitnesses reported that the aircraft bounced during touchdown and began porpoising. After bouncing 4 or 5 times, the nose tire blew out. Subsequently, the aircraft vee ed off the runway and nosed over.NTSB SEA82DA100Accident · No injuriesFinal reportMaule M-5-235C · Mt. Vernon, WAThe purpose of the flight was dual training for short field obstacle landings. On the third approach, a delayed flare resulted in a hard landing and gear collapse.NTSB MIA82DA152Accident · No injuriesFinal reportHughes 269C · Tampa, FLThe pilot reported a loss of engine power while on a supervised solo flight. Witnesses reported a thunderstorm in progress with winds gusting to 15 knots. The pilot landed to the south although he stated the winds were from the northwest. Examination of the…NTSB ATL82DLG12Accident · No injuriesFinal reportBell-Cont 42G EL TOMCAT-MK5A · Oswego, SCThe purpose of the flight was to study cotton fields that the pilot had been assigned to spray in the near future. He stated that during a landing approach on a farm field road, a wasp landed on his left arm and started stinging. The pilot allowed the rotor…NTSB MIA82DA142Accident · No injuriesFinal reportPiper PA-38-112 · West Palm Beach, FLWhile landing, the aircraft was observed to bounce several times. It then veered to the right, went into an area of grass, and nosed over. No malfunctions or failures were reported by either the pilot or the owner.NTSB NYC82DA131Accident · Minor injuriesFinal reportCessna A-152 · Millville, NJOn a cross-country instructional flight the student pilot made a hard landing and the gear collapsed.NTSB FTW82DA248Accident · No injuriesFinal reportCessna 172P Robertson Stol · Fort Worth, TXThe aircraft was equipped with a robertson stol kit. After operating the aircraft in slow flight about 1/2 hr, the pilot elected to land. The approach was flown at 45 KTS with a 500 ft/min sink rate. Power was added to arrest the sink rate just before…NTSB ATL82FKQ16Accident · No injuriesFinal reportBeech 58 · Madison, MSThe pilot reported that during flight, the right front door suddenly opened after light turbulence was encountered. The pilot followed the procedure, as prescribed by the owner's manual, to secure and close the door. As a precaution, he canceled the remainder…NTSB FTW82DA240Accident · No injuriesFinal reportPiper PA-38-112 · Denton, TXThe student pilot was a foreign national that was on his first supervised solo flight. The objective of the flight was to make a touch-and-go and then land. He made a high approach that ended in a bounced landing. The aircraft porpoised and landed on the nose…NTSB NYC82DA160Accident · No injuriesFinal reportCessna 172H · Old Forge, NYThe pilot reported that during arrival, his traffic pattern and approach were normal until he was over the end of the field. The aircraft then suddenly dropped below the glide path and the stall warning horn sounded. He attempted to stop the descent, but the…NTSB ATL82DA173Accident · Serious injuriesFinal reportCameron Ballon 0-77 · Peewee Valley, KYThe pilot reported that he took off in light to moderate wind conditions. During a 30 minute flight, the wind velocity increased. The pilot said that he briefed his passenger on how to position himself to avoid injury in the event of a hard landing. A shallow…