NTSB investigations: Continental I0-470 series, 1986, FL

5 cases on aircraft whose registry engine model is Continental I0-470 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

19642026
NTSB investigations: Continental I0-470 series, 1986, FL per year, 1964–2026: 155 cases
196410
196510
19668
19678
19684
19696
19701
19711
19729
19735
19742
19751
19763
19772
19785
19794
19807
19812
19823
19831
19844
19865
19876
19881
19891
19901
19911
19921
19932
19942
19981
19992
20001
20012
20032
20042
20053
20061
20071
20081
20091
20111
20121
20131
20141
20153
20162
20182
20195
20211
20232
20241
20252

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\") = 1986
    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 ('17027'))
  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 MIA87IA038Incident · No injuriesIncident investigationFinal reportBeech BE-95-55 · Ft. Lauderdale, FLThe private pilot suffered a massive heart attack in cruise flight shortly after take-off. The pilots wife who held an expired private pilots certificate took over and landed successfully. The pilot was pronounced deceased upon arrival at a local hospital. No…Nov 27, 1986 · N5WE · No damageNTSB MIA87LA008Accident · No injuriesLimited investigationFinal reportCessna 210 · Kissimmee, FLThe plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in…Oct 15, 1986 · N7395E · Substantial damageNTSB MIA86LA223Accident · No injuriesLimited investigationFinal reportBeech J35 · Bunnell, FLThe plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment.Aug 2, 1986 · N57UT · Substantial damageNTSB MIA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Hopewell, FLFlight experienced complete engine failure when crankshaft failed due to fatigue cracking of the crankshaft cheek between the number 1 and 2 rodbearing journal. During the subsequent forced landing the aircraft collided with trees due to the pilot not wanting…Jul 30, 1986 · N9620X · Substantial damageNTSB MIA86LA079Accident · No injuriesLimited investigationFinal reportBeech 55 · Ft. Myers, FLThe plt stated that he had experienced an electrical failure & because it was getting dark, he could not see the mechanical landing gear position indicator. He said that he performed a 'gump' check & verified that the gear handle was in the down position, but…Feb 15, 1986 · N163Q · Substantial damage