NTSB investigations: Cessna 182P, 1987
7 cases on aircraft the registry lists as Cessna 182P. 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
| 1972 | 13 |
|---|---|
| 1973 | 23 |
| 1974 | 24 |
| 1975 | 29 |
| 1976 | 40 |
| 1977 | 36 |
| 1978 | 42 |
| 1979 | 31 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 25 |
| 1983 | 22 |
| 1984 | 13 |
| 1985 | 17 |
| 1986 | 14 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 13 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 11 |
| 1994 | 20 |
| 1995 | 8 |
| 1996 | 15 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 13 |
| 2002 | 7 |
| 2003 | 8 |
| 2004 | 13 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 13 |
| 2008 | 3 |
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 2 |
| 2024 | 6 |
| 2025 | 9 |
| 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 ('2075816'))
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 ('2075816'))
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 DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…NTSB MIA87LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Highland Beach, FLThe plt stated that they were at 1000 ft aprx 2 miles off shore en route to palm Beach international when the engine lost power & they ditched the acft in the ocean about 40 ft off the Beach. The salvage personnel stated that the left wing contained aprx 10…NTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…NTSB NYC87FA192Accident · 4 fatalField investigationFinal reportCessna 182P · Ellenville, NYThe acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000…NTSB NYC87LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Vera Cruz, PAThe plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but…NTSB ATL87FA074Accident · 2 fatalField investigationFinal reportCessna 182P · Crossville, TNThe rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…NTSB CHI87LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Utica, MIThe pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…