NTSB investigations: Cessna 182B, 1989
6 cases on aircraft the registry lists as Cessna 182B. 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 | 19 |
|---|---|
| 1965 | 27 |
| 1966 | 21 |
| 1967 | 24 |
| 1968 | 13 |
| 1969 | 13 |
| 1970 | 12 |
| 1971 | 12 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 8 |
| 1975 | 9 |
| 1976 | 7 |
| 1977 | 8 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 6 |
| 1982 | 6 |
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 7 |
| 1992 | 7 |
| 1994 | 7 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 5 |
| 2025 | 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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072706'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072706'))
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 NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.NTSB NYC89FA177Accident · 7 fatalField investigationFinal reportBeech A36 · Salisbury Twp, PAThe failure of both pilots to see and avoid each other. A contributing factor to the accident was that neither pilot was heard over the radio announcing their position and intentions.NTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.NTSB MIA89LA103Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLFailure of the pilot to use the carburetor heat, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstructions (power lines & vehicles) in the emergency landing area.NTSB SEA89LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Bonneville, WASome form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.