NTSB investigations: Cessna 170A, PA

8 cases on aircraft the registry lists as Cessna 170A. 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

NTSB investigations: Cessna 170A, PA per year, 1965–2026: 8 cases
1965	1
1967	3
1968	1
1977	1
1981	1
1985	1

Where

Open the map

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 ('2072304')) 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 ('2072304'))
  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 ('2072304'))
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 NYC85LA078Accident · No injuriesLimited investigationFinal reportCessna 170A · Perkasie, PAThe pilot stated that the aircraft ground looped to the right after touchdown. The left gear collapsed and the aircraft spun to the left.Mar 10, 1985 · N170AS · Substantial damage NTSB NYC81FHA19Accident · Minor injuriesClosedCessna 170 · Uniondale, PAJul 19, 1981 · N1400D · Substantial damage NTSB NYC77FGM25Accident · No injuriesClosedCessna 170A · Apollo, PAMay 21, 1977 · N5424C · Substantial damage NTSB NYC68F0492Accident · Minor injuriesClosedCessna 170A · Belle Vernon, PAApr 23, 1968 · N9295A · Substantial damage NTSB NYC67F0678Accident · No injuriesClosedCessna 170A · Butler, PAApr 11, 1967 · N9759A · Substantial damage NTSB NYC67D0606Accident · Minor injuriesClosedCessna 170A · Milton, PAApr 3, 1967 · N1412D · Substantial damage NTSB NYC67A0105Accident · 3 fatalClosedCessna 170A · Mcclellandtown, PAJan 22, 1967 · N9753A · Destroyed NTSB NYC66F0112Accident · No injuriesClosedCessna 170A · Irwin, PAJul 4, 1965 · N3850V · Substantial damage