Skip to content

NTSB investigations: Cessna 172M, IN

37 cases on aircraft the registry lists as Cessna 172M. 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

19732026

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 ('2072418')) 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 ('2072418'))
  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 ('2072418'))
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 CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…Sep 16, 2026 · N9909Q · Substantial damage NTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · Destroyed NTSB CEN17LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hobart, INThe pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.Jan 6, 2017 · N80374 · Substantial damage NTSB CEN14CA155Accident · No injuriesData collectionFinal reportCessna 172M · South Bend, INThe pilot involved and the phase of flight when the damage was incurred were not determined.Feb 26, 2014 · N9801V · Substantial damage NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.Jan 28, 2004 · N70256 · Substantial damage NTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.Sep 11, 1999 · N172DJ · Substantial damage NTSB CHI98LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkhart, INthe pilot's disorientation that led him to believe he was on the active runway. A factor was the pilot's inattentiveness.May 7, 1998 · N8994V · Substantial damage NTSB CHI98LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Salem, INthe pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…Nov 20, 1997 · N92042 · Substantial damage NTSB CHI96LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Terre Haute, INthe pilot's improper planning/decision, which resulted in his inadequate compensation (or inability to compensate) for the wind condition. The high/gusty wind condition was a related factor.Apr 25, 1996 · N18HZ · Substantial damage NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.Mar 5, 1996 · N21662 · Substantial damage NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.Jun 22, 1989 · N13652 · Substantial damage NTSB CHI88DEX04Accident · No injuriesFinal reportCessna 172M · Alexandria, INAircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…Apr 25, 1988 · N80269 · Substantial damage NTSB CHI87LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Shelbyville, INThe plt's original destn was lexington, KY, however between bluefield, KY and lexington, he amended his destn to indianapolis, IN. The plt stated that fuel consumption was calculated as 7.1 gph, but he did not take into consideration the Cessna 172 time/fuel…Mar 26, 1987 · N19984 · Substantial damage NTSB CHI85LA243Accident · No injuriesLimited investigationFinal reportCessna 172 M · Decatur, INThe pilot landing rnwy 36 winds were 210 degrees, 12 knots gusts 18 knots stalled out high onthe wet on the wet sod runway the nose wheel dug in and then broke off the acft then nosed over inverted.Jun 16, 1985 · N8954V · Substantial damage NTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…May 28, 1982 · N2986U · 2 aircraft · Substantial damage NTSB CHI82DA094Accident · No injuriesFinal reportCessna 172 · Clarksville, INThe pilot reported that the wind was blowing at 12 knots when he took off on a local flight. However, when he returned to land, it was from 270 degrees at about 30 knots. While landing on runway 18, the aircraft veered off the left side of the runway into…Mar 21, 1982 · N9131H · Substantial damage NTSB CHI82FA007Accident · 4 fatalClosedCessna 172 · Kokomo, INOct 22, 1981 · N21766 · Destroyed NTSB CHI80FEX36Accident · No injuriesClosedCessna 172M · Brownsburg, INSep 9, 1980 · N20095 · Substantial damage NTSB CHI80FET23Accident · Minor injuriesClosedCessna 172M · Woodburn, INAug 10, 1980 · N9050H · Substantial damage NTSB CHI80FEX20Accident · No injuriesClosedCessna 172M · Bloomington, INJun 12, 1980 · N61548 · Substantial damage NTSB CHI80FET03Accident · No injuriesClosedCessna 172M · Mentone, INNov 13, 1979 · N5111Q · Substantial damage NTSB CHI79DEX40Accident · No injuriesClosedCessna 172 · Delphi, INAug 30, 1979 · N5230R · Substantial damage NTSB CHI79DEX30Accident · Minor injuriesClosedCessna 172 · Anderson, INJun 13, 1979 · N80519 · Substantial damage NTSB CHI79FET07Accident · No injuriesClosedCessna 172M · Gary, INDec 11, 1978 · N12619 · Substantial damage NTSB CHI78DEX12Accident · No injuriesClosedCessna 172 · Kokomo, INApr 11, 1978 · N9638H · Substantial damage NTSB CHI77FEX36Accident · Serious injuriesClosedCessna 172M · Spencer, INJul 4, 1977 · N19798 · Destroyed NTSB CHI77DEX31Accident · No injuriesClosedCessna 172 · Boonville, INMay 29, 1977 · N9688V · Substantial damage NTSB CHI77FET09Accident · No injuriesClosedCessna 172M · Kendallville, INFeb 19, 1977 · N12989 · Substantial damage NTSB CHI77FEX11Accident · No injuriesClosedCessna 172M · Elwood, INFeb 5, 1977 · N1437U · Substantial damage NTSB CHIMMFET05Accident · No injuriesClosedCessna 172M · Hobart, INNov 17, 1976 · N21893 · Substantial damage NTSB CHI77FA001Accident · 1 fatalClosedCessna 172M · Hagerstown, INOct 2, 1976 · N6945H · Destroyed NTSB CHI75FEA15Accident · No injuriesClosedCessna 172M · Greenwood, INMar 19, 1975 · N5091R · Substantial damage NTSB CHI75DET14Accident · No injuriesClosedCessna 172I · Michigan City, INJan 1, 1975 · N20227 · Substantial damage NTSB CHI74DEA24Accident · No injuriesClosedCessna 172 · Shelbyville, INJan 1, 1974 · N20026 · Substantial damage NTSB CHI74DEA19Accident · No injuriesClosedCessna 172 · Terre Haute, INNov 7, 1973 · N4423Q · Substantial damage NTSB CHI73DEA34Accident · No injuriesClosedCessna 172 · Mt.Vernon, INMay 20, 1973 · N19984 · Substantial damage NTSB CHI73AEA30Accident · Minor injuriesClosedCessna 172M · Lafayette, INMar 30, 1973 · N20644 · Substantial damage