NTSB investigations: Cessna 180A, 1996
3 cases on aircraft the registry lists as Cessna 180A. 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
| 1962 | 2 |
|---|---|
| 1963 | 2 |
| 1964 | 10 |
| 1965 | 6 |
| 1966 | 13 |
| 1967 | 8 |
| 1968 | 8 |
| 1969 | 7 |
| 1970 | 13 |
| 1971 | 9 |
| 1972 | 4 |
| 1973 | 7 |
| 1974 | 4 |
| 1975 | 7 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 1 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 3 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1998 | 1 |
| 1999 | 7 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 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\") = 1996
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072604'))
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") = 1996
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072604'))
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 ANC96LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot of the Cessna 180, N5020E, disregard of an air traffic control clearance/instruction to hold short. A factor in the accident was the failure of both pilots to maintain an adequate visual lookout for other aircraft.NTSB NYC96LA128Accident · No injuriesLimited investigationFinal reportCessna 180 · Fulton, NYThe pilot's inadequate compensation for wind conditions.NTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.