NTSB investigations: Continental IO-520 series, 1992
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
| 1982 | 4 |
|---|---|
| 1983 | 9 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 8 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 10 |
| 2006 | 2 |
| 2007 | 4 |
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 year(c.\"eventDate\") = 1992
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 year(c."eventDate") = 1992
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 DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.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 ANC92LA093Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKFailure to maintain directional control. Factors include tailwheel vibration/shimmy, and an inadvertent ground loop.NTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.NTSB CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.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.