NTSB investigations: Cessna 172N, 1991
57 cases on aircraft the registry lists as Cessna 172N. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 26 |
| 1978 | 62 |
| 1979 | 81 |
| 1980 | 107 |
| 1981 | 86 |
| 1982 | 91 |
| 1983 | 53 |
| 1984 | 55 |
| 1985 | 40 |
| 1986 | 44 |
| 1987 | 42 |
| 1988 | 47 |
| 1989 | 45 |
| 1990 | 46 |
| 1991 | 57 |
| 1992 | 40 |
| 1993 | 51 |
| 1994 | 43 |
| 1995 | 48 |
| 1996 | 37 |
| 1997 | 40 |
| 1998 | 37 |
| 1999 | 46 |
| 2000 | 35 |
| 2001 | 32 |
| 2002 | 43 |
| 2003 | 32 |
| 2004 | 38 |
| 2005 | 26 |
| 2006 | 23 |
| 2007 | 21 |
| 2008 | 21 |
| 2009 | 20 |
| 2010 | 23 |
| 2011 | 22 |
| 2012 | 14 |
| 2013 | 20 |
| 2014 | 15 |
| 2015 | 10 |
| 2016 | 24 |
| 2017 | 19 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 25 |
| 2021 | 15 |
| 2022 | 16 |
| 2023 | 20 |
| 2024 | 13 |
| 2025 | 15 |
| 2026 | 11 |
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\") = 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 ('2072434'))
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") = 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 ('2072434'))
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 LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB MIA92GA024Accident · 1 fatalFinal reportCessna 172N · Okeechobee, FLThe pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB NYC92LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Toledo, OHThe pilot's failure to preform an aircraft preflight, and remove the gust lock from the aileron, resulting in a loss of airplane control during initial climb.NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.NTSB LAX92LA003Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Palo Alto, CAAn inflight los of control due to the failure of the student pilot to correctly configure the rudder trim for takeoff.NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB SEA91LA253Accident · No injuriesLimited investigationFinal reportCessna 172N · Chiloquin, ORThe loss of engine power in flight due to improper maintenance inspections. A factor relating to the accident was the rough terrain at the accident site.NTSB LAX91LA404Accident · No injuriesLimited investigationFinal reportCessna 172 · Cottonwood, AZThe pilot-in-command's delay in raising the flaps and the subsequent inadvertent stall/mush.NTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB LAX91LA383Accident · 3 fatalLimited investigationFinal reportCessna 172 · Arroyo Grande, CAThe pilot's failure to maintain a proper altitude, and continued flight into instrument meteorological conditions.NTSB SEA91LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Butte, MTUnfavorable winds. Factors to the accident were: inadequate weather evaluation and lack of total flight experience.NTSB MIA91LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lake City, FLThe pilot in command's failure to maintain airspeed during a demonstrated downwind soft field takeoff. This resulted in an in flight loss of control, stall, and collision with terrain.NTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.NTSB MIA91WA203Accident · No injuriesForeign investigationCessna 172N · Nassau, BahamasNTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.NTSB CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB LAX91LA325Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAThe cfi's failure to initiate the go-around maneuver in a timely manner, and his failure to terminate the simulated emergency maneuver at a proper altitude. A contributing factor was the gusty surface wind.NTSB DEN91LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COThe pilot selected the wrong runway and landed with a tailwind.NTSB NYC91LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJThe decision of the pilot to discontinue a go-around, from an attempted landing, resulting in the airplane striking trees. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB NYC91LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbus, OHThe failure of the pilot to maintain an adequate visual lookout which resulted in a ground collision with a parked aircraft. Factors related to the accident was the failure of the pilot to taxi on the taxiway centerline and night conditions.NTSB LAX91LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Mariposa, CAThe pilot misjudging his planned approach. A down-sloping runway surface was a factor in the accident.NTSB MIA91LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Rontonda West, FLThe failure of the pilot-in-command to maintain an adequate visual lookout which caused him to fly the airplane into wires.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB NYC91LA166Accident · Minor injuriesLimited investigationFinal reportCessna C-172 · Clarence Center, NYFailure of the pilot to maintain airspeed during a heavy weight takeoff, resulting in a stall and landing in rough terrain.NTSB MIA91LA173Accident · No injuriesLimited investigationFinal reportCessna 172N · Punta Gorda, FLFailure of the pilot to observe the windsock before landing resulting in failure to maintain directional control after landing with a quartering tailwind. The airplane collided with a ditch. Contributing to the accident was lack of total experience of the…NTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.NTSB LAX91LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe partial failure of the engine/powerplant from a worn intake valve and the failure of company/operator management to perform an overhaul on the engine within the time frame recommended by the engine manufacturer.NTSB CHI91LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chicago, ILThe pilot in command (student)'s improper judgement of the proper touchdown point. A factor contributing was the pilot in command's delaying an aborted landing.NTSB ANC91LA062Accident · No injuriesLimited investigationFinal reportCessna 172-N · Egegik, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the high winds.NTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.NTSB BFO91FA049Accident · 1 fatalField investigationFinal reportCessna 172N · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.NTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.NTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.NTSB FTW91LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Huntsville, TXThe pilot's failure to maintain directional control of the airplane. A factor was the emphasis placed upon full-stall landings by his instructor.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.NTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.NTSB LAX91LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAThe installation by maintenance personnel of an incorrect gasket that resulted in the loss of the engine magneto.NTSB CHI91LA124Accident · Minor injuriesLimited investigationFinal reportCessna C172N · North Liberty, INThe pilot's inadvertent touchdown and inadequate remedial action. Related factors are the low pass maneuver, and the soft terrain.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB MIA91LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Clewiston, FLMisjudged wind direction resulting in incorrect runway selection and failure by the PIC to initiate a go-around after landing with a tailwind. Contributing to the accident was the lack of the pilot's total experience.NTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.