Skip to content

NTSB investigations: Cessna 172N, NV

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

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 ('2072434')) 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 ('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 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 ('2072434'))
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 WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.Apr 15, 2023 · N734NJ · Substantial damage NTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…Jul 17, 2022 · N97CX · 2 aircraft · Destroyed NTSB WPR13LA209Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVThe pilot’s inadequate preflight planning, including operating in excess of the maximum certified gross weight and center of gravity limits at a high density altitude, which resulted in the airplane’s inability to maintain a positive rate of climb after…Apr 28, 2013 · N3483E · Substantial damage NTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.Jul 20, 2005 · N4961D · Substantial damage NTSB LAX03LA294Accident · No injuriesLimited investigationFinal reportCessna 172N · Pahrump, NVthe pilot's failure to maintain altitude/clearance from the mountainous terrain while maneuvering, which resulted in an in-flight collision with terrain.Sep 21, 2003 · N6548D · Substantial damage NTSB LAX03FA100Accident · 2 fatalField investigationFinal reportCessna 172N · Ely, NVthe pilot's failure to maintain adequate terrain clearance while flying in a box canyon.Feb 23, 2003 · N9885J · Substantial damage NTSB LAX02LA205Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's decision to continue the flight after dark with an inoperative taxi/landing light deficiency, and his unfamiliarity with the taxiways.Jun 24, 2002 · N160RA · Substantial damage NTSB LAX01LA231Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder City, NVthe loss of engine power while in cruise flight due to the mechanic's improper magneto timing.Jul 1, 2001 · N737SH · Substantial damage NTSB LAX00LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe failure of the pilot-in-command to maintain proper airspeed during the aborted landing go-around which resulted in a stall/mush and impact with terrain.Sep 3, 2000 · N739HA · Substantial damage NTSB LAX96LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder City, NVa loss of directional control due to the student pilot's inadequate compensation for wind conditions and improper remedial action. Factors in the accident were crosswinds, inadvertent brake application, and failure to use the ailerons.Jul 21, 1996 · N6389D · Substantial damage NTSB LAX95LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's improper recovery from a bounced landing. His misjudgment of the height above the runway during flare was a factor.Jun 12, 1995 · N73927 · Substantial damage NTSB LAX95FA198Accident · 4 fatalField investigationFinal reportCessna 172N · Lovelock, NVthe pilot's intentional flight at low altitude and subsequent collision with transmission wires during dusk light conditions.May 28, 1995 · N4773E · Destroyed NTSB LAX94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Schurz, NVthe pilot's inability to maintain an adequate airspeed in the takeoff initial climb due to an encounter with a windshear.Jun 30, 1994 · N733AA · Destroyed NTSB LAX90LA333Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe pilot's failure to maintain sufficient airspeed resulting in an inadvertent stall. A factor in the accident was the strong crosswind conditions.Sep 22, 1990 · N6617D · Substantial damage NTSB SEA90LA069Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Minden, NVThe pilot's poor inflight planning and decision.Apr 20, 1990 · N1065F · Destroyed NTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…Feb 5, 1988 · N2249E · Substantial damage NTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…Apr 12, 1986 · N734JP · Substantial damage NTSB LAX83LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Yerrington, NVThe acft nosed over during a landing in a field near Yerrington, NV. After police found empty beer cans & some unidentified drugs in the aircraft, the plt resisted arrest & assaulted the officers. When interviewed at a hospital, he stated 'it was his time to…Jun 12, 1983 · N739BD · Substantial damage NTSB LAX81FXQ33Accident · No injuriesClosedCessna 172N · Reno, NVAug 23, 1981 · N1093F · Substantial damage NTSB LAX81FVW09Accident · Minor injuriesClosedCessna 172N · Boulder City, NVMar 29, 1981 · N2965E · Destroyed NTSB LAX81FVW05Accident · No injuriesClosedCessna 172N · Las Vegas, NVDec 18, 1980 · N5473D · Substantial damage NTSB LAX80DXQ34Accident · No injuriesClosedCessna 172 · Reno, NVJun 25, 1980 · N734DV · Substantial damage NTSB OAK78DXQ10Accident · Minor injuriesClosedCessna 172 · Incline Vlge, NVFeb 1, 1978 · N737XZ · Substantial damage NTSB OAK77FVW17Accident · No injuriesClosedCessna 172 · Las Vegas, NVMay 29, 1977 · N734GC · Substantial damage