NTSB investigations: Continental O-470 series, TX
15 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 2 |
| 1989 | 3 |
| 1994 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 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 ('17026')
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\" = 353))
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 ('17026')
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" = 353))
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 DFW07CA112Accident · No injuriesData collectionFinal reportCessna 180 · Austin, TXThe loss of engine power as result of carburetor icing. Contributing factors were the lack of suitable terrain for the forced landing and the weather conditions conducive to carburetor icing.NTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.NTSB FTW02LA218Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Mc Allen, TXThe pilot's failure to refuel the airplane resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.NTSB FTW94LA309Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Denton, TXThe fuel starvation induced power loss due to the pilot's failure to maintain an adequate amount of fuel. Factors which contributed were: the lack of suitable terrain for the forced landing, and the pilot's evasive maneuver.NTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.NTSB FTW89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Temple, TXImproper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.NTSB FTW89LA018Accident · No injuriesLimited investigationFinal reportCessna 182B · El Paso, TXThe pilot said he thought he had enough fuel to keep the airplane airborne for 6 hours but the left tank ran dry in 4.0 hours and the right tank went dry at 4.1 hours. The landing was on a ranch airport but was not on a runway and the forced landing was a…NTSB FTW88LA059Accident · No injuriesLimited investigationFinal reportCessna 182P · Weatherford, TXA used eng had just been installed in the acft and the owner and mech were performing a functional test flt. Shortly after takeoff at about 300 ft AGL, the eng lost power. The plt pumped the throttle and the eng restarted but immediately quit again and would…NTSB FTW85LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Wichita Falls, TXPlt intentionally ran the rt fuel tank empty and switched to the left tank which was 1/2 to 3/4 full on takeoff. Plt maintained a left side slip during the landing apch to compensate for x-wind conditions. Plt stated, at 400 ft AGL he noticed a pwr loss.…NTSB FTW84LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Clarksville, TXThe acrt crashed into trees during a forced landing when the engine lost power during takeoff climb after a power reduction. The plt said he was too low to maneuver so he landed straight ahead into the trees. The plt suspected carburetor icing. The…NTSB FTW83LA296Accident · No injuriesLimited investigationFinal reportCessna 182B · Lufkin, TXWhile en route, the eng began surging. All instruments had normal indications, except the manifold pressure & tachometer were varying as the eng surged. The acft began losing alt, so the plt elected to land on a highway. He landed in front of several cars,…