Skip to content

NTSB investigations: Continental C125 series, CA

28 cases on aircraft whose registry engine model is Continental C125 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'CA' 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 ('17011')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'CA' 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 ('17011'))
  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" = 'CA' 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 ('17011'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR23LA161Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Concord, CAThe pilot’s failure to maintain directional control of the airplane during a landing in gusting wind conditions.Apr 14, 2023 · N80922 · Substantial damage NTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.Sep 4, 2009 · N2345B · Substantial damage NTSB LAX04LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Placerville, CAa loss of engine power due to an improperly sized and installed set of sealing gaskets in the gascolator, which resulted in fuel starvation. A factor to the accident was the unsuitable terrain for the forced landing.Mar 18, 2004 · N369BZ · Substantial damage 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.Aug 31, 1994 · N80642 · Substantial damage NTSB LAX85FA259Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Moorpark, CAAcft crashed while being maneuvered in a canyon. Post crash inspection of the propeller revealed no evidence of rotation at impact. One-half gal of automotive fuel was found in the left wing tank and no fuel was found in the right wing tank. Some fuel lines…May 27, 1985 · N80970 · Destroyed NTSB LAX85LA146Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Modesto, CAThe plt attempted a simulated forced landing, stalled the acft 10 to 15 feet high and made a hard landing causing the right main gear to fail.Feb 18, 1985 · N80860 · Substantial damage NTSB LAX78FUQ17Accident · Serious injuriesClosedGlobe GC-1B · Lancaster, CAMar 10, 1978 · N78272 · Substantial damage NTSB LAX76FUG34Accident · 1 fatalClosedGlobe GC-1B · Hesperia, CAFeb 22, 1976 · N3851K · Substantial damage NTSB OAK70D0071Accident · No injuriesClosedSwift GC-1B · Sheltr Cove, CAJun 29, 1969 · N78209 · Substantial damage NTSB OAK68D0137Accident · No injuriesClosedGlobe GC-1B · Columbia, CASep 17, 1967 · N78324 · Substantial damage NTSB LAX68D0088Accident · No injuriesClosedGlobe GC-1B · Ramona, CAAug 10, 1967 · N78246 · Substantial damage NTSB OAK67D0328Accident · No injuriesClosedGlobe GC-1B · San Jose, CAMay 15, 1967 · N3321K · Substantial damage NTSB LAX67F0384Accident · Minor injuriesClosedGlobe GC-1B · Van Nuys, CAMay 3, 1967 · N3749K · Substantial damage NTSB OAK67D0292Accident · No injuriesClosedGlobe GC-1B · San Carlos, CAApr 17, 1967 · N2419B · Substantial damage NTSB LAX67F0255Accident · No injuriesClosedGlobe GC-1B · Hawthorne, CAJan 20, 1967 · N78248 · Substantial damage NTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CADec 18, 1966 · N3818K · Substantial damage NTSB LAX67D0072Accident · No injuriesClosedGlobe GC-1B · Wasco, CAAug 8, 1966 · N78155 · Substantial damage NTSB OAK66D0259Accident · No injuriesClosedGlobe GC-1B · Sacramento, CAApr 30, 1966 · N3224K · Substantial damage NTSB OAK66D0277Accident · No injuriesClosedGlobe GC-1B · San Jose, CAApr 13, 1966 · N3827K · Substantial damage NTSB LAX66F0349Accident · No injuriesClosedGlobe GC-1B · San Fernando, CAMar 9, 1966 · N3346K · Substantial damage NTSB OAK66D0239Accident · No injuriesClosedGlobe D-16 · San Carlos, CAJan 30, 1966 · N2419B · Substantial damage NTSB LAX66D0099Accident · No injuriesClosedGlobe GC-1B · Santa Ana, CAJul 16, 1965 · N78170 · Substantial damage NTSB LAX66F0061Accident · No injuriesClosedGlobe GC-1B · Upland, CAMay 26, 1965 · N78007 · Substantial damage NTSB OAK65F0023Accident · No injuriesClosedGlobe GC-1B · Colusa, CAMar 3, 1965 · N3245K · Substantial damage NTSB LAX65F0051Accident · No injuriesClosedGlobe GC-1B · Thermal, CAFeb 3, 1965 · N78077 · Substantial damage NTSB LAX65D0092Accident · No injuriesClosedGlobe GC-1B · Hemet, CAJan 29, 1965 · N3772K · Substantial damage NTSB UNK64X1759Accident · 1 fatalClosedGlobe GC-1A · Santa Monica, CAMay 13, 1964 · N78087 · Destroyed NTSB UNK64X1193Accident · 2 fatalClosedSwift GC1B · Mt Laguna, CAApr 5, 1964 · N2371B · Destroyed