NTSB investigations: Cessna 172G, 1991

10 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, 1991 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\") = 1991
    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 SEA92LA028Accident · Serious injuriesLimited investigationFinal reportCessna C-172G · Jackson, MTLoss of control due to the pilot's failure to maintain proper airspeed. Factors relating to the accident were the improper flap setting, the high density altitude, mountainous terrain, lack of experience by the pilot, and downdrafft winds.Dec 14, 1991 · N4244L · DestroyedNTSB SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.Oct 6, 1991 · N1372F · DestroyedNTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…Sep 20, 1991 · N1359F · DestroyedNTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.Sep 13, 1991 · N4184L · Substantial damageNTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.Aug 18, 1991 · N5921R · Substantial damageNTSB BFO91LA071Accident · No injuriesLimited investigationFinal reportCessna 172G · Fredericksburg, VAThe pilot's selection of the improper fuel tank. Contributing to the accident was the pilot did not use the check list.Aug 1, 1991 · N6002R · Substantial damageNTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.Apr 10, 1991 · N1375F · Substantial damageNTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.Apr 9, 1991 · N6005R · DestroyedNTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.Mar 2, 1991 · N4417L · Substantial damageNTSB ANC91FA019Accident · No injuriesField investigationFinal reportCessna 172G · Wasilla, AKPilot's not removing the frost from the airplane before attempting to takeoff. Contributing to the accident was the pilot's delayed abort, and the berm.Jan 5, 1991 · N4468L · Substantial damage