NTSB investigations: Continental TSIO-520 series, 2001
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
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 year(c.\"eventDate\") = 2001
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") = 2001
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 DEN02TA011Accident · No injuriesFinal reportCessna 206 · Casper, WYfailure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.NTSB SEA01LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Olympia, WAThe inability of the landing gear to fully extend due to the failure of a hydraulic hose in the nose gear extension system.NTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.NTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.NTSB DEN01LA087Accident · No injuriesLimited investigationFinal reportMooney M20K · Bountiful, UTthe failure of the airplane's electrical system for an undetermined reason, which resulted in the collapse of the left main gear on landing.