NTSB investigations: Continental IO-550 series, NY
11 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 per year
| 2000 | 1 |
|---|---|
| 2002 | 1 |
| 2005 | 2 |
| 2010 | 2 |
| 2012 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2020 | 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\" = 'NY' 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 ('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."eventStateOrRegion" = 'NY' 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 ('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 ERA20CA203Accident · No injuriesClass 4 · Data collectionFinal reportBeech 36 · Batavia, NYThe pilot's failure to extend the landing gear during a precautionary landing after an electrical failure.NTSB ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…NTSB ERA16LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hauppauge, NYThe total loss of engine power, which resulted from the failure of the camshaft gear due to fatigue. Contributing to the accident was the owner/operator's failure to comply with the engine manufacturer's recommended overhaul interval.NTSB ERA12LA295Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Yorktown, NYThe pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.NTSB ERA11FA095Accident · 1 fatalField investigationFinal reportMooney M20R · Dundee, NYThe pilot's decision to operate in known moderate-to-severe icing conditions, which resulted in a loss of control during approach.NTSB ERA10CA273Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmingdale, NYThe pilot's failure to maintain directional control during a go-around attempt.NTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.NTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.NTSB NYC00LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Sloatsburg, NYThe pilot's failure to maintain aircraft control. A factor was the pilot's diverted attention.