Skip to content

NTSB investigations: Beech 58, NM

13 cases on aircraft the registry lists as Beech 58. 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."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 ('1152740')) 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 ('1152740'))
  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 ('1152740'))
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 DEN07FA100Accident · 1 fatalField investigationFinal reportBeech 58 · Placitas, NMthe failure of the pilot to maintain adequate terrain separation, for undetermined reasons, which resulted in controlled flight into terrain. A contributing factor was the mountainous terrain.Jun 16, 2007 · N6750R · Destroyed NTSB FTW02LA189Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Farmington, NMThe failure of the nose landing gear plunger assembly due to fatigue.Jun 23, 2002 · N8245H · Substantial damage NTSB FTW02LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Farmington, NMThe failure of the nose gear actuator retract arm due to fatigue.Oct 26, 2001 · N8117V · Substantial damage NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.Mar 13, 1998 · N9239Q · Substantial damage NTSB FTW97LA367Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Mora, NMloss of power in the right engine for undetermined reason(s). Related factors were: that the power loss occurred above the airplane's single engine service ceiling (at high density altitude), and the lack of suitable terrain for a forced landing.Sep 28, 1997 · N365C · Destroyed NTSB FTW93FA103Accident · 4 fatalField investigationFinal reportBeech 58 · Grants, NMThe pilot's inadequate preflight planning/preparation and the selection of an altitude that would not provide terrain clearance along his planned route. Factors were the dark night conditions and the mountainous terrain.Mar 15, 1993 · N4320W · Destroyed NTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.Mar 5, 1991 · N2019V · Destroyed NTSB FTW84FA104Accident · 4 fatalField investigationFinal reportBeech 58 · Marquez, NMThe acft was flown at altitudes up to 15000 ft in areas of forecast icing. The acft was not equipped with oxygen. The acft was flown above 14000 ft for about 20 minutes after which it descended into icing conditions. Shortly thereafter, the acft made a climb…Dec 27, 1983 · N9121S · Destroyed NTSB FTW83LA055Accident · No injuriesLimited investigationFinal reportBeech 58 · Lovington, NMThe pilot reported that while taking off with a light crosswind, the right passenger door opened. While trying to catch papers and hold the door, the right propeller struck the runway and the right main gear began collapsing. By this time, the pilot decided…Dec 7, 1982 · N18HM · Substantial damage NTSB FTW82FA103Accident · 6 fatalField investigationFinal reportBeech 58 · Magdalena, NMThe plt was advised of the icing conditions to be expected three different times during his wx briefing. At 1524 while enroute at 14,000 ft, the plt was advised of a PIREP of light to moderate icing between 14,O00 & 22,000 ft. the plt replied that was about…Mar 26, 1982 · N36969 · Destroyed NTSB DEN78FQA39Accident · No injuriesClosedBeech 58 · Albuquerque, NMJul 11, 1978 · N9206Q · Substantial damage NTSB DEN76DQA14Accident · No injuriesClosedBeech 58 · Ruidoso, NMAug 31, 1975 · N9027Q · Substantial damage NTSB DEN72AD032Accident · 5 fatalClosedBeech 58 · Las Cruces, NMJan 22, 1972 · N9328Q · Destroyed