NTSB investigations: Continental I0-470 series, 1978
64 cases on aircraft whose registry engine model is Continental I0-470 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\") = 1978
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027'))
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") = 1978
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027'))
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 OAK78DXQ17Accident · No injuriesClosedCessna 205 · Mammoth Lakes, CANTSB MIA78FLA25Accident · No injuriesClosedCessna 310N · Jacksonville, FLNTSB LAX78FA039Accident · 4 fatalClosedBeech 95-B55 · Bear Valy Sprg, CANTSB CHI78DET19Accident · No injuriesClosedCessna 310Q · Fort Wayne, INNTSB MKC78FCG17Accident · No injuriesClosedCessna 210 · Rushville, MONTSB CHI78FEI16Accident · No injuriesClosedCessna 310D · Carrollton, OHNTSB NYC78FNC17Accident · No injuriesClosedCessna 31OJ · Bangor, MENTSB NYC78FGT05Accident · No injuriesClosedCessna 310J · Lititz, PANTSB MKC78FCG16Accident · No injuriesClosedCessna 310 · Bonner Springs, KSNTSB FTW78FPG16Accident · Serious injuriesClosedCessna 310Q · Fort Smith, ARNTSB MIA78FA039Accident · 1 fatalClosedCessna 310 · St Petersburg, FLNTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYNTSB MKC78FER22Accident · No injuriesClosedCessna 310C · Blaine, MNNTSB MKC78FCA11Accident · Serious injuriesClosedBeech M35 · West Plains, MO