NTSB investigations: Continental IO-520 series, 1979
149 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\") = 1979
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") = 1979
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 DEN79FTE76Accident · No injuriesClosedBellanca 17-30 · Colorado Sprng, CONTSB ANC79DAH12Accident · No injuriesClosedCessna 185 · Sheldons Point, AKNTSB MKC79DTK24Accident · No injuriesClosedCessna 188B · Ashton, SDNTSB NYC79IA075Incident · No injuriesClosedLear Jet 35 · Newark, NJNTSB LAX79DUK11Accident · No injuriesClosedBeech E55 · Mesa, AZNTSB NYC79FNC46Accident · Minor injuriesClosedBellanca 17-30 · Panton, VTNTSB MIA79FKG61Accident · No injuriesClosedCessna 188T · Albany, GANTSB LAX79FVA55Accident · Serious injuriesClosedCessna 188 · Modesto, CANTSB ANC79FA076Accident · 1 fatalClosedCessna 207A · Nikishki, AKNTSB LAX79DXQ31Accident · Minor injuriesClosedCessna 206 · Fallon, NVNTSB DEN79FA053Accident · No injuriesClosedCessna TU206 · Ft Collins, CONTSB MKC79FTG13Accident · No injuriesClosedBeech V35 · Bismarck, NDNTSB NYC79DFA28Accident · No injuriesClosedCessna 185 · Durham, NYNTSB CHI79FEI35Accident · No injuriesClosedBeech 95-C55 · Cleveland, OHNTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VINTSB SEA79FYA20Accident · No injuriesClosedCessna 188 · Nyssa, ORNTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LANTSB CHI79DEC38Accident · No injuriesClosedBeech D-55 · Troy, MINTSB CHI79FEK18Accident · Minor injuriesClosedCessna A188B · Alger, OHNTSB ANC79DAG62Accident · No injuriesClosedCessna 185F · Port Allsworth, AKNTSB MKC79DCJ26Accident · No injuriesClosedCessna 188A · Bassett, NENTSB MKC79DCJ29Accident · No injuriesClosedCessna A188B · Hartington, NENTSB ANC79DAG59Accident · No injuriesClosedCessna U206 · Palmer, AKNTSB ANC79DAG76Accident · No injuriesClosedCessna 185E · Soldotna, AKNTSB MIA79FLD73Accident · No injuriesClosedBeech B-55 · Howey, FLNTSB IAD79DKW16Accident · No injuriesClosedCessna A185 · Elizabethton, TNNTSB LAX79FUM18Accident · No injuriesClosedCessna 210J · Carlsbad, CANTSB ANC79FA064Accident · Minor injuriesClosedCessna U206F · Kotlik, AKNTSB ANC79DA062Accident · No injuriesClosedCessna U206 · Emmonak, AKNTSB SEA79DYM44Accident · Minor injuriesClosedCessna 185 · Madras, ORNTSB OAK79DV960Accident · No injuriesClosedBellanca 17-30A · Fall River Mil, CANTSB FTW79FA089Accident · 2 fatalClosedBeech V35B · Pampa, TXNTSB IAD79FID20Accident · No injuriesClosedBeech 58 · Keysville, VANTSB ANC79FA060Accident · No injuriesClosedCessna 207 · Platinum, AKNTSB MIA79FKQ12Accident · No injuriesClosedCessna 188 · Bentonia, MSNTSB OAK79DVA45Accident · Minor injuriesClosedCessna 188B · Hanford, CANTSB SEA79FYK16Accident · No injuriesClosedBeech A36 · Sunriver, ORNTSB MKC79DER44Accident · No injuriesClosedCessna 188 · Gully, MNNTSB OAK79DVG46Accident · No injuriesClosedBeech A-36 · Yuba, CANTSB OAK79FA032Accident · 3 fatalClosedBeech F33A · Orleans, CANTSB FTW79DPJ21Accident · No injuriesClosedCessna A188B · Cushing, OKNTSB MIA79DLD71Accident · No injuriesClosedCessna 188B · Bushnell, FLNTSB FTW79FRG36Accident · 1 fatalClosedCessna A188B · Falfurrias, TXNTSB FTW79DA081Accident · Minor injuriesClosedCessna 185F · Morgan City, LANTSB MIA79DKJ41Accident · No injuriesClosedBeech A36 · Harvest, ALNTSB LAX79FUJ74Accident · No injuriesClosedCessna 207 · Show Low, AZNTSB LAX79FA052Accident · 2 fatalClosedCessna 320E · Tucson, AZNTSB MKC79FCQ21Accident · No injuriesClosedCessna A188B · Minneapolis, KSNTSB MIA79DA105Accident · No injuriesClosedCessna 185 · Jamaica, WNNTSB CHI79DEE56Accident · No injuriesClosedCessna P206 · Park Forrest, IL