Skip to content

NTSB investigations: Cessna 172H, PA

17 cases on aircraft the registry lists as Cessna 172H. 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

19672026

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 ('2072424')) 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 ('2072424'))
  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 ('2072424'))
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 IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.Aug 26, 2005 · N3946R · Substantial damage NTSB NYC03LA127Accident · Minor injuriesLimited investigationFinal reportCessna 172H · East Vincent, PAThe pilot's inadequate in-flight planning/preparation which resulted in fuel exhaustion during cruise flight. The pilot's inadequate preflight preparation in which he failed to refuel the airplane is a contributing factor.Jun 11, 2003 · N3027U · Substantial damage NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.Jul 3, 2000 · N8805Z · Substantial damage NTSB NYC96LA146Accident · No injuriesLimited investigationFinal reportCessna 172H · Cherry Tree, PAthe pilot's failure to assure that adequate takeoff distance was available to clear an obstacle.Jul 8, 1996 · N1412F · Substantial damage NTSB NYC85LA112Accident · No injuriesLimited investigationFinal reportCessna 172H · Middletown, PAThe acft nosed over in a plowed field during a forced landing after a pwr loss during cruise flt. After the pwr loss the plt declared an emergency and set up a slide for the nearby arpt. Strong winds interfered in the planned approach and the acft settled in…Apr 27, 1985 · N8052L · Substantial damage NTSB NYC84LA249Accident · No injuriesLimited investigationFinal reportCessna C172 · Sandy Lake, PAThe acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no…Jul 22, 1984 · N3275L · Substantial damage NTSB NYC83LA022Accident · No injuriesLimited investigationFinal reportCessna 172H · Clarion, PAAfter engine quit pilot tried to return to airport but crashed off airport in a turn collapsing the nose gear and damaging the right wing. The fuel aboard was one gallon in left tank and about two gallons in right tank. The gauges indicated empty for left and…Nov 6, 1982 · N2649L · Substantial damage NTSB NYC81FGM05Accident · No injuriesClosedCessna 172H · Clarion, PANov 14, 1980 · N2649L · Substantial damage NTSB NYC75AN039Accident · 2 fatalClosedCessna 172H · Bluebell, PASep 20, 1974 · N3258L · Destroyed NTSB NYC75AN022Accident · 2 fatalClosedCessna 172 · Catasauqua, PAAug 23, 1974 · N8191L · Destroyed NTSB NYC74FGT15Accident · No injuriesClosedCessna 172 · Carlisle, PAJan 15, 1974 · N8198L · Substantial damage NTSB NYC73FGM10Accident · No injuriesClosedCessna 172H · Emlenton, PAOct 1, 1972 · N3818R · Substantial damage NTSB NYC73AN007Accident · No injuriesClosedCessna 172H · York, PAJul 6, 1972 · N3297L · Substantial damage NTSB NYC71DHD56Accident · No injuriesClosedCessna 172 · Philadelphia, PAMay 19, 1971 · N2878L · Substantial damage NTSB NYC71FGM16Accident · Minor injuriesClosedCessna 172H · Smethport, PASep 28, 1970 · N3241L · Substantial damage NTSB NYC71FHG02Accident · No injuriesClosedCessna 172H · New Cumberland, PAJul 20, 1970 · N3772F · Substantial damage NTSB NYC68F0308Accident · No injuriesClosedCessna 172H · Aliquippa, PADec 9, 1967 · N8262L · Substantial damage