NTSB investigations: Continental O-470 series, 1996
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
| 1982 | 15 |
|---|---|
| 1983 | 15 |
| 1984 | 11 |
| 1985 | 14 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 13 |
| 1989 | 11 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 11 |
| 1995 | 6 |
| 1996 | 12 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 8 |
| 2000 | 2 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 10 |
| 2006 | 6 |
| 2007 | 14 |
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 year(c.\"eventDate\") = 1996
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 year(c."eventDate") = 1996
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 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 ANC97TA016Accident · No injuriesFinal reportCessna 180 · St Mary'S, AKthe pilot's improper use of carburetor heat, and subsequent loss of engine power. Factors associated with the accident were the presence of ice crystals in the atmosphere, and unsuitable terrain for a forced landing.NTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.NTSB SEA97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pocatello, IDinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Soft terrain at the emergency landing site was a related factor.NTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.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 ANC96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fuel starvation caused by the unporting of the right fuel tank, and the pilot's inadequate preflight by not dipping the fuel tank to ensure sufficient fuel quantity to prevent the unporting.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 CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.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 ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.