NTSB investigations: Continental I0-470 series, 1987, UT
2 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 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 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\") = 1987
AND c.\"eventStateOrRegion\" = 'UT' 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") = 1987
AND c."eventStateOrRegion" = 'UT' 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 DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…NTSB DEN87LA052Accident · No injuriesLimited investigationFinal reportCessna 185C · Cedar City, UTDuring normal descent at seven-thousand ft MSL, acft struck a bird. The left wing tip leading edge incurred a dent twenty-four inches long and twelve inches deep. Directional control became difficult so plt made a precautionary landing on highway I-15, and…