NTSB investigations: Continental TSI0-470-B, CO

9 cases on aircraft whose registry engine model is Continental TSI0-470-B. 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

19662026

NTSB investigations: Continental TSI0-470-B, CO per year, 1966–2026: 9 cases
1966	1
1969	1
1971	1
1973	1
1978	1
1995	1
1996	1
2000	1
2001	1

Where

Open the map

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" = 'CO' 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 ('17029')) 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\" = 'CO' 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 ('17029'))
  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" = 'CO' 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 ('17029'))
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 DEN01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 320 · Falcon, COthe pilot's failure to abort the takeoff following a loss of right engine power. A factor was the loss of right engine power for undetermined reasons.Aug 7, 2001 · N3338P · Destroyed NTSB DEN01LA025Accident · No injuriesLimited investigationFinal reportCessna 320C · Englewood, COthe failure of the nose landing gear to fully extend due to a bent extension rod.Nov 30, 2000 · N3043T · Substantial damage NTSB FTW97LA020Accident · No injuriesLimited investigationFinal reportCessna 320A · Longmont, COThe partial failure of the fuel control servo, causing an excessive flow/output of fuel to, and flooding of, the right engine.Oct 18, 1996 · N430N · Substantial damage NTSB FTW95LA372Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gunnison, COFuel exhaustion induced power loss due to the pilot's failure to refuel. A factor was his disorientation.Aug 23, 1995 · N5720X · Substantial damage NTSB DEN78FTE81Accident · No injuriesClosedCessna 320 · Montrose, COJul 30, 1978 · N5735X · Substantial damage NTSB DEN73FTE85Accident · No injuriesClosedCessna 320C · Boulder, COJun 11, 1973 · N543M · Substantial damage NTSB DEN71FXD50Accident · No injuriesClosedCessna 320C · Denver, COFeb 11, 1971 · N3012T · Substantial damage NTSB DEN69D0186Accident · No injuriesClosedCessna 320B · Aspen, COJan 30, 1969 · N5705X · Substantial damage NTSB DEN67D0087Accident · No injuriesClosedCessna 320B · Haswell, COSep 4, 1966 · N986J · Substantial damage