NTSB investigations: Cessna 172H, 1983
7 cases on aircraft the registry lists as Cessna 172H. 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
| 1966 | 11 |
|---|---|
| 1967 | 59 |
| 1968 | 48 |
| 1969 | 32 |
| 1970 | 24 |
| 1971 | 28 |
| 1972 | 32 |
| 1973 | 22 |
| 1974 | 12 |
| 1975 | 16 |
| 1976 | 18 |
| 1977 | 18 |
| 1978 | 13 |
| 1979 | 15 |
| 1980 | 8 |
| 1981 | 6 |
| 1982 | 5 |
| 1983 | 7 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 12 |
| 2002 | 6 |
| 2003 | 14 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 5 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 2 |
| 2025 | 4 |
| 2026 | 1 |
Where
Latest 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
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 CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.NTSB FTW83LA395Accident · No injuriesLimited investigationFinal reportCessna 172H · Plano, TXThe acft collided with 2 parked acft after the student plt lost control during landing. The plt stated that he experienced a crosswind gust or updraft during touchdown. The landing was on rwy 16 and the wind was estimated to be from 220 degrees at 12 KTS. The…NTSB FTW83LA348Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marshall, TXThe aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…NTSB CHI83LA246Accident · No injuriesLimited investigationFinal reportCessna 172H · Dayton, OHThe plt stated he was aware of the displaced threshold due to barriers across the approach end of the rwy. After clearing the last barrier he felt the acft start to fall. He nosed over & added power but the nose gear struck the rwy first. The firewall &…NTSB CHI83LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · West Jefferson, OHThe pilot stated that he made a normal approach and was about to land when he added power to land over a rough area of the grass strip. He was maintaining just above stall speed and at minumum control when a gust of wind pushed the acftto the right toward the…NTSB NYC83FA091Accident · Serious injuriesField investigationFinal reportCessna 172H · Liberty Corner, NJInvestigation revealed that the plt and passenger arrived at the airport at approximately 1820 EST, requested a special VFR clearance and when that clearance could not be approved requested an IFR flight plan. Attempts to activate the IFR flight plan were…