Skip to content

NTSB investigations: Continental I0-470 series, ID

26 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'ID' 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

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 c.\"eventStateOrRegion\" = 'ID' 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 c."eventStateOrRegion" = 'ID' 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

Run 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 WPR24LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310 · Hayden, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control and subsequent stall during a precautionary landing. Contributing to the accident was the improper maintenance…Nov 13, 2023 · N86H · Substantial damage NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.Aug 27, 2022 · N305SU · Substantial damage NTSB GAA17CA245Accident · No injuriesData collectionFinal reportCessna 185 · Marsing, IDThe pilot’s improper landing flare, which resulted in a bounced landing, the failure of the right main landing gear wheel, and a ground loop.Apr 23, 2017 · N4017Y · Substantial damage NTSB WPR13CA193Accident · No injuriesData collectionFinal reportCessna 210B · Caldwell, IDThe pilot’s failure to lower the landing gear, which resulted in a gear-up hard landing.Apr 15, 2013 · N9685X · Substantial damage NTSB SEA02FA083Accident · Serious injuriesField investigationFinal reportGrumman G-44 · Boise, IDA blocked fuel line that resulted in fuel starvation to the engine and the pilot's failure to follow emergency procedures. A contamination of metal flakes on the fuel filter, and an inadequate annual inspection were factors.May 16, 2002 · N700BL · Substantial damage NTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.Sep 26, 2001 · N224H · Substantial damage NTSB SEA99LA153Accident · No injuriesLimited investigationFinal reportCessna 210B · Dixie, IDInadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.Sep 4, 1999 · N9740X · Substantial damage NTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.Nov 1, 1994 · N4801U · Substantial damage NTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.May 23, 1993 · N4080Y · Substantial damage NTSB SEA88LA145Accident · No injuriesLimited investigationFinal reportBeech K-35 · Halley, IDEngine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left…Aug 7, 1988 · N3PH · Substantial damage NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…Aug 4, 1987 · N8883R · Substantial damage NTSB SEA86LA196Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stibnite, IDThe pilot executed a steep, reduced power descent into the destination airstrip. He then reported that when he attempted to reduce the rate of descent with a power application, the engine did not respond. There was no evidence of any mechanical malfunction…Aug 7, 1986 · N7459E · Destroyed NTSB SEA80DYA10Accident · No injuriesClosedCessna 185D · Challis, IDMar 8, 1980 · N5895T · Substantial damage NTSB SEA80FA010Accident · 1 fatalClosedCessna 210 · Malad City, IDDec 7, 1979 · N9524T · Destroyed NTSB SEA79FYP41Accident · No injuriesClosedBeech 95-B55 · Sandpoint, IDAug 15, 1979 · N6220V · Substantial damage NTSB SEA79DYP36Accident · No injuriesClosedCessna 185 · Slate Creek, IDJul 16, 1979 · N9899X · Substantial damage NTSB SEA79DYA13Accident · Minor injuriesClosedCessna 180 · Driggs, IDMay 25, 1979 · N224H · Substantial damage NTSB SEA74DYA15Accident · No injuriesClosedCessna 210 · Bellevue, IDNov 4, 1973 · N9507X · Substantial damage NTSB SEA73DYA09Accident · Minor injuriesClosedCessna 205 · Blackfoot, IDSep 4, 1972 · N1843Z · Substantial damage NTSB SEA72FYA18Accident · Minor injuriesClosedCessna 185 · American Falls, IDNov 2, 1971 · N5895T · Destroyed NTSB SEA71AS017Accident · 2 fatalClosedCessna 210 · Spencer, IDSep 20, 1970 · N9628T · Destroyed NTSB SEA69A0024Accident · 1 fatalClosedCessna 310C · Burley, IDOct 17, 1968 · N1761H · Substantial damage NTSB SEA67D0358Accident · No injuriesClosedCessna 185 · Gooding, IDJun 18, 1967 · N9862X · Substantial damage NTSB SEA66D0243Accident · No injuriesClosedBeech K35 · Blackfoot, IDMar 17, 1966 · N6039E · Substantial damage NTSB SEA65F0023Accident · No injuriesClosedBeech K35 · Boise, IDApr 2, 1965 · N6034E · Substantial damage NTSB UNK65X0900Accident · No injuriesClosedBeechcraft B33 · Arco, IDDec 2, 1964 · N8631M · Substantial damage