NTSB investigations: Continental C90 series, WY
12 cases on aircraft whose registry engine model is Continental C90 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
| 1965 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2008 | 1 |
| 2015 | 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 ('17009'))
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 ('17009'))
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 CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.NTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.NTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.NTSB DEN76FTC28Accident · Serious injuriesClosedCessna 140 · Green River, WYNTSB DEN71DTC06Accident · No injuriesClosedPiper PA-11 · Aladdin, WYNTSB DEN70DXA14Accident · No injuriesClosedCessna 140A · Casper, WYNTSB DEN69D0073Accident · No injuriesClosedCessna 140 · Grass Creek, WYNTSB DEN69D0070Accident · No injuriesClosedLuscombe T-8F · Rock Springs, WYNTSB DEN68D0047Accident · No injuriesClosedPiper PA-11 · Sheridan, WYNTSB DEN67D0250Accident · No injuriesClosedCessna 140 · Burns, WYNTSB DEN65D0065Accident · Minor injuriesClosedChampion 7CCM · Alva, WY