Skip to content

NTSB investigations: Cessna 172F, OH

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

19652026

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 ('2072414')) 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 ('2072414'))
  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 ('2072414'))
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 CEN20LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Harrison, OHA total loss of engine power during approach to land due to carburetor icing during a simulated engine failure, which resulted in impact with trees.Dec 19, 2019 · N5406R · Substantial damage NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.Apr 8, 2017 · N88470 · 2 aircraft · Substantial damage NTSB CEN11LA388Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ironton, OHThe total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 28, 2011 · N5663R · Substantial damage NTSB NYC93LA010Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Wash. Ct. House, OHAn inadvertent stall after the pilot failed to attain flying speed due to a premature liftoff.Oct 7, 1992 · N8849U · Substantial damage NTSB CHI90LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Millersburg, OHFailure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.Jun 13, 1990 · N7955U · Substantial damage NTSB CHI86LA003Accident · No injuriesLimited investigationFinal reportCessna 172F · Canton, OHThe acft overran the rwy and collided with wires and a pole during landing. The student plt stated that he was too fast and landed long during the calm wind landing. He also stated he should have used more flaps.Oct 3, 1985 · N8347U · Substantial damage NTSB CHI85FEI02Accident · Serious injuriesFinal reportCessna 172F · Akron, OHThe acft contacted trees during a night forced landing following a loss of pwr. State patrol personnel reported there was no sign of fuel on board the acft at the accident site. The eng was test run after the accident, during which time it functioned normally.Apr 20, 1985 · N5608R · Substantial damage NTSB CHI84LA341Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Delaware, OHAfter being airborne for aprx 20 min the plt landed, taxied to the end of the strip, and departed again. At about 300 ft AGL the power loss occurred. Investigation of the wreckage revealed 3 qts of oil in the eng with no apparent oil leaks, a combination of…Aug 9, 1984 · N8333U · Substantial damage NTSB CHI82FEK04Accident · Minor injuriesClosedCessna 172 · Norwich, OHDec 30, 1981 · N7999U · Substantial damage NTSB CHI81FEI22Accident · Minor injuriesClosedCessna 172 · Swanton, OHJun 26, 1981 · N8584V · Substantial damage NTSB CHI75ACO57Accident · 1 fatalClosedCessna 172F · Wilmington, OHFeb 16, 1975 · N8466U · Destroyed NTSB CHI73FEI37Accident · Serious injuriesClosedCessna 172F · Swanton, OHApr 7, 1973 · N8472U · Substantial damage NTSB CHI73DEI28Accident · No injuriesClosedCessna 172 · Elyria, OHFeb 13, 1973 · N8605U · Substantial damage NTSB CHI72FEG41Accident · 1 fatalClosedCessna 172F · So.Webster, OHJun 17, 1972 · N5494R · Destroyed NTSB CHI72DEI42Accident · Serious injuriesClosedCessna 172 · Petersburg, OHMay 18, 1972 · N8251U · Destroyed NTSB CHI71FEK38Accident · No injuriesClosedCessna 172F · Cambridge, OHMay 29, 1971 · N5660R · Substantial damage NTSB CHI68D0782Accident · No injuriesClosedCessna 172 · Cincinnati, OHMay 31, 1968 · N8630U · Substantial damage NTSB CHI68D0518Accident · Minor injuriesClosedCessna 172 · Painesville, OHNov 10, 1967 · N5465R · Substantial damage NTSB CHI67D0616Accident · No injuriesClosedCessna 172 · Lodi, OHApr 16, 1967 · N8834U · Substantial damage NTSB CHI67D0547Accident · No injuriesClosedCessna 172 · Youngstown, OHFeb 12, 1967 · N5534R · Substantial damage NTSB CHI66D0696Accident · No injuriesClosedCessna 172 · New London, OHApr 3, 1966 · N5489R · Substantial damage NTSB CHI66D0562Accident · No injuriesClosedCessna 172 · Mt Vernon, OHFeb 9, 1966 · N5660R · Substantial damage NTSB CHI66F0340Accident · No injuriesClosedCessna 172 · Findlay, OHSep 29, 1965 · N8854U · Substantial damage NTSB CHI66D0315Accident · No injuriesClosedCessna 172 · Willoughby, OHSep 1, 1965 · N5592R · Substantial damage NTSB CHI66D0161Accident · No injuriesClosedCessna 172F · Danville, OHAug 14, 1965 · N7870U · Substantial damage NTSB CHI65D0077Accident · No injuriesClosedCessna 172 · Cleveland, OHApr 9, 1965 · N7861U · Destroyed