NTSB investigations: Cessna 172P, NV

10 cases on aircraft the registry lists as Cessna 172P. 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

19832026

NTSB investigations: Cessna 172P, NV per year, 1983–2026: 10 cases
1983	1
1985	1
1988	1
1989	1
1994	1
1995	1
2003	1
2006	1
2010	2

Where

Open the map

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 ('2072436')) 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 ('2072436'))
  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 ('2072436'))
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 WPR10CA255Accident · No injuriesData collectionFinal reportCessna 172P · Las Vegas, NVThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during taxi.May 22, 2010 · N529MC · Substantial damage NTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.Apr 28, 2010 · N914JM · Substantial damage NTSB LAX06CA281Accident · No injuriesData collectionFinal reportCessna 172P · Spanish Springs, NVthe pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.Sep 1, 2006 · N97306 · Substantial damage NTSB LAX03FA124Accident · 2 fatalField investigationFinal reportCessna 172P · North Las Vegas, NVthe applicant pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall/spin.Apr 4, 2003 · N553CH · Destroyed NTSB LAX95LA267Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's loss of directional control during a crosswind landing using full flaps and the lack of familiarity with the crosswind landing component chart for the aircraft.Jul 24, 1995 · N65923 · Substantial damage NTSB LAX94LA186Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Elko, NVthe student pilot's improper use of the throttle and flap controls during a bounced landing recovery, and, his failure to maintain an adequate airspeed, which led to an inadvertent stall/spin.Apr 11, 1994 · N54006 · Substantial damage NTSB SEA89GA064Accident · Minor injuriesFinal reportCessna 172P · Hawthorne, NVThe failure of the pilot to maintain flying speed and proper flying attitude resulting in a stall mush. Contributing to the accident were the density altitude and the variable winds.Apr 2, 1989 · N99713 · Destroyed NTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…Mar 10, 1988 · N98525 · Substantial damage NTSB SEA86LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Winnemucca, NVDirectional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over.Oct 1, 1985 · N53432 · Substantial damage NTSB LAX83LA380Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Jean, NVThe plt took off from the mccarran intl arpt, las vegas, NV & flew to another arpt in the local area at Jean, NV to practice soft field takeoff & landing techniques. During his 1st soft field takeoff, he over rotated the acft & the tail cone contacted the…Aug 10, 1983 · N52023 · Substantial damage