Skip to content

NTSB investigations: Cessna 172G, OH

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

19662026

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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.Jan 8, 2022 · N3964L · Substantial damage NTSB NYC01LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHThe pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.Oct 14, 2000 · N4352L · Substantial damage NTSB BFO95LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Put-In-Bay, OHThe pilot's delay in aborting the landing after selecting the wrong runway. Factors relating to the accident were: garbled radio transmissions on the UNICOM frequency, and the resultant tailwind for landing.Aug 26, 1995 · N3680L · Substantial damage NTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…Jun 8, 1987 · N3644L · Substantial damage NTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…Dec 23, 1986 · N380LA · Substantial damage NTSB CHI85FA316Accident · 1 fatalField investigationFinal reportCessna 172G · Plain City, OHThe plt had just taken off from his pvt strip for the fourth flt of the day when witnesses heard the eng quit. The acft had been flown 3.4 hrs since the last refueling. The acft was being operated on a mixture of avgas and automotive fuel with no STC. The…Jul 29, 1985 · N4202L · Destroyed NTSB CHI81FEG02Accident · No injuriesClosedCessna 172 · Springfield, OHNov 30, 1980 · N6049R · Substantial damage NTSB CHI78FEK10Accident · No injuriesClosedCessna 172G · Plain City, OHMar 7, 1978 · N4202L · Substantial damage NTSB CHI77FEG01Accident · Serious injuriesClosedCessna 172 · Portsmouth, OHOct 3, 1977 · N6050R · Substantial damage NTSB CHI76FEK27Accident · No injuriesClosedCessna 172G · London, OHAug 20, 1976 · N5786R · Substantial damage NTSB CHI72FEG04Accident · Minor injuriesClosedCessna 172 · Cincinnati, OHAug 8, 1971 · N4317L · Substantial damage NTSB CHI71DEI65Accident · No injuriesClosedCessna 172 · Warren, OHJun 30, 1971 · N5904R · Substantial damage NTSB CHI70D0233Accident · Minor injuriesClosedCessna 172G · Coshocton, OHAug 30, 1969 · N3883L · Substantial damage NTSB CHI69D0672Accident · No injuriesClosedCessna 172G · Columbus, OHJun 7, 1969 · N4322L · Substantial damage NTSB CHI69D0251Accident · No injuriesClosedCessna 172 · New Lexingtn, OHSep 22, 1968 · N380LA · Substantial damage NTSB CHI69F0093Accident · No injuriesClosedCessna 172 · Versailles, OHJul 10, 1968 · N1315F · Substantial damage NTSB CHI68D0531Accident · No injuriesClosedCessna 172 · Painesville, OHNov 25, 1967 · N3906L · Substantial damage NTSB CHI68D0364Accident · No injuriesClosedCessna 172 · Lodi, OHSep 4, 1967 · N4141L · Substantial damage NTSB CHI68D0188Accident · No injuriesClosedCessna 172 · New Phila., OHJul 18, 1967 · N1383F · Substantial damage NTSB CHI67D0186Accident · No injuriesClosedCessna 172 · Greenville, OHSep 11, 1966 · N5935R · Substantial damage NTSB CHI67A0038Accident · 4 fatalClosedCessna 172 · South Russel, OHSep 11, 1966 · N4616L · Destroyed NTSB CHI67F0201Accident · Serious injuriesClosedCessna 172G · Thompson, OHJun 29, 1966 · N4237L · Substantial damage NTSB CHI66D0754Accident · Minor injuriesClosedCessna 152 · Leveland, OHMay 5, 1966 · N3609L · Substantial damage