NTSB investigations, WY
26 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
Where
Open the mapLatest 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\" = '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\" = 130)
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" = 130) 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 DEN06LA116Accident · 1 fatalLimited investigationFinal reportBaker RV-3AB · Laramie, WYThe in-flight failure of the right wing spar during aerobatic flight. Contributing to the accident was the owner/operator's failure to comply with the service bulletin issued by the kit manufacturer.NTSB DEN06IA042Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Casper, WYloss of directional control for undetermined reasons. A factor contributing to the incident was the runway maker light.NTSB DEN05LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Rock Springs, WYthe pilot's failure to maintain control of the helicopter during the attempted autorotation after he experienced an engine overspeed that occurred for reasons undetermined.NTSB DEN04LA140Accident · No injuriesLimited investigationFinal reportBeech B-60 · Casper, WYthe missing nose gear assembly bolt, spacer and nut resulting in a gear collapse due to improper maintenance procedures. Contributing to the accident was the collision with the storm drain.NTSB DEN04IA126Incident · No injuriesIncident investigationFinal reportCessna 750 · Jackson, WYthe failure of the right main landing gear trailing link due to fatigue cracking initiated by an undetected manufacturing defect. A contributing factor was the improper plating process by unknown manufacture personnel.NTSB DEN03FA138Accident · 1 fatalField investigationFinal reportWright Hughes 1-B · Yellowstone Nat, WYThe in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.NTSB DEN02TA011Accident · No injuriesFinal reportCessna 206 · Casper, WYfailure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.NTSB DEN01LA142Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Rock Springs, WYthe right main tire blowing out in flight, which resulted in a loss of directional control during landing.NTSB DEN01LA125Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Cody, WYthe failure of the turbine assembly due to an over temperature condition. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.NTSB FTW98LA201Accident · No injuriesLimited investigationFinal reportCessna 320D · Greybull, WYStress overload failure of the bellcrank assembly of the left landing gear.NTSB SEA96LA190Accident · No injuriesLimited investigationFinal reportAviat A-1 · Worland, WYoverload failure of the landing gear axle, after its design stress limits had been exceeded at some undetermined time.NTSB SEA96LA126Accident · No injuriesLimited investigationFinal reportPrice Berkut · Jackson, WYfailure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.NTSB FTW95FA177Accident · 1 fatalField investigationFinal reportBeech 60 · Cheyenne, WYThe pilot's failure to maintain aircraft control. Factors were the instrument weather conditons and the excessive workload imposed on the solo pilot attempting to deal with an emergency situation while flying in instrument meteorological conditions.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYNTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…NTSB DEN85LA195Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Riverton, WYThe plt was crop spraying a field in a Schweizer ag-cat acft when the left landing wire broke. The plt returned to Riverton, WY. During the landing roll, in attempt to stop the acft as soon as possible, he inadvertently applied the brakes too hard, causing…NTSB DEN84LA282Accident · No injuriesLimited investigationFinal reportAerospatiale 316B Alouette III · Cokeville, WYThe plt stated that he lost tailrotor control while maneuvering for a landing. He elected to return to Cokeville airport and make the landing. The plt executed an aitorotation to the runway and during the landing flare, the tail skid struck the runway,…NTSB DEN83FU003Accident · 1 fatalFinal reportWeedhopper Unknown · Powell, WYThe ultralight vehicle crashed in a corn field while on a local pleasure flt. It impacted the soft ground in a nose down, vertical attitude. The engine buried itself to a depth of 18 inches. Examination of the wreckage airframe revealedthat a bolt with a self…NTSB DEN82DA152Accident · No injuriesFinal reportCessna 172N · Lander, WYThe pilot reported that the aircraft suddenly veered to the right after he had slowed to about 30 to 35 KTS. An examination revealed that the nose gear fork had failed in two places. The breaks were just below the strut attachment point and directly accross…NTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…