NTSB investigations: Continental IO-520 series, 1999

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
NTSB investigations: Continental IO-520 series, 1999 per year, 1982–2026: 123 cases
19827
19839
19848
19854
19867
19872
19885
19898
19901
19911
19922
19933
19943
19954
19962
19976
19987
19996
20001
20011
20029
20034
20048
20055
20067
20073

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 year(c.\"eventDate\") = 1999
    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 ANC00FA018Accident · 6 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.Dec 7, 1999 · N1747U · DestroyedNTSB ANC00LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…Oct 27, 1999 · N207SE · Substantial damageNTSB ANC99LA147Accident · No injuriesLimited investigationFinal reportCessna 185F · Pilot Point, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the pilot's inadequate evaluation of the weather conditions, a downdraft, and swampy terrain.Sep 19, 1999 · N60859 · Substantial damageNTSB ANC99LA118Accident · No injuriesLimited investigationFinal reportCessna 206 · Anaktuvuk Pass, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, and weather conditions consisting of clouds, rain, and fog.Aug 22, 1999 · N5446X · Substantial damageNTSB DEN99FA093Accident · 1 fatalField investigationFinal reportBeech V35A · Nederland, COThe pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.Jun 5, 1999 · N68VT · DestroyedNTSB ANC99LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's continued flight into adverse weather conditions. Factors associated with the accident were freezing rain, an accumulation of ice on the wings and ailerons, and diminished directional control.Jan 12, 1999 · N19TA · Substantial damage