NTSB investigations: Continental E185 series, NV

12 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Continental E185 series, NV per year, 1964–2026: 12 cases
1964	1
1967	4
1971	1
1973	1
1975	2
1979	1
1993	1
2020	1

Where

Open the map

Latest cases

Query with SQL

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" = 'NV' 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

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\" = 'NV' 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" = 'NV' 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

Run 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 WPR20LA131Accident · 3 fatalClass 3 · LimitedFinal reportBeech 35 · Currie, NVThe pilot’s failure to maintain airplane control during a forced landing which resulted in a hard landing for reasons that could not be determined based on available evidence.Apr 24, 2020 · N8743A · Destroyed NTSB LAX94LA022Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Indian Springs, NVFailure of the pilot to properly operate the airplane's fuel selector, which resulted in fuel starvation, and his improper emergency procedure for restarting the engine. A factor related to the accident was: the pilot's lack of experience in this make and…Oct 24, 1993 · N5005C · Substantial damage NTSB OAK79FXQ28Accident · No injuriesClosedNavion NAV-4 · Reno, NVJul 29, 1979 · N8880H · Substantial damage NTSB OAK76AP038Accident · 3 fatalClosedBeech 35 · Incline Vlg, NVDec 23, 1975 · N379Z · Destroyed NTSB OAK75DXQ46Accident · Minor injuriesClosedBeech 35 · Elko, NVJun 8, 1975 · N2965V · Substantial damage NTSB OAK73DVW17Accident · Minor injuriesClosedBeech C35 · Adaven, NVFeb 21, 1973 · N686D · Substantial damage NTSB OAK71DXQ33Accident · No injuriesClosedBeech 35 · Gerlach, NVApr 4, 1971 · N694B · Substantial damage NTSB OAK68D0142Accident · No injuriesClosedBeech B35 · Elko, NVOct 12, 1967 · N5208C · Substantial damage NTSB OAK68D0146Accident · No injuriesClosedNavion A · Gerlach, NVMay 8, 1967 · N4214K · Substantial damage NTSB OAK67D0261Accident · No injuriesClosedBeech 35 · Las Vegas, NVMar 12, 1967 · N472B · Substantial damage NTSB OAK67F0286Accident · No injuriesClosedNavion L-17 · Carson City, NVFeb 11, 1967 · N7728C · Substantial damage NTSB UNK65X0201Accident · No injuriesClosedBeechcraft C35 · Ash Meadows, NVOct 8, 1964 · N767D · Substantial damage