Fatal NTSB investigations: Cessna 182F
25 cases on aircraft the registry lists as Cessna 182F. 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 |
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2019 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072714'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072714'))
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 WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.NTSB DEN04FA057Accident · 1 fatalField investigationFinal reportCessna 182F · Burlington, COloss of aircraft control due to structural icing. Factors contributing to the accident were the pilot's inadvertent flight into adverse weather conditions, the icing conditions, and ice fog.NTSB CHI99FA029Accident · 1 fatalField investigationFinal reportCessna 182F · Wichita, KSThe pilot's inadequate preflight inspection and contaminated fuel supply.NTSB ANC97FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 182F · Talkeetna, AKUndetermined.NTSB LAX91FA173Accident · 4 fatalField investigationFinal reportCessna 182F · Young, AZThe pilot's inadequate in-flight decision to continue VFR flight into instrument meteorological conditions and the loss of control of the airplane resulting in an inflight collision with terrain.NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB MKC85FA008Accident · 2 fatalField investigationFinal reportCessna 182F · Hiattville, KSThe acft crashed during a night x-country flt. Ground witnesses who saw the flash from the ground impact stated that there was a thunderstorm in the area at the time of the accident. They also stated that they had difficulty in locating the wreckage due to…NTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…NTSB MKC80FA014Accident · 1 fatalClosedCessna 182S · Womack, MONTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CANTSB MIA77FLG33Accident · 1 fatalClosedCessna 182 · Myrtle Beach, SCNTSB MIA77FA063Accident · 2 fatalClosedCessna 182F · Plymouth, FLNTSB NYC77FA062Accident · 3 fatalClosedCessna 182F · Oxbow, MENTSB SEA74AS007Accident · 4 fatalClosedCessna 182 · Salmon, IDNTSB FTW70AF054Accident · 4 fatalClosedCessna 182S · Jellico, TNNTSB LAX68A0077Accident · 4 fatalClosedCessna 182F · Carlsbad, CANTSB LAX68A0045Accident · 5 fatalClosedCessna 182 · Grand Canyon, AZNTSB MKC68A0029Accident · 3 fatalClosedCessna 182F · Leopold, MONTSB DIA68A0010Accident · 2 fatalClosedCessna 182 · Tangier, VANTSB MKC67A0048Accident · 1 fatalClosedCessna 182F · Sikeston, MONTSB MKC66A0062Accident · 1 fatalClosedCessna 182 · Hyannis, NENTSB CHI65A0098Accident · 2 fatalClosedCessna 182 · Indianapolis, INNTSB UNK64X0213Accident · 1 fatalClosedCessna 182F · Thernopolis, WY