NTSB investigations: Continental O-470 series, 2002
13 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
Open the mapLatest 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\") = 2002
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") = 2002
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 NYC02LA150Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Ravenna, OHThe pilot's loss of directional control for undetermined reasons.NTSB CHI02LA207Accident · No injuriesLimited investigationFinal reportCessna C180A · Ogallala, NEThe pilot's failure to maintain directional control of the aircraft. The open window diverting the pilot's attention was a contributing factor.NTSB SEA02LA118Accident · No injuriesLimited investigationFinal reportCessna 182 E · Sweetgrass, MTThe pilot's failure to adequately compensate for wind conditions after encountering a crosswind gust during the landing roll. Factors include gusty crosswinds, and a fence in the vicinity of the runway.NTSB ATL02LA157Accident · No injuriesLimited investigationFinal reportCessna 182M · Brunswick, GAThe pilot's failure to maintain directional control during landing roll, which resulted in an on-ground collision with a runway sign. A factor was the pilot's inadvertent application of the right brake.NTSB SEA02LA105Accident · No injuriesLimited investigationFinal reportCessna 180K · Idaho Falls, IDThe pilot's inadequate compensation for wind conditions during the landing roll. A crosswind was a factor.NTSB ATL02LA126Accident · No injuriesLimited investigationFinal reportCessna 180 · Jacksonville, FLThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop. A factor related to the accident was the certified flight instructors inadequate supervision of the training flight.NTSB SEA02LA104Accident · No injuriesLimited investigationFinal reportCessna 180K · Helena, MTBinding brakes for undetermined reasons and the pilot's failure to maintain directional control during an aborted takeoff.NTSB LAX02LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbia, CAThe pilot encountered a crosswind gust during the landing roll, resulting in a ground loop and nose over.NTSB ANC02LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the left wing striking the ground. A factor contributing to the accident was the grass-covered runway surface.NTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB LAX02LA127Accident · No injuriesLimited investigationFinal reportCessna 180J · Saline Valley, CAThe pilot's loss of directional control during landing rollout after encountering a water erosion rut in the runway's uneven surface.NTSB LAX02LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Jean, NVThe pilot's failure to maintain directional control.