NTSB investigations: Continental I0-470 series, WY
19 cases on aircraft whose registry engine model is Continental I0-470 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 4 |
| 1969 | 1 |
| 1970 | 1 |
| 1973 | 2 |
| 1977 | 2 |
| 1985 | 1 |
| 1995 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2012 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR12LA392Accident · No injuriesLimited investigationFinal reportCessna 210 · Kemmerer, WYThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the incorrect installation of the fuel bladder tanks.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB WPR09CA059Accident · No injuriesData collectionFinal reportCessna 210 · Sheridan, WYMaintenance personnel's failure to reinstall the left front pilot's seat correctly, which resulted in the pilot's loss of control and subsequent impact with a taxiway sign.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.NTSB DEN85LA086Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Bridger, WYThe acft encountered moderate turbulence and IFR conditions while en route over Fort Bridger, WY. The plt stated he attempted to climb on top but the acft had accumulated ice and the altimeter and VSI indicated a rapid descent. A forced landing was then…NTSB DEN78FTC07Accident · No injuriesClosedCessna 185 · Casper, WYNTSB DEN77IA057Incident · No injuriesClosedBeech 95-B55 · Cheyenne, WYNTSB DEN74FTC12Accident · No injuriesClosedCessna 310 · Cokeville, WYNTSB DEN74FTC14Accident · No injuriesClosedCessna 310P · Rock Springs, WYNTSB DEN70DXA01Accident · No injuriesClosedBeech K35 · Medicine Bow, WYNTSB DEN69A0050Accident · 2 fatalClosedBeech 95-55 · Lander, WYNTSB DEN67D0182Accident · No injuriesClosedCessna 310 · Rock Springs, WYNTSB DEN67A0029Accident · No injuriesClosedCessna 310G · Casper, WYNTSB DEN67F0110Accident · No injuriesClosedCessna 310G · Casper, WYNTSB DEN67D0082Accident · No injuriesClosedCessna 210 · Evanston, WYNTSB DEN66F0019Accident · No injuriesClosedBeechcraft K-35 · Cheyenne, WYNTSB DEN65D0001Accident · No injuriesClosedBeechcraft S-35 · Cody, WYNTSB UNK64X4102Accident · Minor injuriesClosedBeech 35A33 · Casper, WY