NTSB investigations: Continental O-470 series, 1982, WV
3 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 3 |
| 1980 | 2 |
| 1982 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2019 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'WV' 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" = 'WV' 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 ATL82DA201Accident · No injuriesFinal reportCessna 182E · Taplin, WVThe pilot stated that the sod runway had just been mowed. During the takeoff roll, the left wheel pant became filled with cut grass and locked the wheel. Subsequently, the aircraft veered to the left. The pilot reported that the left wing contacted low trees…NTSB ATL82DA133Accident · No injuriesFinal reportCessna 182 · Summersville, WVAccording to the pilot, he made his landing approach high and hot. He touched down long and was unable to stop on the remaining runway. While applying brakes, the aircraft veered off the side of the runway. Subsequently, the nose and right main gear failed.NTSB ATL82DA069Accident · Minor injuriesFinal reportCessna 182P · Huntington, WVAccording to the pilot the engine failed after liftoff at about the 3500 foot point down the runway at approximately 300 feet AGL. The runway has 1000 feet of overrun and the aircraft came to rest near the runup area for runway 12. The aircraft had not been…