NTSB investigations: Continental IO-520 series, 1978
168 cases on aircraft whose registry engine model is Continental IO-520 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 ('17032'))
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 ('17032'))
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 MIA78FKJ78Accident · No injuriesClosedBellanca 300 · Pensacola, FLNTSB MIA78DLA48Accident · No injuriesClosedCessna 188B · Colquitt, GANTSB MIA78FKG53Accident · No injuriesClosedCessna 188B · Cordele, GANTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCNTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCNTSB FTW78DRJ28Accident · Minor injuriesClosedCessna 188 · Fondale, LANTSB MKC78DCD41Accident · No injuriesClosedCessna 188B · Yale, IANTSB FTW78DQG43Accident · No injuriesClosedCessna 188 · Muleshoe, TXNTSB MKC78FA059Accident · Serious injuriesClosedCessna 402A · Manhattan, KSNTSB MKC78DCQ35Accident · No injuriesClosedCessna 188 · Sharon Spring, KSNTSB NYC78FNC43Accident · Serious injuriesClosedBeech A-36 · Burlington, VTNTSB MKC78FTK33Accident · No injuriesClosedCessna A188B · Doland, SDNTSB SEA78DYE32Accident · No injuriesClosedCessna 185 · Oak Harbor, WANTSB NYC78DNC40Accident · No injuriesClosedCessna 185 · St Albans, VTNTSB DEN78DTM29Accident · No injuriesClosedCessna 185 · Green River, UTNTSB MKC78DCJ32Accident · No injuriesClosedCessna 188B · Milford, NENTSB MKC78DCJ31Accident · No injuriesClosedCessna 188B · Crete, NENTSB MIA78DKQ23Accident · Minor injuriesClosedCessna 188B · Doddsville, MSNTSB ANC78DA056Accident · No injuriesClosedCessna 185 · Big Delta, AKNTSB ANC78FAA28Accident · Minor injuriesClosedCessna 206 · Unalakleet, AKNTSB OAK78DVA56Accident · No injuriesClosedCessna 188 · Turlock, CANTSB OAK78DXQ35Accident · Minor injuriesClosedBeech A36 · Chester, CANTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WINTSB SEA78FA043Accident · Minor injuriesClosedCessna 207 · Olga, WANTSB IAD78FLQ24Accident · No injuriesClosedCessna 210L · Leitchfield, KYNTSB DEN78FQA39Accident · No injuriesClosedBeech 58 · Albuquerque, NMNTSB ANC78FA046Accident · No injuriesClosedCessna U206 · Anchorage, AKNTSB MKC78FCG47Accident · No injuriesClosedCessna 210 · Oak Grove, MONTSB LAX78DUJ77Accident · No injuriesClosedBellanca 17-30 · Ft Huachuca, AZNTSB FTW78DRD46Accident · Serious injuriesClosedCessna 185 · Venice, LANTSB ANC78FAA27Accident · No injuriesClosedCessna 185 · Unalakleet, AKNTSB MIA78FKG57Accident · No injuriesClosedCessna 188B · Sylvester, GANTSB FTW78DPG56Accident · No injuriesClosedBeech A36 · Searcy, ARNTSB OAK78DVA52Accident · No injuriesClosedCessna 188B · Modesto, CANTSB LAX78DUJ73Accident · No injuriesClosedCessna 185F · Scottsdale, AZNTSB SEA78DYM37Accident · No injuriesClosedCessna 188A · Enterprise, ORNTSB ANC78DAG99Accident · No injuriesClosedCessna 185 · Naknek, AKNTSB MKC78FCG39Accident · Serious injuriesClosedBeech A36 · Olathe, KSNTSB CHI78FEV40Accident · No injuriesClosedCessna A188B · Ramsey, ILNTSB MIA78DLA40Accident · Serious injuriesClosedCessna A188B · Whigham, GANTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSNTSB MKC78FER59Accident · No injuriesClosedCessna 210 · St Paul, MNNTSB OAK78FVD39Accident · No injuriesClosedCessna T210 · Santa Rosa, CANTSB CHI78FET23Accident · No injuriesClosedCessna 185 · Berrien Spgs, MINTSB FTW78FRG50Accident · No injuriesClosedCessna U206C · Austin, TXNTSB DEN78FA044Accident · 1 fatalClosedCessna U206 · Erie, CONTSB CHI78FEM20Accident · No injuriesClosedBellanca 17-30 · Plainwell, MINTSB SEA78FA035Accident · No injuriesClosedCessna U206 · Billings, MTNTSB CHI78DEV38Accident · No injuriesClosedCessna 188 · Ashmore, ILNTSB MIA78FLD50Accident · Serious injuriesClosedBeech V35B · Lake Wales, FL