NTSB investigations: Cessna 172L, 1977
19 cases on aircraft the registry lists as Cessna 172L. 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
| 1970 | 2 |
|---|---|
| 1971 | 17 |
| 1972 | 34 |
| 1973 | 40 |
| 1974 | 28 |
| 1975 | 23 |
| 1976 | 17 |
| 1977 | 19 |
| 1978 | 17 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 7 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 11 |
| 1989 | 4 |
| 1990 | 8 |
| 1991 | 1 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 4 |
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\") = 1977
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
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") = 1977
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
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 FTW78FPD10Accident · No injuriesClosedCessna 172 · Ft.Worth, TXNTSB MKC78FER14Accident · No injuriesClosedCessna 172L · Minneapolis, MNNTSB MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLNTSB CHI78FEP04Accident · Minor injuriesClosedCessna 172M · Elkhorn, WINTSB NYC77DNC56Accident · No injuriesClosedCessna 172 · Brunswick, MENTSB CHI77FEP61Accident · No injuriesClosedCessna 172L · West Bend, WINTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLNTSB MKC77FCG46Accident · Minor injuriesClosedCessna 172 · Topeka, KSNTSB SEA77DYA33Accident · No injuriesClosedCessna 172 · Challis, IDNTSB MIA77FA071Accident · 5 fatalClosedCessna 172L · Vienna, GANTSB CHI77FEI32Accident · No injuriesClosedCessna 172 · Rittman, OHNTSB LAX77DUJ81Accident · No injuriesClosedCessna 172 · Flagstaff, AZNTSB FTW77FPJ27Accident · No injuriesClosedCessna 172L · Cherokee, OKNTSB NYC77FHA23Accident · Serious injuriesClosedCessna 172 · Basking Ridge, NJNTSB LAX77DUJ54Accident · No injuriesClosedCessna 172 · Chinle, AZNTSB DEN77FTM17Accident · Serious injuriesClosedCessna 172M · Serviers, UTNTSB OAK77FA031Accident · 1 fatalClosedCessna 150L · Gilroy, CANTSB CHI77FEP29Accident · Minor injuriesClosedCessna 172 · Janesville, WINTSB DEN77DQA10Accident · No injuriesClosedCessna 172 · Los Alamos, NM