NTSB investigations: Cessna R172E, 1983
2 cases on aircraft the registry lists as Cessna R172E. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 3 |
| 1979 | 5 |
| 1980 | 2 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 3 |
| 1988 | 1 |
| 1989 | 4 |
| 1992 | 2 |
| 1995 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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 ('2072413'))
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 ('2072413'))
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 FTW83FPJ02Accident · Serious injuriesFinal reportCessna R172E · Little, OKThe acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…NTSB ANC83FA059Accident · Minor injuriesField investigationFinal reportCessna T-41B (R-172E) · Healy, AKThe plt reported that while cruising at 4000 ft MSL, the eng power began to fluctuate, then this was followed by a banging noise, rough eng operation & a decline in power output. He had turned to land into the wind when the eng power increased & stabilized.…