NTSB investigations: Continental C125 series
6 cases on aircraft whose registry engine model is Continental C125 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2004 | 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 ('17011')
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\" = 260))
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 ('17011')
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" = 260))
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 DEN05CA021Accident · No injuriesData collectionFinal reportTemco GC-1B · Angel Fire, NMthe pilot's failure to maintain directional control and his inadequate compensation for wind. Contributing to the accident was the crosswind.NTSB LAX97LA081Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Jean, NVThe failure of both pilots to maintain directional control of the aircraft, and the instructor's inadequate supervision of the flight. A factor in the accident was the limited conventional gear experience of both pilots.NTSB LAX94LA344Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Five Points, CAthe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain the proper runway alignment.NTSB NYC90LA059Accident · No injuriesLimited investigationFinal reportGlobe Swift Gcib · Pittstown, NJThe pilot failed to abort the takeoff after losing directional control during the takeoff ground run. Factors related to the accident were: crosswind, hidden obstruction in high vegetation, and low time in model.NTSB MIA90LA019Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Zellwood, FLImproper planning/decision by the pilot. The crosswind and ditch were related factors.NTSB NYC85LA035Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Millbrook, NYPlt stated that while taxiing off the runway onto the taxiway, a gust of wind caused the acft to drift left. Plt stated he over corrected with rudder and power; acft swerved right, off the narrow prepared surface and down a steep embankment.