Skip to content

NTSB investigations: Continental C145 series, NY

22 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.Apr 25, 2024 · N8084A · Substantial damage NTSB GAA18CA100Accident · No injuriesData collectionFinal reportCessna 170 · Auburn, NYThe pilot’s improper wind correction inputs while taxiing with a quartering tailwind.Jan 11, 2018 · N1997C · Substantial damage NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.May 8, 2004 · N1754D · Destroyed NTSB IAD03LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Randolph, NYThe pilot's failure to attain/maintain proper runway alignment. A factor in the accident was the sun glare.Apr 19, 2003 · N118F · Substantial damage NTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.Sep 12, 1998 · N4709Q · Substantial damage NTSB NYC98LA133Accident · No injuriesLimited investigationFinal reportCessna 170B · Oneonta, NYThe separation of the left rudder cable. A factor was chafing of the cable.Jun 24, 1998 · N3493C · Destroyed NTSB NYC85LA253Accident · No injuriesLimited investigationFinal reportCessna C-170A · Marathon, NYDuring an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…Sep 28, 1985 · N5709C · Substantial damage NTSB NYC83LA169Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Durhamville, NYAccording to the plt, the acft touched down aprx 500 ft down the rwy, and after rolling aprx 200 ft, it encounter a strong gust. Subsequently, the acft veered left & went off the runway. The plt simultaneously applied full power as the acft hit an embankment.…Jul 9, 1983 · N9154A · Substantial damage NTSB NYC83LA007Accident · No injuriesLimited investigationFinal reportGlobe Swift GC-1B · Elmira, NYDuring takeoff, the right side of the canopy separated from the aircraft as it was climbing through about 150 to 200 ft AGL. The pilot notified the tower of the situation and clearance was obtained to land on any runway. According to the pilot, he turned…Oct 10, 1982 · N50BS · Substantial damage NTSB NYC81FFJ20Accident · No injuriesClosedCessna 170 · Great Valley, NYAug 2, 1981 · N4251V · Destroyed NTSB NYC76DFJ10Accident · No injuriesClosedCessna 170B · Leroy, NYOct 5, 1975 · N8086A · Substantial damage NTSB NYC74DFJ26Accident · No injuriesClosedCessna 170A · Batavia, NYFeb 18, 1974 · N5709C · Substantial damage NTSB NYC73DFA23Accident · No injuriesClosedAeronca 15AC · Northville, NYJan 14, 1973 · N1224H · Destroyed NTSB NYC70F0221Accident · No injuriesClosedAeronca 15AC · Cannan, NYDec 17, 1969 · N1287H · Substantial damage NTSB NYC68D0332Accident · No injuriesClosedCessna 170B · Farmingdale, NYDec 10, 1967 · N2465D · Substantial damage NTSB NYC68F0005Accident · No injuriesClosedAeronca S15AC · Parishville, NYMay 18, 1967 · N1088H · Substantial damage NTSB NYC67F0655Accident · No injuriesClosedCessna 170B · Wallkill, NYApr 30, 1967 · N2825C · Substantial damage NTSB NYC66D0587Accident · No injuriesClosedCessna 170B · Island Park, NYMar 26, 1966 · N2866C · Substantial damage NTSB NYC66D0415Accident · No injuriesClosedCessna 170B · Island Park, NYDec 24, 1965 · N2724C · Substantial damage NTSB NYC65F0227Accident · No injuriesClosedAeronca 15AC · Chazy Lake, NYMay 28, 1965 · N1439H · Substantial damage NTSB UNK64X2900Accident · No injuriesClosedGlobe Swift · Flushing, NYJul 18, 1964 · N3888K · Substantial damage NTSB UNK64X0140Accident · No injuriesClosedCessna 171 · Randolph, NYJan 3, 1964 · N1827C · Substantial damage