NTSB investigations: Cessna 180, 1997
8 cases on aircraft the registry lists as Cessna 180. 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 | 61 |
|---|---|
| 1965 | 58 |
| 1966 | 61 |
| 1967 | 61 |
| 1968 | 32 |
| 1969 | 47 |
| 1970 | 44 |
| 1971 | 33 |
| 1972 | 38 |
| 1973 | 34 |
| 1974 | 35 |
| 1975 | 39 |
| 1976 | 29 |
| 1977 | 27 |
| 1978 | 20 |
| 1979 | 24 |
| 1980 | 29 |
| 1981 | 23 |
| 1982 | 17 |
| 1983 | 16 |
| 1984 | 14 |
| 1985 | 8 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 14 |
| 1989 | 10 |
| 1990 | 15 |
| 1991 | 13 |
| 1992 | 14 |
| 1993 | 11 |
| 1994 | 6 |
| 1995 | 13 |
| 1996 | 11 |
| 1997 | 8 |
| 1998 | 12 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 5 |
| 2005 | 13 |
| 2006 | 12 |
| 2007 | 9 |
| 2008 | 12 |
| 2009 | 7 |
| 2010 | 12 |
| 2011 | 10 |
| 2012 | 8 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 9 |
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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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 FTW98FA067Accident · 1 fatalField investigationFinal reportCessna 180 · Johnson City, TXThe pilot's failure to maintain obstacle clearance. Factors were the low ceilings, dark night light conditions, and the pilot's lack of visible horizon in the unpopulated area.NTSB ANC97LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · King Salmon, AKThe distorted/misaligned main landing gear, and an improper maintenance repair of the main landing gear. A factor associated with the accident was rough and uneven terrain.NTSB ANC97LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Umiat, AKThe collapse of the right main landing gear while taxiing to parking.NTSB FTW97LA279Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlisle, ARthe pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).NTSB LAX97LA203Accident · No injuriesLimited investigationFinal reportCessna 180 · Hollister, CAThe pilot's improper use of the elevator and his subsequent failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's application of full power following the loss of directional control, which increased…NTSB NYC97FA099Accident · Serious injuriesField investigationFinal reportCessna 180 · Freedom, PAthe pilot's premature lift off, and his failure to maintain proper runway alignment, which resulted in an inadvertent stall, while attempting to avoid an obstruction (telephone pole). Factors relating to the accident were: the pilot allowed the airplane's…NTSB ANC97LA077Accident · No injuriesLimited investigationFinal reportCessna 180 · Shaktoolik, AKloss of engine power for undetermined reason(s).NTSB LAX97WA194Accident · No injuriesForeign investigationCessna 180 · Rancho Santa Yn, Mexico