Skip to content

NTSB investigations: Continental C145 series, NM

24 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

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.Oct 29, 2019 · N3016A · Substantial damage NTSB GAA17CA382Accident · No injuriesData collectionFinal reportCessna 170 · Alamogordo, NMThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.Jun 28, 2017 · N2774D · Substantial damage NTSB GAA17CA284Accident · No injuriesData collectionFinal reportCessna 170 · Taos, NMThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.May 5, 2017 · N9268A · Substantial damage NTSB CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damage NTSB CEN09CA011Accident · No injuriesData collectionFinal reportCessna 170 · Santa Fe, NMThe flight instructor's delay in taking timely control of the airplane. Contributing to the accident was the crosswind.Oct 12, 2008 · N9100A · Substantial damage NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.Mar 29, 2003 · N5577C · Substantial damage NTSB DEN03LA057Accident · No injuriesLimited investigationFinal reportCessna 170A · Santa Rosa, NMthe pilot's failure to maintain directional control while taxiing for takeoff. A contributing factor was the wind gust.Mar 26, 2003 · N1228D · Substantial damage NTSB FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.Jun 1, 1998 · N1896C · Substantial damage NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.Feb 23, 1990 · N9130A · Substantial damage NTSB DEN84LA171Accident · No injuriesLimited investigationFinal reportCessna 170B · Belen, NMDuring the takeoff roll directional control was lost and the acft rolled off the left side of the rwy. Heavy braking was applied in order to stop short of a fence and the acft nosed over inverted. Both occupants were rated plts. Their statements were…Jun 8, 1984 · N3279A · Substantial damage NTSB FTW80FQA39Accident · Minor injuriesClosedPiper PA-15 · Fort Sumner, NMSep 14, 1980 · N4123H · Substantial damage NTSB DEN77DQA50Accident · No injuriesClosedCessna 170 · Gallup, NMAug 20, 1977 · N9130A · Substantial damage NTSB DEN75DQD21Accident · No injuriesClosedCessna 170 · Playas, NMMay 6, 1975 · N1489D · Substantial damage NTSB DEN75DQA34Accident · No injuriesClosedCessna 170A · Logan, NMFeb 23, 1975 · N1393D · Substantial damage NTSB DEN74DQD26Accident · No injuriesClosedCessna 170B · Las Cruces, NMJun 9, 1974 · N43F · Substantial damage NTSB DEN74DQD12Accident · No injuriesClosedCessna 170B · Las Cruces, NMDec 1, 1973 · N43F · Substantial damage NTSB DEN73FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMAug 17, 1972 · N2790D · Substantial damage NTSB DEN71DQA44Accident · No injuriesClosedCessna 170B · Albuquerque, NMFeb 2, 1971 · N2488D · Substantial damage NTSB DEN69F0176Accident · No injuriesClosedCessna 170 · Las Cruces, NMFeb 9, 1969 · N4222V · Substantial damage NTSB DEN69D0011Accident · No injuriesClosedCessna 170B · Farmington, NMJun 19, 1968 · N8290A · Substantial damage NTSB DEN68D0190Accident · No injuriesClosedCessna 170B · Farmington, NMJan 21, 1968 · N2585C · Substantial damage NTSB DEN67F0225Accident · No injuriesClosedUniv Acft GC-1B · Grants, NMMar 18, 1967 · N2320B · Substantial damage NTSB DEN66D0144Accident · No injuriesClosedCessna 170 · Carlsbad, NMOct 24, 1965 · N4222V · Substantial damage NTSB DEN66D0097Accident · No injuriesClosedCessna 170B · Las Cruces, NMAug 29, 1965 · N2307D · Substantial damage