Skip to content

NTSB investigations: Cessna 180, PA

27 cases on aircraft the registry lists as Cessna 180. 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 ('2072602')) 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 ('2072602'))
  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 ('2072602'))
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 ERA23FA252Accident · 1 fatalClass 3 · FieldFinal reportCessna 180 · Harrisburg, PAThe pilot’s inadequate preflight fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with terrain and objects.May 31, 2023 · N3178D · Substantial damage NTSB NYC08CA203Accident · No injuriesData collectionFinal reportCessna 180 · Kutztown, PAThe pilot's failure to maintain aircraft control.May 29, 2008 · N511MH · Substantial damage NTSB IAD05LA008Accident · 1 fatalLimited investigationFinal reportCessna 180 · Freedom, PAThe pilot's failure to maintain obstacle clearance during the takeoff resulting in an in-flight collision with trees.Oct 27, 2004 · N2922C · Substantial damage NTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.Jul 2, 2000 · N3131D · Substantial damage NTSB NYC97FA099Accident · Serious injuriesField investigationFinal reportCessna 180 · Freedom, PAthe pilot's premature lift off, and his failure to maintain proper runway alignment, which resulted in an inadvertent stall, while attempting to avoid an obstruction (telephone pole). Factors relating to the accident were: the pilot allowed the airplane's…May 26, 1997 · N1802C · Destroyed NTSB NYC90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Hilltown, PAThe pilot receiving training misjudged the airplane's distance from the runway and altitude above the trees. In addition, the CFI failed to provide adequate supervision.Jul 26, 1990 · N1ZT · Substantial damage NTSB NYC81FGM27Accident · Serious injuriesClosedCessna 180 · Rockwood, PAAug 29, 1981 · N2809A · Destroyed NTSB NYC81FGM16Accident · No injuriesClosedCessna 180 · Apollo, PAApr 12, 1981 · N3327D · Substantial damage NTSB NYC79FGM46Accident · No injuriesClosedCessna 180 · Erie, PAAug 29, 1979 · N7746A · Substantial damage NTSB NYC78FGM40Accident · Minor injuriesClosedCessna 180 · Freedom, PAJul 15, 1978 · N9227C · Destroyed NTSB NYC76DHA41Accident · Minor injuriesClosedCessna 180 · Greentown, PAJun 28, 1976 · N2223C · Substantial damage NTSB NYC74DHA33Accident · No injuriesClosedCessna 180 · Greentown, PAJun 11, 1974 · N2223C · Substantial damage NTSB NYC71FHA53Accident · Serious injuriesClosedCessna 180 · Tamiment, PAMay 29, 1971 · N4520B · Destroyed NTSB NYC71AN109Accident · 3 fatalClosedCessna 180 · Tarentum, PAMay 9, 1971 · N180AM · Destroyed NTSB NYC71DHG06Accident · No injuriesClosedCessna 180 · Marietta, PASep 20, 1970 · N3222D · Substantial damage NTSB NYC71DHA11Accident · No injuriesClosedCessna 180 · White Haven, PAJul 31, 1970 · N9317C · Substantial damage NTSB NYC70D0224Accident · Minor injuriesClosedCessna 180 · Greeley, PADec 21, 1969 · N9322C · Substantial damage NTSB NYC69D0171Accident · No injuriesClosedCessna 180 · Beaver Falls, PASep 1, 1968 · N2493C · Substantial damage NTSB NYC69D0028Accident · No injuriesClosedCessna 180 · Freedom, PAJun 2, 1968 · N2922C · Substantial damage NTSB NYC68D0419Accident · No injuriesClosedCessna 180 · Prospect, PAApr 3, 1968 · N2922C · Substantial damage NTSB NYC68F0027Accident · No injuriesClosedCessna 180 · Monroeville, PAJun 18, 1967 · N1717C · Substantial damage NTSB NYC67F0367Accident · No injuriesClosedCessna 180 · Culmerville, PANov 17, 1966 · N3613C · Substantial damage NTSB NYC67F0244Accident · Serious injuriesClosedCessna 180 · Tarentum, PASep 6, 1966 · N1612C · Substantial damage NTSB NYC67F0082Accident · Minor injuriesClosedCessna 180 · Beaver Falls, PAJul 3, 1966 · N3214D · Substantial damage NTSB NYC66F0208Accident · No injuriesClosedCessna 180 · Tarentum, PASep 3, 1965 · N4998A · Substantial damage NTSB NYC65F0111Accident · No injuriesClosedCessna 180 · Allentown, PAApr 19, 1965 · N3675C · Substantial damage NTSB NYC65F0078Accident · No injuriesClosedCessna 180 · Freedom, PAMar 1, 1965 · N3214D · Substantial damage