NTSB investigations: Continental C125 series, 1967
18 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\") = 1967
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") = 1967
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 DEN68D0138Accident · No injuriesClosedGlobe GC-1B · Aurora, CONTSB MIA68D0247Accident · No injuriesClosedGlobe GC-1B · Kennesaw, GANTSB CHI68F0578Accident · No injuriesClosedGlobe Swift GC-1B · W Lafayette, INNTSB OAK68D0137Accident · No injuriesClosedGlobe GC-1B · Columbia, CANTSB MKC68D0297Accident · No injuriesClosedGlobe GC-1B · Harrisonville, MONTSB LAX68D0088Accident · No injuriesClosedGlobe GC-1B · Ramona, CANTSB LAX68D0070Accident · No injuriesClosedGlobe GC-1B · Marana, AZNTSB DEN68D0033Accident · No injuriesClosedTemco D-16 · Colo.Springs, CONTSB MKC68D0004Accident · No injuriesClosedGlobe GC-1B · Missouri City, MONTSB OAK67D0328Accident · No injuriesClosedGlobe GC-1B · San Jose, CANTSB LAX67F0384Accident · Minor injuriesClosedGlobe GC-1B · Van Nuys, CANTSB OAK67D0292Accident · No injuriesClosedGlobe GC-1B · San Carlos, CANTSB MIA67F0516Accident · Serious injuriesClosedGlobe GC-1B · St Augustine, FLNTSB FTW67F0537Accident · Minor injuriesClosedGlobe GC-1B · Stillwater, OKNTSB CHI67D0608Accident · No injuriesClosedGlobe GC-1A · Monee, ILNTSB NYC67F0609Accident · No injuriesClosedGlobe GC-1B · Latrobe, PANTSB LAX67F0255Accident · No injuriesClosedGlobe GC-1B · Hawthorne, CANTSB SEA67F0234Accident · No injuriesClosedGlobe GC-1B · Portland, OR