NTSB investigations: Cessna R172K
6 cases on aircraft the registry lists as Cessna R172K, where the first occurrence was “In flight collision with terrain/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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1997 | 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\" = 230))
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" = 230))
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 LAX97FA225Accident · 2 fatalField investigationFinal reportCessna R172K · Moreno Valley, CAThe pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…NTSB LAX96LA247Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Oroville, CAundetermined.NTSB LAX90LA271Accident · 1 fatalLimited investigationFinal reportCessna R172K · Lone Pine, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.NTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…NTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…NTSB DEN82DA025Accident · No injuriesFinal reportCessna 172 · Near Gillete, WYThe purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid…