NTSB investigations: Continental O-470 series, 1983, PA
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 | 5 |
| 1966 | 5 |
| 1967 | 5 |
| 1968 | 4 |
| 1969 | 2 |
| 1970 | 6 |
| 1971 | 2 |
| 1972 | 3 |
| 1974 | 3 |
| 1975 | 9 |
| 1976 | 2 |
| 1977 | 5 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
| 2009 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2020 | 2 |
| 2023 | 2 |
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\") = 1983
AND c.\"eventStateOrRegion\" = 'PA' 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") = 1983
AND c."eventStateOrRegion" = 'PA' 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 NYC83FA207Accident · 1 fatalField investigationFinal reportCessna 310Q · Scranton, PAShortly after takeoff the acft ws observed on radar making a left 360 deg turn. The plt did not respond to a call from the controller. A witness heard the plane 'sputtering' & observed it in erratic maneuvers prior to it hitting a house. Post exam revealed…NTSB NYC83LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomasville, PAThe acft nosed over during a forced landing after a power loss. Several weeks prior to this accident the acft made a precautionary landing due to a rough running engine. The acft was examined and 1 gallon of water was found in the fuel lines. The water was…