NTSB investigations: Continental O-470 series, 2005, MN
4 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 | 7 |
|---|---|
| 1965 | 2 |
| 1966 | 7 |
| 1967 | 2 |
| 1968 | 4 |
| 1969 | 7 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 8 |
| 1973 | 4 |
| 1974 | 1 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 6 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 1 |
| 1987 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 2 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2002 | 2 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 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\") = 2005
AND c.\"eventStateOrRegion\" = 'MN' 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") = 2005
AND c."eventStateOrRegion" = 'MN' 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 CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.NTSB CHI05CA195Accident · No injuriesData collectionFinal reportCessna 180 · Bowstring, MNThe unsuitable water conditions for takeoff selected by the pilot and his inability to maintain aircraft control in the rough water. Contributing factors were the aborted takeoff initiated by the pilot, the rough water conditions and the high, gusty winds.NTSB CHI05LA097Accident · No injuriesLimited investigationFinal reportCessna 310 · Clear Lake, MNThe collapse of the nose landing gear as a result of the pilot performing improper maintenance on the airplane due to his failure to properly safety the nose landing gear door.