NTSB investigations: Continental IO-520 series, 2006

7 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, 2006 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\") = 2006
    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 LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.Dec 27, 2006 · N4598S · Substantial damageNTSB ANC07LA003Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKThe pilot's misjudgment of distance/altitude during the landing approach, which resulted in an undershoot and in-flight collision with a river embankment. Factors contributing to the accident were reduced visibility due to rain and mist.Oct 13, 2006 · N7336U · Substantial damageNTSB LAX06LA249Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Independence, CAthe pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.Jul 28, 2006 · N346D · Substantial damageNTSB NYC06CA177Accident · No injuriesData collectionFinal reportBeech A36 · Somerville, NJThe pilot's continued flight into known adverse weather.Jul 16, 2006 · N5363P · Substantial damageNTSB ANC06CA088Accident · No injuriesData collectionFinal reportCessna 206F · Fairbanks, AKThe pilot's inadequate weather evaluation, which resulted in the airplane encountering a severe downdraft during takeoff initial climb, and an in-flight collision with terrain. Factors associated with the accident were a thunderstorm and a downdraft.Jul 12, 2006 · N8440Q · 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 DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.Feb 20, 2006 · N510LM · Substantial damage