NTSB investigations: Cessna 175, KS
13 cases on aircraft the registry lists as Cessna 175. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1969 | 2 |
| 1971 | 1 |
| 1974 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 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\" = 'KS' 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 ('2072502'))
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" = 'KS' 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 ('2072502'))
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 MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.NTSB MKC89LA045Accident · No injuriesLimited investigationFinal reportCessna 175 · Lawrence, KSThe plt said that shortly after takeoff, the engine began to misfire and lose power. He elected to abort the takeoff, but was unable to stop on the remaining portion of the runway. He ran off the end, into a farm field, where the acft nosed down and was…NTSB MKC86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Louisburg, KSDuring a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The…NTSB MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSNTSB MKC78FCG56Accident · No injuriesClosedCessna 175 · Leawood, KSNTSB MKC74DCG42Accident · No injuriesClosedCessna 175 · Muscotah, KSNTSB MKC74DCQ27Accident · No injuriesClosedCessna 175 · Hillsboro, KSNTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSNTSB MKC69D0464Accident · Minor injuriesClosedCessna 175 · Washington, KSNTSB MKC69D0360Accident · No injuriesClosedCessna 175 · Colby, KSNTSB MKC67D0212Accident · No injuriesClosedCessna 175 · Ashland, KSNTSB MKC66F0453Accident · No injuriesClosedCessna 175 · Manhattan, KSNTSB MKC65D0123Accident · No injuriesClosedCessna 175 · Olathe, KS