NTSB investigations: Continental O-470 series, 1992
7 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Overrun”. 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 | 7 |
|---|---|
| 1983 | 10 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 7 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
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\") = 1992
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\" = 340))
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") = 1992
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" = 340))
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 DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.NTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.NTSB DEN92FA052Accident · Serious injuriesField investigationFinal reportCessna 182 · Frederick, COThe pilot and operator attempting to operate the aircraft over maximum gross weight.NTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.