Skip to content

NTSB investigations: Cessna 172L, OH

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

19722026

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 ('2072432')) 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 ('2072432'))
  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 ('2072432'))
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 ERA26LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zanesville, OHThe pilot’s failure to maintain clearance from a power line during an approach to land.Nov 24, 2025 · N7805G · Substantial damage NTSB CHI06CA182Accident · No injuriesData collectionFinal reportCessna 172L · Waterford, OHThe pilot's selection of unsuitable terrain for landing. The runway's downhill slope, the wet grass, the fence, and the embankment were factors.Jul 8, 2006 · N7805G · Substantial damage NTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.Oct 14, 2005 · N235U · 2 aircraft · Destroyed NTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.Dec 8, 1999 · N7565G · Substantial damage NTSB BFO94LA138Accident · No injuriesLimited investigationFinal reportCessna 172L · Springfield, OHThe pilot's premature liftoff, failure to attain adequate airspeed, and improper level off.Aug 12, 1994 · N19644 · Substantial damage NTSB NYC91LA206Accident · No injuriesLimited investigationFinal reportCessna 172L · Magnolia, OHThe pilot's improper starting procedure.Aug 11, 1991 · N7594G · Substantial damage NTSB CHI86LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Coldwater, OHThe plt flying at a low altitude during a civil air patrol training maneuver struck a 30-FT high power line with the nose gear. The acft then nosed over and impacted the ground.Nov 17, 1985 · N9896G · Destroyed NTSB CHI85LA282Accident · No injuriesLimited investigationFinal reportCessna 172L · Akron, OHThe acft contacted trees during a forced landing in a cemetery following a loss of pwr while on final apch at Akron fulton arpt. After the accident, 10 gallons of fuel were added to the acft and the eng operated normally when started. An A&P mechanic…Jul 7, 1985 · N7841G · Substantial damage NTSB CHI84LA208Accident · No injuriesLimited investigationFinal reportCessna 172L · Painesville, OHThe acft left the dry asphalt rwy, crossed a grassy area, went through a fence and killed a horse. The plt stated that after landing the airplane 'get pushed to rt of rwy.' Local winds were reported from 040 degs at 10 KTS. The plt had just recently purchased…May 27, 1984 · N19683 · Substantial damage NTSB CHI80FEI21Accident · Minor injuriesClosedCessna 172L · Wadsworth, OHMay 11, 1980 · N9840G · Substantial damage NTSB CHI77FEI32Accident · No injuriesClosedCessna 172 · Rittman, OHJul 17, 1977 · N7938G · Substantial damage NTSB CHI77FEI02Accident · No injuriesClosedCessna 172L · Stronsville, OHOct 11, 1976 · N7972G · Substantial damage NTSB CHI76FEI07Accident · Minor injuriesClosedCessna 172L · Grafton, OHAug 9, 1975 · N19613 · Destroyed NTSB CHI75FEI44Accident · No injuriesClosedCessna 172L · Wadsworth, OHApr 20, 1975 · N4293Q · Substantial damage NTSB CHI73FEI46Accident · No injuriesClosedCessna 172L · Kellys Is, OHJun 7, 1973 · N7296Q · Substantial damage NTSB CHI73DEJ30Incident · No injuriesClosedCessna 172 · Cleveland, OHFeb 27, 1973 · N4370Q · Minor damage NTSB CHI73FEG16Accident · Minor injuriesClosedCessna 172L · Batavia, OHJan 18, 1973 · N7566G · Substantial damage NTSB CHI73FEI15Accident · No injuriesClosedCessna 172 · Medina, OHOct 8, 1972 · N7805G · Substantial damage NTSB CHI72DEI47Accident · No injuriesClosedCessna 172 · Lake Milton, OHJun 4, 1972 · N9868G · Substantial damage NTSB CHI72FLQ26Accident · No injuriesClosedCessna 172L · Bowlng Green, OHJan 11, 1972 · N4392Q · Substantial damage