Skip to content

NTSB investigations: Cessna 172E, OH

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

19642026

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 ('2072412')) 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 ('2072412'))
  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 ('2072412'))
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 ATL87LA251Accident · No injuriesLimited investigationFinal reportCessna 172E · Lebanon, OHA witness rprtd the acft was hi & fast on final apch. The plt stated he landed the acft long & fast & was unable to stop on the remaining rwy. Subsequently, the acft impacted a ditch beyond the dep end of the rwy & the nose gear collapsed. Before the acft…Sep 6, 1987 · N3970S · Substantial damage NTSB ATL86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Clyde, OHThe acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…May 3, 1986 · N3960S · Substantial damage NTSB CHI84LA318Accident · No injuriesLimited investigationFinal reportCessna 172 · Urbana, OHThe pilot stated after the accident that he arrived at his flight planned destination 15 minutes early so he continued the flight an additional hour. The plt experienced an eng failure while on final apch to the rwy at the revised destination arpt. The plt…Jul 29, 1984 · N3891S · Substantial damage NTSB CHI84LA012Accident · No injuriesLimited investigationFinal reportCessna 172E · Cincinnati, OHThe acft collided wih a pole and mail boxes during a forced landing after fuel exhaustion. The pilot was unalbe to find blur ash arpt and asked for assistance from Cincinnati approach. When the arpt was located after over 6 hours of flt time,the acrt ran out…Oct 7, 1983 · N5728T · Substantial damage NTSB CHI83LA399Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Columbia Sta., OHAccording to the non-rated plt, he was on downwind to land when he applied carburetor heat, then the eng RPM began to decrease. He stated that he pushed the throttle forward, but got no response from the eng. He further stated that the acft continued to lose…Aug 30, 1983 · N3540S · Destroyed NTSB CHI83LA177Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Youngstown, OHThe pilot stated that during a landing, the left wing was caught by the wind and the aircraft drifted to the right. A go-around was initiated but the aircraft struck a runway light and a runway distance marker and nosed over.Apr 23, 1983 · N5527T · Destroyed NTSB CHI80FEG16Incident · No injuriesClosedCessna 172E · Chesapeake, OHJun 1, 1980 · N3673S · Minor damage NTSB CHI78FEI08Accident · Serious injuriesClosedCessna 172E · Louisville, OHDec 31, 1977 · N3586S · Substantial damage NTSB CHI73DEI36Accident · No injuriesClosedCessna 172E · N.Jackson, OHMar 16, 1973 · N5336T · Substantial damage NTSB CHI70DGD04Accident · No injuriesClosedCessna 172 · Ashtabula, OHFeb 4, 1970 · N5436T · Substantial damage NTSB CHI70F0380Accident · Serious injuriesClosedCessna 172 · Brookpark, OHNov 14, 1969 · N3688S · Destroyed NTSB CHI70D0382Accident · No injuriesClosedCessna 150 · Salem, OHOct 18, 1969 · N3683S · Substantial damage NTSB CHI70D0368Accident · No injuriesClosedCessna 172 · Canton, OHSep 10, 1969 · N5741T · Substantial damage NTSB CHI69F0405Accident · No injuriesClosedCessna 172 · Columbus, OHDec 28, 1968 · N186HP · Substantial damage NTSB CHI69A0013Accident · 5 fatalClosedCessna 172E · S.Bass Islnd, OHAug 4, 1968 · N3793S · Destroyed NTSB CHI66F0090Accident · Serious injuriesClosedCessna 172 · Indian Lake, OHJul 12, 1965 · N3023U · Destroyed NTSB CHI65F0123Accident · Serious injuriesClosedCessna 172E · Lecta, OHMay 4, 1965 · N3737S · Destroyed NTSB CHI65F0063Accident · No injuriesClosedCessna 172 · Lebanon, OHApr 3, 1965 · N5628T · Substantial damage NTSB CHI65D0085Accident · No injuriesClosedCessna 172 · Cleveland, OHMar 17, 1965 · N5557T · Substantial damage NTSB CHI65D0043Accident · No injuriesClosedCessna 172 · Elyria, OHMar 4, 1965 · N3023U · Substantial damage NTSB CHI65D0014Accident · No injuriesClosedCessna 172 · Youngstown, OHJan 21, 1965 · N5470T · Substantial damage NTSB UNK64X1419Accident · Minor injuriesClosedCessna 172E · Lancaster, OHApr 23, 1964 · N3702S · Substantial damage