Fatal NTSB investigations: Continental I0-470 series, Outside the U.S.
9 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 per year
| 1972 | 1 |
|---|---|
| 1975 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 2004 | 1 |
| 2008 | 1 |
| 2018 | 1 |
| 2022 | 1 |
Latest cases
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 c.\"eventCountry\" <> 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventCountry" <> 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoNTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.NTSB MIA04WA089Accident · 3 fatalForeign investigationCessna 210B · Marsh Harbour, BahamasNTSB LAX95WA165Accident · 2 fatalForeign investigationBeech BE-55 · Laurieton, AustraliaNTSB MIA93WA049Accident · 2 fatalForeign investigationBeech 95-B55B · Walkers Cay, BahamasNTSB LAX26O0011Accident · 5 fatalClosedAero Comdr 500A · Baja Ca Norte, MexicoNTSB MIA75RM074Accident · 1 fatalClosedBeech 95-B55 · Wlkrs Cay, Burkina FasoNTSB OAK73DJY06Accident · 1 fatalClosedCessna 172 · Savannakhet, Laos