NTSB investigations: Cessna 182A, 1987
7 cases on aircraft the registry lists as Cessna 182A. 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 | 48 |
|---|---|
| 1965 | 43 |
| 1966 | 42 |
| 1967 | 28 |
| 1968 | 31 |
| 1969 | 24 |
| 1970 | 17 |
| 1971 | 21 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 19 |
| 1975 | 19 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 13 |
| 1979 | 8 |
| 1980 | 20 |
| 1981 | 11 |
| 1982 | 7 |
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 13 |
| 1986 | 11 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 14 |
| 1990 | 10 |
| 1991 | 13 |
| 1992 | 7 |
| 1993 | 8 |
| 1994 | 6 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 6 |
| 2003 | 8 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 4 |
| 2022 | 1 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072704'))
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 year(c."eventDate") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072704'))
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 LAX88LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Laveen, AZThe pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…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 SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…NTSB LAX87LA278Accident · No injuriesLimited investigationFinal reportCessna 182A · Strathmore, CADuring a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx…NTSB ATL87LA217Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAPIC dpted, intending to fly 0.5 hours on tach. Acft had 11 gals of fuel, 5 in left tank & 6 in right tank. PIC made left climbing spiral to 9000 feet and maneuvered in left turn around airport. On a long staight in, final appch eng quit at about 500 feet AGL.…NTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.