NTSB investigations: Continental GTSI0-520-F-K, TX
7 cases on aircraft whose registry engine model is Continental GTSI0-520-F-K. 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
| 1972 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 2004 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17031'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17031'))
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 CEN15LA199Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Diboll, TXThe total loss of engine power due to the use of an improper fuel type. Contributing to the accident were the servicing of the airplane with the improper fuel, noncompliance with an airworthiness directive, and the fuel nozzle installed on the fueling truck.NTSB DFW05LA045Accident · No injuriesLimited investigationFinal reportCessna 421C · Henderson, TXThe failure of the nose landing gear trunnion lug. A contributing factor was the non-compliance of the service bulletin by maintenance personnel.NTSB FTW85LQG01Accident · No injuriesFinal reportCessna 421B · Amarillo, TXThe acft ground looped following a collapse of the left main gear after a landing roll of aprx 600 to 700 ft. post accident inspection of the gear revealed a bolt had backed out of the gear down lock arm where it locks overcenter.NTSB FTW81FRG66Accident · No injuriesClosedCessna 421C · Hebbronville, TXNTSB FTW78DQG16Accident · No injuriesClosedCessna TU206F · Big Spring, TXNTSB FTW77FRA35Accident · No injuriesClosedCessna 421B · Houston, TXNTSB FTW73AF026Accident · 2 fatalClosedCessna 421 · Fort Hancock, TX