NTSB investigations: Cessna R172K
11 cases on aircraft the registry lists as Cessna R172K, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072431')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072431')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB SEA99LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ORAircraft control was not maintained. The pilot's misjudged flare and inadequate remedial action, along with the flight instructors delayed remedial action were factors.NTSB SEA99LA008Accident · No injuriesLimited investigationFinal reportCessna 172K · Dillon, MTThe student pilot-in-command's failure to maintain directional control. Contributing factors were rough terrain and crosswind conditions.NTSB CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.NTSB FTW89LA162Accident · No injuriesLimited investigationFinal reportCessna 172K · Midlothian, TXThe failure of the pilot to compensate for the crosswind condition, which resulted in a loss of directional control and collision with a tree.NTSB ANC88LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Chignik, AKDuring the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back.NTSB CHI85LA333Accident · No injuriesLimited investigationFinal reportCessna 172XP · Int'L Falls, MNThe acft veered hard to the rt & collided with the water during takeoff at about 45 mph. It was discovered that the left float failed and allowed the left float to turn rt and go under the rt float.NTSB SEA85LA136Accident · Minor injuriesLimited investigationFinal reportCessna R-172-K · Las Vegas, NVDuring landing rollout on runway 19R directional control was lost with the aircraft verring to the right of the runway. Correction was made to the left, but the aircraft veered off the runway to the left. The wind was from 160 at 9. The density altitude was…NTSB LAX85LA018Accident · No injuriesLimited investigationFinal reportCessna R172 · Corning, CAThe plt reported that during a landing on rwy 34, the acft encountered a x-wind gust & was pushed off the rwy. It subsequently collided with a ditch & was damaged. The plt reported that the wind was from 300 deg at 16 gusting 22 KTS.NTSB CHI84LA122Accident · No injuriesLimited investigationFinal reportCessna R172K · Marion, OHThe plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over.NTSB LAX83LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wickenburg, AZThe acft left the runway during landing and collided with a ditch which collapsed the right main gear and nose gear. Thepilot noted during final approach that the windsock did not indicate a cross-wind. The landing was made with 10 degrees of flaps. According…