NTSB investigations: Cessna 172E, 1986
6 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\") = 1986
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") = 1986
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 DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…NTSB FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…NTSB LAX86LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lower Lake, CAThe airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…NTSB ATL86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Clyde, OHThe acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…NTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…