NTSB investigations: Cessna 182L, 1989
4 cases on aircraft the registry lists as Cessna 182L. 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
| 1967 | 1 |
|---|---|
| 1968 | 29 |
| 1969 | 25 |
| 1970 | 22 |
| 1971 | 14 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 14 |
| 1975 | 10 |
| 1976 | 11 |
| 1977 | 3 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 6 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1998 | 3 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 3 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 3 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 1 |
| 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 ('2072726'))
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 ('2072726'))
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 DEN90LA024Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Dove Creek, COImproper flare by the student pilot, his failure to maintain runway alignment, and a delay by the flight instructor (CFI) in initiating remedial action, which resulted in a loss of airspeed and a stall/mush after the aircraft drifted over a cultivated field…NTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.NTSB LAX89LA123Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Watsonville, CAThe pilot's improperly planned approach, and his failure to maintain clearance from the wind sock pole. The proximity of the wind sock (arpt facility) was considered to be a related factor.NTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.