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

19822026
NTSB investigations: Continental TSIO-520 series, 1999 per year, 1982–2026: 143 cases
19826
19838
19848
198510
19864
19878
19888
19892
19907
19919
19924
19934
19945
19952
199610
19976
19982
19997
20003
20013
20022
20035
20047
20053
20065
20075

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.

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.Sep 5, 1999 · N999KM · Substantial damageNTSB 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.Jun 25, 1999 · N8728Q · Substantial damageNTSB 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.Jun 3, 1999 · N1273G · Substantial damageNTSB 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.May 8, 1999 · N3303S · Substantial damageNTSB 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…Apr 30, 1999 · N59235 · DestroyedNTSB 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.Apr 25, 1999 · N36MN · Substantial damageNTSB 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.Apr 20, 1999 · N744MA · Substantial damage