NTSB investigations: Cessna 172P, PA
20 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
| 1981 | 1 |
|---|---|
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2008 | 2 |
| 2016 | 1 |
| 2026 | 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\" = 'PA' 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" = 'PA' 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 ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.NTSB ERA16LA224Accident · No injuriesLimited investigationFinal reportCessna 172P · Honesdale, PAThe pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…NTSB OPS08IA012Incident · No injuriesIncident investigationFinal reportCessna 172 · Reading, PAThe tower local controller permitted an aircraft to conduct a low approach and another aircraft to land on a closed runway. Contributing to the incident were the arrival radar controller who failed to correct the local controller when advised an aircraft…NTSB NYC08CA220Accident · No injuriesData collectionFinal reportCessna 172P · Lancaster, PAThe student pilot's failure to maintain directional control during the landing rollout.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.NTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.NTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.NTSB NYC97LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Tioga, PAThe pilot's improper inflight decision to land downwind with an inoperative airspeed indicator, and his improper landing flare.NTSB NYC94LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Pottsville, PAThe pilot's failure to attain adequate airpseed, which resulted in a stall/mush and collision with a tree.NTSB NYC90LA080Accident · No injuriesLimited investigationFinal reportCessna CE-172P · Hollidaysburg, PAPilot factor in that he failed to ensure there was sufficient fuel on board to complete the flight. This resulted in an engine failure & subsequent forced landing.NTSB NYC88LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Freeport, PAThe plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the…NTSB NYC85FGM01Accident · Serious injuriesFinal reportCessna 172P · West Mifflin, PAAcft landed long with excessive speed. Plt attempted a go-around but was unable to obtain sufficient flying speed before reaching the end of the rwy which drops off into a steep embankment. When the acft reached the end of the rwy ground effect was lost and…NTSB NYC84LA119Accident · No injuriesLimited investigationFinal reportCessna C172 · Corry, PAThe pilot stated that he landing on runway 32 and on initial touchdown the nosewheel contacted the runway after the right main gear, causing the aircraft to ascend back into the air. The aircraft 'porpoised', the left wing tip dipped and collided with a…NTSB NYC83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Latrobe, PAThe acft ran off the runway when the student pilot attempted to close a window during the takeoff roll. As the acft left the runway the nose wheel collapsed rearward and the prop, main gear and fuselage were damaged. The pilot received minor injuries.NTSB NYC83LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Collegeville, PAThe acft made a hard landing after which it swerved off the runway and collided with trees. The pilot was on a solo instructional flight and was landing on runway 27. As the acft touched down hard it bounced and left the confines of therunway. The acft…NTSB NYC83LA006Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, PAReportedly, the pilot made his landing approach too high and too fast. After rolling an undetermined distance, he elected to go-around. According to the passenger, the pilot had started a climb when he banked the aircraft and retracted the flaps. Reportedly,…NTSB NYC82DA122Accident · No injuriesFinal reportCessna 172 · Monongahela, PAThe pilot was on a flight from rostraver, PA to deerfield, oh and return. Before taking off from rostraver, he estimated there was 25 gal of fuel on board. At deerfield, he estimated there was 15 gallons remaining (12 gal usable). But that he would need only…NTSB NYC81FGT09Accident · Minor injuriesClosedCessna 172P · Brogue, PA