NTSB investigations: Continental IO-520 series, 2002, FL
6 cases on aircraft whose registry engine model is Continental IO-520 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
| 1965 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 8 |
| 1968 | 3 |
| 1970 | 4 |
| 1971 | 2 |
| 1972 | 4 |
| 1973 | 2 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 5 |
| 1977 | 6 |
| 1978 | 10 |
| 1979 | 8 |
| 1980 | 12 |
| 1981 | 7 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 6 |
| 1986 | 8 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 5 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 1 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 5 |
| 2008 | 5 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 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\") = 2002
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 ('17032'))
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") = 2002
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 ('17032'))
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 ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.NTSB ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.NTSB MIA02LA146Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Fort Lauderdale, FLthe pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.NTSB ATL02IA112Incident · Minor injuriesIncident investigationFinal reportCessna 210L · Sarasota, FLThe pilot's failure to follow the before landing checklist and confirm that the landing gear was extended.NTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.NTSB ATL02LA070Accident · No injuriesLimited investigationFinal reportCessna 210 · Naples, FLTotal loss of engine power due to improper maintenance by company maintenance personnel which allowed the mixture control linkage to disconnect in flight which resulted in an emergency descent to landing into unsuitable terrain.