NTSB investigations: Continental E185 series, KS
18 cases on aircraft whose registry engine model is Continental E185 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 | 5 |
|---|---|
| 1965 | 2 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 1 |
| 1976 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 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\" = 'KS' 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 ('17014'))
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" = 'KS' 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 ('17014'))
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 DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…NTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.NTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…NTSB MKC85FCQ04Accident · Serious injuriesFinal reportRyan Navion · Blue Rapids, KSThe acft eng lost power after a 30 minute flt and a forced landing resulted in an off.-arpt acc. Witnesses at the acc site did not find any fuel in the tanks or evidence of spillage of fuel. An inspection of the eng did not reveal any discrepancies. A…NTSB MKC76FCQ44Accident · No injuriesClosedBeech C35 · Mankato, KSNTSB MKC69A0030Accident · 3 fatalClosedNavion A · St.John, KSNTSB MKC68D0341Accident · No injuriesClosedBeech 35 · Smith Center, KSNTSB MKC68D0202Accident · No injuriesClosedBeech 35 · Augusta, KSNTSB MKC67F0206Accident · No injuriesClosedBeech 35 · Toronto, KSNTSB MKC67D0078Accident · No injuriesClosedBeech 35 · Anthony, KSNTSB MKC66F0395Accident · No injuriesClosedBeech 35 · Salinga, KSNTSB MKC65F0051Accident · No injuriesClosedBeechcraft A35 · Wichita, KSNTSB MKC65F0007Accident · No injuriesClosedBeechraft 35 · Wichita, KSNTSB UNK65X0483Accident · No injuriesClosedBeechcraft 35 · Smith Center, KSNTSB UNK65X0246Accident · No injuriesClosedBeechraft 35 · Sabetha, KSNTSB UNK64X3290Accident · No injuriesClosedBeechcraft 35 · Meade Lake, KSNTSB UNK64X3087Accident · No injuriesClosedBeechcraft 35 · Ulysses, KSNTSB UNK64X0896Accident · No injuriesClosedBeechcraft A35 · Topeka, KS