Skip to content

NTSB investigations: Cessna 170B, NV

21 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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 WPR23LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Elko, NVThe pilot’s loss of control after encountering a dust devil during takeoff.Jun 16, 2023 · N8223A · Substantial damage NTSB WPR15FA010Accident · 2 fatalField investigationFinal reportCessna 170B · Yerington, NVThe failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…Oct 12, 2014 · N3558C · 2 aircraft · Destroyed NTSB LAX01LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Henderson, NVThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion and a forced landing in rough terrain.Apr 29, 2001 · N2567C · Substantial damage NTSB LAX98LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Fernley, NVthe pilot's failure to maintain terrain clearance during a delayed go-around after an improper decision to continue an approach to an unlighted runway without adequate visual references. Ground fog was a factor in this accident.Oct 24, 1997 · N3155A · Substantial damage NTSB LAX92LA105Accident · 1 fatalLimited investigationFinal reportCessna 170B · Austin, NVThe pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…Jan 28, 1992 · N39HP · Substantial damage NTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.Jun 12, 1989 · N2873C · Substantial damage NTSB SEA85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Winnemucca, NVThe plt was attmepting to depart rwy 02 and the wind was from 300 degs at 15 KTS gusting to 20 KTS. Directional control of the acft was not maintained and it veered off the side of the rwy during the takeoff ground run.Sep 21, 1985 · N1930C · Substantial damage NTSB SEA85LA102Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder City, NVDuring arrival, a person answering the UNICOM reported that rwy 3 was the active rwy & that the wind was 10 KTS. The plt made a wheel landing on rwy 3 in winds that were from 210 deg at 10 KTS. He stated that when the tailwheel came down during the landing…May 2, 1985 · N2518D · Substantial damage NTSB LAX81FA080Accident · 1 fatalClosedCessna 170B · Steamboat, NVApr 30, 1981 · N2318D · Destroyed NTSB LAX80FA001Accident · 2 fatalClosedCessna 170B · Schurz, NVOct 7, 1979 · N8321A · Destroyed NTSB OAK79DXQ19Accident · No injuriesClosedCessna 170B · Reno, NVJun 10, 1979 · N2515D · Substantial damage NTSB OAK76AP011Accident · 3 fatalClosedCessna 170B · Goldfield, NVSep 20, 1975 · N2278D · Destroyed NTSB OAK74AXQ22Accident · Minor injuriesClosedCessna 170B · Eureka, NVFeb 13, 1974 · N2731D · Substantial damage NTSB OAK68A0052Accident · 2 fatalClosedCessna 170B · Hawthorne, NVDec 30, 1967 · N3114B · Destroyed NTSB SEA68D0018Accident · No injuriesClosedCessna 170B · Jackpot, NVFeb 4, 1967 · N2386D · Substantial damage NTSB OAK67D0043Accident · Serious injuriesClosedCessna 170B · Contact, NVJul 5, 1966 · N8201A · Substantial damage NTSB LAX66D0362Accident · No injuriesClosedCessna 170B · Wendover, NVApr 22, 1966 · N3159A · Substantial damage NTSB UNK65X0130Accident · No injuriesClosedCessna 170 · Las Vegas, NVOct 3, 1964 · N4392B · Substantial damage NTSB UNK64X2003Accident · Minor injuriesClosedCessna 170B · Mercury, NVMay 29, 1964 · N2454D · Substantial damage NTSB UNK64X1292Accident · 4 fatalClosedCessna 170B · Gerlach, NVApr 12, 1964 · N3521C · Destroyed NTSB UNK64X0568Accident · No injuriesClosedCessna 170B · Las Vegas, NVFeb 15, 1964 · N8294A · Destroyed