Skip to content

NTSB investigations: Cessna 177, IN

18 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

19672026

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN19LA223Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Elkhart, INAn inadvertent engine start of the airplane and subsequent takeoff without the pilot on-board for reasons that could not be determined based on available evidence.Jul 14, 2019 · N29516 · Substantial damage NTSB CEN18LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Wayne, INThe failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.May 15, 2018 · N9058F · Substantial damage NTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.Jan 22, 2012 · N3435T · Substantial damage NTSB CHI99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greencastle, INthe pilot operating with known deficiencies in equipment and the fuel cap that disengaged. Factors were the wet grass, and muddy terrain conditions.Apr 24, 1999 · N3270T · Substantial damage NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.Dec 9, 1991 · N2961X · Substantial damage NTSB CHI91LA153Accident · No injuriesLimited investigationFinal reportCessna 177 · Decatur, INFailure to obtain airspeed for positive lift off and climb. Factors related to the accident were a grass/sod runway and a high density altitude.May 12, 1991 · N3345T · Substantial damage NTSB CHI88LA151Accident · No injuriesLimited investigationFinal reportCessna 177 · Lowell, INThe student pilot was on final approach for landing when the aircraft began to drift to the left of the runway. The pilot decided to go-around and added full power, pushed the carburetor heat in and retracted the flaps to '1/2'. According to the pilot he…Jul 3, 1988 · N30238 · Substantial damage NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.Jan 23, 1986 · N3244T · Substantial damage NTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…May 5, 1984 · N2959X · Substantial damage NTSB CHI79DEX39Accident · No injuriesClosedCessna 177 · Indianapolis, INAug 30, 1979 · N3108T · Substantial damage NTSB CHI79DET16Accident · No injuriesClosedCessna 177 · Churubusco, INFeb 10, 1979 · N2605Q · Substantial damage NTSB CHI78FET38Accident · No injuriesClosedCessna 177 · Fort Wayne, INSep 24, 1978 · N2605Q · Substantial damage NTSB CHI75FEA04Accident · No injuriesClosedCessna 177 · Mooresville, INJul 26, 1974 · N2269Y · Substantial damage NTSB CHI71FET30Accident · No injuriesClosedCessna 177 · South Bend, INJun 21, 1971 · N30100 · Substantial damage NTSB CHI70FBA17Accident · No injuriesClosedCessna 177 · Center Valley, INApr 26, 1970 · N2391Y · Substantial damage NTSB CHI69D0633Accident · No injuriesClosedCessna 177 · Austin, INMay 2, 1969 · N2929X · Substantial damage NTSB CHI69F0479Accident · Minor injuriesClosedCessna 177 · Shelbyville, INJan 13, 1969 · N2254Y · Substantial damage NTSB CHI68F0394Accident · No injuriesClosedCessna 310 · South Bend, INOct 14, 1967 · N6777T · Substantial damage