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 BFO87FA050Accident · Minor injuriesField investigationFinal reportCessna 172P · Whitemarsh, MDThe pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not…NTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…NTSB LAX87LA285Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kernville, CADuring a solo instructional flight, the student plt was attempting a landing with a 6-10 knot crosswind. While on final approach with full flaps and pwr off, the plt stated that over the threshold at aprx 10 ft AGL in the flare configuration, a gust of wind…NTSB LAX87LA270Accident · No injuriesLimited investigationFinal reportCessna 172P · Grass Valley, CADuring a pleasure flight, while attempting to land at the airport, the pilot made a go around because he was too high. On the second approach, the pilot noted that he may have been a little high and fast. During the landing the aircraft bounced three times…NTSB CHI87LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Ft. Wayne, INThe pilot reported that the airspeed indicator failed in flight. The aircraft landed hard and porpoised. The nose wheel broke off and the aircraft skidded down the runway grinding off the bottom of the carburetor. A fire broke out destroying the aircraft.…NTSB ATL87LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Marion, NCThe acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the…NTSB NYC87LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe Cessna 172 is reported to have lost power after getting airborne while making a short field takeoff from a 1838 ft long runway. The student pilot told the operator he landed the aircraft on the remaining runway and ran off the departure end of the runway.…NTSB LAX87LA353Accident · 1 fatalLimited investigationFinal reportCessna 172P · Independence, CAThe acft was rprtd missing after it departed san jose, CA, at about 1852 PDT on 6/9/87. A search was initiated, but the plane was not found until the wreckage was discovered by a hiker on 6/30/90. The acdnt occurred near kearsarge pass at an elev of 12,000…NTSB MIA87LA174Accident · No injuriesLimited investigationFinal reportCessna 172P · Tallahassee, FLWhile taxiing to take off the left wing collided with an utility pole.NTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…NTSB MIA87LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Wales, FLThe plt selected 20 degrees of flaps for a short field takeoff. At aprx 75 ft AGL he raised them 10 degrees resulting in a nose high altiude. The acft then stalled and crashed uncontrolled in a nose low altitude causing the nose gear to collapse. The acft…NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…NTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.NTSB ATL87FA130Accident · 2 fatalField investigationFinal reportCessna 172P · Kennesaw, GAN5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with…NTSB MIA87LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLWhile landing, the acft floated down the rwy as the result of excessive airspeed during the apch. The plt continued to flare the acft, & as the airspeed bled off, the wings stalled, resulting in a hard landing. The acft then began to propoise, & on the third…NTSB CHI87LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Terre Haute, INAircraft stalled on takeoff during an instructional flight. No malfunctions or mechanical problems were reported by either pilot. Witnesses reported that the engine sounded smooth but did not seem to be developing full power. Inspection of aircraft after the…NTSB LAX87LA162Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Paula, CAAt the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the…NTSB MKC87IA066Incident · No injuriesIncident investigationFinal reportCessna 172 · Neosho, MOThe acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn…NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.NTSB NYC87LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Livingston, NYDuring landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank.NTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…NTSB LAX87FA102Accident · 2 fatalField investigationFinal reportCessna 172P · Cuyama, CAThe plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…NTSB ANC87LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Chena Hot Sprgs, AKThe pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop.NTSB DEN87FA011Accident · Serious injuriesField investigationFinal reportCessna 172P · Gallup, NMWhile flying at a low level spotting deer in mountainous terrain the plt attempted to fly over a ridgeline with terrain that rose faster than the acft climb capability. At low airspeed and altitude he initiated a turn to reverse course toward lower terrain.…NTSB MIA87LA014Accident · No injuriesLimited investigationFinal reportCessna 172P · Pompano Beach, FLThe plt stated that during touch-&-go landing practice on his final landing, he landed hard, the nose gear collapsed and the acft slid to a stop on the runway.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 MIA86LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Live Oak, FLThe student plt stated that after he landed on a wet rwy, he was unable to stop & the acft continued off the end. Before stopping, the acft collided with a fence. According to the operator, the student had landed well beyond the normal touchdown area of the…NTSB CHI86FA215Accident · No injuriesField investigationFinal reportCessna 172P · Grayslake, ILDrg cruise flt, there was a loss of eng power (decreasing to 1900 RPM). The plt initiated a precautionary landing on rwy 27, but overran the intended landing area. The acft contd beyond the end of the rwy & subsequently flipped over in a corn field, west of…NTSB DEN86LA218Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMAccording to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a…NTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…NTSB MIA86LA214Accident · No injuriesLimited investigationFinal reportCessna 172P · Whiting, FLThe private pilot of a rented Cessna 172P experienced an engine failure after flying 4.7 hours on a cross country flight. During the landing roll the nose gear failed in rough terrain. No fuel was found in the aircraft fuel tanks or lines during recovery and…NTSB NYC86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kingston, NYThe student plt was on his 1st solo flt. After a go-around, his next apch was good until the acft encountered a gust of wind just before touchdown. Subsequently, the acft landed hard (hit on rear section), veered off the rwy & nosed over.NTSB LAX86LA284Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Los Angeles, CAThe private plt had no prior experience at the Los Angeles intl. Arpt. & the plt was unknowledgeable of the existence of arpt motor vehicle traffic service roads. The plt was given an ATC clearance to taxi, & in the darkness the plt mistook a service road for…NTSB ATL86LA180Accident · No injuriesLimited investigationFinal reportCessna 172P · Salisbury, NCThe plt reported that the engine lost power and quit shortly after T/0 at about 500-700 ft AGL. He checked the mixture, carb heat and mags but was unable to restart the engine. A 180 turn was made back to the arpt. The plt stated that he let the airspeed…NTSB CHI86LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grand Rapids, MNThe CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted.NTSB DEN86LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMThe plt stated that shortly after takeoff the engine began running rough and she was cleared by the tower to land on any rwy. The plt chose rwy 10. She added one notch of flaps over the rwy threshold and the acft continued to float, touching down with 1/3 of…NTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…NTSB ATL86MA114Accident · 4 fatalMajor investigationFinal reportCessna 172 · Holliston, MAThe Cessna 172 and a bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the bell was traveling in a…NTSB MKC86LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Omaha, NEThe plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of…NTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…NTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…NTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…NTSB LAX86LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Hayward, CAA Cessna 172P collided with a rwy light after veering off rwy 28. The winds at the time off the accident were reported from 350 deg at 6 KTS. The right main landing gear collapsed when it struck a rwy light damaging the right wing and tail section.NTSB LAX86LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Ontario, CAThe owner/plt (PIC) was on a flt for night & instrument currency requirements. He was flying the acft from the left front seat while a commercial plt (cp) was occupying the rgt front seat. Drg an ILS rwy 26L final apch at Ontario, CA, the PIC & cp discussed a…NTSB FTW86FRA09Accident · Serious injuriesFinal reportCessna 172P · Lake Jackson, TXThe acft crashed during forced landing after a power loss. The acft eng quit, after a 4 hr x-country, during the lndg approach. The acft had been flown locally over an hour by another plt (crew). This made a cumulative flt time on the acft of over 5 hrs since…NTSB ATL86LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Alexander City, ALThe acft was observed to make one takeoff and landing from an umimproved pasture. The second takeoff attempted was unsuccessful and the acft collided with a tree and crashed to the ground. The plt did not report any mechanical problems with the acft. There…NTSB FTW86LRA05Accident · No injuriesFinal reportCessna 172 · Tomball, TXThe acft veered off the left side of the rwy during landing. The nose wheel dug into mud and the acft nosed over. The plt said he was unable to correct the violent turn to the left.NTSB DEN86LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Fargo, NDThe acft contacted a snowbank following a loss of directional control during landing. This was the plt's first landing on his second solo flt. Previous to this landing, the student had been practicing landing on rwy 17 with his CFI.NTSB DEN86LA042Accident · No injuriesLimited investigationFinal reportCessna 172P · Missoula, MTThe solo student plt was attempting to land during a local flt when he lost control of the acft during the landing roll. The plt stated that the acft veered to one side of the ice covered rwy where it contacted 6 to 8 inches of snow, the acft continued…
Back to Cessna 172P