NTSB investigations: Continental TSIO-520 series, 1987
5 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 4 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 1 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 2 |
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\") = 1987
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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") = 1987
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…