NTSB investigations: Continental O-470 series, 1982, AL
2 cases on aircraft whose registry engine model is Continental O-470 series. 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
| 1964 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 5 |
| 1970 | 5 |
| 1971 | 3 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 5 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 4 |
| 1978 | 4 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2025 | 1 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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'))
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") = 1982
AND c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA'
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'))
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 ATL82DA240Accident · Minor injuriesFinal reportCessna 180 · Grand Bay, ALReportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he…NTSB ATL82DA210Accident · Minor injuriesFinal reportCessna 182 · Mobile, ALThe pilot experienced a power loss during takeoff and made an emergency landing in a soft soybean field. The aircraft nosed over after landing. Water was found in the fuel in the left tank and carburetor. The pilot had also found water inthe left tank during…