Ongoing NTSB investigations: Continental O-470 series
4 cases on aircraft whose registry engine model is Continental O-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 ('17026')
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 ('17026')
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 ERA26LA197Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Lancaster, OHOn May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ANC25LA063Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182G · Kona, HIOn July 3, 2025, about 0657 Hawaii-Aleutian standard time, a Cessna 182G airplane, N3261S, was substantially damaged when it was involved in an accident near Kona, Hawaii. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182J · Kooskia, IDOn May 31, 2025, about 0930 Pacific daylight time, a Cessna 182J, N3463F, was substantially damaged when it was involved in an accident near Kooskia, Idaho. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA133Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182L · Erie, NVOn April 13, 2025, about 0850 Pacific daylight time, a Cessna 182L, N182VE, was substantially damaged when it was involved in an accident near Erie, Nevada. The pilot and two passengers were uninjured, and one passenger sustained minor injuries. The airplane…