Skip to content

NTSB investigations: Cessna 172K, PA

22 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

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."eventStateOrRegion" = 'PA' 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

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\" = 'PA' 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" = 'PA' 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

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 MIA08CA182Accident · No injuriesData collectionFinal reportCessna 172K · Tunkhannock, PAThe pilot's improper airspeed while landing.Sep 3, 2008 · N79210 · Substantial damage NTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.Apr 22, 2001 · N79210 · Substantial damage NTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…May 5, 1987 · N78506 · Substantial damage NTSB NYC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, PAThe personal flight with four occupants on board landed about 40 feet short of the runway after completing two successful touch and go landings. Pilot stated that the wind was at 220 degrees at 10 knots.Feb 1, 1987 · N79881 · Substantial damage NTSB NYC86LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bloomsburg, PAThe acft was on an IFR flt en route to allegheny county arpt at 6000 ft when an electrical failure occurred. The plt executed a precautionary landing in a muddy fld. The nose wheel caught in mud and the acft nosed over. Examination of the electrical system…Nov 28, 1985 · N7506G · Substantial damage NTSB NYC76FHA31Accident · Minor injuriesClosedCessna 172K · Ashfield, PAMay 16, 1976 · N46428 · Substantial damage NTSB NYC76FGM33Accident · No injuriesClosedCessna 172 · Butler, PAMay 14, 1976 · N84225 · Substantial damage NTSB NYC76FGM11Accident · Minor injuriesClosedCessna 172K · Haydentown, PAOct 28, 1975 · N46698 · Substantial damage NTSB NYC75DGM40Accident · Minor injuriesClosedCessna 172K · Bedford, PAJun 6, 1975 · N79196 · Substantial damage NTSB NYC75FHA40Accident · Minor injuriesClosedCessna 172K · E Stroudsburg, PAMay 14, 1975 · N7293G · Substantial damage NTSB NYC75DGM33Accident · No injuriesClosedCessna 172K · Beaver Falls, PAApr 23, 1975 · N7301G · Substantial damage NTSB NYC74FGM44Accident · Serious injuriesClosedCessna 172 · Jeannette, PAJun 29, 1974 · N1192M · Destroyed NTSB NYC74AN014Accident · 1 fatalClosedCessna 172K · Huntingdon Vly, PAAug 13, 1973 · N7060G · Destroyed NTSB NYC73FGM08Accident · No injuriesClosedCessna 172K · Jeannette, PASep 15, 1972 · N84763 · Substantial damage NTSB NYC73FHD14Accident · Minor injuriesClosedCessna 172 · Norristown, PAAug 28, 1972 · N7127G · Destroyed NTSB NYC72AN137Accident · No injuriesClosedCessna 172K · New London, PAApr 27, 1972 · N7227G · Substantial damage NTSB NYC72FGM34Accident · No injuriesClosedCessna 172K · W.Mifflin, PAFeb 21, 1972 · N7066G · Substantial damage NTSB NYC72DHA12Accident · No injuriesClosedCessna 172 · Collegeville, PAAug 23, 1971 · N7227G · Substantial damage NTSB NYC72DHA06Accident · No injuriesClosedCessna 172I · Berwick, PAAug 1, 1971 · N46315 · Substantial damage NTSB NYC71FHA52Accident · Minor injuriesClosedCessna 172 · Fleetville, PAJun 8, 1971 · N7392G · Substantial damage NTSB NYC71DGM18Accident · Minor injuriesClosedCessna 172K · Russell, PAOct 14, 1970 · N79150 · Substantial damage NTSB NYC70D0062Accident · No injuriesClosedCessna 172 · Montgomeryvile, PAJul 14, 1969 · N84371 · Substantial damage