Skip to content

NTSB investigations: Cessna 172S, OH

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

19792026

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 ('2072439', '2072442')) 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 ('2072439', '2072442'))
  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 ('2072439', '2072442'))
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 WPR18LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mount Vernon, OHAn in-flight fuel-fed fire from an unknown source for reasons that could not be determined due to the extensive fire damage to the airplane.Jul 28, 2018 · N785SP · Destroyed NTSB GAA18CA425Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe student pilot’s improper landing flare, which resulted in a hard landing.Jul 13, 2018 · N12064 · Substantial damage NTSB GAA18CA150Accident · No injuriesData collectionFinal reportCessna 172 · Kent, OHA deer collided with aircraft during landing at night.Mar 7, 2018 · N103KS · Substantial damage NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.Aug 9, 2017 · N5274Q · Substantial damage NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…Jun 11, 2017 · N33FM · Substantial damage NTSB GAA15CA237Accident · No injuriesData collectionFinal reportCessna 172 · Springfield, OHThe pilot's improper pitch control during landing, which resulted in a hard landing.Aug 23, 2015 · N691SP · Substantial damage NTSB CEN09CA509Accident · No injuriesData collectionFinal reportCessna 172S · Bluffton, OHThe student pilot's failure to compensate for wind conditions and maintain aircraft control during the landing.Aug 6, 2009 · N6186T · Substantial damage NTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.Sep 29, 2007 · N2327J · Substantial damage NTSB CHI06CA183Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, OHThe pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.Jul 9, 2006 · N335SP · Substantial damage NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.Sep 6, 2004 · N809SP · Substantial damage NTSB IAD03CA071Accident · No injuriesData collectionFinal reportCessna 172 · Cleveland, OHThe pilot's improper flare, which resulted in a hard landing.Aug 19, 2003 · N229ME · Substantial damage NTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.Mar 27, 2003 · N613SP · Substantial damage NTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.Dec 26, 2002 · N782SP · Substantial damage NTSB CHI79FEI22Accident · No injuriesClosedN American SNJ-4 · Painesville, OHMay 6, 1979 · N5278N · Substantial damage