NTSB investigations: Continental IO-520 series, 1998
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\") = 1998
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") = 1998
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 CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.NTSB FTW98FA276Accident · 2 fatalField investigationFinal reportBeech A36 · Nephi, UTThe improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…NTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.NTSB FTW98LA201Accident · No injuriesLimited investigationFinal reportCessna 320D · Greybull, WYStress overload failure of the bellcrank assembly of the left landing gear.NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.NTSB MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…NTSB ANC98LA017Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKA separation of the axle from the landing gear strut due to overload, and stripping of the axle bolt threads.NTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.