NTSB investigations: Continental O-470 series, 2003
7 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\") = 2003
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") = 2003
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 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 SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.NTSB DEN04LA018Accident · No injuriesLimited investigationFinal reportCessna 182A · Albuquerque, NMthe pilot's delayed use of carburetor heat and his inadequate flare resulting in a loss of engine power and a hard landing. Also causal was the inadequate supervision of the flight. Carburetor icing conditions was a contributing factor.NTSB DEN04LA008Accident · No injuriesLimited investigationFinal reportCessna 182R · Lysite, WYthe pilot's fuel mismanagement resulting in the loss of engine power and the subsequent forced landing. A contributing factor was the lack of suitable terrain for a forced landing and the nose over.NTSB ANC03LA103Accident · No injuriesLimited investigationFinal reportCessna 180 · Nenana, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and a forced landing in unsuitable terrain.NTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW03TA087Accident · Serious injuriesFinal reportBeech T-34B · Hammond, LAThe pilot's inadequate inflight planning/decision resulting in fuel exhaustion and the loss of engine power. A contributing factor was the night light conditions.