NTSB investigations: Continental E185 series, NC
16 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
| 1965 | 3 |
|---|---|
| 1967 | 1 |
| 1970 | 2 |
| 1971 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2024 | 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\" = 'NC' 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" = 'NC' 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 ERA25LA007Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Rutherfordton, NCAn in-flight fire, the origin of which could not be determined based on the available evidence.NTSB MIA07FA154Accident · 1 fatalField investigationFinal reportNorth American Navion · Clayton, NCThe pilot's intentional abrupt maneuver during low altitude cruise flight to avoid obstructions ahead, resulting in an in-flight collision with terrain and a building. Contributing to the accident were the failure of the pilot to obtain a preflight weather…NTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB ATL80DKM18Accident · No injuriesClosedNavion A · Mooresville, NCNTSB IAD79DKM15Accident · No injuriesClosedRyan Navion · Newton, NCNTSB IAD78DLJ19Accident · Minor injuriesClosedRyan Navion · Wilmington, NCNTSB IAD76DKM26Accident · No injuriesClosedBeech 35 · Canton, NCNTSB NYC72AN072Accident · No injuriesClosedBeech A35 · Clayton, NCNTSB NYC72DKM16Accident · No injuriesClosedBeech C35 · Arden, NCNTSB IAD70FKM15Accident · Minor injuriesClosedNavion A · Rutherfordton, NCNTSB IAD70FKM02Accident · Minor injuriesClosedNavion A · Gastonia, NCNTSB DIA67F0107Accident · No injuriesClosedBeech D35 · Morrisville, NCNTSB MIA66F0304Accident · No injuriesClosedBeechcraft D35 · Greensboro, NCNTSB MIA66A0019Accident · 1 fatalClosedBeechcraft A-35 · Statesville, NCNTSB MIA66D0015Accident · No injuriesClosedBeechcraft B-35 · Manteo, NC