NTSB investigations: Cessna 172, 1987

13 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

19642026
NTSB investigations: Cessna 172, 1987 per year, 1964–2026: 1,096 cases
196480
196577
196684
196785
196865
196935
197032
197137
197240
197335
197435
197515
197629
197725
197827
197915
198021
198127
198211
19836
19848
198513
19868
198713
198821
198915
19906
199111
199212
199310
199410
19959
199612
19974
199813
19999
20009
20019
20026
20032
20042
200511
20064
20079
20088
20093
20104
20116
20124
20137
20143
20155
20163
20176
20186
20196
20203
20218
20224
20233
20242
20255
20263

Latest 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\") = 1987
    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.

NTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…Dec 28, 1987 · N4297F · Substantial damageNTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…Dec 20, 1987 · N7970B · DestroyedNTSB MIA88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Titusville, FLAfter a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…Oct 24, 1987 · N4207F · Substantial damageNTSB ATL87LA241Accident · No injuriesLimited investigationFinal reportCessna 172 · Baxley, GADuring a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at…Aug 25, 1987 · N4275F · Substantial damageNTSB ANC87LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pt. Mackenzie, AKAfter a complete engine failure and an emergency landing on the beach, the pilot lost directional control of the aircraft causing the plane to nose over on its back. Examination of the engine revealed a blocked oil screen which caused oil starvation.Aug 8, 1987 · N7169A · Substantial damageNTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…Aug 2, 1987 · N8696B · DestroyedNTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…Jun 21, 1987 · N7121A · Substantial damageNTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.Jun 18, 1987 · N3913F · Substantial damageNTSB FTW87LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Cameron, TXDuring takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement.Jun 14, 1987 · N5079A · Substantial damageNTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…May 29, 1987 · N4173F · Substantial damageNTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…May 24, 1987 · N5711A · 2 aircraft · DestroyedNTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.May 3, 1987 · N7259A · Substantial damageNTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.Feb 14, 1987 · N8896B · Substantial damage