NTSB investigations: Continental C125 series, 1964
19 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\") = 1964
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") = 1964
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 UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKNTSB UNK65X1019Accident · No injuriesClosedGlobe GC1B · Lexington, NCNTSB UNK65X0194Accident · No injuriesClosedGlobe GC1B · Powell, TNNTSB UNK64X3937Accident · No injuriesClosedGlobe GC1B · Citra, FLNTSB UNK64X2499Accident · No injuriesClosedGlobe Swift GC1B · Leesburg, VANTSB UNK64X2035Accident · No injuriesClosedGlobe Swift Gcib · Mobile, ALNTSB UNK64X1962Accident · No injuriesClosedTemco Swift GC1B · Ansonia, CTNTSB UNK64X1759Accident · 1 fatalClosedGlobe GC-1A · Santa Monica, CANTSB UNK64X1731Accident · Serious injuriesClosedGlobe GC1B · Bayport, NYNTSB UNK64X1543Accident · No injuriesClosedGlobe Swift GC1B · Knoxville, TNNTSB UNK64X1373Accident · No injuriesClosedGlobe Swift GC1B · Hampshire, ILNTSB UNK64X1358Accident · No injuriesClosedGlobe Swift GC1B · New Haven, CTNTSB UNK64X1193Accident · 2 fatalClosedSwift GC1B · Mt Laguna, CANTSB UNK64X1192Accident · No injuriesClosedSwift GC1B · Latrobe, PANTSB UNK64X1108Accident · No injuriesClosedSwift GC1B · Denver, CONTSB UNK64X0428Accident · Serious injuriesClosedStubbe · Pueblo, CONTSB UNK64X0356Accident · No injuriesClosedSwift GC1B · Olathe, KSNTSB UNK64X0290Accident · No injuriesClosedSwift GC1B · Presque Isle, MENTSB UNK64X0218Accident · No injuriesClosedGlobe Swift GC-1B · Midland, TX