Skip to content

NTSB investigations: Continental C145 series, PA

25 cases on aircraft whose registry engine model is Continental C145 series. 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

19642026

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.engine_model_code IN ('17012')) 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.engine_model_code IN ('17012'))
  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.engine_model_code IN ('17012'))
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 ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.Sep 22, 2020 · N2772D · Substantial damage NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.May 12, 2018 · N2485D · Substantial damage NTSB IAD03LA002Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Somerset, PAThe mechanic's failure to discover several mechanical deficiencies during a pre-buy inspection, which either independently or collectively resulted in a subsequent engine failure. A factor was the power lines in the forced landing area.Oct 7, 2002 · N6652N · Substantial damage NTSB NYC85LA134Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Whitpain, PAThe acft overran the end of the rwy and contacted rough terrain during takeoff. The plt stated the acft lifted off aprx 1/2 the way down the rwy but it did not have enough airspeed to accelerate and climb. The plt attempted to abort the takeoff however, the…May 24, 1985 · N80902 · Substantial damage 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 NYC82DA179Accident · No injuriesFinal reportCessna 170 · Erwinna, PAThe right axle of the landing gear separated after a normal landing. The gear dug into the ground and the aircraft nosed over.Aug 1, 1982 · N3988V · Substantial damage NTSB NYC81FHA19Accident · Minor injuriesClosedCessna 170 · Uniondale, PAJul 19, 1981 · N1400D · Substantial damage NTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PAMay 8, 1981 · N250K · Substantial damage NTSB NYC79FGT09Accident · No injuriesClosedCessna 170 · Bloserville, PAFeb 22, 1979 · N4220V · Substantial damage NTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PAOct 14, 1976 · N1269H · Substantial damage NTSB NYC75DHA36Accident · No injuriesClosedCessna 170B · Hazleton, PAApr 12, 1975 · N3124A · Substantial damage NTSB NYC74DGT13Accident · No injuriesClosedAeronca 15AC · Columbia C Rds, PAOct 20, 1973 · N1271H · Substantial damage NTSB NYC72FGT01Accident · No injuriesClosedAeronca 15AC · Liberty, PAAug 9, 1971 · N1271H · Substantial damage NTSB NYC71FHG04Accident · Serious injuriesClosedCessna 170 · Lockhaven, PAAug 14, 1970 · N4080V · Substantial damage NTSB NYC68F0042Accident · No injuriesClosedGlobe GC-1B · Lehighton, PAJul 10, 1967 · N78128 · Substantial damage NTSB NYC67D0647Accident · No injuriesClosedCessna 170 · Corry, PAMay 6, 1967 · N1827C · 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 NYC67D0333Accident · No injuriesClosedCessna 170 · New Wilmington, PAAug 18, 1966 · N2595V · Substantial damage NTSB NYC66F0180Accident · No injuriesClosedGlobe GC-1B · Butler, PAJul 19, 1965 · N78104 · Substantial damage NTSB NYC66F0112Accident · No injuriesClosedCessna 170A · Irwin, PAJul 4, 1965 · N3850V · Substantial damage NTSB NYC65A0156Accident · 1 fatalClosedCessna 170 · Neffsville, PAJun 27, 1965 · N4080V · 2 aircraft · Minor damage NTSB NYC65F0213Accident · No injuriesClosedCessna 170 · Elizabethville, PAMay 17, 1965 · N2896C · Substantial damage NTSB UNK64X0598Accident · No injuriesClosedGlobe GC1B · Scranton, PAFeb 17, 1964 · N3785K · Substantial damage