NTSB investigations: Continental E185 series, 1966
76 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, newest first
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 year(c.\"eventDate\") = 1966
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 year(c."eventDate") = 1966
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 LAX67D0024Accident · No injuriesClosedNavion B · Buckeye, AZNTSB OAK66D0303Accident · No injuriesClosedBeech D35 · Mendota, CANTSB CHI66F0723Accident · Minor injuriesClosedBeech 35 · Cincinnati, OHNTSB SEA67F0033Accident · No injuriesClosedBeech C35 · Corvallis, ORNTSB FTW67F0227Accident · No injuriesClosedBeech 35 · Fort Worth, TXNTSB LAX66A0086Accident · 1 fatalClosedBeech 35 · ZNTSB LAX66D0360Accident · No injuriesClosedBeech B35 · Colton, CANTSB MKC66D0529Accident · No injuriesClosedBeech D35 · Minneapolis, MNNTSB FTW66D0633Accident · No injuriesClosedBeech C35 · Sparkman, ARNTSB CHI66F0695Accident · No injuriesClosedBeech 35 · Eaton, MINTSB FTW66D0617Accident · No injuriesClosedMavion A · Jonesboro, ARNTSB DEN66F0292Accident · No injuriesClosedBeech 35 · Texico, NMNTSB OAK66F0232Accident · No injuriesClosedBeech 35 · Coalinga, CANTSB ANC66D0101Accident · No injuriesClosedBeech C35 · Wasilla, AKNTSB CHI66D0676Accident · No injuriesClosedBeech A35 · Crystal Lake, ILNTSB LAX66D0332Accident · No injuriesClosedBeech 35 · Cantil, CANTSB MKC67D0078Accident · No injuriesClosedBeech 35 · Anthony, KSNTSB NYC66D0540Accident · No injuriesClosedCessna 150 · Islip, NYNTSB FTW66A0097Accident · 2 fatalClosedBeech C35 · Brownsville (Gulf of Mexico)NTSB LAX66D0289Accident · No injuriesClosedBeech 35 · El Monte, CANTSB FTW66F0502Accident · No injuriesClosedBeechcraft 35 · Grand Prairie, TXNTSB SEA66F0208Accident · No injuriesClosedBeechcraft C35 · Newport, WANTSB CHI66F0544Accident · No injuriesClosedBeechcraft C35 · Kankakee, ILNTSB MKC66F0395Accident · No injuriesClosedBeech 35 · Salinga, KSNTSB MIA66F0397Accident · No injuriesClosedNavion A · Montgomery, ALNTSB CHI66D0525Accident · No injuriesClosedBeechcraft A35 · Cynthiana, KY