NTSB investigations: Cessna 172A, 1965
21 cases on aircraft the registry lists as Cessna 172A. 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 | 26 |
|---|---|
| 1965 | 21 |
| 1966 | 19 |
| 1967 | 14 |
| 1968 | 14 |
| 1969 | 13 |
| 1970 | 11 |
| 1971 | 5 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 6 |
| 1975 | 6 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 6 |
| 1979 | 6 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 2 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 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\") = 1965
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072404'))
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") = 1965
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072404'))
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 FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXNTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDNTSB MIA66F0381Accident · Serious injuriesClosedCessna 172 · Baxley, GANTSB FTW66D0440Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MONTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GANTSB NYC66D0295Accident · No injuriesClosedCessna 172 · Moorestown, NJNTSB NYC66F0244Accident · No injuriesClosedCessna 172 · Harwinton, CTNTSB NYC66A0035Accident · 2 fatalClosedCessna 172 · West Dover, VTNTSB FTW66D0306Accident · No injuriesClosedCessna 172 · Booker, TXNTSB SEA66F0092Accident · No injuriesClosedCessna 172 · Kent, WANTSB CHI65F0148Accident · No injuriesClosedCessna 172 · Ionia, MINTSB NYC65F0131Accident · No injuriesClosedCessna 172A · Westminster, MDNTSB FTW66F0206Accident · No injuriesClosedCessna 172 · San Antonio, TXNTSB CHI65D0146Accident · No injuriesClosedCessna 172A · Jacksonville, ILNTSB SEA65F0021Accident · No injuriesClosedCessna 172 · Pullman, WANTSB SEA65D0027Accident · No injuriesClosedCessna 172A · Seattle, WANTSB NYC65F0047Accident · No injuriesClosedCessna 172 · Tewksbury, MANTSB UNK65X1345Accident · No injuriesClosedCessna 172 · Victoria, TXNTSB UNK65X1306Accident · No injuriesClosedCessna 172 · Manchester, KY