Skip to content

NTSB investigations, WY

23 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 'WY' 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

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\" = 'WY' 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" = 'WY' 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 DEN08LA008Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Afton, WYThe pilot's failure to correct the alignment of the airplane and his improper recovery from a bounced landing, resulting in exceeding the design stress limits that caused the right main landing gear to fail. A contributing factor in this accident was the…Oct 10, 2007 · N245CT · Substantial damage NTSB DEN07LA036Accident · No injuriesLimited investigationFinal reportFairchild SA227BC · Gillette, WYwind shear.Dec 8, 2006 · N779BC · Substantial damage NTSB DEN05LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Rock Springs, WYthe pilot's improper flare and recovery from a bounced landing.Mar 19, 2005 · N30874 · Substantial damage NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.Oct 7, 2004 · N73764 · Substantial damage NTSB DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.Aug 4, 1999 · N4789J · Substantial damage NTSB DEN99LA084Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Baggs, WYThe pilot not maintaining the main rotor's RPM. Factor's were the high density altitude, and the mountainous/hilly terrain.May 22, 1999 · N535H · Substantial damage NTSB FTW97LA329Accident · No injuriesLimited investigationFinal reportFairchild Heli-Porter PC6/B2-H2 · Gillette, WYFailure by the pilot in command to follow procedures and retrim the stabilizer for landing.Aug 26, 1997 · N354F · Substantial damage NTSB FTW97LA318Accident · No injuriesLimited investigationFinal reportCessna 175 · Rock Springs, WYThe delayed landing flare by both student pilot and flight instructor, and the flight instructor's inadequate supervision of the student. Factors were the no flap steep approach at low airspeed.Aug 18, 1997 · N7518M · Substantial damage NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.Aug 23, 1996 · N206FT · Substantial damage NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.Apr 18, 1996 · N733FF · Substantial damage NTSB SEA95LA059Accident · Minor injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Gillette, WYThe pilot in command's failure to retract the spoilers and the consequent high sink rate on an unstabilized final approach. Factors contributing to the accident were: icing conditions, both pilots diverted attention, inadequate flight crew coordination, and…Mar 4, 1995 · N311BR · Substantial damage NTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.Feb 27, 1994 · N21840 · Substantial damage NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.May 27, 1993 · N43LL · Substantial damage NTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.Jul 29, 1992 · N4906N · Substantial damage NTSB SEA91LA256Accident · No injuriesLimited investigationFinal reportLyons Stueckle Quickie Q-2 · Cheyenne, WYThe premature landing flare by the pilot.Sep 28, 1991 · N82SL · Substantial damage NTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.Sep 13, 1990 · N3981F · Substantial damage NTSB DEN89LA153Accident · No injuriesLimited investigationFinal reportStitts SA7D · Evanston, WYImproper compensation by the pilot for wind conditions. Contributing factors were: high density altitude, unfavorable wind, and downdraft.Jul 2, 1989 · N1113E · Substantial damage NTSB DEN89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Cheyenne, WYFailure of the pilot-in-command to properly recover from a bounced landing.Apr 5, 1989 · N83864 · Substantial damage 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.…Oct 4, 1988 · N21SP · Substantial damage 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…Jul 25, 1988 · N5266J · Substantial damage NTSB DEN84FA275Accident · 2 fatalField investigationFinal reportCessna 182F · Rock Springs, WYThe acft was being operated on the return leg of flt from California to Wisconsin. A landing apch was made to rwy 27 at Rock Springs (elev 6747), temp was 76 degrees, wind 220 at 23 KTS. Acft was observed to bounce back into the air after touchdown and then…Aug 31, 1984 · N3110U · Destroyed NTSB DEN83LA037Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lander, WYThe aircraft nose wheel collapsed during landing. The plane then turned left went off the runway and collided with a snowbank. An examination of the aircraft revealed no evidence of a mechanical malfunction or failure of the nose gear prior to touchdown.Dec 22, 1982 · N756CK · Substantial damage 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…Aug 12, 1982 · N88Q · Substantial damage