OpenAirDocs.org

NTSB investigations: Continental IO-520 series, AZ

6 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight encounter with weather”. 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

19822026

Where

Open the map

Latest 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\" = 'AZ' 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 ('17032')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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.

NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.May 2, 2007 · N3210L · Substantial damageNTSB LAX06FA130Accident · 2 fatalField investigationFinal reportBeech F33A · Kingman, AZThe noninstrument rated pilot's cruise flight into instrument meteorological conditions, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent, and an in-flight collision with terrain. Factors associated with the…Mar 20, 2006 · N41PT · DestroyedNTSB LAX88FA101Accident · 2 fatalField investigationFinal reportCessna U206F · Lk Havasu City, AZPilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.Feb 2, 1988 · N60566 · DestroyedNTSB LAX87FA200Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Flagstaff, AZThe plt & his wife desired to return to their Flagstaff, AZ, home following a weekend at stockton, CA., & they departed sck in VFR weather conditions. The weather at the destination arpt had been below VFR minimums all morning & it was forecast to remain poor…Nov 3, 1986 · N93495 · DestroyedNTSB LAX83FA050Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Williams, AZThe original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…Nov 25, 1982 · N14748 · DestroyedNTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…Mar 18, 1982 · N499W · Destroyed