Skip to content

NTSB investigations: Cessna 172M, NV

23 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA' 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

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 c.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA'
  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

Run 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 WPR23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172M · Carson City, NVThe pilot’s failure to maintain aircraft control during an aborted landing in gusting wind conditions.Aug 25, 2023 · N4432R · Substantial damage NTSB WPR23LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Las Vegas, NVThe student helicopter pilot’s failure to follow the tower controller’s landing instructions, which resulted in a midair collision.Nov 18, 2022 · N88E · 2 aircraft · Substantial damage NTSB LAX03LA023Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, NVThe pilot's failure to maintain directional control during takeoff. A contributing factor was the ditch.Nov 5, 2002 · N13265 · Substantial damage NTSB LAX01LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Carson City, NVThe pilot's failure to follow the approved procedures for the aircraft when he attempted to takeoff at high density altitude with the wing flaps fully extended.Jul 19, 2001 · N20466 · Substantial damage NTSB LAX01LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain runway alignment.Apr 1, 2001 · N9572H · Substantial damage NTSB LAX99LA123Accident · No injuriesLimited investigationFinal reportCessna 172M · Reno, NVThe pilot's inadequate compensation for the crosswind condition and his failure to maintain runway alignment during the crosswind landing.Mar 19, 1999 · N5242R · Substantial damage NTSB LAX98LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Henderson, NVThe pilot's decision to attempt a landing in crosswind conditions at or above the demonstrated capability of the aircraft, and his subsequent failure to maintain proper runway alignment.Apr 26, 1998 · N64006 · Substantial damage NTSB LAX94LA349Accident · 1 fatalLimited investigationFinal reportCessna 172M · Jackpot, NVthe pilot's failure to maintain aircraft control due to spatial disorientation during a moonless night departure over an area without ground reference lights. A factor in the accident was the pilot's lack of instrument training and experience.Sep 3, 1994 · N21704 · Destroyed NTSB LAX94LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVthe pilot's decision to attempt a landing in crosswind conditions which exceeded the capability of the aircraft.Aug 8, 1994 · N4390R · Substantial damage NTSB LAX91LA296Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Minden, NVThe flight instructor's inadequate supervision of the student pilot during a simulated emergency.Jul 8, 1991 · N9598H · Substantial damage 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.Sep 22, 1990 · N13686 · Substantial damage 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).Apr 13, 1990 · N9021H · Destroyed NTSB SEA89LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVThe student pilot's improper compensation for wind conditions, and improper recovery from a bounced landing. Factors related to the accident were: the adverse wind condition and the student's lack of total flying experience.Jul 29, 1989 · N9598H · Substantial damage NTSB SEA88LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Battle Mountain, NVAt about 1 mile from the departure airport and 200 feet AGL, the pilot elected to make a right turn back to the airport, as the aircraft was not climbing and power lines were in the flight path. During the turn, the pilot lost control of the aircraft. The…Sep 10, 1988 · N8895V · Destroyed NTSB SEA88LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Mead, NVThe pilot was flying very close to the water for the purpose of dropping beer to friends. The pilot allowed the aircraft to inadvertently descend and strike the water.Apr 12, 1988 · N91555 · Destroyed NTSB LAX82DA060Accident · No injuriesFinal reportCessna 172M · Carson City, NVThe aircraft struck an 18 inch high frozen snow bank that a snow plow had left stretched across the approach end of runway 09. The pilot not able to see the snow bank due to fresh fallen snow. The right main gear was sheared off and the aircraft slid to a…Jan 22, 1982 · N13083 · Substantial damage NTSB LAX80FVW19Accident · No injuriesClosedCessna 172M · Las Vegas, NVJul 3, 1980 · N5235R · Substantial damage NTSB OAK79DVW10Accident · No injuriesClosedCessna 172 · Gabbs, NVFeb 27, 1979 · N64216 · Destroyed NTSB OAK78FXQ31Accident · No injuriesClosedCessna 172 · Reno, NVAug 19, 1978 · N61710 · Substantial damage NTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVDec 22, 1976 · N12364 · Destroyed NTSB OAK76FVW17Accident · No injuriesClosedCessna 172M · Boulder City, NVApr 6, 1976 · N9977V · Substantial damage NTSB OAK76FXQ26Accident · Minor injuriesClosedCessna 172M · Carson City, NVNov 26, 1975 · N12404 · Substantial damage NTSB OAK76FVW06Accident · No injuriesClosedCessna 172M · Pioche, NVNov 8, 1975 · N12726 · Substantial damage