NTSB investigations: Cessna 182P
22 cases on aircraft the registry lists as Cessna 182P, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2007 | 2 |
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 ('2075816')
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\" = 220))
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 ('2075816')
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" = 220))
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 NYC08CA016Accident · No injuriesData collectionFinal reportCessna 182 · Hendersonville, NCThe pilot's failure to calculate weight and balance prior to departure, which resulted in departure above the maximum allowable gross weight, and the airplane's inability to climb. Contributing to the accident was the high density altitude.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.NTSB DEN04LA052Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Monticello, UTthe pilot's failure to maintain aircraft control during takeoff. Contributing factors include the sudden windshift and the bushes.NTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.NTSB NYC03LA054Accident · 1 fatalLimited investigationFinal reportCessna 182P · So. Charleston, WVThe pilot's failure to perform a go-around prior to touchdown. Factors in the accident were the rising terrain and tail wind.NTSB CHI02LA055Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Elkhart, INThe pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.NTSB NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.NTSB SEA99GA007Accident · 1 fatalFinal reportCessna 182P · Deming, WATerrain clearance was not maintained for undetermined reasons. Mountainous terrain was a factor.NTSB LAX99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Payson, AZthe pilot's failure to maintain runway alignment during a go-around.NTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.NTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.NTSB CHI94LA130Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Chesterfield, MOFailure of the pilot to follow proper IFR procedures and maintain proper altitude during the approach. Factors related to the accident were: darkness, the weather conditions, and failure of the approach controller to issue an IFR transponder code to the…NTSB LAX92FA160Accident · 2 fatalField investigationFinal reportCessna 182P · Arcata, CAThe pilot's descent below decision height, and his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the adverse weather conditions and the dark night light conditions.NTSB LAX91FA344Accident · 1 fatalField investigationFinal reportCessna 182P · Lovelock, NVFailure of the pilot to maintain sufficient altitude for obstruction clearance, and his inadequate visual scan.NTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.NTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB SEA86LA122Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Smiths Ferry, IDThe plt was returning to home base from a business flight on which he delivered parts to company personnel. The acft was observed flying down the north fork of the river at low altitude with its wings dipping. Aprx one mile after entering the canyon, the acft…NTSB ATL83FIJ02Accident · Serious injuriesFinal reportCessna 182P · Bluefield, WVThe plt reported that he began an ILS approach to the mercer county arpt. He stated that he planned to descend to 3200 ft MSL, then execute a missed approach & return to abington, VA. The arpt elevation was 2857 ft MSL. He stated that he remembered glancing…NTSB ATL83FA012Accident · 1 fatalField investigationFinal reportCessna 182P · Conyers, GAAircraft was observed making low passes. During on of these low passes aircraft collided with wires, trees and a tennis court. Pilots blood ethanol level was 214 mg percent. The pilot had not been given permission by the owner to fly the aircraft.NTSB ANC82DAA09Accident · No injuriesFinal reportCessna 182 · Ft. Yukon, AKThe pilot stated that he overflew the Ft. Yukon airport and observed men working on runway 21. He flew a downwind pattern for runway 03. While on final approach to runway 03 the pilot observed an "x" on the end of the runway the pilot attempted a landing off…