NTSB investigations: Cessna R172K

8 cases on aircraft the registry lists as Cessna R172K, where the first occurrence was “Loss of control - in flight”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations: Cessna R172K per year, 1983–2026: 8 cases
1983	1
1984	2
1986	1
1989	1
1992	1
1994	1
2001	1

Where

Open the map

Latest cases

Query with SQL

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" = 250)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 250))
  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" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX01LA256Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Mammoth Lakes, CAThe pilot's inadequate in-flight planning and his failure to maintain sufficient altitude above the terrain. Factors were the high terrain and the blind canyon.Jul 21, 2001 · N736YR · Destroyed NTSB NYC94FA128Accident · 4 fatalField investigationFinal reportCessna K172R · Tremont City, OHFailure of the pilot to maintain control of the airplane. A factor related to the accident was: the pilot's lack of experience in the type of operation.Jul 16, 1994 · N1124V · Destroyed NTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.May 11, 1992 · N4695K · Substantial damage NTSB LAX89LA216Accident · No injuriesLimited investigationFinal reportCessna 175K · Bagdad, AZTotal loss of engine power due to undetermined reasons.Jun 17, 1989 · N9729V · Destroyed NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…Jan 1, 1986 · N7320K · Destroyed NTSB DEN85LA022Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Longmont, COThe pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over.Oct 28, 1984 · N758CG · Substantial damage NTSB LAX84FA473Accident · 3 fatalField investigationFinal reportCessna R172K · Independence, CAThe plt and two pax departed on a pleasure flt to look for a deer hunting area. Witnesses near the accident site stated that the saw the acft 'fly down the canyon on a northerly heading, reverse course and attempt to fly up the canyon.' They saw the acft…Sep 9, 1984 · N736XF · Destroyed NTSB LAX83LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · San Martin, CAThe acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…Jan 14, 1983 · N9927V · Substantial damage