NTSB investigations: Cessna 182E, NM
12 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 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 ('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" = '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 ('2072712'))
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 DEN04LA077Accident · No injuriesLimited investigationFinal reportCessna 182E · Santa Teresa, NMthe pilot's inadequate in-flight planning and decision-making, which resulted in the loss of engine power due to fuel exhaustion. Contributing factors to the accident were the fuel exhaustion and the lack of suitable terrain for a forced landing.NTSB DEN00FA053Accident · 1 fatalField investigationFinal reportCessna 182E · El Prado, NMThe pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…NTSB FTW98LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Las Cruces, NMthe pilot's improper use of (or failure to use) carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Related factors were: the carburetor icing (weather) conditions, and the lack of suitable terrain for a forced…NTSB FTW82DA298Accident · No injuriesFinal reportCessna 182E · Albuquerque, NMThe pilot stated that after a normal approach, the aircraft touched down at about 90 mph on the first 1/4 to 1/3 of the runway. He raised the flaps and applied brakes. He noticed that there was insufficient braking action to stop on the wet runway, but by the…NTSB DEN77FA029Accident · 3 fatalClosedCessna 182E · Pecos, NMNTSB DEN75DQA46Accident · No injuriesClosedCessna 182E · Roy, NMNTSB DEN69D0253Accident · No injuriesClosedCessna 182E · Albuquerque, NMNTSB DEN68F0224Accident · No injuriesClosedCessna 182 · Raton, NMNTSB DEN68D0157Accident · No injuriesClosedCessna 182 · Roswell, NMNTSB DEN67D0220Accident · No injuriesClosedCessna 182 · Regina, NMNTSB DEN66A0034Accident · 3 fatalClosedCessna 182E · Santa Fe, NMNTSB UNK64X1911Accident · No injuriesClosedCessna 182 · Carlsbad, NM