NTSB investigations: Cessna 172P, OH
26 cases on aircraft the registry lists as Cessna 172P. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1991 | 3 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2008 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072436'))
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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN14CA274Accident · No injuriesData collectionFinal reportCessna 172P · Bluffton, OHThe student pilot's failure to maintain aircraft control, which resulted in a hard landing.NTSB CEN11LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHThe partial loss of engine power due to carburetor icing and the pilot’s delayed use of carburetor heat and failure to attain the proper touchdown point on the runway during the precautionary landing.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CHI08CA159Accident · No injuriesData collectionFinal reportCessna 172P · Athens, OHThe student pilot's failure to maintain directional control during landing. A factor contributing to the accident was a nose wheel vibration.NTSB CHI08IA113Incident · No injuriesIncident investigationFinal reportCessna 172P · Kelley's Island, OHThe pilot's failure to maintain aircraft control during landing. Contributing to the accident were the pilot's selection of the wrong runway and a tailwind.NTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.NTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.NTSB NYC91LA210Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sandusky, OHThe pilot initiated an emergency landing when the engine RPM went to zero due to a broken tachometer cable. He did not attain the proper touchdown point and overran the end of the runway.NTSB NYC91LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe instructor pilot's failure to maintain control of the airplane during landing in a strong crosswind.NTSB NYC91FA055Accident · 1 fatalField investigationFinal reportCessna 172P · Rattlesnake Isl, OHThe cfi's delayed decision to execute a go-around from a long landing and subsequent failure to obtain/maintain flying speed.NTSB CHI90LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Middletown, OHThe inability to establish a sufficient climb after takeoff. Contributing to the accident was the pilot's lack of total experinece in this type of aircraft.NTSB ATL89LA183Accident · No injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe pilot's improper go-around procedure of fully retracting the flaps which resulted in the airplane mushing into trees. Contributing factor(s) was: a misjudgement of flare height above the runway and failure to remove the carburetor heat which may have…NTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…NTSB ATL88LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Wakeman, OHThe 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…NTSB ATL88LA062Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHAt 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy…NTSB ATL87DEI11Accident · No injuriesFinal reportCessna 172P · Stow, OHThe pilot flared too high on landing and the aircraft bounced on touchdown. The pilot did not use the proper technique to recover from the bounced landing and lost control of the aircraft. The aircraft departed from the runway and struck two taxi lights and a…NTSB ATL87LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172P · East Liverpool, OHRwy repair was in progress. The rwy was closed & battery powered lights were left to mark a 5 inch deep ditch that crossed the runway. Arpt & rwy lights were left off. The FBO continued to rent acft for operations from the arpt. The plt departed on a 28 mi…NTSB CHI85LA350Accident · No injuriesLimited investigationFinal reportCessna C-172P · Zanesville, OHPlt aborted takeoff from taxiway when he realized that he as not on rwy. Plt stated he was confused by taxiway marking & he believes taxiway arrows are misleading.NTSB CHI85LA250Accident · No injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft collided with a fence during landing the wind was from 230 degrees at 14 KTS and the landg was on rwy 28 the plt said that may be she would have had better control with less than full flaps.NTSB CHI85LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Phillipsburg, OHDuring a night VFR approach to a strange airport the acft struck power lines located one-half mile from the end of the rwy. The plt stated that she was unaware of the wires & was not aware that her acft had collided with them until her forward progress was…NTSB CHI84LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHNose gear collapsed during hard, flat landing.NTSB CHI84LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe student pilot, with an instructor pilot, were practicing touch & go landings. On the approach, the student allowed the speed to decrease, the acft stalled and landed hard and bounced back in the air. The student pilot added power to go around but did not…NTSB CHI84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft landed in a plowed field during an off arpt forced landing after power loss in the traffic pattern for landing. The arpt manager reported that when he reached the acft the carburetor heat was off. The pilot said she thought she usedit but was not…NTSB CHI83LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Cincinnati, OHThe student pilot touched down on runway 06, bounced, the nose gear collapsed and the pilot loss direction control. The aircraft nosed over.