NTSB investigations: Cessna 172K, MN
9 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
| 1969 | 2 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1983 | 2 |
| 1988 | 1 |
| 2009 | 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\" = 'MN' 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" = 'MN' 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 CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.NTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…NTSB CHI83LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Canton, MNThe acft collided with a tree about 20-30 ft AGL in IMC weather after calling rochester approach at 1244 CDT to say that he was lost and in a thunderstorm. The plt was not instrument rated. Radio contact was lost at 1247 CDT. The flt originated in alton, IL…NTSB CHI83LA240Accident · No injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNThe acft veered off the rwy during landing. The landing was on rwy 07. The wind was from 360 degrees at 15 KTS. A thunderstorm was in the area and some turbulence remained. The pilot stated he felt one good bump at 50 AGL and from that point to touchdown very…NTSB MKC78FER95Accident · Minor injuriesClosedCessna 172K · Grygla, MNNTSB MKC74DER53Accident · No injuriesClosedCessna 172K · Maple Lake, MNNTSB MKC73DER70Accident · No injuriesClosedCessna 172K · Ranier, MNNTSB MKC70F0312Accident · No injuriesClosedCessna 172 · Worthington, MNNTSB MKC70D0070Accident · Minor injuriesClosedCessna 172 · Austin, MN