NTSB investigations: Cessna 182A
12 cases on aircraft the registry lists as Cessna 182A, where the first occurrence was “Loss of control - in flight”. 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 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 250))
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" = 250))
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 LAX99FA220Accident · 4 fatalField investigationFinal reportCessna 182A · Paso Robles, CAthe pilot's failure to set the trim as prescribed by the published check list. This led to a steep climb angle which caused the airspeed to decay, resulting in a stall at an altitude too low to allow recovery.NTSB NYC97LA140Accident · No injuriesLimited investigationFinal reportCessna 182A · Hayfield Twnshp, PAThe pilot's improper decision to attempt a takeoff from unsuitable terrain and failure to maintain airspeed. A factor in this accident was the gusty wind conditions.NTSB BFO94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Berea, KYThe pilot-in-command's failure to maintain adequate airspeed during the takeoff. A factor related to the accident is the gusty wind conditions.NTSB CHI92LA245Accident · No injuriesLimited investigationFinal reportCessna 182A · Colfax, INThe pilot's selection of the wrong runway and a premature lift off. Factors were uphill terrain and unfavorable (quartering/tail) wind.NTSB LAX91FA203Accident · 1 fatalField investigationFinal reportCessna 182A · Lee Vining, CAThe failure of the pilot to maintain aircraft control due to spatial disorientation during a night approach.NTSB FTW91FA072Accident · Serious injuriesField investigationFinal reportCessna 182A · Fentress, TXThe improper major modification of the airplane by the operator, and the resultant separation of the door, window and windshield. A factor was the installation of a non approved jump door.NTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…NTSB MIA87FA231Accident · Serious injuriesField investigationFinal reportCessna 182A · Pensacola, FLThe plt stated that just after liftoff he flew into a layer of haze and became disoriented, the aircraft stalled, crashed into a dirt mound, spun around and came to rest off the left side of the runway. The aircraft then exploded and was consumed by post…NTSB MKC86FA048Accident · 1 fatalField investigationFinal reportCessna 182A · Clinton, IAThe pilot normally made several touch and go landings before departing the local area. He was known to not fly near clouds or at night. For this flight, the ceiling was at least 1000 feet at takeoff and was at least 700 feet in the accident area. Airplane was…NTSB NYC85LA160Accident · No injuriesLimited investigationFinal reportCessna 182P · Newport, NHThe acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft…NTSB FTW83FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Bethany, OKThe student pilot departed Oklahoma city, OK en route to chickasha, OK. The acft was observed to depart runway 17R and proceed wsw of the airport. The acft wreckage was located about 1 1/2 miles west of wiley post airport. The acft was intact and exam…NTSB ATL82FA212Accident · 4 fatalField investigationFinal reportCessna 182A · Louisburg, NCWitnesses observed the takeoff roll as being unusually long. The acft never climbed much above 100-200 ft AGL, & struck trees 1/2 mi off the end of the rwy. The flaps were observed up during takeoff. Normal takeoff flap setting used by the club for carrying…