Cessna 172
NTSB investigations · 1,097
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 ('2072402')
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 ('2072402')
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 DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…NTSB CHI85FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172The aircraft was seen to depart racine, WI on August 3, for ft meyers, FL, but never arrived at its destination. On the fourth day of the search a ramp check at albany-dougherty county airport, Georgia indicated that the aircraft was refueled there at approx…NTSB LAX85FVA02Accident · Serious injuriesFinal reportCessna 172 · Santa Nella, CAWitnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.NTSB DEN85LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Opheim, MTThe plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged.NTSB NYC85LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Kintnersville, PAThe pilot decided to abort the takeoff when he realized that too much runway was being used. During the rollout, the pilot began to turn the aircraft to the right. The wind lifted the tail of the aircraft until it nosed over onto its back.NTSB DEN85LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Wesbter, SDThe student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…NTSB FTW85LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Mccoy, TXThe plt stated that he had departed the gala ranch strip & was flying at aprx 100 ft AGL to show his passengers their ranch property. While in slow flight with the flaps deployed, the plt entered a downwind skidding left turn. The acft subsequently stalled &…NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB MIA85LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miles City, FLThe acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using…NTSB NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…NTSB LAX84IA448Incident · No injuriesIncident investigationFinal reportCessna 172 · Redding, CAPlt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.NTSB SEA84LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Moscow, IDThe acft ran off the rwy into tall wet weeds during a landing on a private agricultural airstrip. The plt said a x-wind caused the swerve. A weather reporting station 6 NM away reported the wind as 7 KTS with no gusts. The plt landed to thenorth and the…NTSB SEA84LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Stewart Island, WAThe plt landed to the west on a wet grass strip with 1/4 inch of standing water. He said he had no traction & the acft slid off the end between 2 trees, damaging both wings. He also said the wind was 090 deg at 5 KTS gusting 15 KTS.NTSB LAX84LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague, CAAn improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &…NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB ATL83FA378Accident · 3 fatalField investigationFinal reportCessna 172 · Benson, NCAprx 3 mi south of the crash site, a witness saw the acft flying northbound along a railroad track. He reported that the acft was flying below tree top level & the eng was running smoothly. A short time later, another witness aprx 1 1/2 mi further north, also…NTSB LAX83LA391Accident · No injuriesLimited investigationFinal reportCessna 172 · Herndon, CAThe pilot reported that the approach and landing were normal. During rollout, the acft's landing light failed and the pilot was unable to see well enough to maintain his course on the rwy. The acft veered off the left side onto soft terrain and the nose gear…NTSB ATL83LA320Accident · No injuriesLimited investigationFinal reportCessna 172 · Folkstone, NCThe plt reported that during takeoff, his seat slid all the way aft. When this occurred, he pulled the yoke aft & the acf entered a power on stall & crashed. Reportedly, the plt did not secure the seat before taking off.NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…NTSB NYC83LA199Accident · No injuriesLimited investigationFinal reportCessna 172 · Easton, NYThe plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.NTSB MKC83LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenfield, MOThe plt reported that before landing he applied carburetor heat & extended full flaps. Reportedly, he made a steep approach to the 3000 ft, sod rwy. He said he overshot the 1st half of the rwy & touched down at about midfield. At this point, the plt initiated…NTSB LAX83LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Alamo, NVAfter takeoff from a desert road the acft settled & struck a yucca tree.NTSB FTW82DA374Accident · Minor injuriesFinal reportCessna 172 · Vain, OKThe pilot and his passenger took off on a local flight and flew over a runway that they were constructing in their pasture. The pilot stated that he was in slow flight over the runway. Both occupants received concussions in the accident and could not recall…NTSB FTW82DA224Accident · No injuriesFinal reportCessna 172 · Duncan, OKThe student pilot was practicing touch-and-go landings in winds from the southeast at 10 gusting 15 KTS. Just prior to landing, the aircraft encountered a gust of wind, then touched down hard. The engine fire wall was buckled and two tires blew out.NTSB LAX82DA197Accident · No injuriesFinal reportCessna 172 · Fresno, CAThe acft landed hard, bounced, veered left & collided with a parked acft. The CFI recognized that the approach speed wastoo slow & waited too long before taking over. A deliberate turn was made to avoid residences.NTSB ATL82DA097Accident · No injuriesFinal reportCessna 172 · Brook Haven, MSThe pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.NTSB FTW82DA057Accident · No injuriesFinal reportCessna 172 · Navajo Dam, NMThe pilot landed at an unattended airport on what he thought to be approximately 2 inches of snow. It turned out to be 8 inches and the aircraft turned over on landing.NTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…NTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INNTSB NYC82DNA09Accident · 2 fatalClosedCessna 172N · Nantucket, MANTSB LAX82FVD05Accident · No injuriesClosedCessna 172 · Ukiah, CANTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MONTSB FTW82FA006Accident · 1 fatalClosedCessna 172P · Orange, TXNTSB DEN81FTG18Accident · No injuriesClosedCessna 172 · Bowdon, NDNTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALNTSB LAX81AA119Accident · 1 fatalClosedCessna R172K · San Jose, CANTSB LAX81FVD32Accident · Serious injuriesClosedCessna 172 · Santa Rosa, CANTSB LAX81DVM25Accident · No injuriesClosedBolen 172 · San Jose, CANTSB DEN81DTI13Accident · No injuriesClosedCessna 172 · Schafers Mdws, MTNTSB CHI81FEM29Accident · No injuriesClosedCessna 172 · Mackinac Is, MINTSB MKC81DCJ21Accident · No injuriesClosedCessna 172 · Naper, NENTSB NYC81FA067Accident · Minor injuriesClosedCessna 172 · Bridgeport, NJNTSB DEN81FA044Accident · 2 fatalClosedCessna 172 · Price, UTNTSB CHI81FEI20Accident · Serious injuriesClosedCessna 172 · Akron, OHNTSB CHI81FEE37Accident · No injuriesClosedCessna 172P · Plainfield, ILNTSB LAX81FVD22Accident · No injuriesClosedCessna 172 · Novato, CA
Back to Cessna 172