NTSB investigations: Cessna 172M, 1990
37 cases on aircraft the registry lists as Cessna 172M. 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
| 1972 | 3 |
|---|---|
| 1973 | 24 |
| 1974 | 59 |
| 1975 | 82 |
| 1976 | 104 |
| 1977 | 99 |
| 1978 | 92 |
| 1979 | 80 |
| 1980 | 59 |
| 1981 | 50 |
| 1982 | 53 |
| 1983 | 34 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 38 |
| 1987 | 29 |
| 1988 | 28 |
| 1989 | 38 |
| 1990 | 37 |
| 1991 | 36 |
| 1992 | 31 |
| 1993 | 37 |
| 1994 | 24 |
| 1995 | 29 |
| 1996 | 23 |
| 1997 | 35 |
| 1998 | 30 |
| 1999 | 22 |
| 2000 | 22 |
| 2001 | 30 |
| 2002 | 26 |
| 2003 | 24 |
| 2004 | 18 |
| 2005 | 16 |
| 2006 | 18 |
| 2007 | 16 |
| 2008 | 24 |
| 2009 | 14 |
| 2010 | 15 |
| 2011 | 13 |
| 2012 | 18 |
| 2013 | 20 |
| 2014 | 20 |
| 2015 | 9 |
| 2016 | 10 |
| 2017 | 19 |
| 2018 | 14 |
| 2019 | 13 |
| 2020 | 16 |
| 2021 | 8 |
| 2022 | 24 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 12 |
| 2026 | 8 |
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\") = 1990
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
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") = 1990
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
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 CHI91LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Austin, MNThe pilot-in-command (student)'s failure to properly evaluate and compensate for gusty wind condiitons and to maintain directional of the aircraft during initial climb. Contributing was the student pilot's lack of total experience and wind gusts.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB NYC91FA034Accident · 2 fatalField investigationFinal reportCessna 172M · Perham, METhe pilot initiating flight into known icing conditions which resulted in an accumulation of airframe ice and a failure to maintain airspeed. The contributing factor was the existing icing conditions.NTSB MIA91FA029Accident · 1 fatalField investigationFinal reportCessna 172M · Homestead, FLThe failure of the pilot to insure adequate fuel was present in the aircraft for the flight resulting in loss of engine power due to fuel exhaustion.NTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB LAX91LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · San Carlos, CAThe pilot's visual lookout was inadequate.NTSB ANC90LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anchorage, AKThe pilot's poor judgement due to consumption of alcohol, and his improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL90LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Stokesdale, NCThe failure of the engine driven oil pump which resulted in oil starvation to the engine. Factors were: the faa's failure to provide sufficient standards for airworthiness directive compliance, and the rough terrain.NTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.NTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB ANC90FA167Accident · 2 fatalField investigationFinal reportTaylorcraft DCO-75 · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.NTSB MIA90LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLThe failure of the pilot to arrest the high rate of descent prior to touchdown.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB LAX90LA289Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Goleta, CAThe loss of engine oil pressure for undetermined reasons.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB FTW90FA151Accident · Minor injuriesField investigationFinal reportCessna 172M · Elmendorf, TXInadequate visual lookout by both pilots in the T-38 and by the instructor pilot (CFI) in the Cessna 172.NTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.NTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.NTSB LAX90LA188Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for crosswind conditions. The crosswind was a factor in the accident.NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.NTSB LAX90LA166Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Jose, CAThe pilot's improper preflight, improper raising of the flaps after becoming airborne, and failure to maintain adequate flying speed, which resulted in an inadvertent stall.NTSB ATL90FA105Accident · 1 fatalField investigationFinal reportCessna 172M · Jonesboro, GAPilot-in-command's inadequate preflight and inflight planning, and his delayed climb after execution of a go-around. Contributing factors were his misreading of airfield wind information, his improper utilization of the flaps during climbout, his failure to…NTSB SEA90FA065Accident · Serious injuriesField investigationFinal reportCessna 172M · Incline Village, NVImproper in-flight planning/decision by the instructor pilot (CFI), and his failure to maintain adequate altitude and clearance from obstructions. Factors related to the accident were: mountainous terrain, high density altitude, and the trees (obstructions).NTSB LAX90LA131Accident · No injuriesLimited investigationFinal reportCessna 172M · Groveland, CAThe pilot improperly used the flight controls during the landing roll-out.NTSB DEN90LA079Accident · No injuriesLimited investigationFinal reportCessna 172M · Colorado Spring, COThe pilot's decision to initiate flight into known adverse weather, and his in-flight planning/decison. Factors related to the accident were: the adverse weather conditions, and the accumulation of airframe ice.NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB DEN90LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkhorn, MTThe pilot's decision to attempt flight in terrain and conditions which exceeded the performance capabilities of the airplane.NTSB LAX90LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Redding, CAThe pilot's decision not to use full flaps which resulted in a long landing on a wet runway.NTSB FTW90FA063Accident · 1 fatalField investigationFinal reportCessna 172M · Tomball, TXFailure of the pilot in Cessna 150, N714RS, to comply with the air traffic control clearance, and failure of both pilots to maintain adequate visual lookout to see-and-avoid each other. Factors related to the accident were: physical impairment of the pilot in…NTSB LAX90LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAImproper in-flight planning/decision by the pilot-in-command (PIC), and his failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall/mush.NTSB FTW90LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Goliad, TXThe pilot in command's failure to identify and correct for carburetor icing conditions which existed at the time of the accident and precipitated the precautionary landing.NTSB NYC90LA056Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Danbury, CTImproper maintenance, inadequate surveillance by the company/operator, and inadequate preflight by the pilot, which resulted in a fire during an attempted engine start. A factor related to the accident was: the unsecured fuel line.NTSB LAX90LA063Accident · No injuriesLimited investigationFinal reportMooney Mark 22 · Apple Valley, CAThe failure of the pilot of the Mooney to stop his aircraft in a timely manner to avoid a collision.