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 DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…NTSB LAX87LA137Accident · No injuriesLimited investigationFinal reportCessna 172C · Kahului, HIThe acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…NTSB NYC87LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Danbury, CTStudent pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank.NTSB BFO87LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Charlottesville, VAAfter climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft…NTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…NTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…NTSB FTW87LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Bay City, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when he lost control of the aircraft due to a cross wind.NTSB NYC87LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &…NTSB NYC87LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Beaver Falls, PAThe pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged.NTSB NYC87LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Duanesburg, NYOn lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an…NTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…NTSB FTW87LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Worth, TXThe nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.…NTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…NTSB MIA87LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sarasota, FLTwo ldg attempts were made at the physician plt's private arpt but were abandoned due to strong shifting violent winds. The plt later stated the last thing he remembered was seeing 500 ft on the altimeter & telling himself 'to get up & out of there' the acft…NTSB MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…NTSB LAX87FA057Accident · No injuriesField investigationFinal reportCessna 172N · Santa Paula, CAA Cessna 172 & a Dehavilland gipsy moth collided at 150 ft. AGL while on short final approach to the uncontrolled arpt. On base leg the plt flying the moth failed to observe & yield the right of way to the Cessna which was already established on the final…NTSB CHI87DEX03Accident · 3 fatalFinal reportCessna 172N · Raymond, OHThe accident aircraft impacted in an open field shortly after a predawn departure from an unattended airport. IMC prevailed an no flight plan was in effect. In a conversaton held the day before with a local pilot the pilot of the accident aircraft stated his…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…NTSB LAX87MA018Accident · 2 fatalMajor investigationFinal reportCessna 172N · Altadena, CAWhile rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…NTSB NYC87FA011Accident · 1 fatalField investigationFinal reportCessna 172 · Croton On Hud., NYStudent pilot advised by millville fss that VFR flight not recommended due to current and forecast IFR conditions throughout route of flight. Acft observed flying near base of low clouds and in and out of clouds prior to crashing in a residential area.NTSB SEA87LA002Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe plt initiated the takeoff from a taxiway with a 100 ft obscured sky and 1/4 visibility in fog. The non-instrument rated plt was unable to maintain the rwy heading during initial climb. The acft drifted to the right of the taxiway and struck trees located…NTSB SEA87LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Madras, OROn landing touchdown, aircraft nose tire blew out. The student pilot over-corrected with controls and power, causing the aircraft to balloon into the air and touch down a second time in a flat attitude, resulting in a hard landing.NTSB NYC86LA242Accident · No injuriesLimited investigationFinal reportCessna 172 · Seven Springs, PAPilot came in long and high for landing, attempted to land then decided to abort due to insufficient runway remaining. The aircraft continued off the end of the runway.NTSB NYC86LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Pedricktown, NJFlight encountered a gust of wind on takeoff, ran off the left side and collided with a sewer ditch. The aircraft flipped over and received substantial damage.NTSB FTW86LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Vick, LAThe pilot was given incorrect information as to the location of his destination airstrip. However, he found an airstrip at that approximate location. It was a 2500 foot grass strip as opposed to the 3600 foot grass strip which he was expecting. While on the…NTSB MKC86LA182Accident · No injuriesLimited investigationFinal reportCessna 172 · Hayes Center, NEWhile en route, the plt encountered deteriorating wx conditions. He stated that he found himself above an overcast with visibilities decreasing. He saw a hole in the cloud layer and descended thru it. He stated that wx conditions were bad below the cloud…NTSB SEA86LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Lord Flat, ORThe plt elected to go-around at about four feet AGL. Flaps were reduced from 40 degrees of flaps to 20 degrees of flaps and a gentle right turn was made due to rising terrain. The acft then settled onto the ground and crossed two ditches before coming to…NTSB CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…NTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…NTSB MIA86LA192Accident · No injuriesLimited investigationFinal reportCessna 172N · Pensacola, FLThe plt stated that he landed long on the wet grass rwy. As he attempted to stop, the acft slid off the side of the rnwyinto a ditch, severing the nose gear & collapsing the left main landing gear.NTSB NYC86LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PADuring takeoff roll and as the aircraft was brought to full power, the flight started to veer left. Attempts to correct with right rudder but the aircraft continued to roll left. The aircraft could not be brought under control before contact with two parked…NTSB MIA86LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Bartow, FLThe plt stated that she landed hard on the nose wheel and the prop struck the ground, damaging the structure of the aircraft.NTSB LAX86LA237Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Goodyear, AZThe student pilot was on her first supervised solo on runway 03 at Goodyear airport, Goodyear, AZ. Her instructor advised her to make three touch & go takeoff's and landings. The instructor positioned herself near the landing area and advised the student…NTSB FTW86LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Vega, TXThe pilot was practicing touch and go landings, when the aircraft began veering to the left after landing. He tried to apply full right rudder, but the aircraft continued to veer left off the runway. The pilot pulled the nose up to clear a tractor. The…NTSB LAX86LA217Accident · No injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe student pilot was returning to Thermal airport, Thermal, CA after completing a round robin solo cross country flight. While landing on runway 30 the student encountered a 90 degree right crosswind and lost control of the airplane. The airplane exited the…NTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…NTSB LAX86LA210Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearlake, CAThe flt instructor (CFI) said he was instructing the student in how to judge a straight-in approach and landing to a dock with minimal taxiing required. During the approach, the CFI determined that the student was overshooting the desired touchdown point, so…NTSB LAX86LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe plt misjudged the flare during landing and the acft touched down in a nose low attitude shearing the nose gear from the acft. The density altitude was calculated to be 3,500 ft when the accident occurred.NTSB MIA86LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Augustine, FLThe private pilot with a total of 36.2 hours of logged flight time, stated that she landed hard on the nose wheel and the nose strut failed during a full stop landing.NTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…NTSB LAX86LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAWitnesses reported that they observed the plt make 2 approaches and landings prior to the accident. On the landing just before the accident, they observed an 'extremely hard landing on the nose gear.' They reported that the plt then taxied back to takeoff…NTSB ATL86LA101Accident · No injuriesLimited investigationFinal reportCessna 172N · Advance, NCWhile on final apch to rwy 27,plts vision restricted by sun glare. Plt indicated that he was high & fast and landed too long to allow go around. Overran runway, nose gear mired and acft nosed over.NTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…NTSB LAX86LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Apple Valley, CAA Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had…NTSB FTW86LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, OKDuring takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…NTSB SEA86LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · American Falls, IDThe student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet.NTSB SEA86LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Concrete, WAThe pilot was flying only 50 feet AGL when the aircraft struck power lines. A successful landing was then accomplished at an airport.NTSB ATL86LA078Accident · No injuriesLimited investigationFinal reportCessna 172N · Washington, NCThe student pilot stated that the aircraft encountered a gust of wind during landing flare causing the aircraft to drift to the left upon touchdown. In an attempt to correct for the drift the student pilot applied left brake pressure as well as left rudder…
Back to Cessna 172N