NTSB investigations: Cessna 172P, 1988
39 cases on aircraft the registry lists as Cessna 172P. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1969 | 1 |
|---|---|
| 1973 | 1 |
| 1980 | 2 |
| 1981 | 9 |
| 1982 | 30 |
| 1983 | 34 |
| 1984 | 36 |
| 1985 | 32 |
| 1986 | 24 |
| 1987 | 42 |
| 1988 | 39 |
| 1989 | 27 |
| 1990 | 28 |
| 1991 | 39 |
| 1992 | 36 |
| 1993 | 26 |
| 1994 | 22 |
| 1995 | 19 |
| 1996 | 24 |
| 1997 | 25 |
| 1998 | 19 |
| 1999 | 24 |
| 2000 | 21 |
| 2001 | 16 |
| 2002 | 16 |
| 2003 | 25 |
| 2004 | 18 |
| 2005 | 17 |
| 2006 | 9 |
| 2007 | 10 |
| 2008 | 13 |
| 2009 | 9 |
| 2010 | 16 |
| 2011 | 14 |
| 2012 | 12 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 12 |
| 2016 | 9 |
| 2017 | 7 |
| 2018 | 10 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 7 |
| 2022 | 10 |
| 2023 | 7 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 9 |
Where
Open the mapLatest cases
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 MKC89LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Little Falls, MNWhile attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…NTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB BFO89LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cambridge, MDThe stu plt did three takeoffs & lndgs with the instr aboard and then three more during solo flight. On his fourth takeoff try he used aileron and rudder to maintain directional control on the rwy. There was an 8 to 10 kt crosswind. The stu said when the acft…NTSB MKC89LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Blue Springs, MOThe plt said, while cruising over a water reservoir at about 500 feet AGL, he collided with two waterfowl, believed to be geese. One struck the wing tip, the other near the wing root. Acft control remained constant with no control problems encountered, and…NTSB LAX89FA018Accident · 2 fatalField investigationFinal reportCessna 172P · Union City, CALoss of control of the aircraft by the pilot when he inadvertently entered instrument meteorological conditions. Factors contributing to the accident were, dark night light conditions and foggy weather conditions, inadvertent flight into IMC under visual…NTSB DEN89LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot was practicing touch-and-go landings in a 15 kt crosswind condition in an acft in which he had 8 hrs experience. During takeoff roll after the sixth landing the plt lost control and the acft departed the side of the rnwy.NTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…NTSB FTW89LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXNTSB NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…NTSB DEN88LA206Accident · No injuriesLimited investigationFinal reportCessna 172 · Greeley, COThe student plt reported that he was making touch and go landings. During landing roll the crosswind lifted the right wing and caused the acft to drift to the left. The student plt said he attempted to correct the drift, to no avail. The left main wheel…NTSB SEA88LA178Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Shelton, WAAbout 10 mins after t/o, the plt noted the engine running rough and elected to return to the point of departure for precautionary lndg. Approach was high and fast, leading to balked lndg. On throttle application, eng quit. Acft collided with trees beyond…NTSB FTW88FA162Accident · 1 fatalField investigationFinal reportCessna 172P · Marietta, OKThe plt elected to land on rwy 17 with wind from 300 degrees at 6 knots. During the second go-around the airplane's left wing struck a tree at a point 30 feet above the ground and the aircraft ended up inverted in a parking lot. Plt stated he had landed at…NTSB LAX88FA307Accident · 4 fatalField investigationFinal reportCessna 172 · Grand Canyon, AZThe pilot failed to maintain control of the aircraft during nigh visual meteorological conditions. Contributing to this accident was the pilot's lack of recent experience at nigh and the lack of outside visual references due to darkness.NTSB CHI88FA231Accident · 1 fatalField investigationFinal reportCessna 172P · Boyne City, MIThe pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient…NTSB LAX88FAMS3Accident · 3 fatalMissing aircraftFinal reportCessna 172P · Kauai, HIThe pilot departed for honolulu, HI after flying for 3 hours, 45 minutes without refueling. The flight to honolulu takes 1 hour. The airplane has a full fuel endurance of four hours. It disappeared from navy radar 25 miles southeast of Kauai. Acft wreckage…NTSB NYC88LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Freeport, PAThe plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the…NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WINTSB LAX88LA281Accident · No injuriesLimited investigationFinal reportCessna 172P · Imperial, CADuring a solo instructional flt, while landing, a gust of wind raised one wing, putting weight on main wheel and one nose wheel. The pilot regained control; however, the airplane veered off the runway and nosed over in the soft dirt.NTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…NTSB LAX88FA240Accident · 1 fatalField investigationFinal reportCessna 172P · Descanso, CAPilot's poor judgment and intentional decision to low fly the aircraft below the minimum safe altitude.NTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.NTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.NTSB CHI88LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairmont, MNThe student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…NTSB FTW88FA114Accident · Minor injuriesField investigationFinal reportCessna 172P · Houston, TXMooney N231QB was involved in a midair collision with Cessna N96957 while both aircraft were landing at the uncontrolled west Houston-lakeside airport. The Mooney aircraft was returning on a straight-in approach. The pilots of the Cessna aircraft were in the…NTSB BFO88LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Gaithersburg, MDAccording to the plt, after touchdown the acft encountered a crosswind gust. The acft drifted left of the rwy where it collided with trees. The plt reported no mechanical malfunction.NTSB FTW88LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXThe student pilot failed to maintain directional yaw axis control of the aircraft during the crosswind take off.NTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…NTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…NTSB CHI88LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Sauk Center, MNWhile enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…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 CHI88LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Sebewaing, MIThe plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed…NTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.NTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…NTSB CHI88LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Wayne, INAirplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface.NTSB ATL88LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Wakeman, OHThe 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…NTSB NYC88LA079Accident · 1 fatalLimited investigationFinal reportCessna 172P · East Hampton, NYThe flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…NTSB MIA88IA099Incident · No injuriesIncident investigationFinal reportBeech C-99 · Orlando, FLDrg a visual apch to Orlando intl arpt, bar harbor flt 3949 (Beech C-99, N232BH) contacted the tower (local controller) at 1817:07 & rprtd 5 mi north of the VOR for landing. The VOR was located 5.8 mi north of the rwy. About 20 sec later, the local controller…NTSB SEA88LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon Island, WADuring landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60…NTSB CHI88LA047Accident · No injuriesLimited investigationFinal reportCessna 172P · Jenison, MIThe low total time pilot took off in crosswind conditions for a proficiency flight and during a go around lost directional control and struck a snow bank along the downwind side of the runay.