NTSB investigations: Cessna 172C, 1983
4 cases on aircraft the registry lists as Cessna 172C. 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 | 18 |
|---|---|
| 1965 | 12 |
| 1966 | 23 |
| 1967 | 14 |
| 1968 | 12 |
| 1969 | 10 |
| 1970 | 7 |
| 1971 | 7 |
| 1972 | 9 |
| 1973 | 4 |
| 1974 | 5 |
| 1975 | 4 |
| 1976 | 7 |
| 1977 | 5 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 4 |
| 2016 | 3 |
| 2018 | 3 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 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\") = 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 ('2072408'))
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 ('2072408'))
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 LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…NTSB ATL83LA356Accident · No injuriesLimited investigationFinal reportCessna 172C · Portsmouth Isl., NCBefore hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the…NTSB LAX83LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Rubidoux, CAThe acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.