NTSB investigations: Beech A36, 2008

6 cases on aircraft the registry lists as Beech A36, where the sequence of events included Off-field or emergency landing. 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.

Cases per year

20082026
NTSB investigations: Beech A36, 2008 per year, 2008–2026: 47 cases
20086
20093
20102
20113
20122
20133
20142
20154
20164
20172
20184
20193
20213
20222
20233
20251

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 2008
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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.

NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.Dec 1, 2008 · N3058Y · Substantial damageNTSB CEN09CA038Accident · No injuriesData collectionFinal reportBeech A36 · Salina, KSThe pilot's failure to properly manage the available fuel supply, which resulted in fuel starvation and subsequent loss of engine power.Oct 18, 2008 · N3112Y · Substantial damageNTSB CEN09LA014Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe total loss of engine power due to a fracture in the oil filter adapter housing. Contributing to the accident was the lack of suitable terrain for the forced landing.Oct 8, 2008 · N703KP · DestroyedNTSB CHI08CA175Accident · No injuriesData collectionFinal reportBeech A36 · Dwight, ILThe loss of engine power for undetermined reasons. Contributing to the accident was the highway signpost that the airplane impacted during the landing rollout.Jul 1, 2008 · N6051M · Substantial damageNTSB DFW08LA169Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olathe, KSA loss of engine power for undetermined reasons.Jun 24, 2008 · N28HN · Substantial damageNTSB CHI08LA154Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MNA loss of engine thrust due to the propeller separating from the aircraft as a result of fatigue failure of the propeller attachment bolts caused by the insufficient torque of the bolts during installation.Jun 9, 2008 · N7214Y · Substantial damage