Cessna 172P
NTSB investigations · 844
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 NYC83LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Bridgeport, CTAfter practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane…NTSB FTW83LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Katy, TXDuring landing the nose wheel contacted a 12 inch rice field type mud dam & the acft flipped over.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.NTSB LAX83LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Dateland, AZDuring takeoff, the pilot was using the right side of a private strip to avoid an area of mud. At lift-off speed, the right wing tip struck a power pole near the right side of the runway and veered toward an irrigation ditch. The pilot was able to clear over…NTSB ATL83FKM01Accident · 1 fatalFinal reportCessna 172P · Near Maider, NCThe pilot crashed into trees 6 miles east of maiden, NC in deteriorating weather. Witnesses described the weather as rainy and foggy in the area of crash. Some heard the aircraft flying low before colliding with trees. The pilot was off course for statesville…NTSB LAX83LA027Accident · No injuriesLimited investigationFinal reportCessna 172 · Antioch, CAThe pilot stated that he came in high and fast, with only 20 degrees of flaps on his second landing attempt. Because of hilly terrain, the pilot elected to land long rather than execute a go-around. The aircraft overran the runway, rolled into a ditch and…NTSB DEN83FTI02Accident · 2 fatalFinal reportCessna 172P · Dillon, MIThe pilot and three passengers departed Dillon, mt at about 0740 MDT to scout for elk in preparation for hunting the next day. According to a passenger, they flew directly to a mountain area about 30 miles away where they spotted some elk. He said that while…NTSB MKC83LA011Accident · No injuriesLimited investigationFinal reportCessna 172PII · Hutchinson, KSPilot made three go-arounds because of gusty winds. While taxiing to tiedown downwind the wind blew the aircraft over. Winds gusting to 25 KTS.NTSB NYC83LA008Accident · No injuriesLimited investigationFinal reportCessna 172P · Grahamsville, NYThe pilot and two passengers departed on a local sightseeing flight with full fuel tanks. About one hour after takeoff, the pilot flew over the passengers' house to take pictures. While a passenger was photographing the house, the pilot's attention was…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 ATL83FKW01Accident · 2 fatalFinal reportCessna 172P · Gallatin, TNCessna 172P, N5313K crashed into a densely wooded area during the initial portion of cross-country flight. The pilot and his wife were killed but an infant son survived. Weather was not a factor.NTSB DEN82DA204Accident · No injuriesFinal reportCessna 172 · Rock Springs, WYAccording to the pilot, a strong gust of wind lifted the aircraft during the landing and power was applied for a go-around. Another gust of wind forced the aircraft off the runway into the dirt next to the runway. When the aircraft departed the runway, the…NTSB FTW82DA361Accident · No injuriesFinal reportCessna 172P · Plainview, TXWhile receiving traffic advisories enroute to Plainview, the plt of the C-172 was given the traffic advisory freq for hale county arpt as 120.7. However the plt copied 127.7 & reached ftw center instead. The plt made no further attempts to obtain the correct…NTSB ANC82DAG46Accident · No injuriesFinal reportCessna 172 · Quinhagak, AKThe pilot reported that he landed on a gravel bar about 900 ft long with a passenger to go fishing. Later, he took off to the west with a slight head wind. Near the end of the gravel bar was a tree with branches sticking out of the water. As the pilot took…NTSB FTW82DA348Accident · No injuriesFinal reportCessna 172P · Albuquerque, NMThe student pilot lost control of the aircraft after a bounced landing. The aircraft ran off the side of the runway, encountered sandy terrain, and was damaged. The density altitude was about 7000 ft.NTSB CHI82DA277Accident · Minor injuriesFinal reportCessna 172P · Bruce, WIThe pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and…NTSB CHI82DA251Accident · Serious injuriesFinal reportCessna 172P · Washington Island, WIDuring arrival, the pilot made an approach to runway 14 for a night landing. After flaring to land, the aircraft was observed to float. The pilot stated that he had come in high, and during a go-around, the aircraft did not seem to climb properly, then…NTSB FTW82DA248Accident · No injuriesFinal reportCessna 172P Robertson Stol · Fort Worth, TXThe aircraft was equipped with a robertson stol kit. After operating the aircraft in slow flight about 1/2 hr, the pilot elected to land. The approach was flown at 45 KTS with a 500 ft/min sink rate. Power was added to arrest the sink rate just before…NTSB ATL82FA164Accident · Serious injuriesField investigationFinal reportCessna 172P · Asheville, NCThe flt reportedly involved mountain flying techniques. The student observed that the acft was not climbing normally & the CFI suggested they slow to 70K. The student started a turn toward a wide valley but the CFI urged him to continue toward the mtns which…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 NYC82DA112Accident · No injuriesFinal reportCessna 172P · Greenville, METhe pilot reported that during takeoff, there was a partial loss of engine power after the float plane had climbed about 200 to 300 ft. carburetor heat was applied, but there was no immediate effect. The pilot reported that after the plane started to settle,…NTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…NTSB ATL82DA143Accident · No injuriesFinal reportCessna 172P · Jonesboro, GAThe pilot stated that after applying brakes on landing roll the aircraft began to hydroplane on water that was on the runway. He elected to raise the flaps and apply full power in a attempt to go-around but was unable to clear trees off the end of the runway.NTSB FTW82DA184Accident · No injuriesFinal reportCessna 172P · Las Cruces, NMThe student pilot reported that during landing, the airspeed was too high. Reportedly, the aircraft touched down hard on all three gear, propoised, and subsequently, the plane was damaged. The wind was reported as light and variable.NTSB NYC82FA091Accident · Serious injuriesField investigationFinal reportCessna 172P · Sanford, MEA Piper PA-28, N81029, and a Cessna 172P, N53442, were approaching to land on runway 14, when they collided about 1000 ft from the threshold. The pilot of the Piper stated that he had entered the traffic pattern and began to explain the mechanics of the…NTSB FTW82DA233Accident · No injuriesFinal reportCessna 172P · Chandeleur Isla, LAWhile on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to…NTSB SEA82DA062Accident · No injuriesFinal reportCessna 172N · Lisabuella, WAThe pilot landed on a freshly mowed, grass runway. He reported that he had a left crosswind at 10 gusting 15 knots. The aircraft touched down at about 1/3 of the way down the runway. About 450 ft from the departure end, the brakes were applied. However, the…NTSB NYC82DA074Accident · No injuriesFinal reportCessna 172 · Morristown, NJThe student pilot proceeded to the Morristown municipal airport to practice touch and go landings. He stated that during his first touch and go, the right wing picked up. He initiated a go-around to correct the problem. However, during the go-around, a wing…NTSB FTW82DA121Accident · Minor injuriesFinal reportCessna 172P · Albuquerque, NMThe aircraft with a full load at a high density altitude (7800 feet) failed to climb. Upon turning downwind at low altitude the aircraft appeared to stall and collide with the ground.NTSB SEA82DA023Accident · No injuriesFinal reportCessna 172P · Sinclair Island, WAThe airport was a privately owned strip approximately 1200 ft in length. About the last 25 percent of runway 33 was angled approximately 30 degrees to the right. Tth runway was considered unidirectional with landings normally made to the north/northwest and…NTSB LAX82DA056Accident · No injuriesFinal reportCessna 172 · Big Bear, CAThe pilot stated that during landing she flared the airplane and touched down hard. On the third bounce she added power for a go-around. The plane drifted to the left, collided with a snowbank and flipped over.NTSB FTW82FA004Accident · 2 fatalClosedCessna 172P · Flat, TXNTSB NYC81FGT09Accident · Minor injuriesClosedCessna 172P · Brogue, PANTSB CHI81FER48Accident · No injuriesClosedCessna 172P · Thief River Fa, MNNTSB MIA81FA089Accident · 2 fatalClosedCessna 172P · Hollister, FLNTSB MIA81DLA27Accident · No injuriesClosedCessna 172 · Keystone Hgts, FLNTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GANTSB FTW81DQG21Accident · No injuriesClosedCessna 172P · Paducah, TXNTSB CHI81DEP12Accident · No injuriesClosedCessna 172P · New Glarus, WINTSB ATL81FA048Accident · 1 fatalClosedCessna 172P · Woodbury, TNNTSB ATL81FID05Accident · No injuriesClosedCessna 172 · Tangier Island, VANTSB DEN81FTC05Accident · No injuriesClosedCessna 172 · Rock Springs, WYNTSB NYC73FFA25Accident · No injuriesClosedCessna 320B · Utica, NYNTSB OAK69F0233Accident · No injuriesClosedCessna 320 · Nut Tree, CA
Back to Cessna 172P