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 LAX88LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear City, CAJust after takeoff the engine experienced a loss of power. A forced landing was made off the airport in a lake. . The airplane partially sank. The engine was removed to a maintenance facility for examination. No preexisting malfunctions or mechanical failures…NTSB FTW88LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Graham, TXThe student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident.NTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…NTSB ATL88LA160Accident · No injuriesLimited investigationFinal reportCessna 172N · Gilbert, SCThe airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of…NTSB MIA88FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Vero Beach, FLThe acft was observed to touch down on rwy 36 with full flaps on the grass strip bordered on both sides by citrus groves, surface winds in the area were 120 degs at 11 KTS. The acft was observed to drift to the left off the rwy toward the grove. The plt…NTSB LAX88FA146Accident · 1 fatalField investigationFinal reportCessna 172N · Saticoy, CAA certificated private pilot and his instructor, conducting training in a 172P, were turning left to a southeasterly heading at 3,400 feet MSL, near an uncontrolled airport. A Cessna 172N on a pleasure flight in the vicinity was climbing on a southwesterly…NTSB MIA88LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Key West, FLAccording to the plt he was on a fish spotting flight. The acft lost power. The plt ditched in the ocean. He was picked up by a passing boat & taken to Key West, FL. He stated that due to the past history of this acft, his opinion was that the cause of the…NTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…NTSB LAX88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbia, CAAt the end of a pleasure flight, while on short final over the landing threshold, the left wing suddenly lifted. The pilot lost control of the aircraft which collided with the terrain and nosed over. There were no reported mechanical failures or malfunctions.NTSB NYC88LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Southbridge, MADuring takeoff from Southbridge airport, the aircraft encountered a crosswind. The aircraft started drifting to the right even though full left aileron and full power were being applied. The pilot cut the power to abort the takeoff, and the aircraft impacted…NTSB MKC88FA058Accident · 4 fatalField investigationFinal reportCessna 172N · Oxford, IAWitnesses stated that the aircraft appeared to be in trouble immediatley after takeoff, as the wings were rapidly rocking while it was struggling to stay airborne. The aircraft turned sharply left, where it then barely cleared a row of trees. The airplane…NTSB NYC88LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · North Hanover, NJThe eng lost power while the acft was circling at aprx 1500 ft AGL & the occupants were engaged in aerial photography. Subsequently, the acft was damaged during an emergency landing in a swampy area. An exam of the acft revealed the left tank was empty. The…NTSB MIA88FA114Accident · 2 fatalField investigationFinal reportCessna 172N · Kissimmee, FLThe acft was observed at about 2000 ft sw bound & the sound of the eng could be heard. The acft was next observed about a minute later inbound at about 50 ft & eng sound could be heard. The witness heard a 'poof' sound & the acft was observed inverted. The…NTSB LAX88LA112Accident · No injuriesLimited investigationFinal reportCessna 172N · Temecula, CAAt the end of a local pleasure flight, while on final approach, the pilot reported that there was a strong crosswind. Just prior to touchdown the wing lifted and the pilot lost control of the aircraft and collided with a wind tee. There were no mechanical…NTSB DEN88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe private plt was practicing landings at centennial airport, denver, Colorado. Rnwy 17L, an asphalt rnwy 8,500 feet long and 101 feet wide, was in use. The plt reported that when he attempted to add power on final approach, the throttle cable would not…NTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…NTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.NTSB CHI88LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Fond Du Lac, WINTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…NTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…NTSB LAX88LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAA Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to…NTSB MIA88FA044Accident · 1 fatalField investigationFinal reportCessna 172N · Palm Coast, FLThe student plt was flying the acft on a solo instructional flt in the north practice area & was assigned to practice landings, takeoffs, stalls & slow flt. Witnesses stated they observed the acft flying at a very low altitude just before it collided with a…NTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…NTSB LAX88LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAAt the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft…NTSB ATL88LA021Accident · No injuriesLimited investigationFinal reportCessna 172P · Swainsboro, GAThe acft was being returned to its home base following a 100 hour inspection. The plt reported that the eng quit as he was descending prior to traffic pattern entry. An off airport landing was attempted. The landing gear was extensivelydamaged and the…NTSB ATL88LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Brookville, OHWhile on final approach the acft began to fall below the flight path the plt desired. Remedial actions were insufficient to correct the deviation. The acft impacted short of the rwy and collapsed the landing gear. Investigation revealed the use of 40 degrees…NTSB BFO88FA002Accident · 1 fatalField investigationFinal reportCessna 172N · Lowmoor, VAThe acft was involved in powerline patrol over mountainous terrain at low altitude. The plt made a climbing right turn to avoid a ridge and went into a valley where he was boxed in by two ridges. He unsuccessfully tried to outclimb one of the ridges before he…NTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…NTSB CHI87LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.…NTSB FTW87LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Edmond, OKThe pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined.NTSB CHI87LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Perham, MNThe pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed.NTSB LAX87LA324Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lee Vining, CAWhile flying over mountainous terrain. The pilot inadvertently followed the wrong road & went into a box canyon area. He stated the visibility was about 5 miles & he did not see the upcoming rising elevation. Eventually, he got into a situation were the acft…NTSB LAX87LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sonora, CADuring a pleasure flt the engine suddenly lost partial power. The plt made a forced landing in a parking lot where the aircraft touched down and collided with a fence that borders the lot. The engine was inspected and test run for approx 20 minutes at…NTSB LAX87LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Temple Bar, AZThe stall warning horn sounded during climbout following a touch-and-go landing. Rising terrain was reported beyond the end of the runway and the pilot was unable to continue to climb while maintaining a safe airspeed. The density altitude was approximately…NTSB ATL87LA237Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksonville, ALThe plt departed Jacksonville in VFR conds without obtaining a wx briefing. While en route, she observed thunderstorm activity & elected to return to Jacksonville. By the time she returned, the wx had deteriorated & the wind had shifted to the south. The wind…NTSB LAX87FA290Accident · No injuriesField investigationFinal reportCessna 172N · Palmdale, CAA Dehavilland DHC-6, N931MA, operating as transworld express flt 7591 (twe 7591) & a Cessna 172N, N737EV, collided abt 10 miles west/southwest of Palmdale, CA at abt 5500 ft MSL. Twe 7591 was descending on a 355 deg mag heading; N737EV was level and was…NTSB CHI87LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Troy, MIThe plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…NTSB LAX87LA238Accident · No injuriesLimited investigationFinal reportCessna 172N · Malibu, CADuring a local instructional flight, the pilot stated that they were flying along the coast aprx 1 mile offshore and 500 ft AGL. The student started a climbing right turn towards land. The student continued to apply back pressure to the point that the acft…NTSB CHI87LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Prairie Duchien, WIWhile in cruise flight, tape which was holding a piece of plexiglass over the cracked windshield came loose. The windshield lifted up and the pilot was not able to maintain altitude. During the forced landing in a soft field. The nose gear sheared off.NTSB ANC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Salcha, AKThe pilot was indecisive during his attempted takeoff. He first elected to abort the effort, then changed his mind and added full power to continue the take off. The airplane rose a few feet off the river bar before stalling and crashing into the river.NTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…NTSB NYC87LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJAccording to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a…NTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…NTSB ATL87LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Union Grove, NCThe plt reported that he was attempting to make a soft-field ldg in a plowed field at a friend's farm. He had not landed there previously. After initial touchdown was made on the main ldg gear, the nosewheel dug into a rise in the terrain and the airplane…NTSB SEA87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ritter Butte, ORDuring a cross country flt the plt noticed that he was gradually losing his communications radio and navigational instruments. Shortly afterwards the plt noticed that the fuel gauges were quickly approaching empty. Since hostile terrain was ahead the plt…NTSB LAX87LA189Accident · 4 fatalLimited investigationFinal reportCessna 172N · Lihue, HIThe pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…NTSB NYC87FA119Accident · 4 fatalField investigationFinal reportCessna 172N · Ferguson Twnshp, PAThe pilot, who had not completed his checkout in a Cessna 172, was observed to make a long landing and lift off with approximately 750 ft of runway remaining. The aircraft was observed to enter a nose high pitch attitude and drift into a right turn. The…NTSB MIA87LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Pine Key, FLThe plt stated that during cruise flt the eng began to run rough. He then attempted to solve the problem to no avail. Unable to maintain alt he elected to land the acft on a road. While taxiing, both wings collided with street signs. Post crash examination of…NTSB ATL87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Vidalia, GAThe plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed…NTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…
Back to Cessna 172N