OpenAirDocs.org

NTSB investigations: Cessna 170

8 cases on aircraft the registry lists as Cessna 170, where the first occurrence was “Loss of control - in flight”. 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

19882026

Where

Open the map

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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072302')
      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\" = 250))
  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 ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.Sep 28, 1998 · N3482C · Substantial damageNTSB CHI93LA342Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lexington, ILan inadequate climb airspeed by the pilot-in-command.Aug 28, 1993 · N3825V · DestroyedNTSB ANC92LA014Accident · No injuriesLimited investigationFinal reportCessna 170 · Whiskey Gulch, AKThe pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.Nov 7, 1991 · N2584V · Substantial damageNTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…Nov 25, 1990 · N4030V · Substantial damageNTSB DEN90FA155Accident · Serious injuriesField investigationFinal reportCessna 170 · Fillmore, UTThe pilot's failure to maintain airspeed which resulted in inadvertent stall.Jul 10, 1990 · N4068V · Substantial damageNTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.Jun 3, 1990 · N3944V · Substantial damageNTSB CHI88LA215Accident · No injuriesLimited investigationFinal reportCessna 170 · Boyceville, WIShortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft…Aug 21, 1988 · N3804V · Substantial damageNTSB FTW88LA128Accident · No injuriesLimited investigationFinal reportCessna 170 · Marble Falls, TXThe pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…Jul 4, 1988 · N2642V · Substantial damage