NTSB investigations: Cessna 182G, 1982
3 cases on aircraft the registry lists as Cessna 182G. 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 | 15 |
|---|---|
| 1965 | 19 |
| 1966 | 18 |
| 1967 | 20 |
| 1968 | 13 |
| 1969 | 7 |
| 1970 | 11 |
| 1971 | 10 |
| 1972 | 4 |
| 1973 | 9 |
| 1974 | 7 |
| 1975 | 9 |
| 1976 | 5 |
| 1977 | 5 |
| 1978 | 2 |
| 1979 | 4 |
| 1980 | 10 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 3 |
| 2007 | 3 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2017 | 1 |
| 2018 | 3 |
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2025 | 1 |
| 2026 | 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072716'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072716'))
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 NYC83FHA02Accident · Serious injuriesFinal reportCessna 182G · Rocky Hill, NJThe acft touched down on the last third of the rwy, made a series of bounces followed by a go-around at which time the acft collided with several tree tops & crashed.NTSB MIA83LA002Accident · No injuriesLimited investigationFinal reportCessna 182 · Cocoa, FLDuring takeoff, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot s-turned and landed on a clear area beside the runway to keep from going into a river. Subsequently, the nose gear collapsed and the aircraft flipped over.…NTSB MIA82DA097Accident · No injuriesFinal reportCessna 182G · Lake Wales, FLThe pilot stated that while on short final the engine would not respond to power increases and remained at idle speed. The pilot swerved around a building and dove the aircraft under wires finally coming to rest in a ditch. Examination of the fuel system…