NTSB investigations: Cessna 182E, NV

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

19652026

NTSB investigations: Cessna 182E, NV per year, 1965–2026: 6 cases
1965	1
1966	1
1967	1
1993	1
2001	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 ('2072712')) 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 ('2072712'))
  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 ('2072712'))
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 LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.May 20, 2001 · N9344X · Substantial damage NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.Mar 16, 2001 · N9277X · Substantial damage NTSB LAX93LA350Accident · No injuriesLimited investigationFinal reportCessna 182E · Minden, NVthe pilot's inadequate preflight planning and failure to use all available runway. A factor in the accident was the high density altitude condition.Sep 12, 1993 · N3393Y · Substantial damage NTSB LAX68D0135Accident · No injuriesClosedCessna 182 · Temple Bar, NVSep 17, 1967 · N2823Y · Substantial damage NTSB OAK67D0085Accident · No injuriesClosedCessna 182 · Elko, NVAug 21, 1966 · N3303Y · Substantial damage NTSB LAX66F0123Accident · No injuriesClosedCessna 182 · Las Vegas, NVOct 3, 1965 · N2998Y · Substantial damage