Skip to content

NTSB investigations: Continental C125 series, FL

17 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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA18TA222Accident · Serious injuriesFinal reportGlobe GC1B · Wellington, FLThe partial loss of engine power during the initial climb due to a sticking intake valve on the No. 3 cylinder.Aug 17, 2018 · N80932 · Substantial damage NTSB ERA14LA363Accident · 1 fatalLimited investigationFinal reportTemco GC 1B · Yulee, FLThe pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.Jul 28, 2014 · N1CY · Substantial damage NTSB MIA95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Venice, FLFailure of the globe GC-1B (swift) pilot to see the Piper PA-23 in time to avoid a collision, and the Piper PA-23 pilot's delay in initiating remedial action to avoid the collision.Apr 2, 1995 · N346PB · 2 aircraft · Minor damage NTSB MIA90LA019Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Zellwood, FLImproper planning/decision by the pilot. The crosswind and ditch were related factors.Oct 28, 1989 · N80528 · Substantial damage NTSB MIA85FA102Accident · 2 fatalField investigationFinal reportGlobe Swift GC-1B · Rockledge, FLThe acft crashed into a field after experiencing a loss of pwr. Inspection revealed one of the two check valves inside the eng driven fuel pump was unsetted and wedged between the metal pump housing and the pump diaphram actuating plate. With the check valve…Feb 23, 1985 · N1ZF · Substantial damage NTSB MIA84FA005Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Venice, FLImmediately after takeoff the plt radioed on UNICOM that his cowling was coming open & that he was returning to the field. Other plts waiting for takeoff reported seeing that acft enter a left turn between 200-300 ft AGL & become very slow. One of the plts…Oct 8, 1983 · N80682 · Destroyed NTSB MIA82DA158Accident · No injuriesFinal reportGlobe GC-1B · St. Augustine, FLThe purpose of the flight was to practice spot landings for a competitive event at a later time. The pilot reported that he made an approach to runway 13 on a hot morning with up and downdrafts. He estimated that the wind was variable from 130 to 220 deg at…Jul 10, 1982 · N78118 · Substantial damage NTSB MIA81FA037Accident · 2 fatalClosedGlobe GC-1B · Englewood, FLJan 18, 1981 · N80606 · Destroyed NTSB MIA77FKT65Accident · No injuriesClosedGlobe GC-1B · Homestead, FLAug 14, 1977 · N80955 · Substantial damage NTSB MIA75DKT81Accident · No injuriesClosedGlobe GC-1A · Pahokee, FLMay 15, 1975 · N90333 · Substantial damage NTSB MIA71DLA40Accident · No injuriesClosedSwift GC-1B · Defuniak Spgs, FLMar 30, 1971 · N3823K · Substantial damage NTSB MIA71DLD58Accident · No injuriesClosedGlobe GC-1B · Silver Spgs, FLMar 28, 1971 · N78055 · Substantial damage NTSB MIA71FLA13Accident · No injuriesClosedGlobe GC-1B · Tallahassee, FLSep 10, 1970 · N90333 · Substantial damage NTSB MIA67F0516Accident · Serious injuriesClosedGlobe GC-1B · St Augustine, FLApr 15, 1967 · N80646 · Destroyed NTSB MIA67F0244Accident · No injuriesClosedGlobe GC-1B · Brooksville, FLOct 23, 1966 · N80682 · Substantial damage NTSB UNK65X1380Accident · No injuriesClosedGlobe GC1B · Miami, FLFeb 1, 1965 · N78323 · Substantial damage NTSB UNK64X3937Accident · No injuriesClosedGlobe GC1B · Citra, FLSep 12, 1964 · N80712 · Substantial damage