Major NTSB investigations: Continental TSIO-520 series
8 cases on aircraft whose registry engine model is Continental TSIO-520 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
| 1976 | 1 |
|---|---|
| 1980 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 2003 | 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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
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 MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…NTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB FTW87MA133Accident · 1 fatalMajor investigationFinal reportCessna P210R · Arnett, OKThe flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…NTSB LAX87MA052Accident · 4 fatalMajor investigationFinal reportBeech A36TC · Bakersfield, CAOn an instructional flt, the student plt & instructor (CFI) made an ILS low apch to rwy 30R. Drg a go-arnd (missed apch)a twr ctlr obsvd a 'light trace of smoke' emanating fm the eng exhaust. Shortly thereafter, the acft 'banked hard to the left and appeared…NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…NTSB ATL84MA052Accident · 4 fatalMajor investigationFinal reportBeech 58TC · Knoxville, TNDuring arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…NTSB DEN80AA023Accident · 4 fatalClosedCessna TU206G · Clovis, NMNTSB MIA76AM108Accident · 5 fatalClosedCessna 414 · Brighton, FL