NTSB investigations: Cessna 172E, 1971
18 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\") = 1971
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") = 1971
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 MIA72OKT41Accident · No injuriesClosedCessna 172E · Exuma (Atlantic Ocean)NTSB MKC72FER34Accident · No injuriesClosedCessna 172E · Walker, MNNTSB FTW72DQD16Accident · 4 fatalClosedCessna 172E · S.Buenaventra, MexicoNTSB MIA72FLA17Accident · No injuriesClosedCessna 172E · Compass Lake, FLNTSB NYC72FHM12Accident · Serious injuriesClosedCessna 172E · Paramus, NJNTSB CHI72FEM10Accident · No injuriesClosedCessna 172E · Bay City, MINTSB NYC72AN023Accident · 1 fatalClosedCessna 172E · Greene, NYNTSB DEN72DTE14Accident · No injuriesClosedCessna 172E · Brandon, CONTSB FTW72FRG15Accident · No injuriesClosedCessna 172E · Corpus Chrsti, TXNTSB MIA72AM008Accident · 2 fatalClosedCessna 172E · Ft.Lauderdale, FLNTSB MKC72AK003Accident · 3 fatalClosedCessna 172E · Montrose, SDNTSB MKC71DCJ76Accident · No injuriesClosedCessna 172E · Ainsworth, NENTSB MIA71AM108Accident · 1 fatalClosedCessna 172E · Villalba, PRNTSB MKC71DCJ65Accident · No injuriesClosedCessna 172 · Grand Isl, NENTSB LAX71AL068Accident · 1 fatalClosedCessna 172E · El Cajon, CANTSB NYC71FHJ25Accident · No injuriesClosedCessna 172 · Mahopac, NYNTSB FTW71FRD32Accident · No injuriesClosedCessna 172E · Kenner, LANTSB LAX71DUQ47Accident · No injuriesClosedCessna 172E · Van Nuys, CA