NTSB investigations: Continental C125 series, 1966
22 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 per year
| 1964 | 19 |
|---|---|
| 1965 | 13 |
| 1966 | 22 |
| 1967 | 18 |
| 1968 | 8 |
| 1969 | 9 |
| 1970 | 9 |
| 1971 | 9 |
| 1972 | 8 |
| 1973 | 4 |
| 1974 | 1 |
| 1975 | 7 |
| 1976 | 5 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1966
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 year(c."eventDate") = 1966
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" 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 LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CANTSB MIA67F0301Accident · No injuriesClosedTemco GC-1B · Agricola, MSNTSB OAK67D0161Accident · No injuriesClosedGlobe GC-1B · Las Vegas, NVNTSB MIA67F0244Accident · No injuriesClosedGlobe GC-1B · Brooksville, FLNTSB CHI68D0039Accident · Minor injuriesClosedGlobe GC-1B · Polo, ILNTSB CHI67F0167Accident · No injuriesClosedGlobe GC-1B · Lafayette, INNTSB LAX67D0072Accident · No injuriesClosedGlobe GC-1B · Wasco, CANTSB NYC67D0282Accident · No injuriesClosedGlobe GC-1B · Croton, NYNTSB NYC67D0140Accident · No injuriesClosedGlobe GC-1B · Colts Neck, NJNTSB NYC67F0085Accident · No injuriesClosedGlobe GC-1B · Fairfield, NJNTSB CHI67F0016Accident · No injuriesClosedTemco GC1B · Ann Arbor, MINTSB DEN66D0352Accident · No injuriesClosedSwift GC1B · Wilcox, AZNTSB OAK66D0259Accident · No injuriesClosedGlobe GC-1B · Sacramento, CANTSB OAK66D0277Accident · No injuriesClosedGlobe GC-1B · San Jose, CANTSB SEA66F0297Accident · No injuriesClosedGlobe Swift GC-1B · Mulino, ORNTSB FTW66F0627Accident · Minor injuriesClosedGlove GC1B · Morgan, TXNTSB NYC66F0674Accident · Serious injuriesClosedGlobe GC-1B · Covington, VANTSB LAX66F0349Accident · No injuriesClosedGlobe GC-1B · San Fernando, CANTSB FTW66D0592Accident · No injuriesClosedGlobe GC-1B · Laporte, TXNTSB MIA66D0408Accident · No injuriesClosedSwift GC-1B · Memphis, TNNTSB OAK66D0239Accident · No injuriesClosedGlobe D-16 · San Carlos, CANTSB CHI66D0526Accident · No injuriesClosedGlobe 125 · Franklin, IN