NTSB investigations: Continental C145 series, 1986

5 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “Loss of control - on ground/water”. 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 C145 series, 1986 per year, 1982–2026: 126 cases
19826
198314
19846
19853
19865
198710
19883
19893
19906
19914
19924
19934
19942
19953
19967
19977
19989
19995
20004
20011
20024
20032
20043
20054
20064
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\") = 1986
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012')
      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\" = 260))
  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 ANC86LA091Accident · No injuriesLimited investigationFinal reportCessna 170A · Tyonek, AKThe relatively inexperienced private pilot attempted to land his airplane on a gravel beach as the tide was receding. He failed to maintain directional control and the airplane was substantially damaged in the ensuing ground loop.Jun 27, 1986 · N9033A · Substantial damageNTSB ANC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 15 AC Sedan · Neal Lake, AKAccording to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was…Jun 9, 1986 · N1450H · Substantial damageNTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…May 4, 1986 · N66F · Substantial damageNTSB ANC86LA040Accident · No injuriesLimited investigationFinal reportCessna 170-B · Whittier, AKThe pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back.Mar 22, 1986 · N1999C · Substantial damageNTSB MKC86LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Alliance, NEThe plt had just completed a biennial flight review in Alliance, Nebraska and was returning to land on his ranch property south of Alliance. Wind rpts fm the Alliance airport, and the FAA flight service station in scottsbluff, indicated winds generally fm the…Feb 21, 1986 · N3400C · Substantial damage