NTSB investigations: Cessna 172I, 1969
21 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\") = 1969
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") = 1969
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 CHI70F0364Accident · No injuriesClosedCessna 150G · Cahokia, ILNTSB NYC70F0204Accident · No injuriesClosedCessna 150 · Canastota, NYNTSB FTW70D0298Accident · Minor injuriesClosedCessna 172I · Memphis, TXNTSB NYC70F0190Accident · No injuriesClosedCessna 172I · Belle Vernon, PANTSB NYC70F0168Accident · Minor injuriesClosedCessna 172I · Little Valley, NYNTSB LAX70F0128Accident · No injuriesClosedCessna 172 · Fullerton, CANTSB DEN70D0058Accident · No injuriesClosedCessna 172 · Fruita, CONTSB CHI70A0006Accident · 3 fatalClosedCessna 172I · Barrington, ILNTSB CHI70F0210Accident · Serious injuriesClosedCessna 172I · Northbrook, ILNTSB MKC70D0041Accident · No injuriesClosedCessna 172I · Scott City, KSNTSB FTW70D0002Accident · No injuriesClosedCessna 172 · Chamal, MexicoNTSB NYC70F0015Accident · No injuriesClosedCessna 172I · Marshfield, MANTSB DEN70D0017Accident · Minor injuriesClosedCessna 172 · Fountain, CONTSB CHI70D0006Accident · No injuriesClosedCessna 172 · Shelby, INNTSB CHI70D0003Accident · No injuriesClosedCessna 172 · Collinsville, ILNTSB NYC69F0427Accident · Serious injuriesClosedCessna 172I · West Milford, NJNTSB FTW69D0473Accident · No injuriesClosedCessna 172 · Burleson, TXNTSB SEA69A0050Accident · 3 fatalClosedCessna 172I · Spokane, WANTSB NYC69D0361Accident · No injuriesClosedCessna 172I · Biddeford, MENTSB MIA69D0405Accident · No injuriesClosedCessna 172 · Winter Haven, FLNTSB FTW69D0343Accident · No injuriesClosedCessna 172 · Clinton, OK