NTSB investigations: Cessna 172, 1988
21 cases on aircraft the registry lists as Cessna 172. 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
| 1964 | 80 |
|---|---|
| 1965 | 77 |
| 1966 | 84 |
| 1967 | 85 |
| 1968 | 65 |
| 1969 | 35 |
| 1970 | 32 |
| 1971 | 37 |
| 1972 | 40 |
| 1973 | 35 |
| 1974 | 35 |
| 1975 | 15 |
| 1976 | 29 |
| 1977 | 25 |
| 1978 | 27 |
| 1979 | 15 |
| 1980 | 21 |
| 1981 | 27 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 8 |
| 1985 | 13 |
| 1986 | 8 |
| 1987 | 13 |
| 1988 | 21 |
| 1989 | 15 |
| 1990 | 6 |
| 1991 | 11 |
| 1992 | 12 |
| 1993 | 10 |
| 1994 | 10 |
| 1995 | 9 |
| 1996 | 12 |
| 1997 | 4 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 9 |
| 2002 | 6 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 11 |
| 2006 | 4 |
| 2007 | 9 |
| 2008 | 8 |
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 4 |
| 2013 | 7 |
| 2014 | 3 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 5 |
| 2026 | 3 |
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 ('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_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 ('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 ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB MIA89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLThe student pilot reported that during preflight inspection, he did not replace the oil cap after he checked the oil. Subsequently, oil was vented overboard during flight & the engine lost power. The nose gear collapsed during a forced landing.NTSB DEN89LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Riverton, WYThe instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…NTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…NTSB NYC89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lancaster, PAThe pilot of the Cessna 172 was returning solo from atlantic city when the aircraft ran out of fuel. He landed in a corn field and the aircraft flipped over. Examination of the wreckage revealed no fuel in the aircraft. The plt said he fueled the acft with 20…NTSB DEN88LA209Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Questa, NMThe private plt and 1 pax were taking off using 2,500 ft of a 4,000 x 50 ft dirt strip with a d/a of 9,200 ft. during intial climb the plt noticed a sink rate. The plt said he varied the angle of flaps from 5 to 25 deg 'in search of lift.' The right wing and…NTSB MIA88LA270Accident · No injuriesLimited investigationFinal reportCessna 172 · Panacea, FLThe pilot stated that while attempting a go-around he inadvertently selected all flaps up and the aircraft crashed into the trees at the end of the runway.NTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INNTSB CHI88LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Neillsville, WINTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…NTSB CHI88LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Moraine, OHWhile on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…NTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…NTSB CHI88LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172 · North Liberty, INWhile departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…NTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.NTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…NTSB BFO88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkton, MDDuring cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the…NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…NTSB LAX88FA094Accident · 2 fatalField investigationFinal reportCessna 172 · Temple City, CAPilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.NTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…