NTSB investigations: Continental O-470 series, 2004
7 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - in flight”. 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 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 3 |
| 1985 | 12 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 12 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 9 |
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\") = 2004
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\" = 250))
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") = 2004
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" = 250))
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 NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB ANC04LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.NTSB NYC04FA137Accident · 1 fatalField investigationFinal reportCessna 182C · Kutztown, PAThe towplane pilot's failure to maintain a climb while towing a glider for undetermined reasons, which resulted in the early release of the glider and the tow plane's subsequent impact with trees.NTSB ATL04LA103Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Sale Creek, TNThe pilot's failure to maintain airspeed, and the pilot's alcohol impairment that resulted in an inadvertent stall and collision with the ground.NTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.NTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.