NTSB investigations: Continental I0-470 series, TX
9 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “Loss of engine power”. 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
| 1985 | 1 |
|---|---|
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 2 |
Where
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.\"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 ('17027')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 ('17027')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.NTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.NTSB FTW96LA093Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Houston, TXa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW85LA299Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Alpine, TXThe plt experienced a partial pwr loss when about 50 ft above the rwy, just after liftoff. The acft was about 300 ft down the rwy with some rwy still remaining. He landed the acft but was unable to stop until the acft had run through the perimeter fence. It…