Skip to content

NTSB investigations: Beech 99A

12 cases on aircraft the registry lists as Beech 99A. 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

19712026

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 ('1154003')) 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 ('1154003'))
  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 ('1154003'))
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 ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.Oct 14, 2020 · N499CZ · Substantial damage NTSB GAA17CA244Accident · No injuriesData collectionFinal reportBeech 99 · Waukesha, WIAn in-flight collision with a bird during the approach.Apr 24, 2017 · N899CZ · Substantial damage NTSB WPR17LA056Accident · No injuriesLimited investigationFinal reportBeech 99 · Billings, MTThe fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.Jan 19, 2017 · N326CA · Substantial damage NTSB ERA16LA137Accident · No injuriesLimited investigationFinal reportBeech 99 · Rockland, METhe airplane’s encounter with isolated severe turbulence, which resulted in substantial airframe damage.Mar 2, 2016 · N198WA · Substantial damage NTSB CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…Jan 25, 2007 · N699CZ · 2 aircraft · Substantial damage NTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.Oct 18, 2004 · N955AA · Substantial damage NTSB MIA00WA062Accident · No injuriesForeign investigationBeech 99A · St. Barthelemy, WNDec 31, 1999 · N491BB · Substantial damage NTSB SEA89LA031Accident · No injuriesLimited investigationFinal reportBeech 99A · Spokane, WAAcft was left overnight in heavy precip. Plt failed to ensure fuselage drains were clear and water accumulation drained before departing into below freezing flight temps. On lndg at dest, plt unable to achieve flare, resulting in hard lndg. Investigation…Dec 24, 1988 · N4954W · Substantial damage NTSB FTW82DA301Accident · No injuriesFinal reportBeech B99A · Abilene, TXThe pilot was in the left seat and was getting a check ride from the chief pilot who was in the right seat. After making a series of touch-and-go landings, the aircraft pulled slightly to the left during a takeoff. A full pattern was then flown to runway 17R…Jul 28, 1982 · N326CA · Substantial damage NTSB FTW80IA006Incident · Minor injuriesClosedBeechcraft B99 · Abilene, TXOct 31, 1979 · N35CA · Minor damage NTSB IAD78FA033Accident · Minor injuriesClosedBeech B99A · Clarksburg, WVJan 17, 1978 · N1924T · Substantial damage NTSB FTW71AF037Accident · Serious injuriesClosedBeech 99A · Killeen, TXJan 12, 1971 · N12RA · Destroyed