NTSB investigations: Cessna 182Q, 1987
9 cases on aircraft the registry lists as Cessna 182Q. 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
| 1977 | 6 |
|---|---|
| 1978 | 15 |
| 1979 | 21 |
| 1980 | 15 |
| 1981 | 17 |
| 1982 | 13 |
| 1983 | 14 |
| 1984 | 9 |
| 1985 | 8 |
| 1986 | 6 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 10 |
| 1990 | 4 |
| 1991 | 10 |
| 1992 | 10 |
| 1993 | 8 |
| 1994 | 6 |
| 1995 | 10 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 9 |
| 2000 | 5 |
| 2001 | 9 |
| 2002 | 15 |
| 2003 | 6 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 10 |
| 2008 | 2 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 10 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 8 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 5 |
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 ('2072732'))
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 ('2072732'))
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 MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…NTSB SEA87LA189Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cathlamet, WAThe pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop.NTSB DEN87LA227Accident · No injuriesLimited investigationFinal reportCessna 182Q · Albuquerque, NMThe instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake…NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB NYC87FA215Accident · 4 fatalField investigationFinal reportCessna 182Q · Sparta, NJThe acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was…NTSB LAX87LA274Accident · No injuriesLimited investigationFinal reportCessna 182Q · Upper Lake, CANTSB FTW87LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Midland, TXOn April 15, 1987, at approximatly 1910 CDT, the private pilot of a Cessna 182Q attempted to land on a 2650 ft dirt runway near Midland, TX. Witness stated she landed long and fast. The brakes failed due to a pre-existing crack in the left brake line. The…NTSB LAX87LA152Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palm Springs, CADuring a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was…NTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…