NTSB investigations: Beech D95A

7 cases on aircraft the registry lists as Beech D95A, where the first occurrence was “Loss of control - in flight”. 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

19822026

NTSB investigations: Beech D95A per year, 1982–2026: 7 cases
1982	1
1994	1
1998	1
1999	2
2003	1
2006	1

Where

Open the map

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 ('1153408') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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 ('1153408')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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 ('1153408')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.Dec 18, 2006 · N144PG · Destroyed NTSB LAX03FA078Accident · 2 fatalField investigationFinal reportBeech D95A · Lancaster, CAa loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.Jan 31, 2003 · N5639S · Destroyed NTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.Dec 22, 1999 · N456E · Substantial damage NTSB LAX99LA124Accident · No injuriesLimited investigationFinal reportBeech D95A · Dillingham, HIThe student's failure to maintain aircraft control in the gusty crosswind conditions due to limited left yaw authority induced by the simulated single engine approach. The flight instructor's inadequate supervision of the flight and his failure to terminate…Mar 19, 1999 · N199Q · Substantial damage NTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.Apr 24, 1998 · N479AM · Destroyed NTSB LAX94LA340Accident · 1 fatalLimited investigationFinal reportBeech D95A · Oakdale, CAImproper in-flight planning/decision by the flight instructor (CFI), and the cfi's inadequate supervision by not assuring that the minimum control speed (VMC) was maintained. A factor related to the accident was: the cfi's lack of experience in multi-engine…Aug 28, 1994 · N4835J · Destroyed NTSB DCA82AA023Accident · 5 fatalFinal reportBeech D95A · Columbia, MDThe acft was vectored to intercept the localizer course for an ILS approach to rwy 10 at balt-wash-intl arpt. It was then observed to fly through & to the north of the localizer course. The acft was then directed to turn left to a heading of 360 for…May 28, 1982 · N187Q · Destroyed