NTSB investigations: Cessna 182P, 2007
13 cases on aircraft the registry lists as Cessna 182P. 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
| 1972 | 13 |
|---|---|
| 1973 | 23 |
| 1974 | 24 |
| 1975 | 29 |
| 1976 | 40 |
| 1977 | 36 |
| 1978 | 42 |
| 1979 | 31 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 25 |
| 1983 | 22 |
| 1984 | 13 |
| 1985 | 17 |
| 1986 | 14 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 13 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 11 |
| 1994 | 20 |
| 1995 | 8 |
| 1996 | 15 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 13 |
| 2002 | 7 |
| 2003 | 8 |
| 2004 | 13 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 13 |
| 2008 | 3 |
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 2 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 5 |
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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075816'))
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") = 2007
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075816'))
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 NYC08CA016Accident · No injuriesData collectionFinal reportCessna 182 · Hendersonville, NCThe pilot's failure to calculate weight and balance prior to departure, which resulted in departure above the maximum allowable gross weight, and the airplane's inability to climb. Contributing to the accident was the high density altitude.NTSB CHI08CA024Accident · No injuriesData collectionFinal reportCessna C-182 · Cedar Springs, MIThe pilot's decision to takeoff with strong, gusty winds and his inability to stop the airplane prior to it traveling off the end of the runway during the delayed aborted takeoff. Factors associated with the accident were the wet, grass airstrip and gusty…NTSB LAX08CA017Accident · No injuriesData collectionFinal reportCessna 182P · Troutdale, ORThe pilot's inadequate compensation for the tailwind condition and failure to maintain an adequate airspeed.NTSB DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB LAX07CA265Accident · No injuriesData collectionFinal reportCessna 182P · Fall City, WAThe pilot's failure to maintain directional control.NTSB CHI07CA284Accident · No injuriesData collectionFinal reportCessna 182P · Eau Claire, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor associated with the accident was the ditch.NTSB SEA07LA234Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDThe total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…NTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.NTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.NTSB SEA07CA216Accident · No injuriesData collectionFinal reportCessna 182P · Baker City, ORThe pilot's failure to maintain airspeed and misjudged flare during landing.NTSB SEA07CA150Accident · No injuriesData collectionFinal reportCessna 182P · Aurora, ORThe pilot's misjudged flare during landing, and his improper recovery from a bounced landing, resulting in collision with the runway.NTSB CHI07CA136Accident · No injuriesData collectionFinal reportCessna 182P · Traer, IAThe pilot's failure to maintain control of the airplane during landing on the grass airstrip. A contributing factor was the pilot's limited experience operating on grass runways. Additional factors were the runway cone struck during landing and the irrigation…NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.