NTSB investigations: Cessna 172G, 1984

4 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
NTSB investigations: Cessna 172G, 1984 per year, 1965–2026: 595 cases
19652
196667
196781
196841
196935
197027
197132
197222
197321
197414
197511
197614
197711
197811
19797
19805
19819
19825
19836
19844
19854
19866
19878
19888
19899
19907
199110
19929
19934
19945
19958
19966
19976
19985
19997
20004
20012
20026
20034
20052
20063
20072
20102
20111
20121
20132
20154
20173
20186
20193
20201
20216
20223
20233
20243
20255
20262

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\") = 1984
    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 NYC84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Forrestport, NYThe acft stalled into trees near the edge of a lake and tumbled into the water after the engine quit due to fuel exhaustion at 2000 ft AGL aprx 2 miles from the lake. The plt said he should have used a dip-stick to measure the fuel in the tanks before takeoff…Jul 15, 1984 · N3736L · Substantial damageNTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…Jun 30, 1984 · N4650L · Substantial damageNTSB ATL84LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Newberry, SCThe plt had executed a go-around from an approach to rwy 4 due to a crosswind & gusty wind conditions. While on downwindhe observed that the wind was favoring rwy 10. He overshot the approach end of rwy 10 & executed another go-around. Upon observing that he…Mar 16, 1984 · N3674L · DestroyedNTSB MKC84LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mountain View, ARThe acft collided with trees during a forced landing after the engine lost power. The plt had taken off for a x-country without full fuel tanks. After the accident a mechanic found no useable fuel aboard the acft.Feb 21, 1984 · N3826L · Substantial damage