NTSB investigations: Cessna 182C, NV

11 cases on aircraft the registry lists as Cessna 182C. 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 182C, NV per year, 1964–2026: 11 cases
1964	2
1965	1
1966	1
1969	1
1971	1
1972	1
1987	1
1990	1
2010	1
2022	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 ('2072708')) 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 ('2072708'))
  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 ('2072708'))
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 WPR23LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182C · Boulder City, NVA total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.Oct 3, 2022 · N511W · Substantial damage NTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.Jan 23, 2010 · N8948T · Substantial damage NTSB LAX90LA313Accident · No injuriesLimited investigationFinal reportCessna 182C · Reno, NVFuel exhaustion and the pilot's failure to perform refueling.Aug 31, 1990 · N9021T · Substantial damage NTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…Dec 29, 1987 · N8819T · Destroyed NTSB OAK73DXQ07Accident · No injuriesClosedCessna 182 · Elko, NVAug 2, 1972 · N8941T · Substantial damage NTSB OAK71FVW30Accident · No injuriesClosedCessna 182C · Las Vegas, NVApr 25, 1971 · N8588T · Substantial damage NTSB OAK70D0028Accident · No injuriesClosedCessna 182 · Lovelock, NVJul 6, 1969 · N8977T · Substantial damage NTSB LAX66A0088Accident · 3 fatalClosedCessna 182C · Mcgill, NVMay 15, 1966 · N8520T · Destroyed NTSB UNK65X1230Accident · No injuriesClosedCessna 182 · Lathrup Wells, NVJan 4, 1965 · N9054T · Substantial damage NTSB UNK65X1057Accident · Serious injuriesClosedCessna 182 · Las Vegas, NVDec 19, 1964 · N8588T · Destroyed NTSB UNK64X2054Accident · Minor injuriesClosedCessna 206 · Wells, NVMay 31, 1964 · N5158U · Substantial damage