NTSB investigations: Cessna 182R, 1988
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\") = 1988
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") = 1988
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 LAX89FA058Accident · 2 fatalField investigationFinal reportCessna 182R · Gorman, CAThe aircraft entered into an uncontrolled descent. The existence of a mountain wave along the aircraft's flight route, the failure of the crew to evaluate reported weather conditions along the flight route, the crews attempt to fly into known adverse weather…NTSB FTW88DRG12Accident · No injuriesFinal reportCessna 182R · Spicewood, TXThe plt said the windsock indicated the wind was from the northeast; however, witnesses said the winds were from the south & the acft landed downwind. The plt said he went around after the 1st apch, & on the next pattern, he made a lowerfinal apch. He said…NTSB DEN88GA185Accident · 1 fatalFinal reportCessna 182R · Georgetown, CONTSB MIA88LA205Accident · No injuriesLimited investigationFinal reportCessna 182R · Tampa, FLThe plt rprtd that drg the takeoff roll, he 'rotated aircraft at 65 kts' but it would not become airborne. He then aborted the takeoff, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit a ditch & nosed over. An exam of the flt…NTSB FTW88LA122Accident · No injuriesLimited investigationFinal reportCessna 182R · Garden City, TXThe pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…NTSB DEN88LA073Accident · No injuriesLimited investigationFinal reportCessna 182R · Pueblo, COThe instrument rated pvt plt was completing a personal IFR flight from telluride, Colorado, to Colorado springs, Colorado, with three pax. The destination wx went below IFR minimums prior to the flight's arrival and the aircraft diverted to Pueblo, Colorado,…