NTSB investigations: Continental IO-550 series
10 cases on aircraft whose registry engine model is Continental IO-550 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
| 1991 | 1 |
|---|---|
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 3 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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 ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.NTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.NTSB MIA04LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · N. Lauderdale, FLThe erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.NTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.NTSB FTW03LA005Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Lewisville, TXThe improper reinstallation of the left aileron by maintenance personnel. A contributing factor was the non-suitable terrain for the forced landing.NTSB FTW02LA189Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Farmington, NMThe failure of the nose landing gear plunger assembly due to fatigue.NTSB FTW02LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Farmington, NMThe failure of the nose gear actuator retract arm due to fatigue.NTSB LAX01IA241Incident · No injuriesIncident investigationFinal reportBeech A36 · Bakersfield, CADuring landing approach, mechanical binding of the elevator control cable occurred due to a contract mechanic's improper maintenance.NTSB LAX92LA038Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe pilot's inability to control the aircraft during the landing roll due to a failure of the left brake and nose wheel steering systems. The failure of the brake and steering systems was due to a deterioration of the 'o' ring seals caused by the use of…