NTSB investigations: Continental O-470 series, 2001, GA
6 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 | 2 |
|---|---|
| 1965 | 5 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 5 |
| 1969 | 5 |
| 1971 | 6 |
| 1972 | 6 |
| 1973 | 3 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1999 | 2 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 3 |
| 2007 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2001
AND c.\"eventStateOrRegion\" = 'GA' 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") = 2001
AND c."eventStateOrRegion" = 'GA' 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 MIA01LA233Accident · No injuriesLimited investigationFinal reportBeech A45 · Eatonton, GAThe inadvertent sliding of the airplane on tall grass when the pilot aborted takeoff and the swerved the airplane to the left of the runway to avoid deer which had walked onto the runway, resulting in the airplanes left wing contacting a tree.NTSB MIA01LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Winder, GAA total loss of engine power due to fatigue failure of the number two piston immediately after takeoff, resulting in collision with trees and the terrain during an emergency descent.NTSB MIA01LA215Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Savannah, GAThe delay of the pilot to perform a go-around following a bounced landing and porpoise, and failure of the pilot to maintain directional control resulting in the airplane departing the runway and colliding with a berm.NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.