Skip to content

NTSB investigations: Cessna 172, OH

34 cases on aircraft the registry lists as Cessna 172. 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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.Aug 11, 2019 · N8928B · Substantial damage NTSB BFO95LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Wauseon, OHThe pilot's failure to obtain/maintain adequate altitude/clearance from obstacles during an attempted go-round. Related factors are the pilot's failure to attain the planned approach and the improper go-around procedures.Jun 23, 1995 · N6403B · Destroyed NTSB NYC93LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Marengo, OHThe pilot's inadequate visual lookout due to sunglare, which resulted in a tree strike on final approach.Oct 3, 1992 · N3980F · Substantial damage NTSB BFO92LA128Accident · No injuriesLimited investigationFinal reportCessna 172 · Groveport, OHThe pilot's inadequate preflight planning by selecting unsuitable soft terrain which resulted in a nose over during an aborted takeoff.Sep 7, 1992 · N6044A · Substantial damage NTSB CHI90DEK05Accident · Minor injuriesFinal reportCessna 172 · Urbana, OHWater contamination of the fuel, and the pilot's inadequate preflight, which resulted in loss of engine power.May 22, 1990 · N6195E · Substantial damage NTSB ATL89LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Galion, OHThe pilot's failure to retract the flaps prior to adding power for takeoff resulting in a premature lift-off, and the pilot's failure to maintian control of the airplane after lift-off which resulted in a stall/mush.Feb 1, 1989 · N8121B · Substantial damage NTSB ATL89LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Williamsburg, OHA defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.Jan 19, 1989 · N8774B · Substantial damage NTSB ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…Dec 24, 1988 · N8193B · Destroyed NTSB CHI88LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Moraine, OHWhile on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…Jul 7, 1988 · N7222W · 2 aircraft · Substantial damage NTSB ATL86LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kirkland, OHPilot had flown from wisconson to cape cod on Wednesday and was returning to Wisconsin on Sunday. He had departed provincetown on Sunday morning and stopped at hyannis due to weather. He then flew on to saratoga springs, NY with a stop at westover, arriving…Jul 7, 1986 · N7098A · Substantial damage NTSB CHI81FEI20Accident · Serious injuriesClosedCessna 172 · Akron, OHJun 4, 1981 · N6938A · Substantial damage NTSB CHI74FEK06Accident · Serious injuriesClosedCessna 172 · Caledonia, OHOct 6, 1973 · N7121T · Substantial damage NTSB CHI74FEG07Accident · No injuriesClosedCessna 172 · Forest Park, OHSep 1, 1973 · N7110A · Substantial damage NTSB CHI73AEK17Accident · No injuriesClosedCessna 172 · Lancaster, OHMar 11, 1973 · N4205F · Substantial damage NTSB CHI73FEG09Accident · Serious injuriesClosedCessna 172 · Montgomery, OHOct 25, 1972 · N4123F · Destroyed NTSB CHI73DEI18Accident · No injuriesClosedCessna 172 · Millersburg, OHSep 19, 1972 · N7107A · Substantial damage NTSB CHI72FEG28Accident · No injuriesClosedCessna 172 · Batavia, OHFeb 17, 1972 · N8572B · Substantial damage NTSB CHI72DEI09Accident · No injuriesClosedCessna 172 · Steubenville, OHJul 24, 1971 · N6812A · Substantial damage NTSB CHI70FGD27Accident · Serious injuriesClosedCessna 172 · Middle Bass, OHJun 19, 1970 · N4074F · Substantial damage NTSB CHI69D0611Accident · No injuriesClosedCessna 172 · Swanton, OHApr 9, 1969 · N7110A · Substantial damage NTSB CHI69F0512Accident · No injuriesClosedCessna 172 · Columbus, OHMar 6, 1969 · N6264E · Substantial damage NTSB CHI68D0356Accident · No injuriesClosedCessna 172 · Findlay, OHOct 8, 1967 · N6148E · Substantial damage NTSB CHI67D0518Accident · No injuriesClosedCessna 172 · Petersburg, OHFeb 12, 1967 · N8153B · Substantial damage NTSB CHI67F0084Accident · Minor injuriesClosedCessna 172 · Circleville, OHJul 4, 1966 · N6462B · Substantial damage NTSB CHI66D0431Accident · No injuriesClosedCessna 172 · Canton, OHNov 10, 1965 · N9170B · Substantial damage NTSB CHI66A0046Accident · 3 fatalClosedCessna 172 · West Salem, OHNov 7, 1965 · N7346A · Destroyed NTSB CHI66F0355Accident · No injuriesClosedCessna 172 · Delaware, OHOct 7, 1965 · N6430E · Substantial damage NTSB CHI66D0020Accident · No injuriesClosedCessna 172 · Cleveland, OHJun 26, 1965 · N16QB · Substantial damage NTSB CHI65F0169Accident · No injuriesClosedCessna 172 · Harrison, OHMay 19, 1965 · N6919A · Substantial damage NTSB UNK65X0742Accident · 4 fatalClosedCessna 172E · Kelleys Isld, OHNov 16, 1964 · N7758U · Destroyed NTSB UNK65X0562Accident · 1 fatalClosedCessna 172 · Springboro, OHNov 4, 1964 · N8158B · Destroyed NTSB UNK65X0223Accident · No injuriesClosedCessna 172 · Seville, OHOct 10, 1964 · N16QB · Substantial damage NTSB UNK64X2418Accident · Minor injuriesClosedCessna 172 · Ansonia, OHJun 21, 1964 · N5776A · Destroyed NTSB UNK64X0252Accident · 2 fatalClosedCessna 172 · Columbus, OHJan 15, 1964 · N8390B · Destroyed