NTSB investigations: Continental IO-360 series, 2009
12 cases on aircraft whose registry engine model is Continental IO-360 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 | 1 |
|---|---|
| 1965 | 11 |
| 1966 | 12 |
| 1967 | 17 |
| 1968 | 18 |
| 1969 | 16 |
| 1970 | 19 |
| 1971 | 15 |
| 1972 | 12 |
| 1973 | 12 |
| 1974 | 13 |
| 1975 | 20 |
| 1976 | 12 |
| 1977 | 17 |
| 1978 | 29 |
| 1979 | 20 |
| 1980 | 19 |
| 1981 | 13 |
| 1982 | 17 |
| 1983 | 10 |
| 1984 | 14 |
| 1985 | 12 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 10 |
| 1989 | 10 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 5 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 6 |
| 1999 | 9 |
| 2000 | 8 |
| 2001 | 12 |
| 2002 | 13 |
| 2003 | 12 |
| 2004 | 9 |
| 2005 | 17 |
| 2006 | 13 |
| 2007 | 6 |
| 2008 | 15 |
| 2009 | 12 |
| 2010 | 8 |
| 2011 | 11 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 5 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 7 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 9 |
| 2023 | 7 |
| 2024 | 8 |
| 2025 | 8 |
| 2026 | 4 |
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\") = 2009
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045'))
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") = 2009
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045'))
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 ERA10WA096Accident · 1 fatalForeign investigationHuber Hartmut Express · Berry Island, BahamasOn December 12, 2009, at 1300 UTC, an experimental, amateur-built Harmut Huber Express, N93HE, operated by a private individual, crashed into the water on short final approach to Chub Cay Airport (MYBC), Berry Island, Bahamas. The pilot was killed and the…NTSB ERA10LA042Accident · No injuriesLimited investigationFinal reportBeriev BE-103 · Miami, FLA malfunction of the landing gear retraction/extension and indication system for undetermined reasons, which resulted in one or more components being improperly positioned for the water landing.NTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.NTSB ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.NTSB WPR09LA480Accident · No injuriesLimited investigationFinal reportCessna R172K · Page, AZThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR09LA268Accident · Serious injuriesLimited investigationFinal reportMaule M-5-210C · Ogden, UTA loss of engine power during takeoff for undetermined reasons.NTSB CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.NTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.NTSB WPR09LA177Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Baker, CAA total loss of engine power for undetermined reasons.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09LA115Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Rialto, CAA partial loss of engine power to one engine during initial climb for undetermined reasons.