NTSB investigations: Cessna 172H, 1984
6 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
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 ('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") = 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 ('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 LAX85LA009Accident · No injuriesLimited investigationFinal reportCessna 172H · Long Beach, CAThe plt said that after he returned to the arpt for a night landing, he applied back pressure during the flare, then heard the stall warning horn. Subsequently, the acft was damaged when it landed hard & bounced. However, the plt was able to taxi to the…NTSB NYC84LA249Accident · No injuriesLimited investigationFinal reportCessna C172 · Sandy Lake, PAThe acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no…NTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…NTSB CHI84LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Port Washington, WIThe plt stated that after takeoff from a sod field covered with tall grass, the acft drifted to the right of the rwy. While bringing the acft back to the center of the rwy, the acft stalled. The nose gear hit the ground & collapsed, the left wing hit a fence…NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB NYC84LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Hagerstown, MDThe plt initiated a 5 mi straight-in approach. When the acft was within 2 mi of the arpt, the plt reduced power, appliedcarb heat & slowed the acft. When it appeared he was going to land short, he added power, but the eng would not respond. The acft was…