NTSB investigations: Continental O-470 series, 1998
12 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 20 |
|---|---|
| 1983 | 21 |
| 1984 | 11 |
| 1985 | 15 |
| 1986 | 19 |
| 1987 | 15 |
| 1988 | 14 |
| 1989 | 11 |
| 1990 | 17 |
| 1991 | 13 |
| 1992 | 11 |
| 1993 | 13 |
| 1994 | 11 |
| 1995 | 14 |
| 1996 | 9 |
| 1997 | 12 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 13 |
| 2001 | 7 |
| 2002 | 13 |
| 2003 | 12 |
| 2004 | 14 |
| 2005 | 11 |
| 2006 | 15 |
| 2007 | 12 |
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\") = 1998
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\" = 260))
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") = 1998
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" = 260))
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 CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB ANC98LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadvertent activation of the brakes during the landing roll resulting in a ground loop/swerve.NTSB FTW98LA373Accident · No injuriesLimited investigationFinal reportCessna 182L · St. George, UTThe pilot's failure to maintain control of the airplane. Factors were excessive airspeed and allowing the airplane to porpoise with subsequent loss of directional control.NTSB SEA98LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Anaconda, MTA ground-loop resulting from the pilot's inadequate remedial action while attempting to correct for an inadvertent loss of directional control during the landing roll. Factors include the loss of directional control and attempting to land with a tailwind.NTSB FTW98LA343Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Watkins, COThe pilot's loss of control during taxi due to excessive taxi speed.NTSB SEA98LA114Accident · No injuriesLimited investigationFinal reportCessna 182P · Chico Hot Spgs., MTThe pilot's inadequate remedial action while attempting to compensate for a change in crosswind velocity. Factors include a crosswind, hills near the runway, and high vegetation (weeds) near the runway.NTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.NTSB MIA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180D · Natchez, MSThe pilot's improper use of brakes on landing rollout. The tailwind was a factor.NTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB ANC98LA024Accident · No injuriesLimited investigationFinal reportCessna 180H · Tatitna, AKThe pilot's selection of unsuitable terrain for landing. A factor was the snow machine ruts creating a rough landing surface.NTSB FTW98LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Keeline, WYfailure of the pilot to maintain directional control of the airplane during the landing roll. Factors relating to the accident included: a snow covered/icy/muddy area on the runway, and the proximity of a snowbank to the runway.