NTSB investigations: Continental C90 series, OK
22 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2026 | 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\" = 'OK' 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" = 'OK' 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 ANC26LA035Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7EC · Hollis, OKNTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.NTSB CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB FTW98LA409Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Catoosa, OKThe pilot's failure to maintain control of the airplane resulting in an inadvertent stall.NTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…NTSB FTW86LA143Accident · No injuriesLimited investigationFinal reportForney F-1A · Wagoner, OKAn 80 yr old stu plt with an expired medical certificate was using auto fuel in the acft without an STC. FAA records forthe acft showed a sale was pending for svrl yrs. During flt, the plt decided to make a precautionary landing when the engine began 'running…NTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.NTSB FTW78FA049Accident · 2 fatalClosedPiper PA-18 · Greenfield, OKNTSB FTW76DPJ43Accident · Minor injuriesClosedAeronca 7FC · Thomas, OKNTSB FTW72DPJ28Accident · No injuriesClosedCessna 140 · Boise City, OKNTSB FTW72AF011Accident · 2 fatalClosedPiper PA-18 · Broken Bow, OKNTSB FTW69D0488Accident · No injuriesClosedChampion 7EC · Guthrie, OKNTSB FTW69D0225Accident · Minor injuriesClosedLuscombe 8F · Drumright, OKNTSB FTW68F0532Accident · No injuriesClosedAeronca 7EC · Okla.City, OKNTSB FTW68D0540Accident · No injuriesClosedPiper PA-11 · Altus, OKNTSB FTW68F0422Accident · No injuriesClosedCessna 140 · Ponca City, OKNTSB FTW68D0091Accident · No injuriesClosedCessna 140 · Blackwell, OKNTSB FTW67F0113Accident · Serious injuriesClosedCessna 140A · Wilson, OKNTSB UNK65X1454Accident · No injuriesClosedCessna 140A · Ardmore, OKNTSB UNK65X0917Accident · Minor injuriesClosedCessna 140A · Ardmore, OKNTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OK