NTSB investigations: Continental TSIO-520 series, 1999
7 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\") = 1999
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") = 1999
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 DEN99LA174Accident · No injuriesLimited investigationFinal reportCessna P210N · Santa Fe, NMA non-mechanical total loss of engine power for reasons undetermined. Factors were maneuvering to avoid oncoming vehicles, and the rough and uneven terrain.NTSB LAX99LA231Accident · No injuriesLimited investigationFinal reportCessna TU206F · Saline Valley, CAThe pilot's failure to verify the fuel quantity prior to departure, which led to fuel exhaustion.NTSB NYC99LA128Accident · Serious injuriesLimited investigationFinal reportCessna T310Q · West Laurens, NYthe pilot's impairment due to hypoxia, which resulted in reduced situational awareness and a power loss due to fuel exhaustion.NTSB LAX99LA174Accident · No injuriesLimited investigationFinal reportCessna T303 · San Diego, CAThe pilot-in-command's inaccurate fuel consumption calculations that resulted in fuel exhaustion and the subsequent ditching.NTSB DEN99LA070Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…NTSB LAX99LA164Accident · No injuriesLimited investigationFinal reportBeech 36TC · Lake Elsinore, CAFuel starvation due to the pilot's inadequate preflight inspection procedures and his failure to accurately determine the amount of fuel onboard prior to departure. A factor in the accident was the erratic fuel quantity sensor in the left fuel tank.NTSB MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.