NTSB investigations: Continental IO-550 series
464 cases on aircraft whose registry engine model is Continental IO-550 series. 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, newest first
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 ('17042'))
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 ('17042'))
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 SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB LAX92LA038Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe pilot's inability to control the aircraft during the landing roll due to a failure of the left brake and nose wheel steering systems. The failure of the brake and steering systems was due to a deterioration of the 'o' ring seals caused by the use of…NTSB FTW91DRG06Accident · 1 fatalFinal reportQuestair Venture · San Marcos, TXThe pilot's failure to maintain flying airspeed resulting in a stall.NTSB LAX91LA107Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe failure of the fuel system vent check valve, which resulted in fuel starvation to the aircraft's engine.NTSB ATL90IA087Incident · No injuriesIncident investigationFinal reportMooney M-20L · Augusta, GAThe reported performance problem during climbout was undetermined. The pilot's decision to land with the landing gear retracted contributed to the minor damage sustained.NTSB DEN89LA014Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Garfield, CON31135 was being ferried to japan from wichita with an enroute stop in oakland, CA. The acft was equipped with cabin mounted ferry tanks. The plt stated that he switched from the acft fuel tanks to the ferry tank and about 20 minutes later the right eng quit.…NTSB LAX86LA259Accident · Serious injuriesLimited investigationFinal reportBeech A-36TC · San Rafael, CAThe acft stalled and collided with the ground initial during a takeoff initial climb. He indicated that he misjudged the stall buffet as turbulent airflow from a crosswind. The right wing dropped and the acft stalled. The plt also indicated the stall warning…NTSB ANC86LA004Accident · No injuriesLimited investigationFinal reportCessna 206 · Tanana, AKWhile en route, the eng lost power, so the plt made an emergency landing on a gravel bar. During the landing, the acft nosed over & came to rest in water. An exam revealed that the fuel sumps & lines were frozen & there was ice in the fuel pump.NTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.NTSB LAX83LA440Accident · No injuriesLimited investigationFinal reportBeech A36 · Redding, CAReportedly, during the landing roll, the acft settled while the gear was in transit. At that time, the flaps were in the down position & were damaged. According to the plt, the gear lights were green. Later, he said that something may have gone wrong with the…NTSB SEA83LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Klamath Falls, ORThe acft groundlooped off the runway during landing in a gusty crosswind. The pilot and passnger were not injured. The winds were reported as 300 degrees 18 knots gusting to 22 knots.NTSB OAK79FXQ12Accident · No injuriesClosedNavion H · S Lake Tahoe, CANTSB ANC79DAG04Accident · No injuriesClosedCessna 180 · Farewell Lake, AKNTSB DEN69D0126Accident · No injuriesClosedBeech 36 · Denver, CO