NTSB investigations: Continental C125 series
199 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.
Cases, newest first
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'))
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'))
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 SEA84LA210Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Sheridan, ORCFI stated, 'the acft became airborne aprx 2/3 of the way down a 3000 ft gravel and dirt rwy. At lift off, OR slightly before or after, student put on full flaps. Until this point student was in control of the airplane except for minor corrections from me.…NTSB SEA84FA204Accident · 2 fatalField investigationFinal reportVaughn MA-5 Charger · Buxton, ORWitnesses reported seeing the acft engaged in aerobatic flight described as 'like a spray plane conducting spray operations.' The acft collided with relatively level terrain during one of these maneuvers. No airframe or powerplant failures/malfunctions were…NTSB CHI84LA191Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Columbus, OHThe acft right main gear failed during takeoff roll when it passed over an arresting cable. It was reported that the tailwheel was damaged on a previous landing at rickenbacker afb when it passed over an arresting cable and had since been replaced.…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…NTSB FTW83LA293Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Marion, TXThe acft collided with fences during a forced landing after an engine fuel fire. The left exhaust pipe failed and the misdirected heat burned through a fuel line. The fuel ignited filling the cockpit with smoke. The engine quit due to fuel starvation and the…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…NTSB CHI81FEK29Accident · Serious injuriesClosedGlobe GC-1 · Mt Vernon, OHNTSB MIA81FA037Accident · 2 fatalClosedGlobe GC-1B · Englewood, FLNTSB FTW80FPG30Accident · Serious injuriesClosedGlobe GC-1B · Carbon City, ARNTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANTSB FTW79FPD31Accident · No injuriesClosedGlobe GC-1B · Keller, TXNTSB LAX79FA037Accident · 2 fatalClosedGlobe Swift GC1B · Parker, AZNTSB NYC78FNC25Accident · No injuriesClosedGlobe GC-1B · Rockport, MENTSB LAX78FUQ17Accident · Serious injuriesClosedGlobe GC-1B · Lancaster, CANTSB MIA77FKT65Accident · No injuriesClosedGlobe GC-1B · Homestead, FLNTSB CHI77FEE21Accident · Minor injuriesClosedGlobe GC-1B · Marengo, ILNTSB FTW77FRA11Accident · No injuriesClosedGlobe GC-1B · Cypress, TXNTSB MIA77FKG04Accident · No injuriesClosedGlobe GC-1B · Zebulon, GANTSB CHI76FEV64Accident · No injuriesClosedGlobe GC-1B · Burnside, ILNTSB FTW76DPA31Accident · Minor injuriesClosedGlobe GC-1B · Allen, TXNTSB ANC76DAH35Accident · No injuriesClosedNelson NJ4 · Big Lake, AKNTSB LAX76FUG34Accident · 1 fatalClosedGlobe GC-1B · Hesperia, CANTSB MKC76FER19Accident · Serious injuriesClosedTemco GC-1B · Lake Elmo, MNNTSB MIA76DKJ06Accident · No injuriesClosedTemco GC-1B · Millerville, ALNTSB FTW76DRJ03Accident · No injuriesClosedGlobe GC-1B · Minden, LANTSB CHI75DEP59Accident · No injuriesClosedGlobe GC-1B · Milwaukee, WINTSB MIA75DKT81Accident · No injuriesClosedGlobe GC-1A · Pahokee, FLNTSB OAK75FVW18Accident · No injuriesClosedGlobe GC-1B · Boulder City, NVNTSB CHI75DEE39Accident · No injuriesClosedGlobe GC-1B · Channahon, ILNTSB NYC74AN101Accident · 2 fatalClosedGlobe GC-1B · Advance, NCNTSB NYC74FNE05Accident · No injuriesClosedTemco GC-1B · Hartford, CTNTSB NYC73FHM31Accident · Serious injuriesClosedGlobe GC-1B · Fairfield, NJNTSB NYC73AN135Accident · 2 fatalClosedGlobe GC-1B · Warwick, NYNTSB NYC73DNE28Accident · No injuriesClosedDavis D-1K · Chester, CTNTSB MIA73FKJ35Accident · No injuriesClosedSwift GC-1B · Birmingham, ALNTSB SEA73FYE19Accident · No injuriesClosedSwift GC-1B · Snohomish, WANTSB NYC73ANO67Accident · 2 fatalClosedSwift GC-1B · Salisbury, MDNTSB NYC73DHA09Accident · No injuriesClosedSwift GC-1B · Blairstown, NJNTSB FTW72FFD46Accident · Serious injuriesClosedGlobe GC-1B · Weatherford, TXNTSB FTW72DPA23Accident · No injuriesClosedGlobe GC-1B · Dallas, TXNTSB MKC72DCG47Accident · No injuriesClosedGlobe GC-1B · St Joseph, MONTSB NYC72FNE24Accident · No injuriesClosedGlobe GC-1B · East Haven, CTNTSB MKC72FCJ42Accident · No injuriesClosedTemco GC-1B · Grand Island, NENTSB MIA72FKG49Accident · Serious injuriesClosedGlobe GC-1B · Cordele, GANTSB CHI72FEP18Accident · No injuriesClosedGlobe GC-1B · Sheboygan, WINTSB MKC72FCG16Accident · Serious injuriesClosedGlobe GC-1B · Brunswick, MONTSB MKC72DER06Accident · No injuriesClosedGlobe GC-1B · Big Fork, MNNTSB MKC71FTK32Accident · No injuriesClosedGlobe GC-1B · Rapid City, SDNTSB DEN71FQA53Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMNTSB MIA71DLA40Accident · No injuriesClosedSwift GC-1B · Defuniak Spgs, FL