OpenAirDocs.org

NTSB investigations: Cessna 172G, 1987

8 cases on aircraft the registry lists as Cessna 172G. 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

19652026

Where

Open the map

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 ('2072420'))
  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 FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.Oct 27, 1987 · N3931L · Substantial damageNTSB ANC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · 45 Nw Anchorage, AKThe pilot stated that he believed he ran out of fuel during the IFR flight.Oct 3, 1987 · N3128L · Substantial damageNTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…Jul 4, 1987 · N1162F · DestroyedNTSB MIA87LA182Accident · No injuriesLimited investigationFinal reportCessna 172G · Caribbean SeaThe plt became disoriented while flying from saint lucia to saint vincent after he incorrectly selected the wrong station when navigating using the adf. He contacted ATC who advised him to climb & was advised that the flt was aprx 20 miles west of saint…Jun 13, 1987 · N4346W · Substantial damageNTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…Jun 8, 1987 · N3644L · Substantial damageNTSB FTW87LA109Accident · No injuriesLimited investigationFinal reportCessna 172G · Houston, TXA student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his…Apr 23, 1987 · N1107F · Substantial damageNTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…Mar 20, 1987 · N3630L · Substantial damageNTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…Jan 9, 1987 · N3971L · Substantial damage