Skip to content

NTSB investigations: Continental C145 series, OR

28 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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 WPR24LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Scappoose, ORThe pilot’s failure to maintain aircraft control during the landing roll in gusting wind conditions.Apr 30, 2024 · N1657D · Substantial damage NTSB WPR20LA097Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Baker City, ORThe failure of the No. 2 connecting rod bearing as a result of oil starvation due to a contaminated oil filter screen.Feb 27, 2020 · N5478C · Substantial damage NTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.Sep 19, 2014 · N3210A · Substantial damage NTSB WPR11CA397Accident · Minor injuriesData collectionFinal reportCessna 170B · Jefferson, ORThe pilot's failure to maintain clearance from power transmission lines during the landing approach into the sun.Aug 19, 2011 · N2789D · Substantial damage NTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.Jul 30, 2011 · N9741A · Substantial damage NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.May 1, 2005 · N6352Y · Destroyed NTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.Sep 22, 1996 · N2496D · Substantial damage NTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.Jan 2, 1996 · N2761D · Substantial damage NTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.Aug 17, 1994 · N8339A · Substantial damage NTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.Jul 29, 1985 · N8011A · Substantial damage NTSB SEA7LFYC22Accident · Minor injuriesClosedCessna 170B · Cascade Locks, ORSep 27, 1975 · N2772D · Substantial damage NTSB SEA76FYI03Accident · No injuriesClosedAeronca 15AC · Lapine, ORJul 13, 1975 · N1313H · Substantial damage NTSB SEA76DYI01Accident · No injuriesClosedCessna 170 · Redmond, ORJul 5, 1975 · N8282A · Destroyed NTSB SEA75DYI24Accident · No injuriesClosedCessna 170B · Medford, ORMay 26, 1975 · N2639D · Substantial damage NTSB SEA74DYC16Accident · Minor injuriesClosedCessna 170A · Imnaha, ORSep 15, 1973 · N9211A · Substantial damage NTSB SEA73DYI13Accident · Minor injuriesClosedCessna 170A · Bandon, ORApr 8, 1973 · N9270A · Substantial damage NTSB SEA73DYC14Accident · No injuriesClosedCessna 170B · Wallowa, ORDec 9, 1972 · N8365A · Substantial damage NTSB SEA72FYC31Accident · No injuriesClosedCessna 170 · Donald, ORMar 28, 1972 · N2772D · Substantial damage NTSB SEA71FVQ01Accident · Minor injuriesClosedCessna 170 · Redmond, ORJul 17, 1970 · N9571A · Destroyed NTSB SEA70D0130Accident · No injuriesClosedCessna 170B · Agnes, ORSep 13, 1969 · N4359B · Substantial damage NTSB SEA68F0220Accident · No injuriesClosedCessna 170B · Prineville, ORNov 14, 1967 · N2732D · Substantial damage NTSB SEA68D0192Accident · No injuriesClosedGlobe GC-1B · Warrenton, ORSep 12, 1967 · N2384B · Substantial damage NTSB SEA67F0217Accident · No injuriesClosedCessna 170A · Chiloquin, ORSep 16, 1966 · N5471C · Substantial damage NTSB SEA67F0105Accident · No injuriesClosedCessna 170B · Troutdale, ORAug 9, 1966 · N2575D · Substantial damage NTSB SEA66F0273Accident · Minor injuriesClosedCessna 170A · Wallowa, ORApr 27, 1966 · N2635V · Destroyed NTSB SEA66D0160Accident · No injuriesClosedCessna 170 · Monument, OROct 1, 1965 · N3903V · Substantial damage NTSB SEA65D0054Accident · No injuriesClosedCessna 170B · Nyssa, ORApr 26, 1965 · N2513D · Substantial damage NTSB UNK64X1554Accident · No injuriesClosedCessna 170B · Prineville, ORMay 2, 1964 · N2850C · Substantial damage