NTSB investigations: Continental IO-520 series, TX
8 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1996 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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 ('17032')
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\" = 130))
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 ('17032')
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" = 130))
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 DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.NTSB FTW03LA075Accident · No injuriesLimited investigationFinal reportCessna 401 · Mc Allen, TXThe pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend.NTSB FTW03FA054Accident · 1 fatalField investigationFinal reportCessna 402C · Lewisville, TXThe failure of the attitude indicator, and the pilot's failure to maintain aircraft control as a result of spatial disorientation following the failure of the attitude indicator. Contributing factors were a low ceiling, clouds, and dark night conditions.NTSB FTW02LA032Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Houston, TXthe failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.NTSB FTW96FA373Accident · 1 fatalField investigationFinal reportBeech D55 · Corsicana, TXThe pilot's failure to maintain minimum control airspeed which resulted in the loss of control. Factors were the bent collar of the left main fuel tank refueling neck which resulted in fuel siphoning from the tank in flight, the pilot's failure to follow…NTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…NTSB FTW89LA030Accident · No injuriesLimited investigationFinal reportCessna A185H · San Antonio, TXDuring the landing roll, the left wheel brake cylinder failed and the airplane groundlooped. The plt did not file an accident report.NTSB FTW85FA078Accident · 1 fatalField investigationFinal reportBeech V35A · Midlothian, TXN7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…