NTSB investigations, WY
8 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2007 | 1 |
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\" = 354)
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" = 354) 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 DEN07LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Basin, WYThe carburetor icing causing a partial loss of engine power, and the pilot's failure to maintain aircraft control leading to the inadvertent stall. A factor contributing to the accident was the conditions conducive for carburetor icing.NTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.NTSB DEN03LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Laramie, WYA partial loss of engine power for undetermined reasons. Contributing factors were the high density altitude, trees, mountainous terrain, and unsuitable terrain on which to make a forced landing.NTSB DEN02LA051Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Medicine Bow, WYthe unsuitable terrain encountered during the emergency autorotation, following a partial loss of engine power. Factors contributing to this accident were fuel contamination (water), the low altitude, the high winds, and the tailwind.NTSB SEA93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Riverton, WYThe pilot did not perform an abort of the takeoff after observing a partial loss of power. Factors include improper use of the mixture control.NTSB SEA91LA154Accident · 1 fatalLimited investigationFinal reportJerrell RV-4 · Yellowstonepark, WYA collapsed induction air duct. Factors include inadequate design by the manufacturer/builder, and a misjudged rate of descent by the pilot.NTSB DEN86FTI01Accident · Minor injuriesFinal reportMiller Sievers Special · Gillette, WYOn March 3, 1986 at approximately 1715 MST, an experimental Miller, sievers special, struck the ground during takeoff at the Gillette-campbell county airport, Gillette, Wyoming. The pilot stated that just after takeoff on runway 34, the aircraft appeared to…NTSB DEN84LA286Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Lyman, WYThe plt stated that engine RPM began deteriorating during a climb to cruise flt. He returned to the landing site where the RPM decayed to flt idle, an autorotation was entered and a hard landing resulted. The engine ran for 1 hour in a test cell after the…