Skip to content

NTSB investigations: Cessna R172K

208 cases on aircraft the registry lists as Cessna R172K. 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, newest first

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')) 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'))
  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'))
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 DEN82DA162Accident · No injuriesFinal reportCessna 172XP · 3 Miles Sw Of D, COThe aircraft was cruising at 11000 ft when the engine began to run rough. Attempts to enrich and then lean the mixture, throttle adjustments and switching the fuel tanks did not alleviate the engine roughness. The engine then lost all power. Another plt…Aug 15, 1982 · N736JX · Destroyed NTSB MKC82DA134Accident · No injuriesFinal reportCessna R172K · Hansell, IAThe pilot reported that during the takeoff roll, he was blinded by the sun and allowed the aircraft to drift into tall corn beside the runway. Subsequently, the aircraft nosed over.Jul 31, 1982 · N758AG · Substantial damage NTSB LAX82DA190Accident · Minor injuriesFinal reportCessna 172XP · Hilo, HIThe pilot stated that he requested 30 gallons of fuel for an estimated flight time of 3.5 hours. During the flight the engine ran rough and the right tank went to empty. The pilot then switched tanks and about 2 minutes later the pilot stated that the left…May 21, 1982 · N7320K · Substantial damage NTSB MIA82DA119Accident · No injuriesFinal reportCessna 172K · Geneva, FLThe pilot stated that while on short final a gust of wind raised the right wing of the aircraft. Upon making a correction some airspeed was lost and the nose was lowered. During landing the nose gear collapsed and the aircraft turned over.May 7, 1982 · N1355V · Substantial damage 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…Jan 29, 1982 · N758RD · Substantial damage NTSB FTW82FRA14Accident · 1 fatalFinal reportCessna R172K · Hearne, TXBefore the aircraft took off, fog was noted at the airport. Witnesses reported that the ceiling was about 100 to 200 ft and the visibility was about 1/2 mile. Reportedly, the pilot tried to contact the fss by telephone; however, only a pay telephone was…Jan 2, 1982 · N758SK · Destroyed NTSB ATL81FA112Accident · 3 fatalClosedCessna 172K · Philomath, GASep 4, 1981 · N758EQ · Destroyed NTSB LAX81DVG63Accident · No injuriesClosedCessna R172K · Chiles Valley, CAAug 30, 1981 · N1580V · Substantial damage NTSB LAX81DXQ27Accident · No injuriesClosedCessna R172K · So Lake Tahoe, CAJul 20, 1981 · N9927V · Substantial damage NTSB LAX81FUG40Accident · No injuriesClosedCessna R172K · Yucca Valley, CAJul 10, 1981 · N736LJ · Substantial damage NTSB FTW81DQG38Accident · No injuriesClosedCessna R172K · Milnesand, NMJun 19, 1981 · N736BF · Substantial damage NTSB DEN81FTC13Accident · No injuriesClosedCessna 172XP · Moorcroft, WYApr 26, 1981 · N1254V · Substantial damage NTSB FTW81FPM03Accident · No injuriesClosedCessna R172K · Lenapah, OKNov 30, 1980 · N758BN · Substantial damage NTSB SEA80FA041Accident · No injuriesClosedCessna R172K · Renton, WAAug 11, 1980 · N736UN · Substantial damage NTSB MKC80DCQ29Accident · No injuriesClosedCessna 172 · Hoxie, KSAug 8, 1980 · N736FX · Substantial damage NTSB SEA80DYP25Accident · Minor injuriesClosedCessna R172K · Mullen, IDJun 26, 1980 · N758KG · Destroyed NTSB DEN80FTC16Accident · 2 fatalClosedCessna R172K · Cheyenne, WYMay 21, 1980 · N758LA · Destroyed NTSB CHI80FA031Accident · 3 fatalClosedCessna 172K · Manistee, MIMar 19, 1980 · N4692K · Destroyed NTSB FTW80DPG14Accident · No injuriesClosedCessna 172K · Little Rock, ARFeb 29, 1980 · N758HA · Substantial damage NTSB LAX80DUJ34Accident · Minor injuriesClosedCessna R172K · Concho, AZFeb 28, 1980 · N758PP · Substantial damage NTSB CHI80FA027Accident · 1 fatalClosedCessna 172XP · Indianapolis, INFeb 26, 1980 · N758HQ · Destroyed NTSB ANC80DAG34Accident · No injuriesClosedCessna 172K · Iliamna, AKFeb 18, 1980 · N7381K · Substantial damage NTSB CHI80FEP17Accident · Minor injuriesClosedCessna 172 · Bruce, WIFeb 6, 1980 · N1167V · Substantial damage NTSB LAX80DXQ13Accident · No injuriesClosedCessna 172K · Ely, NVJan 13, 1980 · N736EG · Substantial damage NTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILDec 21, 1979 · N736UL · Destroyed NTSB DEN80FTE14Accident · Minor injuriesClosedCessna R172K · Montrose, CODec 14, 1979 · N736LR · Substantial damage NTSB SEA79DYE49Accident · No injuriesClosedCessna R172K · Bellingham, WASep 22, 1979 · N6417K · Substantial damage NTSB FTW79DPJ38Accident · No injuriesClosedCessna R172K · El Reno, OKSep 19, 1979 · N4634K · Substantial damage NTSB MKC79FA055Accident · 2 fatalClosedCessna 172XP · Intl Falls, MNSep 16, 1979 · N736QH · Destroyed NTSB IAD79FID30Accident · No injuriesClosedCessna 172K · Hopewell, VAAug 30, 1979 · N4714K · Substantial damage NTSB FTW79FA062Accident · 1 fatalClosedCessna R172K · Uvalde, TXMar 14, 1979 · N736TN · Destroyed NTSB NYC79FA024Accident · 2 fatalClosedCessna 172K · Dover Plains, NYFeb 23, 1979 · N736FW · Destroyed NTSB LAX79DVM11Accident · No injuriesClosedCessna R172H · Sn Luis Obspo, CAFeb 6, 1979 · N1157V · Substantial damage NTSB DEN79FA020Accident · 1 fatalClosedCessna R172K · Banner, WYFeb 6, 1979 · N758AV · Destroyed NTSB FTW79FA037Accident · 2 fatalClosedCessna 172XP · Abilene, TXDec 29, 1978 · N758CA · Destroyed NTSB SEA79FYP04Accident · 1 fatalClosedCessna R172K · Dayton, WADec 1, 1978 · N736TH · Destroyed NTSB FTW79DPJ39Accident · No injuriesClosedCessna 172 · Enid, OKSep 27, 1978 · N736HH · Substantial damage NTSB DEN78FTF02Accident · No injuriesClosedCessna 172 · Mancos, COSep 27, 1978 · N5329V · Substantial damage NTSB NYC78FA093Accident · 2 fatalClosedCessna R172K · Venice Center, NYSep 16, 1978 · N9655V · Substantial damage NTSB NYC78FGT14Accident · No injuriesClosedCessna 172 · Hershey, PAAug 29, 1978 · N833G · Substantial damage NTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORAug 15, 1978 · N736XU · Destroyed NTSB NYC78FNEZBAccident · No injuriesClosedCessna 172 · Plainville, CTJul 29, 1978 · N5497V · Substantial damage NTSB MIA78DKT62Accident · No injuriesClosedCessna 172XP · Ft.Lauderdale, FLJul 5, 1978 · N6192K · Substantial damage NTSB CHI78FEI24Accident · No injuriesClosedCessna R172K · Smithfield, OHJun 28, 1978 · N736XC · Substantial damage NTSB FTW78FPA26Accident · No injuriesClosedCessna R172K · Gordanville, TXMay 26, 1978 · N736HJ · Substantial damage NTSB MKC78FCA25Accident · No injuriesClosedCessna R172 · Sikeston, MOMay 3, 1978 · N1147V · Substantial damage NTSB OAK78DXQ19Accident · No injuriesClosedCessna 172 · Elko, NVApr 24, 1978 · N736KP · Substantial damage NTSB MIA78FKG28Accident · No injuriesClosedCessna R172K · Augusta, GAMar 23, 1978 · N736QV · Substantial damage NTSB LAX78DUJ39Accident · Minor injuriesClosedCessna XP172 · Cameron, AZMar 23, 1978 · N9633V · Substantial damage NTSB DEN78FTE25Accident · No injuriesClosedCessna 172 · Idaho Springs, COFeb 4, 1978 · N736SP · Minor damage