NTSB investigations: Cessna 172I, 1983
5 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\") = 1983
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") = 1983
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 CHI83LA435Accident · No injuriesLimited investigationFinal reportCessna 172 · Plymouth, MIThe plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…NTSB MIA83LA229Accident · 1 fatalLimited investigationFinal reportCessna 172I · Miami, FLThe acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…NTSB FTW83LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Forrest City, ARThe acft experienced power failure from about 20 feet AGL during takeoff from a private grass strip. A witness heard theengine spit and pop during the takeoff roll. He said it sounded just like his old pickup when it runs out of gas. After the accident the…NTSB MKC83FA087Accident · No injuriesField investigationFinal reportCessna 172 I · Paola, KSThe acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson…NTSB ATL83LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, GAThe aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they…