NTSB investigations: Cessna 172K, IN
11 cases on aircraft the registry lists as Cessna 172K. 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
| 1971 | 2 |
|---|---|
| 1974 | 2 |
| 1975 | 1 |
| 1978 | 2 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2001 | 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\" = 'IN' 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 ('2072430'))
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" = 'IN' 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 ('2072430'))
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 CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB CHI88LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Converse, INThe plt had flown one closed circuit pattern of the local arpt and landed to pick up two additional passengers. Purpose of the local flight was for sightseeing. The acft was parked with engine at idle. One boarding passenger approached the acft from the left…NTSB CHI83LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenburg, INThe pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…NTSB CHI80FEX11Accident · Minor injuriesClosedCessna 172 · Mooresville, INNTSB CHI79DEX10Accident · No injuriesClosedCessna 172 · Indianapolis, INNTSB CHI78FEX35Accident · Serious injuriesClosedCessna 172K · Lanesville, INNTSB CHI75AC055Accident · 3 fatalClosedCessna 172K · Columbus, INNTSB CHI75FEA05Accident · No injuriesClosedCessna 172K · Greenwood, INNTSB CHI74FET22Accident · No injuriesClosedCessna 172K · Wyatt, INNTSB CHI72FEA25Accident · No injuriesClosedCessna 172 · Greencastle, INNTSB CHI72FEA09Accident · Minor injuriesClosedCessna 172K · Wolcott, IN