NTSB investigations: Continental IO-470 series, TX
4 cases on aircraft whose registry engine model is Continental IO-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
| 1968 | 1 |
|---|---|
| 1985 | 1 |
| 1991 | 1 |
| 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17044'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17044'))
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 CEN26LA190Accident · 1 fatalClass 3 · LimitedPreliminary reportDowner 14-19-3 · Forney, TXOn May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived…NTSB FTW92FA022Accident · 2 fatalField investigationFinal reportCessna 310C · Waller, TXThe loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.NTSB FTW85LA128Accident · No injuriesLimited investigationFinal reportCessna 205 · College Station, TXThe acft veered to the right on touchdown. The plt was unable to regain control before the acft departed the right side of the rwy and nosed over when it entered the soft terrain. No evidence of a nose gear failure was found.NTSB FTW69F0199Accident · No injuriesClosedBell 47G-4A · Portland, TX