NTSB investigations: Continental IO-520 series, 1973
88 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\") = 1973
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") = 1973
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 LAX73FUJ84Accident · Serious injuriesClosedBeech G33 · Flagstaff, AZNTSB MIA73FLG48Accident · No injuriesClosedCessna U206C · Little River, SCNTSB FTW73FPG54Accident · No injuriesClosedCessna A188B · Tryonza, ARNTSB FTW73FRG87Accident · No injuriesClosedCessna T210F · Corpus Chrsti, TXNTSB LAX73FUG54Accident · Minor injuriesClosedCessna 185E · Big Bear Cy, CANTSB FTW73FPM11Accident · No injuriesClosedCessna A188 · Tulsa, OKNTSB CHI73FEE58Accident · No injuriesClosedCessna 421 · Crystal Lake, ILNTSB IAD73FKW26Accident · No injuriesClosedCessna 210 · Athens, TNNTSB NYC73DFJ24Accident · Minor injuriesClosedCessna A185E · Penn Yan, NYNTSB DEN73DTC25Accident · No injuriesClosedCessna T210J · Riverton, WYNTSB MKC73DCQ28Accident · Minor injuriesClosedCessna 188 · Mccune, KSNTSB CHI73FEE54Accident · No injuriesClosedBellanca 17-30A · Polo, ILNTSB NYC73FGM29Accident · No injuriesClosedBellanca 17-30A · Freidens, PANTSB DEN73FTE71Accident · No injuriesClosedBeech V35 · Walsenburg, CONTSB DEN73FTE72Accident · No injuriesClosedBeech V35TC · Delta, CONTSB NYC73DHD35Accident · No injuriesClosedBellanca 14-19 · N.Philadelphia, PANTSB MIA73FLG42Accident · No injuriesClosedBeech 95-C55 · Orangeburg, SCNTSB DEN73DTM25Accident · No injuriesClosedBeech V35-TC · Hanksville, UTNTSB ANC73DAG81Accident · No injuriesClosedCessna 185E · Kenai, AKNTSB DEN73AD044Accident · Serious injuriesClosedCessna U206 · Las Cruces, NMNTSB IAD73FLQ23Accident · No injuriesClosedCessna 210 · Henderson, KYNTSB FTW73FPJ11Accident · No injuriesClosedBeech 95-C55 · Norman, OKNTSB IAD73FLJ21Accident · No injuriesClosedCessna 401A · Morrisville, NCNTSB ANC73DAG77Accident · No injuriesClosedCessna 185E · Glennallen, AKNTSB CHI73AEE46Accident · Minor injuriesClosedBeech V35 · Mount Morris, ILNTSB MIA73FKQ24Accident · No injuriesClosedCessna A188 · Lexington, MSNTSB DEN73DTE60Accident · Minor injuriesClosedBeech A36 · Glenwood Spg, CONTSB LAX73DUG39Accident · Minor injuriesClosedBellanca 17-30A · Mountn Pass, CANTSB MIA73FLD55Accident · No injuriesClosedCessna 172E · Sebring, FLNTSB LAX73DUG36Accident · No injuriesClosedCessna 210D · Big Bear, CANTSB CHI73DEE44Accident · No injuriesClosedCessna P206 · Dixon, ILNTSB LAX73AL037Accident · Serious injuriesClosedCessna U206C · Kayenta, AZNTSB OAK73DXQ21Accident · No injuriesClosedCessna P206 · Susanville, CANTSB FTW73DQG28Accident · No injuriesClosedBellanca 17-30 · Matador, TXNTSB NYC73DFJ18Accident · Serious injuriesClosedBellanca 17-30 · Dunkirk, NYNTSB FTW73FPG36Accident · No injuriesClosedCessna U206B · Hermitage, ARNTSB MKC73FER36Accident · Serious injuriesClosedCessna A185E · Warroad, MNNTSB FTW73DRG42Accident · No injuriesClosedCessna 210L · Muzquiz, Mexico