Fatal NTSB investigations: Continental O-470 series, AL
7 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
| 1981 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2003 | 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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 ATL03FA075Accident · 2 fatalField investigationFinal reportCessna 180 · Oxford, ALThe pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.NTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.NTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB ATL81FA090Accident · 2 fatalClosedCessna 182M · Haleyville, AL