Skip to content

NTSB investigations: Cessna 335

10 cases on aircraft the registry lists as Cessna 335. 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

19842026

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075601')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075601'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075601'))
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 ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.Dec 1, 2018 · N79HP · Destroyed NTSB ERA18FA244Accident · 2 fatalField investigationFinal reportCessna 335 · Lake Worth, FLThe pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.Sep 9, 2018 · N2707J · Destroyed NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.Jul 4, 2002 · N27069 · Substantial damage NTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.Oct 17, 2000 · N8354N · Destroyed NTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.Mar 3, 1993 · N26CP · Substantial damage NTSB CHI89LA136Accident · No injuriesLimited investigationFinal reportCessna 335 · Pontiac, MIFailure of the right main landing gear extension/retraction component resulting from unacceptable loads incurred due to improper adjustment.Jul 14, 1989 · N2706T · Substantial damage NTSB SEA89FA021Accident · 2 fatalField investigationFinal reportCessna 335 · Arlington, WADrg a ngt arr, the plt was vectored for a LOC rwy 34 apch. After rchg the final apch fix/outer marker (om), he was clrd for the apch. Abt 5 or 6 min later, the ATC ctlr noticed the acft was aprx 7 mi nw of the arpt, climbing abv 3000' MSL. Missed apch…Dec 3, 1988 · N2706F · Destroyed NTSB LAX86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 335 · Yuba City, CAUpon completing a 35 min sight-seeing flight the plt entered the traffic pattern & prepared for landing. While descending, both engines lost all power. The plt stated that he repositioned the fuel selectors to the aux tanks, power was restored to the left…Dec 11, 1985 · N2708X · Destroyed NTSB NYC85FGT01Accident · Serious injuriesFinal reportCessna 335 · Barrville, PAThe Cessna 335 was making a contact approach when it flew into the ground. The aircraft received substantial damage and the pilot received serious injuries. Winds in the area were reported at 25 knots with gusts to 35 knots. Visual meteorological conditions…Feb 12, 1985 · N6821C · Destroyed NTSB NYC84LA260Accident · No injuriesLimited investigationFinal reportCessna 335 · University Park, PAThe acft experienced a rt main gear collapse during landing. The plt stated that the gear was checked down & locked on base & final apch. After landing, according to the plts statement, the landing gear warning sounded & the acft started aturn to the rt. A…Aug 1, 1984 · N6821C · Substantial damage