Skip to content

NTSB investigations: Cessna 305C (0-1E)

13 cases on aircraft the registry lists as Cessna 305C (0-1E). 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

19722026

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 ('2074014')) 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 ('2074014'))
  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 ('2074014'))
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 WPR23LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305C (0-1E) · Big Bear City, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.Jun 17, 2023 · N62TX · Substantial damage NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.Aug 27, 2022 · N305SU · Substantial damage NTSB CEN20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Castroville, TXThe pilot's failure to maintain directional control during landing.Jun 4, 2020 · N88688 · Substantial damage NTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.Jun 12, 2017 · N305CM · Substantial damage NTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…Dec 17, 2013 · N83CN · Substantial damage NTSB SEA07CA215Accident · No injuriesData collectionFinal reportCessna 305-C · Chino, CAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2007 · N919BD · Substantial damage NTSB ATL87LA005Accident · Serious injuriesLimited investigationFinal reportCessna 305C · Catherine, ALPlt had landed in a soybean field to participate in a dove hunt. Abt 1000 he decided to fly to another field near a restaurant for breakfast. He attempted a short field t.o. and at about 100 ft AGL, he stated that the eng quit with no warning. As a result of…Oct 11, 1986 · N720BC · Substantial damage NTSB LAX84LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Ballard, CAThe pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of…May 22, 1984 · N73857 · 2 aircraft · Minor damage NTSB LAX82FJA03Accident · No injuriesFinal reportCessna 305 (L-19) · Mokuleia, HIDuring the landing roll, the aircraft began to veer left and would not respond to right rudder or brake application. The plane continued off the left side of the runway, and the right wing was damaged. An investigation revealed that the right brake had…Jan 10, 1982 · N5639V · Substantial damage NTSB ANC75DAG38Accident · No injuriesClosedCessna 305 · Ugashik, AKSep 21, 1974 · N6234 · Substantial damage NTSB OAK75DJA02Accident · No injuriesClosedCessna 305C · Honolulu, HISep 3, 1974 · N5639V · No damage NTSB ANC74DAG58Accident · No injuriesClosedCessna 305 · Susitna, AKSep 20, 1973 · N6233 · Substantial damage NTSB OAK73DJA07Accident · No injuriesClosedCessna 305C · Wheelr Afb, HINov 25, 1972 · N5639V · Substantial damage