NTSB investigations: Cessna R172K, ID
7 cases on aircraft the registry lists as Cessna R172K. 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
| 1980 | 1 |
|---|---|
| 1992 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2014 | 1 |
| 2021 | 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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072431'))
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072431'))
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 WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.NTSB SEA03CA162Accident · No injuriesData collectionFinal reportCessna R172K · Idaho Falls, IDThe pilot's failure to see and avoid a parked aircraft while taxiing.NTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.NTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.NTSB SEA80DYP25Accident · Minor injuriesClosedCessna R172K · Mullen, ID