NTSB investigations: Cessna 182A
13 cases on aircraft the registry lists as Cessna 182A, 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
| 1986 | 2 |
|---|---|
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 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 ('2072704')
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 ('2072704')
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 CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.NTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB FTW01LA144Accident · No injuriesLimited investigationFinal reportCessna 182A · Baytown, TXThe unqualified person's failure to maintain clearance with the power lines while maneuvering. A factor was the dark night light conditions.NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).NTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.NTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB FTW89LA054Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Brownsville, TXThe pilot failed to compensate for the existing wind conditions and maintain proper alignment with the runway. The wind conditions and the sunglare are considered to be contributing factors to the accident.NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB LAX88FA187Accident · 2 fatalField investigationFinal reportCessna 182A · Grand Canyon, AZPilots selection of an inappropriate cruise altitude which did not ensure adequte terrain clearance on the leg of the flight from page to Grand Canyon, Arizona. A factor in the accident was the pilot's flight schedule on the day of the accident which may have…NTSB FTW86LPA19Accident · No injuriesFinal reportCessna 182A · Decatur, TXThe acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…NTSB DEN86LA078Accident · No injuriesLimited investigationFinal reportCessna 182 · Wray, COAccording to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the…