NTSB investigations: Continental I0-470 series, ND
10 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 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 2018 | 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 c.\"eventStateOrRegion\" = 'ND' 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" = 'ND' 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 CEN18LA354Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bowman, NDThe loss of engine power due to fuel starvation.NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…NTSB DEN85LA024Accident · No injuriesLimited investigationFinal reportCessna 185C · Williston, NDThe acft collided with a bridge during an aborted takeoff after failing to get airborne. The plt aborted the takeoff butthe acft failed to stop in time to avoid a collision with a railroad bridge abutment made of concrete. The plt stated that the acft had…NTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…NTSB MKC69F0334Accident · No injuriesClosedCessna 310H · Bowman, NDNTSB MKC68F0456Accident · No injuriesClosedCessna 310H · Minot, NDNTSB MKC67A0046Accident · No injuriesClosedCessna 205 · Minot, NDNTSB MKC67F0299Accident · No injuriesClosedBeech J35 · Grand Forks, NDNTSB UNK64X3069Accident · No injuriesClosedBeech K35 · Bismark, ND