Skip to content

NTSB investigations: Cessna 177, OH

32 cases on aircraft the registry lists as Cessna 177. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073704'))
  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.

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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 5, 2017 · N3225T · Substantial damage NTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.May 4, 2008 · N29650 · Substantial damage NTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.Sep 13, 2002 · N2916X · Substantial damage NTSB NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.Apr 30, 1997 · N2921X · Substantial damage NTSB NYC96FA178Accident · 1 fatalField investigationFinal reportCessna 177 · Youngstown, OHthe pilot's delay in aborting the landing, and his failure to attain adequate airspeed to fly out of ground effect, which resulted in a stall/mush and collision with the ground. Factors relating to the accident were: the pilot's improper recovery from a…Aug 31, 1996 · N2992X · Destroyed NTSB IAD96LA095Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Versailles, OHFuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.Jun 14, 1996 · N3197T · Substantial damage NTSB ATL87LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Brookville, OHThe plt reported a partial pwr loss at about 30 ft AGL during the initial takeoff climb. He elected to land straight ahead in a soft, plowed field. The acft nosed over during the landing. Post accident inspection revealed evidence of water in the fuel lines.Apr 18, 1987 · N2356Y · Substantial damage NTSB CHI85LA066Accident · No injuriesLimited investigationFinal reportCessna 177 · Cadiz, OHThe acft was damaged during a forced landing after the eng failed inflight. The plt stated that about 10 miles west of harrison airport the eng began sputtering & running rough. When unable to regain full power the plt attempted to glide to tapan airpark, a…Dec 8, 1984 · N2835X · Substantial damage NTSB CHI84LA147Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Kelleys Island, OHAccording to the plt, rotation occurred about 3/5 of the way down the gravel strip and the acft climbed to 20-30 ft when the power loss occurred. In an effort to maintain alt the nose attitude was increased and the tail of the acft struck the trees and then…Mar 30, 1984 · N30204 · Substantial damage NTSB CHI83LA390Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Cadiz, OHThe plt elected to takeoff on an upsloping rwy since the wind was favorable for its direction. However, the temp was 84 degs, the elevation was 1174 ft & there was a hill beyond the end of the rwy. Additionally, the acft was loaded to near its maximum gross…Aug 21, 1983 · N2835X · Destroyed NTSB CHI83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot took off with an estimate 4 hrs of fuel on board. While en route, he encountered headwinds that were stronger than expected. After about 3 hrs and 48 min of flight, he was still about 27 to 28 mi from his destination and diverted to the Dayton…Dec 25, 1982 · N3136T · Substantial damage NTSB CHI83FA050Accident · 1 fatalField investigationFinal reportCessna 177 · Medina, OHAt about 1430 EST, the pilot took off from freedom field, Medina, OH in VFR conditions. When he returned about 3 hrs later at dusk, the weather was estimated to be: 400 ft overcast, 3/4 mi visibility with fog. A flight instructor heard the plane fly over the…Dec 1, 1982 · N29528 · Destroyed NTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHDec 11, 1976 · N29380 · Destroyed NTSB CHI76FEG21Accident · No injuriesClosedCessna 177 · Kettering, OHAug 12, 1976 · N30139 · Destroyed NTSB CHI74DEI21Accident · Minor injuriesClosedCessna 177 · Perrysville, OHSep 27, 1973 · N3380T · Destroyed NTSB CHI73DEK22Accident · No injuriesClosedCessna 177 · Findlay, OHApr 30, 1973 · N30076 · Substantial damage NTSB CHI73FEK18Accident · No injuriesClosedCessna 177 · Johnstown, OHMar 23, 1973 · N2925X · Substantial damage NTSB CHI73DEI10Accident · No injuriesClosedCessna 177 · Strongsville, OHAug 26, 1972 · N2291Y · Substantial damage NTSB CHI73DEI09Accident · No injuriesClosedCessna 177 · Put-In-Bay, OHJul 24, 1972 · N30085 · Substantial damage NTSB CHI73FEI02Accident · Minor injuriesClosedCessna 177 · Wakeman, OHJul 1, 1972 · N3456T · Destroyed NTSB CHI72FEI01Accident · Serious injuriesClosedCessna 177 · Milan, OHJul 5, 1971 · N3335T · Destroyed NTSB CHI71FEK34Accident · Minor injuriesClosedCessna 177 · Ada, OHApr 25, 1971 · N3379T · Substantial damage NTSB CHI71FGD15Accident · Serious injuriesClosedCessna 177 · Painesville, OHSep 19, 1970 · N2936E · Destroyed NTSB CHI71FGD14Accident · Minor injuriesClosedCessna 177 · Northfield, OHAug 30, 1970 · N30037 · Destroyed NTSB CHI70FGA12Accident · No injuriesClosedCessna 177 · Batavia, OHJun 7, 1970 · N30239 · Substantial damage NTSB CHI70D0388Accident · Minor injuriesClosedCessna 177 · N.Phldelphia, OHSep 7, 1969 · N2969X · Substantial damage NTSB CHI70A0011Accident · 2 fatalClosedCessna 177 · Northfield, OHJul 27, 1969 · N29555 · Destroyed NTSB CHI70D0147Accident · No injuriesClosedCessna 177 · Swanton, OHJul 17, 1969 · N3206T · Destroyed NTSB CHI69D0418Accident · No injuriesClosedCessna 177 · Hillsboro, OHDec 18, 1968 · N3384T · Substantial damage NTSB CHI69F0299Accident · No injuriesClosedCessna 177 · Xenia, OHSep 27, 1968 · N2910X · Substantial damage NTSB CHI69D0143Accident · No injuriesClosedCessna 177 · Port Clinton, OHJul 22, 1968 · N2809X · Substantial damage NTSB CHI69D0052Accident · Minor injuriesClosedCessna 177 · Wellsville, OHJul 3, 1968 · N2315Y · Destroyed