NTSB investigations: Cessna 172E, 1984
7 cases on aircraft the registry lists as Cessna 172E. 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 | 52 |
|---|---|
| 1965 | 50 |
| 1966 | 32 |
| 1967 | 28 |
| 1968 | 25 |
| 1969 | 19 |
| 1970 | 24 |
| 1971 | 18 |
| 1972 | 14 |
| 1973 | 7 |
| 1974 | 9 |
| 1975 | 5 |
| 1976 | 10 |
| 1977 | 8 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 7 |
| 1981 | 5 |
| 1982 | 7 |
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 8 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 3 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 6 |
| 2006 | 3 |
| 2007 | 4 |
| 2009 | 4 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 5 |
| 2021 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412'))
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 ANC84LA159Accident · No injuriesLimited investigationFinal reportCessna 172E · Palmer, AKThe acft was taking off from an airport which was an unimproved field site. According to the plt the acft would not accelerate and climb out so he stalled into the brush along a creek bed. The plt said the acft had departed this field before but both times…NTSB CHI84LA318Accident · No injuriesLimited investigationFinal reportCessna 172 · Urbana, OHThe pilot stated after the accident that he arrived at his flight planned destination 15 minutes early so he continued the flight an additional hour. The plt experienced an eng failure while on final apch to the rwy at the revised destination arpt. The plt…NTSB LAX84LA416Accident · No injuriesLimited investigationFinal reportCessna 172E · Elk Grove, CAThe acft bounced several times during landing according to a plt witness near the rwy. During the bounces the acft left the rwy in a crosswind. The damage to the acft was estimated as minor up to this time. The plt of the accident acft decided to try to…NTSB MIA84LA187Accident · No injuriesLimited investigationFinal reportCessna 172E · Vero Beach, FLThe plt reported that the acft ran out of fuel & landed just short of the rwy. He said that the acft impacted palmettos on the rwy extension & the nose gear was torn off.NTSB MKC84LA169Accident · No injuriesLimited investigationFinal reportCessna 172E · Waterloo, IAThere was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on…NTSB CHI84LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lk In The Hills, ILThe plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing.NTSB LAX84LA127Accident · No injuriesLimited investigationFinal reportCessna 172E · Selma, CAThe plt stated he was practicing landings when after takeoff following a full stop landing, the 'motor stopped then started again momentarily.' He landed in a vineyard. Responding officers from the sherriff's department observed no fuelin the aircraft tanks.