Fatal NTSB investigations: Continental O-470 series
12 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 | 3 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 ATL06LA069Accident · 1 fatalLimited investigationFinal reportCessna 182B · Gainesville, GAThe pilots improper preflight planning and preparation which resulted in a loss of engine power due to fuel exhaustion.NTSB IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.NTSB ATL04FA069Accident · 1 fatalField investigationFinal reportCessna 182A · Traphill, NCThe loss of engine power due to carburetor ice. Contributing factors were conditions conducive for carburetor icing.NTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.NTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB SEA86FA041Accident · 1 fatalField investigationFinal reportCessna 182 · Juneau, AKPilot requested clearance to return to airport after takeoff due to eng power loss. Clearance was given by ATC. Pilot made rt turn from about 100 ft alt. Acft crashed about 1500 foot south of rwy. No shoulder harnesses installed. Pax survived. Ice found on…NTSB LAX86FA039Accident · 1 fatalField investigationFinal reportCessna 182P · Cottonwood, AZWitnesses saw the plt depart with frost covering the acft & without either a runup or warmup. The witnesses reported that the plt 'scraped the frost from a small square directly in front of him on the windshield' just prior to takeoff. Temp & dew point were…NTSB ANC85FA078Accident · 3 fatalField investigationFinal reportCessna 180H · Anchorage, AKThe acft ran out of fuel after the plt extended his original flt plan route to circumnavigate areas of poor weather. The acft was over water when fuel exhaustion occurred and the acft was ditched under unfavorable conditions.NTSB FTW84FA103Accident · 1 fatalField investigationFinal reportBeech H35 · Taos, NMThe plt stated that a new fuel system had just recently been installed in miami, FL & he forgot about the new system while switching tanks & accidently turned it to the off position. When the eng quit he realized what he had done & switched back to a full…NTSB LAX83FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Auburn, CAPrior to this flt, the acft had not been flown for two months or refueled in five months. During that period, it had been exposed to unusually heavy amounts of rainfall. An annual inspection had been completed on 1/12/82 & 77 hrs had been flown since that…NTSB ATL83FA095Accident · 1 fatalField investigationFinal reportCessna 182L · Weyers Cave, VAThe acft crashed after takeoff when the engine lost power. The acft had not been flown for several months. An instructorwas invited on the extended cross-country to help the pilot who also had not flown for some time. During the pre-flight a considerable…