NTSB investigations, UT
42 cases where the first occurrence was “Hard landing”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 4 |
| 1989 | 3 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest cases
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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' AND 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 LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.NTSB DEN05LA061Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Spanish Fork, UTthe student's failure to maintain control of the helicopter. Contributing factors were high airspeed, high rate of descent, the instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB DEN04CA143Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Spanish Fork, UTthe pilot's failure to maintain adequate rotor rpm during a practice autorotation, and the flight instructor's improper flare. A contributing factor was the instructor's inadequate supervision of the pilot.NTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.NTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.NTSB DEN04LA039Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. George, UTthe pilot's improper flare which resulted in a hard landing.NTSB DEN04LA028Accident · No injuriesLimited investigationFinal reportCessna 150H · Bountiful, UTthe unqualified person's failure to maintain aircraft control, which resulted in a hard landing. Contributing factors include the instructor's inadequate supervision, the instructor's inadequate recovery from a bounced landing, and the two parked aircraft.NTSB DEN03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · St. George, UTthe pilot's improper flare technique, resulting in a hard landing that caused the nose landing gear down-lock to fail and the gear to collapse. A contributing factor was the unfavorable wind.NTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.NTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.NTSB DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB DEN01LA015Accident · No injuriesLimited investigationFinal reportMurdock RAF 2000 GTX · Ogden, UTThe pilot's improper touchdown which resulted in a hard landing. Factors were lack of familiarity with the aircraft and lack of total experience.NTSB DEN01LA001Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Ogden, UTThe pilot's failure to maintain a proper descent rate during landing flare/touchdown. A factor was the tail wheel failure due to overload.NTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB DEN99LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tooele, UTAn inadequate flare during landing touchdown, resulting in a fracture of the right main landing gear strut. A factor was the flight instructor's failure to properly supervise the student.NTSB FTW98LA369Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Blanding, UTThe pilot's inadequate landing flare, causing components of the nose wheel landing gear to fracture.NTSB FTW98LA297Accident · No injuriesLimited investigationFinal reportPeebles/Lancair 360 LC-20 · Price, UTThe pilot's excessive descent rate on final approach and his delayed use of power to arrest the excessive descent rate.NTSB SEA96LA202Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mapleton, UTthe pilot's improper flare, which resulted in a hard landing.NTSB SEA96LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe pilot's improper flare and inadequate recovery from a bounced landing. His improper approach was a related factor.NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.NTSB SEA94LA166Accident · No injuriesLimited investigationFinal reportHughes 369HS · West Jordan, UTThe pilot not maintaining a proper descent rate and his delayed remedial action.NTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.NTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.NTSB DEN89FA192Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Bullfrog, UTImproper flare by the pilot, his failure to maintain runway alignment, and the improper remedial action which resulted in a loss of control. The high density altitude and objects (runway light and smudge pot) were considered to be contributing factors.NTSB DEN89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student pilot's improper flare which resulted in a hard landing & separation of the nose landing wheel. Contributing to the accident was the pilot's lack of total experience.NTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…NTSB DEN87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Price, UTThe student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft…NTSB DEN86LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Monument Valley, UTThe plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There…NTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…NTSB DEN85LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-180N · Delta, UTThe acft was flown by a student plt and his instructor on a local tng flt. During landing the sutdent plt did not flair the acft in time, hit hard and bounced. The instructor took control, made a soft landing followed by the main landing gear collapsing. The…NTSB DEN85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTThe student plt was on his 1st solo flt. His instructor plt reported that the student made a high & fast apch. The acft touched down on its main gear, bounced, then came down on the nose gear which collapsed. After the nose gear collapsed, the acft skidded…NTSB DEN84LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Salt Lake City, UTAccording to the plt the southerly wind was gusting to an unknown intensity and wind shear was encountered during landing. Ground contact occurred in a nose down attitude on the nose landing gear.