Skip to content

NTSB investigations: Cessna 170B, NM

20 cases on aircraft the registry lists as Cessna 170B. 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" = '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.aircraft_model_code IN ('2072306', '2072307')) 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.aircraft_model_code IN ('2072306', '2072307'))
  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.aircraft_model_code IN ('2072306', '2072307'))
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 WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.Nov 15, 2021 · N3463C · Substantial damage 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 CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · 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 DEN89LA116Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Deming, NMThe pilot's failure to maintain directional control during the takeoff ground run, resulting in a loss of control and collision with the terrain. The lack of experience in this type of aircraft is considered to be a factor.May 5, 1989 · N3475D · 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 DEN75FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMAug 21, 1974 · N2546C · 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 DEN69D0127Accident · No injuriesClosedCessna 170B · Whites City, NMOct 14, 1968 · N2953D · Substantial damage NTSB DEN69D0101Accident · No injuriesClosedCessna 170 · Albuquerque, NMSep 9, 1968 · N3186B · 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 DEN67D0045Accident · Minor injuriesClosedCessna 170B · Roswell, NMJul 29, 1966 · N2309D · Substantial damage NTSB DEN67D0001Accident · No injuriesClosedCessna 170 · Deming, NMMay 31, 1966 · N4302B · Substantial damage NTSB DEN66D0097Accident · No injuriesClosedCessna 170B · Las Cruces, NMAug 29, 1965 · N2307D · Substantial damage NTSB UNK64X2578Accident · No injuriesClosedCessna 170B · Albuquerque, NMJun 30, 1964 · N3444D · Substantial damage