NTSB investigations: Cessna 172N, 1992
40 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\") = 1992
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") = 1992
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 FTW93LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Tryon, OKPower loss due to fuel starvation and the pilots improper selection of the off position on the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB LAX93FA046Accident · 2 fatalField investigationFinal reportCessna 172N · Tehachapi, CAThe pilot's decision to cruise at an altitude inadequate to ensure terrain clearance. Factors which contributed to the accident were: the pilot's failure to obtain a preflight weather briefing, the dark night, and likely instrument meteorological conditions.NTSB MIA93LA016Accident · No injuriesLimited investigationFinal reportCessna 172N · Ormond Beach, FLA fire of an undetermined source which erupted in the left cabin area during takeoff.NTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.NTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.NTSB ATL93LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Apex, NCThe pilot's improper in-flight planning and his inadequate compensation for wind conditions, which resulted in the overrun of the runway. Factors were the tail wind conditions, and the downhill, grass runway.NTSB DEN93LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COFailure of the pilot in command to maintain directional control during landing roll. A factor was excessive airspeed during landing.NTSB DEN92LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COThe pilot's failure to maintain directional control of the airplane. A factor was: crosswind.NTSB BFO92LA142Accident · No injuriesLimited investigationFinal reportCessna 172N · Havre De Grace, MDThe pilot's improper use of carburetor heat control resulting in a total loss of engine power. Factors contributing to the accident include the existence of weather conditions conducive to carburetor icing and the rough terrain on which the aircraft was…NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB ANC92LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Seldovia, AKThe failure of the pilot to perform a go around when a tail wind was encountered prior to touch down. Factors related to the accident were: the tailwind and the downdraft.NTSB LAX92LA382Accident · No injuriesLimited investigationFinal reportCessna 172N · Fillmore, CAThe first pilot's poor inflight decision to fly into a box canyon. Contributing to this accident was the box canyon and the downdraft.NTSB LAX92LA380Accident · No injuriesLimited investigationFinal reportCessna 172N · Stanfield, AZThe cfi's poor in-flight decision to demonstrate the simulated engine out emergency landing at too low an altitude and misjudging the altitude during the circling maneuver.NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.NTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.NTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.NTSB LAX92LA342Accident · No injuriesLimited investigationFinal reportCessna 172 · Van Nuys, CAThe student pilot's improper use of the checklist to assure that the trim tab was in the proper position and failure to follow normal procedures and directives. Contributing to this accident was the pilot's lack of total experience, misreading of the trim…NTSB MIA92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Panama City, FLThe pilot-in-command's failure to stand clear of the propeller as he rotated it by hand, resulting in the propeller rotating around due to engine compression, striking the pilot, causing him to lose his balance and fall to the ramp, resulting in serious…NTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.NTSB MIA92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sanford, FLInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid of the power line. The proximity of the power line was a related factor.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB CHI92LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOThe improper use of the aircraft brake system by the pilot in command.NTSB LAX92LA265Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe student pilot's misjudging the landing flare, the cfi's delayed remedial action and his failure to adequately supervise the conduct of the flight.NTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.NTSB BFO92LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Coatesville, PAThe passengers interference with the control yoke, which resulted in the airplane entering an unusual attitude, and the pilot overstressing the wings during the recovery.NTSB BFO92LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172N · St Francis, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The wind condition was a related factor.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB NYC92LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryan, OHThe failure of the student pilot to maintain directional control during landing roll. Factors related to the accident were: the pilot's lack of total experience and lack of recent experience.NTSB NYC92LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · New Madison, OHThe pilot's failure to attain a proper touchdown point. Contributing to the accident was the pilot inadequately planned his approach and his failure to perform a go-around.NTSB NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.NTSB NYC92LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, OHThe failure of the pilot to maintain airplane directional control after landing, which resulted in a departure from the runway and encounter with rough terrain.NTSB LAX92FA164Accident · Serious injuriesField investigationFinal reportCessna 172N · Claremont, CAThe pilots improper preflight and inflight planning/decisions, his continued VFR flight into IMC conditions, and his failure to initiate timely remedial actions.NTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…NTSB MIA92LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilots in command of both aircraft failure to maintain vigilance and see and avoid each other resulting in a midair collision. Contributing to the accident was the local controllers failure to issue traffic advisories.NTSB DEN92LA033Accident · No injuriesLimited investigationFinal reportCessna 172N · Parshall, COImproper use of powerplant controls by the duel student and inadequate supervision by the CFI. Factors were: carburetor heat not used, deep snow covered terrain, and carburetor ice conditions.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.NTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.