NTSB investigations: Continental A&C75 series, 1971
19 cases on aircraft whose registry engine model is Continental A&C75 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 | 48 |
|---|---|
| 1965 | 34 |
| 1966 | 33 |
| 1967 | 39 |
| 1968 | 28 |
| 1969 | 19 |
| 1970 | 19 |
| 1971 | 19 |
| 1972 | 16 |
| 1973 | 15 |
| 1974 | 12 |
| 1975 | 14 |
| 1976 | 16 |
| 1977 | 17 |
| 1978 | 15 |
| 1979 | 17 |
| 1980 | 15 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 14 |
| 1984 | 5 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 2 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 5 |
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 5 |
| 2019 | 6 |
| 2020 | 4 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 3 |
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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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 MKC72DTG14Accident · No injuriesClosedPiper J-3 · Colgan, NDNTSB OAK72DVA47Accident · No injuriesClosedErco 415-C · Merced, CANTSB FTW72FRA18Accident · Minor injuriesClosedErco 415 · Houston, TXNTSB MKC72FTG13Accident · No injuriesClosedErco 415-C · Buxton, NDNTSB FTW72FRA14Accident · No injuriesClosedPiper J3C-65 · Nederland, TXNTSB ANC72DAG63Accident · No injuriesClosedAeronca 7AC · Hope, AKNTSB NYC72FNE13Accident · Minor injuriesClosedPiper J3C-65 · Durham, CTNTSB NYC72FHD14Accident · No injuriesClosedErco 415-C · Pemberton, NJNTSB SEA71DYA41Accident · Minor injuriesClosedPiper J-3 · Paris, IDNTSB IAD71DKM39Accident · No injuriesClosedErcoupe 415C · Marion, NCNTSB MKC71FCJ71Accident · No injuriesClosedTaylorcraft BC12-D · Red Cloud, NENTSB LAX71DUG89Accident · No injuriesClosedErco 415-C · Elsinore, CANTSB CHI71DER07Accident · No injuriesClosedPiper J3C · Star Prairie, WINTSB MKC71FDM56Accident · No injuriesClosedCulver Cadet · Faribault, MNNTSB LAX71DUG71Accident · No injuriesClosedTaylorcraft BC12-D · Riverside, CANTSB OAK71FXQ29Accident · No injuriesClosedErco 415-CD · Reno, NVNTSB OAK71AP033Accident · 1 fatalClosedCulver LCA · Dos Palos, CANTSB OAK71DVM40Accident · Minor injuriesClosedEroupe 415CD · Palo Alto, CANTSB FTW71FRG77Accident · No injuriesClosedErcoupe 415-C · San Antonio, TX