Skip to content

NTSB investigations: Cessna 172, NV

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

19642026

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 WPR10CA144Accident · No injuriesData collectionFinal reportCessna 172 · Sparks, NVA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the correct fuel selector position.Feb 22, 2010 · N7499A · Substantial damage NTSB WPR10LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Pahrump, NVFuel starvation as a result of the improper installation of the carburetor float valve by unknown personnel.Jan 30, 2010 · N8959B · Substantial damage NTSB LAX96LA278Accident · 1 fatalLimited investigationFinal reportCessna 172 · Midas, NVthe decision of the pilot to perform a low-level steep turn which resulted in an inadvertent loss of control and subsequent stall/spin. Factors were high density altitude and inadequate altitude for recovery.Jul 19, 1996 · N1958D · Destroyed NTSB LAX93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Montgomery Pass, NVThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the downdraft, low ceiling, rain, obscuration, and the mountainous terrainJun 5, 1993 · N6185E · Destroyed NTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…Aug 2, 1987 · N8696B · Destroyed NTSB LAX83LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Alamo, NVAfter takeoff from a desert road the acft settled & struck a yucca tree.Nov 7, 1982 · N41783 · Substantial damage NTSB LAX81FA013Accident · 1 fatalClosedCessna 172 · Winnemucca, NVNov 14, 1980 · N6848A · Destroyed NTSB OAK78FVW07Accident · Serious injuriesClosedCessna 172 · Boulder City, NVDec 30, 1977 · N5951A · Destroyed NTSB OAK74DXQ43Accident · No injuriesClosedCessna 172 · Minden, NVJun 7, 1974 · N5139A · Substantial damage NTSB OAK71FVW20Accident · Minor injuriesClosedCessna 172 · Las Vegas, NVJan 3, 1971 · N6350E · Substantial damage NTSB OAK69D0298Accident · No injuriesClosedCessna 172 · Caliente, NVMar 30, 1969 · N7915B · Substantial damage NTSB OAK68A0034Accident · 2 fatalClosedCessna 150G · Las Vegas, NVOct 8, 1967 · N3229J · 2 aircraft · Destroyed NTSB OAK67D0163Accident · No injuriesClosedCessna 172 · Wendover, NVNov 3, 1966 · N8613B · Substantial damage NTSB OAK67F0096Accident · Serious injuriesClosedRyan PT-22 · Sparks, NVSep 25, 1966 · N56243 · 2 aircraft · Substantial damage NTSB LAX66D0283Accident · No injuriesClosedCessna 172 · Las Vegas, NVJan 23, 1966 · N5380R · Substantial damage NTSB LAX66F0320Accident · No injuriesClosedCessna 172 · Las Vegas, NVJan 18, 1966 · N5773A · Substantial damage NTSB LAX66D0170Accident · No injuriesClosedCessna 172 · Las Vegas, NVNov 7, 1965 · N5380R · Substantial damage NTSB UNK64X2170Accident · No injuriesClosedCessna 172 · Lathrop Wells, NVJun 7, 1964 · N7954B · Substantial damage NTSB UNK64X1024Accident · No injuriesClosedCessna 172 · Boulder City, NVMar 23, 1964 · N8118B · Substantial damage