NTSB investigations: Continental IO-550-N
166 cases on aircraft whose registry engine model is Continental IO-550-N. 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 ('17215'))
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 ('17215'))
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 NYC08FA138Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Front Royal, VAThe pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…NTSB DFW08FA060Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Lindsay, OKThe flight instructor's failure to maintain control of the airplane, which resulted in an inadvertent stall while maneuvering.NTSB LAX08FA043Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Paso Robles, CAThe pilot's encounter with isolated moderate (or greater) turbulence, updrafts, and downdrafts associated with localized mountain wave conditions at low altitude, and, his failure to maintain adequate airspeed during the encounter that resulted in an…NTSB MIA08LA024Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Hendersonville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control.NTSB CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB SEA07IA201Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Reno, NVThe failure of the left turbocharger as a result of a production defect in the unit's compressor due to a machining process change by the manufacturer that was made without formal documentation or substantiation.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB NYC07FA126Accident · 3 fatalField investigationFinal reportColumbia Aircraft Mfg LC42-550FG · Burnsville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control and subsequent impact with several parked airplanes.NTSB NYC07LA094Accident · 2 fatalLimited investigationFinal reportRomeo Lancair Legacy RG · Fulton, NYA loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB DEN07LA082Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Luna, NMthe pilot's failure to activate the pitot heat while flying in the clouds and visible moisture, resulting in pitot tube contamination and the subsequent loss of air data for the primary flight display. Contributing to the accident was the icing conditions,…NTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.NTSB DEN07WA005Accident · No injuriesForeign investigationCirrus Design SR22 · Karlsruhe-Baden, GermanyNTSB CHI06FA245Accident · 1 fatalField investigationFinal reportCirrus SR22 · Indianapolis, INThe pilot's failure to maintain sufficient airspeed, which resulted in a stall and subsequent spin. Contributing to the accident were the pilot's inadequate preflight planning, the overloaded condition of the airplane, and the CG aft of the CG limit.NTSB ATL06LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22-GTS · Mc Rae, GAThe pilot's failure to use supplemental oxygen where required, and his failure to maintain sufficient airspeed to avoid a stall.NTSB LAX05LA267Accident · No injuriesLimited investigationFinal reportBarnes Lancair Legacy · Groveland, CAThe inaccurate fuel quantity sensors and the pilot's failure to verify the fuel quantity on board prior to takeoff, which resulted in fuel exhaustion.NTSB DEN84LA297Accident · No injuriesLimited investigationFinal reportWindecker Research Eagel AC7 · Deming, NMThe acft collided with the rwy gear up after takeoff. The plt said he encountered a microburst which forced the acft to the rwy. There were reported thunderstorms in the area. The plt also said he is going to alter his takeoff proceduresto raising the landing…