Skip to content

NTSB investigations: Cessna 172F, PA

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

19652026

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 ('2072414')) 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 ('2072414'))
  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 ('2072414'))
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 ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.May 31, 2014 · N8394U · Substantial damage NTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.Oct 28, 2011 · N5613R · Substantial damage NTSB NYC97FA048Accident · 1 fatalField investigationFinal reportCessna 172F · Conrad, PAVFR flight by the pilot into instrument meteorological conditions (IMC), and spatial disorientation of the pilot, which led to loss of aircraft control, an uncontrolled descent, and subsequent collision with wooded terrain. Factors relating to the accident…Jan 25, 1997 · N8835U · Destroyed NTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.Jun 10, 1994 · N5522R · Substantial damage NTSB BFO93LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Normalville, PAThe presence of carburetor icing conditions, which caused a total loss of engine power. A factor related to the accident was the pilot's delayed use of carburetor heat and rough terrain.Jul 6, 1993 · N7954U · Substantial damage NTSB NYC89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honesdale, PAThe loss of directional control by the pilot during landing.Mar 16, 1989 · N5517R · Substantial damage NTSB NYC81DHA08Accident · No injuriesClosedCessna 172 · Morgantown, PAMar 14, 1981 · N5721R · Destroyed NTSB NYC79DHA25Accident · No injuriesClosedCessna 172F · Brecknock, PASep 3, 1979 · N5689R · Substantial damage NTSB NYC79FGT12Accident · No injuriesClosedCessna 172 · New Cumberland, PAMar 28, 1979 · N5413R · Substantial damage NTSB NYC79FA012Accident · 3 fatalClosedCessna 172F · Mcadoo, PANov 23, 1978 · N5170F · Substantial damage NTSB NYC76FHA27Accident · Minor injuriesClosedCessna 172F · Lehighton, PAApr 28, 1976 · N8893U · Substantial damage NTSB NYC73DGM28Accident · No injuriesClosedCessna 172 · Wattsburg, PAApr 16, 1973 · N5360R · Substantial damage NTSB NYC72AN049Accident · 4 fatalClosedCessna 172L · Meyerstown, PAOct 8, 1971 · N7527G · 2 aircraft · Substantial damage NTSB NYC70FHG07Accident · Serious injuriesClosedCessna 172 · Forksville, PAJun 7, 1970 · N7862U · Destroyed NTSB NYC69D0393Accident · No injuriesClosedCessna 172 · Fogelsville, PAApr 17, 1969 · N8831U · Substantial damage NTSB NYC67F0074Accident · No injuriesClosedCessna 172F · Reading, PAJul 24, 1966 · N8691U · Substantial damage NTSB NYC67F0387Accident · No injuriesClosedCessna 172F · Sharon, PAJul 9, 1966 · N5721R · Substantial damage NTSB NYC66D0592Accident · No injuriesClosedCessna 172 · Reading, PAApr 16, 1966 · N8691U · Substantial damage NTSB NYC66F0499Accident · No injuriesClosedCessna 172 · West Mifflin, PAMar 1, 1966 · N5439R · Substantial damage NTSB NYC66D0360Accident · No injuriesClosedCessna 172 · Erie, PASep 22, 1965 · N5360R · Substantial damage NTSB NYC65F0125Accident · No injuriesClosedCessna 172F · Ambler, PAMar 27, 1965 · N8432U · Substantial damage NTSB UNK65X1357Accident · No injuriesClosedCessna 172 · Leighton, PAJan 27, 1965 · N7950U · Substantial damage