NTSB investigations: Continental IO-520 series, 2007, FL

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

Cases per year

19652026
NTSB investigations: Continental IO-520 series, 2007, FL per year, 1965–2026: 259 cases
19651
19663
19678
19683
19704
19712
19724
19732
19748
19755
19765
19776
197810
19798
198012
19817
198211
19836
19843
19856
19868
19875
19885
19896
19901
19914
19925
19933
19945
19964
19973
19982
19997
20001
20015
20026
20036
20044
20055
20063
20075
20085
20103
20113
20121
20136
20143
20155
20164
20171
20185
20194
20203
20214
20221
20241
20252
20261

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\") = 2007
    AND c.\"eventStateOrRegion\" = 'FL' 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'))
  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 ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.Aug 26, 2007 · N904DZ · Substantial damageNTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.Apr 19, 2007 · N2874B · Substantial damageNTSB MIA07IA080Incident · No injuriesIncident investigationFinal reportBeech E-55 · Key West, FLFailure of the nose landing gear drag brace due to overload during landing rollout for undetermined reasons. Contributing to the accident was the airplane had not been modified with an improved nose landing gear drag brace.Mar 31, 2007 · N25612 · Minor damageNTSB MIA07FA056Accident · 1 fatalField investigationFinal reportBeech 95-C55 · Port Orange, FLThe pilot's failure to maintain airspeed during initial climb resulting in inadvertent stall. Contributing to the accident was the pilot's improper positioning of the left fuel selector which resulted in fuel starvation to the left engine.Mar 4, 2007 · N100FG · Substantial damageNTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.Feb 17, 2007 · N6641V · Destroyed