NTSB investigations: Continental C90 series, OR
18 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1969 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2019 | 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\" = 'OR' 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" = 'OR' 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 GAA19CA189Accident · No injuriesData collectionFinal reportCessna 140 · Corvallis, ORThe pilot’s failure to maintain directional control during the landing roll, which resulted in a propeller strike and subsequent nose-over.NTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.NTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB SEA03LA088Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Oregon City, ORThe student pilot's failure to maintain aircraft control during the landing roll. A tailwind and gusting conditions were factors.NTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.NTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB SEA87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · The Dalles, ORThe pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45…NTSB SEA81DYM23Accident · No injuriesClosedCessna 140 · Pendleton, ORNTSB SEA77DYI01Accident · No injuriesClosedCessna 120 · Crane, ORNTSB SEA74DYC60Accident · No injuriesClosedMooney M10 · Lebanon, ORNTSB SEA70D0009Accident · No injuriesClosedChampion 7EC · Eagle Point, ORNTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORNTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORNTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORNTSB UNK64X1279Accident · No injuriesClosedCessna 140A · Burns, OR