NTSB investigations: Cessna 182R, 1987
6 cases on aircraft the registry lists as Cessna 182R. 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 8 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2018 | 1 |
| 2020 | 3 |
| 2022 | 2 |
| 2023 | 3 |
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 ('2072731'))
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 ('2072731'))
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 FTW87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Alice, TXThe pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical…NTSB LAX87LA206Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Carefree, AZAt the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…NTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.NTSB LAX87FA146Accident · 2 fatalField investigationFinal reportCessna 182R · Avenal, CAThe plt, with suspended commerical privileges & no current medical cert, borrowed his parents acft. While flying along an interstate highway at night, the acft collided with electrical transmission lines & crashed. Initial impact occurred at about 115' AGL.…NTSB ATL87LA072Accident · No injuriesLimited investigationFinal reportCessna 182R · Mobile, ALThe student plt was making a second attempt to land after a hard ldg, bounce, and subsequent go-around. On the first attempt, the acft touched down hard on all three wheels and swerved to the rt. The student plt reportedly pulled the nose up and the acft…NTSB SEA87LA052Accident · No injuriesLimited investigationFinal reportCessna 182R II · Spokane, WAPlt attempted instrument approach in conditions conducive to structural icing; I.e., fog, light snow, temp 32F. Acft not equipped for deice. Structural ice accretion during approach and climb-out following missed approach degraded acft performance so that…