Cessna 172N
NTSB investigations · 1,815
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 ('2072434')
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 ('2072434')
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 FTW82DRJ19Accident · No injuriesFinal reportCessna 172N · Lufkin, TXN733BD was holding for the active runway when N59257 taxied into the tail of the aircraft. N733BD received substantial damage and N59257 received minor damage.NTSB LAX82FA226Accident · Serious injuriesField investigationFinal reportCessna 172 · Granada Hills, CAThe student pilot departed van nuys, CA at about 1530 PDT on a round-robin, cross-country flight to turlock, CA. It was a combination personal and training flight. His instructor pilot (CFI) had verbally approved the flight, but did not endorse the student's…NTSB FTW82DA247Accident · No injuriesFinal reportCessna 172 · Houston, TXAfter the student pilot returned from a cross-country. He taxied into the parking area, but noticed there were no parking spaces available. While making a 180 deg turn, the right wing struck a fence post. After hitting the post, the plane turned and the…NTSB DEN82DA112Accident · No injuriesFinal reportCessna 172 · Colorado Spring, COThe pilot saw thunderstorms near pueblo and Colorado springs, CO, and checked the ATIS at both places. He encountered turbulence on the approach to the airport, but otherwise, the approach and touchdown were normal. According to the pilot, a strong gust of…NTSB MKC82DA103Accident · No injuriesFinal reportCessna 172N · Marion, IAThe pilot reported that he took off, stayed in the traffic pattern, and made a normal approach with one notch of flaps at about 75 mph. He stated that on final approach, the wind shifted from 350 to almost 180 degrees. He landed long and was unable to stop on…NTSB NYC82DA123Accident · Minor injuriesFinal reportCessna 172N · Schellsburg, PADuring a cross-country flight the pilot encountered lowering ceilings and rain. The pilot descended to 2200 feet; however, the weather continued to deteriorate and the pilot elected to climb. The aircraft collided with trees and was destroyed.NTSB CHI82FA186Accident · 2 fatalField investigationFinal reportCessna 172N · Milford, MIEarlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…NTSB NYC82DA096Accident · No injuriesFinal reportCessna 172N · Taberg, NYThe aircraft touched down about 1/3 of the way down grass runway. The pilot reported the runway surface was slippery and that he should have approached from the opposite direction where 50 foot wires were not a clearance problem.NTSB LAX82DA180Accident · No injuriesFinal reportCessna 172 · Bakersfield, CAThe student pilot had been cleared to land at meadows field but landed five miles to the south-southeast at Bakersfield airpark. Upon taxiing back to takeoff the left wing collided with a backhoe which was working alongside the runway installing a lighting…NTSB FTW82DA181Accident · Minor injuriesFinal reportCessna 172N · Houston, TXOn landing roll the aircraft began to swerve to the right. The pilot attempted to correct by applying power, left rudderand brake and the aircraft began to swerve to the left. The aircraft departed the runway, across a taxiway and into a row of parked…NTSB DEN82DA083Accident · No injuriesFinal reportCessna 172 · Sturgis, SDThe pilot landed in an open field to go to an auction. When he taxied back downwind to start his takeoff, the wind was gusting to 28 knots. The pilot estimated that he was moving about 15 mph as he turned to head back into the wind. As he started a right…NTSB LAX82FA171Accident · 3 fatalField investigationFinal reportCessna 172N · El Portal, CAThe wreckage was located at 4,750 ft MSL on the east side of a north/south oriented ridge. The acft had traveled uphill approximately 110 ft on a 45 deg slope on a heading of 236 deg, coming to rest about 50 ft below the top of the ridge.NTSB LAX82DA206Accident · No injuriesFinal reportCessna 172 · Mojave, CAWhile the pilot was boarding the aircraft, 2 linemen were holding the wings down. During taxi, the pilot was having difficulty controlling the aircraft. As the aircraft was turning to the runway heading, the wind raised the right wing, the spinning prop hit…NTSB LAX82DA149Accident · No injuriesFinal reportCessna 172 · Litchfield Park, AZThe student was a private pilot who was practicing for a commercial certificate. During the flight, he elected to make a simulated emergency landing on a dirt strip. He stated that during the takeoff phase of a touch and go, he encountered a dust devil.…NTSB ATL82DA112Accident · No injuriesFinal reportCessna 172 · Buckhannon, WVThe pilot reported making a normal approach to runway 26 in turbulent and windy conditions. He estimated that the wind was from 360 degrees at 15 to 20 knots. After the main wheels touched down, he encountered a gust of wind that he estimated was above 30…NTSB MIA82DA111Accident · 3 fatalFinal reportCessna 172N · Near Westbay, FLDuring the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & visbilities just east of panama city & along the gulf coast. At 2015, approximately 28 mi se of destin, the plt contacted eglin approach control(a/c) & was…NTSB LAX82DA141Accident · No injuriesFinal reportCessna 172 · Bakersfield, CAThe pilot was landing on an airstrip with a vineyard about 20 ft left of the runway. There was a left quartering headwind at 10 knots. The first landing was aborted after touchdown when the plane started to veer left as the brakes were applied. The next…NTSB NYC82DA072Accident · Minor injuriesFinal reportCessna 172N · Trenton, NJDuring a departure, the pilot initiated an intersection takeoff with about 4000 ft of runway remaining. He reported that the takeoff proceeded normally through lift-off to about 25 ft AGL. From there, the aircraft returned to the runway surface and bounced.…NTSB SEA82DA051Accident · Minor injuriesFinal reportCessna 172N · Pocatello, IDThe pilot stated that the aircraft encountered a gust of wind shortly after commencing takeoff roll which moved it directly across the runway. Initially the pilot maintained full power while attempting to regain control of the aircraft however shortly…NTSB FTW82DA113Accident · No injuriesFinal reportCessna 172N · Tomball, TXThe student pilot lost control of the aircraft during a practice touch and go landing. The aircraft swerved off the left side of runway into a plowed area and nosed down.NTSB ATL82DA091Accident · No injuriesFinal reportCessna 172 · Chantilly, VAThe pilot flew into an area of high forecast winds and altered his destination as a precaution. However, he failed to ask for or take precautionary measures after landing and the aircraft was blown over while taxiing.NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.NTSB ATL82FLT03Accident · 1 fatalFinal reportCessna 172N · Greenfield, TNWitnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a…NTSB ATL82FA080Accident · 1 fatalField investigationFinal reportCessna 172N · Francisco, NCThe non-instrument rated pilot received a partial weather briefing by telephone, but hung up when he obtained the information that he requested. FBO personnel stated that he looked and acted tired before taking off at 0022 EST. Subsequently, the plane was…NTSB MKC82DA045Accident · No injuriesFinal reportCessna 172N · Thayer, MODuring takeoff, the pilot's seat slid full aft just as the aircraft became airborne. The pilot was unable to reach the rudders or powerplant controls and could not control the aircraft. The plane crashed into trees on the left side of the runway. No…NTSB FTW82FPJ14Accident · 1 fatalFinal reportCessna 172N · Hulen, OKThe pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that…NTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…NTSB DEN82DA043Accident · No injuriesFinal reportCessna 172 · Broomfield, COAfter landing the aircraft was taxiing to the ramp when a gust of wind lifted the left wing up and tipped the Cessna over on its back. Wind was gusting over 40 KTS.NTSB FTW82FPM11Accident · 2 fatalFinal reportCessna 172 · Heavener, OKThe aircraft crashed at night on rising terrain about 300 ft below the crest of a hill. The nearest weather reporting station was at mcalester, OK. The weather at mcalester was 1200 ft overcast, visibility 7 miles, ceiling ragged. The mcalester field…NTSB LAX82DA102Accident · No injuriesFinal reportCessna 172 · San Carlos, CAReportedly, the accident occurred after the aircraft veered right during a landing and the pilot opted to go-around. The pilot did not provide additional information concerning this accident.NTSB LAX82DA095Accident · No injuriesFinal reportCessna 172N · Mammoth, AZThe pilot was on a solo cross-country flight in preparation for his commercial pilot certificate. He had begun a descent from 10,500 ft for landing at his destination airport when the engine quit. Attempts to restart the engine were unsuccessful and a forced…NTSB DEN82FTE17Accident · Serious injuriesFinal reportCessna 172 · Boulder, COThe engine lost power while the aircraft was cruising at 7500 ft MSL at night. During a forced landing, the aircraft touched down on steep, rocky soil. The aircraft bounced and then nosed over after a second touchdown. During an interview about two hours…NTSB SEA82DA031Accident · No injuriesFinal reportCessna 172N · Redmond, WAThe student and instructor were practicing water landings on lake sammamish near Redmond, WA. The winds were initially calm. On the second landing, it was noted that the wind began to pick up. Reportedly, wind shear was encountered during final approach for…NTSB LAX82FA080Accident · Minor injuriesField investigationFinal reportCessna 172N · Catalina Island, CAWhile circling around Catalina Island turning in an out of canyons at 1700 feet MSL the engine lost power. At los angeles international airport, 38 miles to the nnw, the temperature was 65 degrees and the dew point was 45 degrees. All attemps to restart the…NTSB LAX82DA081Accident · No injuriesFinal reportCessna 172N · Grand Canyon, AZThe aircraft was observed to taxi and takeoff with full flaps and a density altitude of about 7700 feet. According to a witness aboard the aircraft the stall warning was going on and off from shortly after takeoff until landing. At about 150 feet AGL the…NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…NTSB LAX82FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Santa Ysabel, CADrg wx briefings at 1024 & 1247 the plt was advised that VFR flt was not recommended due to low ceilings & icing conditions. At about 1418 the acft departed. At 1439 the plt contacted flight watch (fw) & reported picking up leading edge ice 6.4 mi east of the…NTSB NYC82DA031Accident · No injuriesFinal reportCessna 172N · Wrightstown, NJThe pilot returned from a local flight with four passengers on board. The aircraft gross weight was near the maximum limit and the center of gravity was near the forward limit. The pilot entered the traffic pattern for landing on runway 36. The wind was from…NTSB CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…NTSB MIA82FLD13Accident · Serious injuriesFinal reportCessna 172 · Crystal River, FLThe private pilot was a foreign national that was dispatched on a solo cross-country training flight. However, he departed on a different route with a passenger. During the return flight, he encountered deteriorating weather and decided to land at the Crystal…NTSB DEN82DA026Accident · No injuriesFinal reportCessna 172 · Bryce Canyon, UTAfter arriving from a cross-country flight, the pilot landed on an icy runway with calm wind conditions. During ground roll, the aircraft began sliding to the left. The left wheel hit snow and pulled the aircraft further left. The pilot applied right rudder…NTSB ATL82DA044Accident · No injuriesFinal reportCessna 172N · Cumberland Isla, GAThe 2500 ft runway had trees on 3 sides. The normal pattern for landing was from east to west and departures were normally from west to east. A long, shallow, tailwind approach was made from the east at about 65 knots. The pilot used 40 degrees of flaps and…NTSB MKC82FA023Accident · 1 fatalField investigationFinal reportCessna 172N · 5m E. Greensbur, KSThe plt received a wx briefing for a flt to dodge city,KS. The fss specialist asked the plt if he was proposing his flight under IFR since his destination was reporting IMC. The plt replied that he was. A ground witness at haviland,KS located about 5 miles…NTSB LAX82DA041Accident · No injuriesFinal reportCessna 172N · Bullhead City, AZWhile the pilot was landing with a tailwind, the aircraft went off the left side of the runway and traveled over a raised area beside the runway. The pilot reported that the nosewheel caught on the hillside as a gust of wind was encountered and the airplane…NTSB CHI82DA022Accident · No injuriesFinal reportCessna 172N · Sandusky, OHThe wind was from the south-southwest at 15, gusting 20 knots. The fixed base operator had advised all pilots to use runway 18. After arriving, the pilot of N737LH saw another aircraft using runway 27 and elected to land on that runway. He noted a left…NTSB NYC82FFA02Accident · No injuriesClosedCessna 172 · Edinburg, NYNTSB LAX82FA029Accident · 1 fatalClosedCessna 172 · Vernon, AZNTSB LAX82DUJ23Accident · No injuriesClosedCessna 172 · Roll, AZNTSB LAX82FVM06Accident · No injuriesClosedCessna 172 · San Carlos, CANTSB ATL82FIG04Accident · No injuriesClosedCessna 172N · Stevensville, MD
Back to Cessna 172N