NTSB investigations: Cessna 182B, NM
8 cases on aircraft the registry lists as Cessna 182B. 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.
Cases per year
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'NM' 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 ('2072706'))
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" = 'NM' 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 ('2072706'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR25LA207Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182B · Belen, NMOn July 4, 2025, about 0900 mountain daylight time, a Cessna 182B, N7166E, was substantially damaged when it was involved in an accident near Belen, New Mexico. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB FTW82DA395Accident · Minor injuriesFinal reportCessna 182B · Albuquerque, NMThe pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon…NTSB DEN77FQA45Accident · No injuriesClosedCessna T210 · Abiquiu, NMNTSB DEN75DQG08Accident · No injuriesClosedCessna 182B · Clovis, NMNTSB DEN74FQA47Accident · No injuriesClosedCessna 182B · Farmington, NMNTSB DEN68D0161Accident · No injuriesClosedCessna 182 · Chama, NMNTSB DEN67F0146Accident · No injuriesClosedCessna 182B · Raton, NMNTSB DEN66D0309Accident · No injuriesClosedCessna 182 · Santa Rosa, NM