NTSB investigations: Continental IO-520 series, FL
12 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
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 3 |
| 2001 | 2 |
Where
Latest 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\" = 'FL' 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" = 'FL' 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 ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.NTSB MIA01LA130Accident · No injuriesLimited investigationFinal reportCessna 210N · Gainesville, FLThe pilot's delay in securing all non-essential electrical equipment in-flight resulting in battery depletion before complete gear extension was accomplished using the normal system and subsequent collapse of the main landing gear. A contributing factor in…NTSB MIA92LA189Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLUndetected chaffing and grounding of a wire to the nose landing gear squat switch which resulted in the landing gear being signalled at all times for gear up when electrical power was applied to the system. Contributing to the accident was the overheating of…NTSB MIA92LA188Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLFailure of the right main landing gear actuator due to overstress for undetermined reasons which resulted in loss of all landing gear system hydraulic fluid which in turn resulted in the pilot being unable to extend and lock the landing gear.NTSB MIA92LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · West Palm Beach, FLPartial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.NTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.NTSB MIA89IA118Incident · No injuriesIncident investigationFinal reportCessna P206B · West Palm Beach, FLFailure of the throttle control arm resulting in the loss of engine power. The failure was caused by poor maintenance.NTSB MIA86LA186Accident · No injuriesLimited investigationFinal reportCessna U206F · Ft. Myers, FLThe private pilot had just completed a short no-radio night flight and during the landing roll the nose gear wheel assembly separated from the aircraft. Examination revealed that the wrong nuts had been installed on the wheel assembly at the last annual…NTSB MIA86LA104Accident · No injuriesLimited investigationFinal reportCessna 210E · Jacksonville, FLAfter departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct…NTSB MIA86LA030Accident · No injuriesLimited investigationFinal reportCessna 210M · Ft.Lauderdale, FLWhile in cruise flight the pilot attempted to lower the landing gear and the right main landing gear would not extend. During this process the aircraft generator went off the line. The pilot attempted to manually lower the landing gear and extended the nose…NTSB MIA85IA074Incident · No injuriesIncident investigationFinal reportCessna C-402 · Miami, FLOn 1/7/85 at about 0750 EST, N60SA, a Cessna 402 landed leftmain gear collapsed, on a commuter air taxi, positioning flight at maimi, FL. VMC prevailed at the time an IFR flight plan was filed. The aircraft received minor damage and the pilot, the sole…NTSB MIA84LA010Accident · No injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe acft landed gear up after the landing gear could be extended in flight. The plt stated during the app to St. Augustine attempts to lower the gear were unsuccessful. The gear doors would open and the hydraulic pump was working butthe gear would not extend.…