NTSB investigations: Cessna 182E
6 cases on aircraft the registry lists as Cessna 182E, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072712')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072712')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 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 SEA99FA150Accident · 4 fatalField investigationFinal reportCessna 182E · Ryegate, MTThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from mountainous terrain. Factors include low ceilings and inadequate in-flight planning.NTSB CHI96FA094Accident · 2 fatalField investigationFinal reportCessna 182 · Odell, ILVFR flight by the pilot into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, probably due to spatial disorientation of the pilot. Factors relating to the accident were: darkness, reduced visibility due to the weather…NTSB ATL91FA031Accident · 1 fatalField investigationFinal reportCessna 182E · Saluda, NCThe continued visual flight rules flight into instrument meteorological conditions. Contributing factor were fog, rain, and low ceiling.NTSB DEN83FA084Accident · Serious injuriesField investigationFinal reportCessna 182 · Huntsville, UTThe afct collided with a tree and crashed during a go-around. The weather was IMC and the pilot and passenger were seriously injured. The pilot received a weather briefing and was told that VFR flt, on his intended route, was not recommended due to low…NTSB FTW82FRG30Accident · 2 fatalFinal reportCessna 182E · Armstrong, TXBefore taking off, the pilot reviewed the weather in person at the college station fss, but declined an official weather briefing. He departed in good VFR conditions and flew into an area of known and forcasted low ceilings. While en route, his flight path…