NTSB investigations: Beech 65-A90

6 cases on aircraft the registry lists as Beech 65-A90, where the first occurrence was “In flight collision with terrain/water”. 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 65-A90 per year, 1982–2026: 6 cases
1982	1
1985	1
1993	2
1996	1
1998	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 ('1152908') 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" = 230)) 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 ('1152908')
      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\" = 230))
  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 ('1152908')
    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" = 230))
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 FTW99LA013Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Russellville, ARThe pilot's failure to maintain clearance with the ground due to the pilot's improper use of the flaps and the ensuing inadvertent descent. Factors were the dark night conditions, the pilot's diverted attention, and the foggy windshield.Oct 17, 1998 · N90GN · Substantial damage NTSB IAD97FA023Accident · Serious injuriesField investigationFinal reportBeech 65-A90 · Orange, VAThe pilot's inadequate preflight inspection and his failure to complete the pretakeoff checklist which resulted in a takeoff roll with the control lock in place.Nov 16, 1996 · N814SW · Destroyed NTSB DEN93FA053Accident · 2 fatalField investigationFinal reportBeech 65-A90 · Mount Ida, ARThe pilot's failure to establish an adequate climb rate. Factors in the accident were: pilot fatigue from lack of sleep, and the weather conditions.May 1, 1993 · N530N · Destroyed NTSB FTW93LA077Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Marfa, TXThe pilot's continued descent below the proper altitude. Factors were the dark night, fog, and the crew's poor coordination.Jan 30, 1993 · N363N · Substantial damage NTSB MIA85LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Apalachicola, FLAn ATP plt (PIC) said he was checking out another (commercial) plt in the acft. As the commercial plt was making a takeoff from a touch-&-go landing, the acft lost altitude & collided with water. The commercial plt stated that he was looking for the flap…Jun 30, 1985 · N28SE · Destroyed NTSB CHI82FA098Accident · No injuriesField investigationFinal reportBeech 65-A90 · Kalamazoo, MIThe plt heard a grinding noise when he attempted to lower the landing gear. The gear would not extend with either the normal or emergency systems. The acft landed with the gear in the partially extended position. Subsequent to examinationof the nose landing…Mar 24, 1982 · N6069C · Substantial damage