NTSB investigations: Continental O-470 series, 1973, FL
9 cases on aircraft whose registry engine model is Continental O-470 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 | 8 |
|---|---|
| 1965 | 9 |
| 1966 | 7 |
| 1967 | 9 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 9 |
| 1971 | 6 |
| 1972 | 10 |
| 1973 | 9 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 8 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 8 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 10 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 2 |
Where
Latest 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\") = 1973
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
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") = 1973
AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
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 MIA74DKT45Accident · No injuriesClosedCessna 180 · Delray Beach, FLNTSB MIA74DKT38Accident · No injuriesClosedCamair 480 · Lantana, FLNTSB MIA74DLD17Accident · Minor injuriesClosedCessna 182 · Sanford, FLNTSB MIA74FLD09Accident · Minor injuriesClosedBeech H35 · Leesburg, FLNTSB MIA73DLA45Accident · No injuriesClosedCessna 182 · Century, FLNTSB MIA73FKT93Accident · Minor injuriesClosedCessna 182 · Florida City, FLNTSB MIA73DKT90Accident · No injuriesClosedCessna 182 · W.Palm Beach, FLNTSB MIA73DKT60Accident · No injuriesClosedBeech 95-B55 · Ft.Lauderdale, FLNTSB MIA73FKT51Accident · No injuriesClosedCessna 180A · Hollywood, FL