NTSB investigations: Cessna 172H, 1976
18 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\") = 1976
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") = 1976
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 CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MINTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXNTSB NYC77FGM03Accident · No injuriesClosedCessna 172 · West Hickory, NYNTSB IAD77DID06Accident · No injuriesClosedCessna 172H · Lynchburg, VANTSB DEN77DTM01Accident · No injuriesClosedCessna 172H · Parowan, UTNTSB SEA77FYG04Accident · Serious injuriesClosedCessna 172 · Grangeville, IDNTSB FTW76AF120Accident · 3 fatalClosedCessna 172H · Glen Rose, TXNTSB MKC76AK077Accident · 4 fatalClosedCessna 172 · Mandan, NDNTSB DEN76FQA59Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMNTSB FTW76FPJ50Accident · Serious injuriesClosedCessna 172 · Hooker, OKNTSB FTW76DRG80Accident · No injuriesClosedCessna 172H · Lowake, TXNTSB MIA76FLD74Accident · Serious injuriesClosedCessna 172H · Windermere, FLNTSB NYC76FHM29Accident · No injuriesClosedCessna 172H · Mahopac, NYNTSB CHI76FEC43Accident · No injuriesClosedCessna 172H · Flushing, MINTSB OAK76AP053Accident · 3 fatalClosedCessna 172H · Hollister, CANTSB CHI76FEV33Accident · No injuriesClosedCessna 172H · Jerseyville, ILNTSB LAX76SL071Accident · 1 fatalClosedCessna 172H · Winslow, AZNTSB OAK76DVD22Accident · Minor injuriesClosedCessna 172 · Ft Bragg, CA