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 ATL82DA096Accident · No injuriesFinal reportBeech 65-A90 · Winston-Salem, NCBefore landing, the pilot was advised by approach control that Boeing 737 training was being conducted on runway 33. The pilot agreed to land on runway 21 and hold short of runway 33. The aircrews conducting 737 training were so advised. The aircraft was on…NTSB FTW82DA112Accident · No injuriesFinal reportPiper-Aerostar 601P · Aspermont, TXThe pilot stated that he made a normal approach to land on runway 18. He reported that he was familiar with the local wind conditions and estimated the wind as gusty, 10 to 25 knots. He stated a possible wind shear brought about a slightly greater than normal…NTSB NYC82DA064Accident · No injuriesFinal reportCessna 152 · Ronkonkoma, NYWhile the student was on a local flight, the wind shifted from 240 degrees (down the runway) to 180 degrees. After returning, the student entered the traffic pattern for landing on runway 24. The downwind leg was extended to accommodate departing traffic.…NTSB CHI82DA106Accident · Minor injuriesFinal reportPiper PA-32-300 · Van Wert, OHThe pilot-in-command had a private, single-engine-land, certificate. The occupant of the right front seat was a commercial, single-engine-land, pilot. The landing approach was made to runway 27. The pilot-in-command estimated that the winds were from 220…NTSB CHI82DA105Accident · No injuriesFinal reportAero Commander 100 · Mineral Point, WIThe right main gear collapsed during a landing on runway 22 with the wind from 140 degrees at 15 gusting 22 knots. Subsequently, the aircraft veered to the right and went off of the runway. It continued into a gully and nosed over. An examination revealed…NTSB SEA82DA043Accident · Minor injuriesFinal reportCessna 150F · Hoquiam, WAThe private pilot had been making touch and go landings with a passenger on board for about one hour. He had made about 6 or 7 uneventful landings. On the last approach, the nose pitched down when the plane was about 50 ft AGL over the numbers. The empennage…NTSB FTW82DA107Accident · No injuriesFinal reportBeech 95-B55 · Afton, OKDuring landing the aircraft bounced on the nose gear three times before the nose gear collapsed. The aircraft slid 60 yards on its nose and stopped midway down the runway.NTSB LAX82DA123Accident · Minor injuriesFinal reportBölkow Phoebus C · Livermore, CAWhile returning to the gliderport, the aircraft had insufficient altitude to glide to the runway. The pilot elected to land in a field about 1/2 mile from the gliderport. Just before touchdown, he diverted his attention from the landing and became concerned…NTSB SEA82DA041Accident · No injuriesFinal reportGrumman AA-5B · Lebanon, ORThe pilot had about 3 hours of flying experience in this make and model of aircraft. This was his first landing with rear-seat passengers. The pilot reported that the wind was variable and gusting to 15 knots. During the landing flare, the pilot felt a sudden…NTSB LAX82FA113Accident · Serious injuriesField investigationFinal reportCessna 177 · San Fernando, CAThe pilot had received a two hour check-out in his recently purchased aircraft. He had about 6 to 7 hours of flying time in this aircraft. The accident occurred during his second solo flight after check-out. After arriving at the airport, the pilot made a…NTSB ATL82IA076Incident · No injuriesIncident investigationFinal reportCessna 172F · Mobile, ALUpon arrival at the aircraft, the pilot noted that the nose gear strut was under inflated. The pilot, who is training to be an A&P mechanic, diagnosed the problem as an oil leak. However, to avoid aborting the flight, he inflated the strut with air only and…NTSB ATL82DA079Accident · No injuriesFinal reportHughes H-369HS · Lexington, KYThe pilot was practicing autorotation from 15 to 20 ft AGL. On the final landing, the helicopter touched down hard and the main rotor blades fexed downward and struck the tail boom.NTSB MIA82DA073Accident · No injuriesFinal reportBeech F33A · West Palm Beach, FLPersonnel on duty in the tower observed the aircraft bounce during landing. They stated that the nose gear appeared to collapse on the final touchdown. The pilot stated that he felt a vibration when the nose gear contacted the runway. He stated that pulled…NTSB MIA82DA070Accident · No injuriesFinal reportPiper PA-30 · Crescent City, FLThe pilot landed on an upward sloping runway in very calm wind conditions. He stated that he failed to properly monitor the airspeed on final approach, and when he chopped the power, it resulted in a hard landing.NTSB LAX82FUJ33Accident · No injuriesFinal reportHatz CB-1 · Tucson, AZThe pilot reported that during landing, he flared early, misjudged his height, and landed hard. The left gear failed during touchdown, and the aircraft flipped over.NTSB FTW82DA097Accident · No injuriesFinal reportCessna 172M · Tyler, TXWhile the instructor pilot was demonstrating a barrier/obstacle landing, the aircraft touched down hard and bounced. A power recovery was made and the flight was terminated. The pilots inspected the aircraft after landing, but no damage was noted until four…NTSB ATL82DA081Accident · No injuriesFinal reportSchweizer SGS-1-35 · Marion, NCWhile turning from downwind through base to final approach for landing, the pilot noted a strong tailwind. He reported that the tailwind blew the glider across the runway and over the boundary fence. He angled back to clear the fence and land on the runway…NTSB ANC82DA024Accident · No injuriesFinal reportPiper PA-38-112 · Anchorage, AKStudent pilot rounded out too high,aircraft bounced and became airborne. The student did not apply power and the CFI added power for a go-around. However he stated he waited too long before applying power and the right wing stalled. The aircraft veered right…NTSB FTW82DA074Accident · No injuriesFinal reportPiper PA-38-112 · Temple, TXThe pilot decided to practice takeoffs and landings on runway 15 with the wind from 190 degrees at 20 gusting 30 KTS. During the first landing, the aircraft touched down, bounced/ballooned, then touched down hard in a nose down attitude. The aircraft was…NTSB SEA82DA031Accident · No injuriesFinal reportCessna 172N · Redmond, WAThe student and instructor were practicing water landings on lake sammamish near Redmond, WA. The winds were initially calm. On the second landing, it was noted that the wind began to pick up. Reportedly, wind shear was encountered during final approach for…NTSB FTW82DA072Accident · No injuriesFinal reportCessna T210M · Clovis, NMAfter a normal approach, the aircraft was flared high and began porpoising after touchdown. After bouncing twice, the nose gear collapsed and the aircraft slid to a stop on the runway.NTSB NYC82DA040Accident · No injuriesFinal reportCessna 310Q · Doylestown, PAWhile descending ice began to accummulate on the windshield and leading edges of the wings. The pilot stated that the windshield was covered with 1/2 to 3/4 inch of ice but he was able to clear a small strip large enough for him to see out. Upon reducing…NTSB MKC82DA041Accident · No injuriesFinal reportPiper PA-60/601P · Carroll, IAThe pilot was on a flight from Kansas city, MO to sac city, IA. After making an approach at sac city, he went around, diverted, and made an NDB approach at Carroll, IA. He said that he encountered icing conditions during the approaches. At Carroll, the pilot…NTSB CHI82DA064Accident · No injuriesFinal reportFairchild Hiller 227C · Bloomington, INThe aircraft was being pre-positioned for a scheduled flight. During a visual approach to land, the captain (PIC) called for the flaps to be lowered in incremental settings (16.5, 27 & 40 deg). The flap handle was moved to the appropriate positions, but…NTSB MIA82DA054Accident · No injuriesFinal reportCessna 152 · St. Petersburg, FLThe student pilot was on her first supervised solo flight. During the second landing the aircraft bounced and while attempting to recover the pilot first added power then cut it. The aircraft dropped down on its nose and the nose gear collapsed.NTSB LAX82DA076Accident · No injuriesFinal reportCessna 172M · San Luis Obispo, CADuring landing, the aircraft bounced twice. On the third touchdown, the nosewheel failed, the nosewheel tire blew out and the firewall was bent. The pilot reported that the wind was gusting to 15 knots.NTSB DEN82DA033Accident · No injuriesFinal reportCessna 210 · Rapid City, SDDuring landing, the nosewheel began to shimmy while the brakes were being applied. The nose gear failed at the end of the runway, and the plane continued off the end and down an embankment, then nosed over. The pilot stated in part that he touched down past…NTSB ATL82DA053Accident · Minor injuriesFinal reportBellanca 8GCBC · Stevensville, MDThe pilot landed with 10 degrees of flaps in a 10 to 15 knot, left crosswind condition. He reported that wind gusts picked up the left wing and he was unable to adequately compensate with power and aileron. The aircraft became airborne and then hit the ground…NTSB CHI82DA045Accident · No injuriesFinal reportSikorsky UH-19B · Urbana, ILThe pilot and a medical attendant were on a flight to Urbana to make a medical evacuation. The pilot stated that just prior to touchdown, the helicopter began to rotate to the left. He reported that he landed immediately, cut the power, and stopped the…NTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.NTSB FTW82DA053Accident · No injuriesFinal reportCessna P206 · Las Cruces, NMDuring arrival, the pilot received an advisory from UNICOM to land on runway 04. He reported that during the landing, he encountered a variable, quartering tailwind that was gusting to 30 knots. The nose gear assembly and attaching fuselage structure were…NTSB LAX82DA043Accident · No injuriesFinal reportCessna 182E · Santa Monica, CAUpon landing touchdown the aircraft bounced at high speed and departed the runway. The pilot applied brakes and the aircraft skidded to a stop just short of a ditch.NTSB MKC82DA026Accident · No injuriesFinal reportPiper PA-24-250 · Liberty, MOThe instructor pilot reported encountering wind shear at about 12 to 15 ft AGL during a short field landing on runway 19. She stated that there were several obstructions that could create a wind effect. The surface wind was from the northeast at five knots.…