NTSB investigations, WY
10 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2004 | 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\" = 352)
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" = 352) 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 DEN04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Gillette, WYimproper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB DEN99LA061Accident · No injuriesLimited investigationFinal reportMooney M20K · Medicine Bow, WYA fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.NTSB SEA91LA128Accident · No injuriesLimited investigationFinal reportEnstrom F280C · Baggs, WYExhaust valve failure, resulting in a partial power loss. Contributing factors were low altitude and rough/uneven terrain.NTSB DEN90LA164Accident · No injuriesLimited investigationFinal reportMooney M20F · Torrington, WYA partial loss of power due to a failed exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB DEN89LA122Accident · No injuriesLimited investigationFinal reportCessna 175 · Sheridan, WYBinding (stuck) #4 exhaust valve. High vegetation (hay) and a hidden obstruction (ditch) were contributing factors.NTSB DEN88FA121Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rock Springs, WYShortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The…NTSB DEN84LA201Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cheyenne, WYThe aircraft collided with a tree during an emergency landing following loss of throttle control at a low RPM. Examination revealed that an uncertified throttle cable had been installed, it failed at the attachment to the throttle body.NTSB DEN83LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Worland, WYThe acft collided with a ditch and collapsed the landing gear during a forced landing after the engine quit during a ferry flight. The plt refueled the empty right fuel tank and topped-off the left tank with 3 gallons of fuel before the initial takeoff on the…NTSB DEN82FTC08Accident · Minor injuriesFinal reportCessna T210N · Near Laramie, WYThe pilot reported that on a previous flight, he had an engine problem, in which, he was unable to obtain more than 27 to 28 inches of manifold pressure. He had the engine checked, no problem was found that would have caused the loss of manifold pressure, and…