NTSB investigations: Continental I0-470 series, 1985, CA
4 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 | 16 |
|---|---|
| 1965 | 26 |
| 1966 | 28 |
| 1967 | 21 |
| 1968 | 11 |
| 1969 | 14 |
| 1970 | 16 |
| 1971 | 8 |
| 1972 | 5 |
| 1973 | 6 |
| 1974 | 7 |
| 1975 | 6 |
| 1976 | 4 |
| 1977 | 2 |
| 1978 | 6 |
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 5 |
| 1982 | 6 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 7 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 3 |
| 2025 | 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\") = 1985
AND c.\"eventStateOrRegion\" = 'CA' 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") = 1985
AND c."eventStateOrRegion" = 'CA' 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 LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…NTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…NTSB LAX85LA362Accident · No injuriesLimited investigationFinal reportCessna 210 · Sylmar, CAThe pilot reported that the aircrafts engine experienced mechanical trouble and a forced landing on a freeway was attempted. The aircraft's left wing struck a metal center divider during the landing rollout. The results of an engine oil analysis revealed high…NTSB LAX85LA176Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Paso Robles, CAThe plt pulled the prop through by hand after attempts to start the acft failed. The unoccupied acft started and traveled aprx 200 ft before contacting the left wing of another acft. Inspection revealed the 'p' lead on the left magneto was not grounded. The…