NTSB investigations: Cessna 172E, 1982
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\") = 1982
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") = 1982
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 NYC83IA013Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Augusta, METhe student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…NTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…NTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…NTSB FTW82DA149Accident · Minor injuriesFinal reportCessna 172 · Delaplane, AROn landing the pilot noticed braking action was poor due to wet grass on the strip. The nose of the aircraft struck a soft spot on the runway, sank in and sheared off the nose gear. The aircraft then nosed over. Investigation revealed the pilot/owner had…NTSB CHI82DA038Accident · No injuriesFinal reportCessna 172 · Greencastle, INThe student arrived at the airport on a cross-country flight and requested landing advisories on the UNICOM frequency. The student stated that somebody replied that runway 18 was in use. Before landing, the pilot overflew the airport 4 times. Two of these…NTSB DEN82DA031Accident · No injuriesFinal reportCessna 172N · Broomfield, COPrior to landing, the pilot monitored the ATIS and noted that the wind was from 320 degrees at 15 knots. While on final approach for landing, he heard a radio transmission stating that the wind was gusting to 30 knots. While landing, he thought the right tire…NTSB MIA82DKJ03Accident · No injuriesFinal reportCessna 172 · Malone, FLThe pilot elected to land on a runway with 800 feet of hard sod and 2700 feet of soft dirt. The aircraft nosed over when the nose wheel dug into the dirt.