NTSB investigations: Cessna 182, NV

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

NTSB investigations: Cessna 182, NV per year, 1964–2026: 9 cases
1964	1
1966	1
1969	2
1970	2
1979	1
1987	1
1993	1

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 ('2072702')) 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 ('2072702'))
  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 ('2072702'))
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 LAX93LA222Accident · No injuriesLimited investigationFinal reportCessna 182P · Reno, NVIncorrect installation of a bearing in the airplane's alternator during overhaul by maintenance personnel. A factor in the accident was the rough, uneven terrain.May 24, 1993 · N642WR · Substantial damage NTSB SEA87LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Boulder City, NVThe pilot was attempting to land the aircraft with a 15 knot tailwind gusting to 20 knots. The density altitude was over 6,000 feet and the runway was an uphill runway with rising terrain ahead. The pilot stated that he decided to go-around but that shortly…Aug 19, 1987 · N5549B · Substantial damage NTSB LAX79DVW18Accident · No injuriesClosedCessna 182A · Las Vegas, NVJul 7, 1979 · N6319B · Substantial damage NTSB OAK71DXQ21Accident · No injuriesClosedCessna 182 · Reno, NVOct 12, 1970 · N5349B · Substantial damage NTSB OAK71AP014Accident · 4 fatalClosedCessna 182 · Virginia City, NVSep 12, 1970 · N5828B · Destroyed NTSB OAK70F0132Accident · Minor injuriesClosedCessna 182 · Las Vegas, NVSep 10, 1969 · N5510B · Destroyed NTSB OAK70F0175Accident · No injuriesClosedCessna 182 · N.Las Vegas, NVJun 16, 1969 · N5543B · Substantial damage NTSB LAX66F0316Accident · No injuriesClosedCessna 182 · Tonapah, NVMar 25, 1966 · N5616B · Substantial damage NTSB UNK64X3434Accident · 1 fatalClosedCessna 182 · Elko, NVAug 16, 1964 · N5436B · Destroyed