NTSB investigations: Cessna 182C, 1987
9 cases on aircraft the registry lists as Cessna 182C. 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 | 25 |
|---|---|
| 1965 | 16 |
| 1966 | 15 |
| 1967 | 19 |
| 1968 | 9 |
| 1969 | 11 |
| 1970 | 8 |
| 1971 | 7 |
| 1972 | 4 |
| 1973 | 4 |
| 1974 | 7 |
| 1975 | 8 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 9 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 9 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 4 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 2 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 5 |
| 2013 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 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 ('2072708'))
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 ('2072708'))
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 SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…NTSB ATL88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Hazel Green, ALThe airplane hit a tree and crashed about 300 yds short of the rwy while on final appch to land. The plt indicated that he became preoccupied with the airspeed indicator and allowed the airplane to descend below the proper glide path. The plt had less than 1…NTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…NTSB CHI87LA170Accident · No injuriesLimited investigationFinal reportCessna 182C · Clio, MIThe plt stated he departed with 55 gals of fuel. After 3.5 hrs of level flt at 7500 ft MSL he declared fuel exhaustion to the FAA flint twr. He was 3-4 miles frm a suitable arpt but was too low on final to reach the rwy. He landed on a road and struck a pole…NTSB MIA87LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Opa Locka, FLThe plt stated that he was on a long final apch for Opa Locka airport & he lost all power. During a forced landing in an open field he struck a pile of logs, collapsing the nose gear. Post crash run of the eng revealed no evidence that would suggest a failure…NTSB MKC87LA104Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Wamego, KSThe PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.…NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…NTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.NTSB MKC87LA047Accident · No injuriesLimited investigationFinal reportCessna 182C · Rolla, MOThe engine started running rough enroute and pilot was able to get it running smoothly but he continued to his destination. Airplane was too high on approach so pilot went around. On downwind, engine started running rough again and pilot was unable to correct…