NTSB investigations: Continental O-470 series, 2006
6 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\") = 2006
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") = 2006
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 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 NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.NTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.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 MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.