NTSB investigations: Continental TSIO-520 series, 1994
5 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
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\") = 1994
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") = 1994
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 SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.NTSB NYC94FA067Accident · 1 fatalField investigationFinal reportCessna 414 · Defiance, OHThe pilot's inadequate inflight decision and planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB CHI94LA073Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Olathe, KSthe pilot's failure to follow procedures and directives regarding the positioning of the fuel tank selector to the fullest tank for the landing portion of flight.