NTSB investigations: Continental GTSIO-520-C
14 cases on aircraft whose registry engine model is Continental GTSIO-520-C, 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 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035')
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 NYC03FA001Accident · 1 fatalField investigationFinal reportBeagle B.206 Basset · West Carrollton, OHThe pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…NTSB FTW01LA002Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Andrews, TXThe hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.NTSB FTW00LA019Accident · No injuriesLimited investigationFinal reportCessna TU206A · Jeanerette, LAThe total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.NTSB LAX99FA225Accident · Minor injuriesField investigationFinal reportCessna 402A · Van Nuys, CAThe pilot's inadequate fuel management that resulted in fuel exhaustion and the subsequent collision with vehicles during a forced landing on a city street.NTSB SEA95LA174Accident · No injuriesLimited investigationFinal reportCessna T210K · Bliss, IDThe pilot's failure to properly manage the fuel system to avoid running a tank dry at a low altitude. A factor was the lack of suitable terrain for a forced landing.NTSB BFO91LA013Accident · No injuriesLimited investigationFinal reportCessna 421B · Morganfield, KYLost of power of both engines due to the pilot's mismanagement of the fuel system.NTSB FTW89FA074Accident · 1 fatalField investigationFinal reportCessna 421 · Brownsville, TXThe pilot's improper emergency procedure after lossing power in the right engine, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: fuel starvation of the right engine,…NTSB MKC88LA079Accident · No injuriesLimited investigationFinal reportCessna 310P · Berryville, ARWhile trying out his friend's newly purchased twin, the pilot stated an emergency landing was made due to power loss because of fuel starvation. The PIC said he was negligent because he did not possess a multiengine rating and also did not study the fuel…NTSB MIA88FA144Accident · Serious injuriesField investigationFinal reportBeech A-23 · Fort Myers, FLThe private pilot experienced an engine failure on final approach and executed a forced landing to a wooded area and crashed. The pilot said he had flown about 2.0 hours on the right tank and did not switch to the left tank prior to landing. Another pilot had…NTSB MIA87FA069Accident · 1 fatalField investigationFinal reportCessna T210F · Tallahassee, FLPlt/owner was informed by mechanics that the acft fuel tanks had water contamination on two occurrences prior to test flights. The plt reported he ahd had water contamination and believed the fuel caps were leaking. New caps were ordered to be installed at…NTSB DEN86FA033Accident · Serious injuriesField investigationFinal reportCessna 421B · Franktown, COThe acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an…NTSB MIA84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 411A · Gainsville, FLThe acft crashed while on a ILS approach to the Gainsville, airport. Investigation revealed that the plt had advised approach control that he was 'low on fuel.' After two missed approaches the plt radioed that he was 'out of fuel.' The plt did not have charts…NTSB FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…NTSB FTW82DA261Accident · Minor injuriesFinal reportCessna T310P · Dallas, TXThe aircraft owner, who had not flown for one year, and a flight instructor were on an instructional flight to prepare the owner for a flight review. After flying about one hour, they returned to the airport and began practicing landings. After the second…