Fatal NTSB investigations: Continental IO-520 series, OR

9 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Fatal NTSB investigations: Continental IO-520 series, OR per year, 1978–2026: 9 cases
1978	1
1982	1
1994	1
1999	1
2001	1
2003	1
2004	1
2008	1
2011	1

Where

Open the map

Latest cases

Query with SQL

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" = 'OR' 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 ('17032')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'OR' 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 ('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 c."eventStateOrRegion" = 'OR' 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 ('17032'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.Oct 25, 2011 · N3062H · 2 aircraft · Substantial damage NTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.Oct 29, 2008 · N2570X · Substantial damage NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.May 19, 2004 · N61611 · Destroyed NTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.Oct 20, 2003 · N136SB · Destroyed NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…Sep 5, 2001 · N18414 · Destroyed NTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.Nov 11, 1999 · N6245E · Substantial damage NTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.Feb 3, 1994 · N50VT · Destroyed NTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…Jul 24, 1982 · N7932K · Destroyed NTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNov 19, 1978 · N7320V · Destroyed