NTSB investigations: Continental O-470 series, CA
27 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 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 2 |
| 2002 | 1 |
| 2003 | 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\" = 'CA' 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" = 'CA' 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 LAX07LA216Accident · No injuriesLimited investigationFinal reportCessna 180A · Redding, CAFuel exhaustion due to the pilot's inadequate in-flight planning/decision concerning fuel system management and his failure to refuel while en route.NTSB LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.NTSB LAX06CA244Accident · No injuriesData collectionFinal reportCessna 182D · Santa Clarita, CAA loss of engine power due to fuel exhaustion. The fuel exhaustion was the result of a split O-ring on the right fuel cap, which allowed fuel to siphon out of the right fuel tank during flight.NTSB LAX04LA210Accident · Minor injuriesLimited investigationFinal reportDowner Bellanca 14-19-2 · Lancaster, CAThe pilot's fuel mismanagement by his failure to follow the recommended procedures for operation of the auxiliary fuel tank, which resulted in fuel starvation and loss of engine power during cruise flight.NTSB LAX04FA068Accident · Minor injuriesField investigationFinal reportCessna 182P · Watsonville, CAa loss of engine power due to water contamination of the fuel system and the pilot's inadequate preflight inspection. A contributing factor was the pilot/owner's failure to comply with the appropriate Airworthiness Directive.NTSB LAX02LA077Accident · No injuriesLimited investigationFinal reportBeech T-34B/D-45 · San Simeon, CAthe pilot's inadequate preflight of the airplane in which he failed to close the fuel drain resulting in a fuel leak and fuel exhaustion.NTSB LAX98LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · California City, CAThe pilot's failure to assure that an adequate supply of fuel was available for the flight and his inadequate preflight planning/preparation.NTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.NTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.NTSB LAX97LA190Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lamont, CAthe pilot's failure to maintain adequate fuel for the flight.NTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.NTSB LAX97LA080Accident · No injuriesLimited investigationFinal reportCessna 182P · Fullerton, CAFuel system water contamination due to the failure of both pilots to purge all water from the fuel system prior to departure. Contributing factors were: failure of the mechanic conducting the recent annual inspection to identify and replace a deteriorated…NTSB LAX96LA322Accident · Minor injuriesLimited investigationFinal reportCessna 305A · San Diego, CAFuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.NTSB LAX96LA303Accident · No injuriesLimited investigationFinal reportCessna 182B · Santa Ana, CAImproper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.NTSB LAX96LA241Accident · No injuriesLimited investigationFinal reportCessna 182 · Mendota, CAThe pilot's decision to intentionally shut down the engine; his failure to verify the surface winds during the prolonged orbiting descent over the airport, which resulted in a final approach with a tailwind component; and his misjudging of the aircraft's…NTSB LAX93LA072Accident · No injuriesLimited investigationFinal reportCessna 180K · Fullerton, CAThe airplane's owners (including the pilot) poor maintenance and the pilot's inadequate preflight inspection. Contributing to this accident was the deteriorated overwing fuel caps seals and the tailwind.NTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.NTSB LAX91LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lake Elsinore, CAUndetermined engine power loss. A factor ws the soft terrain.NTSB LAX91LA062Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Imperial, CAFuel exhaustion.NTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.NTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…NTSB LAX86LA173Accident · No injuriesLimited investigationFinal reportCessna 182A · Death Valley, CAThe acft collided with terrain after a loss of pwr 50 yards short of the rwy. The plt stated he used various fuel selector positions while en route. Upon entry into the traffic pattern on a right downwind, the left tank was selected. On final apch the plt…NTSB LAX86FVD05Accident · Serious injuriesFinal reportCessna 182C · Oakland, CAThe acft contacted several vehicles during a forced landing following a loss of pwr shortly after takeoff. Post accident inspection of the acft revealed the carburetor bowl was 1/3 full of water. No other discrepancies were noted which would have resulted in…NTSB LAX85FA128Accident · Serious injuriesField investigationFinal reportCessna 182C · Apple Valley, CAThe acft was observed to enter the left downwind leg at a low alt of about 200 ft AGL. The engine stopped completely, & the plt attempted to land on the runway, but impacted the ground short & to the left of the apch end of the rwy. Wing flaps were found…NTSB LAX85FA084Accident · Serious injuriesField investigationFinal reportCessna 310 · Temecula, CAThe acft experienced a total power loss of the rt eng during takeoff from rancho calif airport & crashed about one half mi northwest. The plt reported that the acft would not climb, nor would it maintain altitude at about 40 ft AGL. He stated that when he…NTSB LAX84LA489Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Lincoln, CAAfter a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear…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…