NTSB investigations: Continental E185 series, IA
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 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'IA' 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" = 'IA' 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 CHI07LA062Accident · 2 fatalLimited investigationFinal reportHallburg Amphibian S21D · Grinnell, IAThe inadequate preflight planning/preparation by the pilot in command and the fuel exhaustion during cruise flight. An additional cause was the inadequate forced landing procedure. A contributing factor was the tailwind.NTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB MKC85LA097Accident · No injuriesLimited investigationFinal reportBeech 35 · Ames, IAThe plt reports that the acft had slowed to taxi speed after landing when the gear warning horn began to blow followed shortly by collapse of the landing gear. Examination of the landing gear electrical circuitry failed to reveal any deficiencies.NTSB MKC80FA022Accident · Serious injuriesClosedBeech A35 · Creston, IANTSB MKC80FCD07Accident · No injuriesClosedBeech C35 · Somers, IANTSB MKC77FCD30Accident · No injuriesClosedBeech 35 · Clinton, IANTSB MKC71FCD85Accident · No injuriesClosedBeech A35 · Davenport, IANTSB MKC71DCD73Accident · No injuriesClosedBeech 35 · Rockwell Cty, IANTSB MKC70DCD35Accident · No injuriesClosedBeech A35 · Newton, IANTSB MKC69F0307Accident · No injuriesClosedBeech A35 · Burlington, IANTSB MKC68D0288Accident · No injuriesClosedBeech B35 · Hamburg, IANTSB MKC68F0082Accident · No injuriesClosedBeech 35 · Newton, IANTSB MKC67F0057Accident · No injuriesClosedBeech 35 · Lowden, IANTSB MKC65D0029Accident · No injuriesClosedNavion A · Rock Valley, IANTSB MKC65F0004Accident · No injuriesClosedBeechraft 35 · Creston, IANTSB UNK65X0857Accident · No injuriesClosedBeechcraft D35 · Cedar Rapids, IANTSB UNK65X0115Accident · No injuriesClosedBeechcraft 35 · Spencer, IA