Ongoing NTSB investigations: Continental I0-470 series
4 cases on aircraft whose registry engine model is Continental I0-470 series, where the defining event was Loss of engine power (partial). 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
| 2025 | 3 |
|---|---|
| 2026 | 1 |
Where
Open the mapLatest 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.\"completionStatus\" = 'Ongoing'
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342'))
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."completionStatus" = 'Ongoing'
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '342'))
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 WPR26LA335Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210 · Polson, MTOn September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title…NTSB WPR26FA068Accident · 1 fatalClass 3 · FieldPreliminary reportBeech K35 · Summer Lake, OROn December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal…NTSB ANC25LA077Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210-5 · Yakutat, AKOn July 23, 2025, about 1700 Alaska daylight time, a Cessna 210-5 (205) airplane, N8457Z, was substantially damaged when it was involved in an accident on a remote beach about 50 miles southeast of Yakutat, Alaska. The pilot was uninjured. The airplane was…NTSB ERA25LA269Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech K35 · Sylacauga, ALOn July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…