NTSB investigations: Cessna 172I, 1971
20 cases on aircraft the registry lists as Cessna 172I. 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
| 1967 | 1 |
|---|---|
| 1968 | 16 |
| 1969 | 21 |
| 1970 | 25 |
| 1971 | 20 |
| 1972 | 13 |
| 1973 | 8 |
| 1974 | 15 |
| 1975 | 4 |
| 1976 | 11 |
| 1977 | 4 |
| 1978 | 5 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 4 |
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 1 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 3 |
| 2024 | 5 |
| 2025 | 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 ('2072426'))
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 ('2072426'))
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 MKC72DTK15Accident · No injuriesClosedCessna 172I · Aberdeen, SDNTSB DEN72FQA22Accident · No injuriesClosedCessna 172 · Bernalillo, NMNTSB MKC72DER19Accident · No injuriesClosedCessna 172I · Crosby, MNNTSB MIA72FKG27Accident · Serious injuriesClosedCessna 172I · Marietta, GANTSB NYC72DGM06Accident · No injuriesClosedCessna 172I · Franklin, PANTSB DEN71DTE16Accident · No injuriesClosedCessna 172 · Fort Carson, CONTSB NYC71FFJ36Accident · No injuriesClosedCessna 172 · Honeoye Falls, NYNTSB CHI71DEI56Accident · Minor injuriesClosedCessna 172 · Medina, OHNTSB CHI71FCA06Accident · Minor injuriesClosedCessna 172I · Bethalto, ILNTSB NYC71FHM28Accident · No injuriesClosedCessna 172 · Marlboro, NYNTSB NYC71FGM45Accident · No injuriesClosedCessna 172 · Beaver Falls, PANTSB LAX71DUM37Accident · No injuriesClosedCessna 172 · Calexico, CANTSB CHI71FBQ36Accident · No injuriesClosedCessna 172 · Manito, ILNTSB SEA71DWA34Accident · Minor injuriesClosedCessna 172I · Mulino, ORNTSB MIA71FKW42Accident · No injuriesClosedCessna 172 · New Tazewell, TNNTSB CHI71DBJ63Accident · No injuriesClosedCessna 172 · Battle Creek, MINTSB MIA71DLD53Accident · Minor injuriesClosedCessna 172I · Daytona Beach, FLNTSB LAX71FUD10Accident · No injuriesClosedCessna 172 · Santa Monca, CANTSB NYC71DFA42Accident · No injuriesClosedCessna 172 · Canastota, NYNTSB CHI71AC050Accident · 2 fatalClosedCessna 172 · Missing Aircraft