NTSB investigations: Continental I0-470 series, 1982, PA
3 cases on aircraft whose registry engine model is Continental I0-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 | 4 |
|---|---|
| 1965 | 2 |
| 1967 | 5 |
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 5 |
| 1971 | 3 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1982 | 3 |
| 1987 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 2 |
| 2003 | 3 |
| 2006 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 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\" = '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 ('17027'))
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" = '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 ('17027'))
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 NYC82FHA10Accident · Serious injuriesFinal reportNavion G · Doylestown, PAAt approximately 75-100 ft the eng quit. The acft landed with the gear up & slid off the end of the rwy approximately 200-300 ft. the plt acknowledged taking off with the fuel selector on the empty left tip tank.NTSB NYC82DA084Accident · No injuriesFinal reportBeech 35-33 · Altoona, PAThe pilot stated that before landing, he performed his cockpit duties and put the gear in the down position. However, he lost sight of another aircraft in the traffic pattern and became preoccupied with trying to locate the aircraft. He was also preoccupied…NTSB NYC82DA040Accident · No injuriesFinal reportCessna 310Q · Doylestown, PAWhile descending ice began to accummulate on the windshield and leading edges of the wings. The pilot stated that the windshield was covered with 1/2 to 3/4 inch of ice but he was able to clear a small strip large enough for him to see out. Upon reducing…