NTSB investigations: Continental C145 series, 1982

6 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, 1982 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\") = 1982
    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 DEN83LA023Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Durango, COThe pilot landed at a private airstrip and lost control of aircraft in a crosswind. The aircraft departed the runway and collided with a ditch. The pilot believed he lost control of his aircraft because of the wet runway and strong crosswind.Nov 11, 1982 · N9164A · Substantial damageNTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.Jul 6, 1982 · N8220A · Substantial damageNTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.Jun 22, 1982 · N2741C · Substantial damageNTSB LAX82DA229Accident · No injuriesFinal reportCessna 170B · Pacoima, CAThe pilot reported that he landed on runway 12 with a slight crosswind from the right. After touchdown, the aircraft veered to the right, the left wingtip and the propeller struck the surface, and the plane nosed over.Jun 20, 1982 · N8151A · Substantial damageNTSB ANC82DAA04Accident · No injuriesFinal reportCessna 170 · Chicken, AKThe student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before…Jun 8, 1982 · N4593C · Substantial damageNTSB ANC82DA022Accident · No injuriesFinal reportCessna 170 · Poorman, AKAfter making a low pass over the runway and noting that it was plowed with berms on both sides and that there were bare patches on the runway the pilot elected to land. Shortly after touchdown the left ski encountered a bare spot on the frozen snow and ice…Mar 3, 1982 · N8177A · Substantial damage