NTSB investigations: Continental TSIO-520 series, 1997
6 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 7 |
| 1991 | 9 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 10 |
| 1997 | 6 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 5 |
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\") = 1997
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\" = 353))
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") = 1997
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" = 353))
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 CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.NTSB MIA98LA019Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe pilot's improper management of fuel resulting in a total loss of engine power on both engines due to fuel exhaustion.NTSB IAD98LA009Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Smoketown, PAThe pilot in command's (CFI) improper management of the fuel supply, which resulted in fuel exhaustion of the selected tank and the subsequent loss of engine power.NTSB SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…NTSB FTW97LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Durango, COthe pilot's improper planning/decision, and failure to ensure there was sufficient fuel aboard for the flight, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a successful…NTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.