NTSB investigations: Beech 100
10 cases on aircraft the registry lists as Beech 100. 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
| 1974 | 1 |
|---|---|
| 1977 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1997 | 1 |
| 2008 | 1 |
| 2016 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152916'))
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 ('1152916'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.NTSB FTW90LA087Accident · Serious injuriesLimited investigationFinal reportBeech 100 · Uvalde, TXImproper IFR procedure by the pilot by not maintaining the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: darkness, low ceiling, fog, and rain.NTSB FTW89FA166Accident · Serious injuriesField investigationFinal reportBeech BE 100 · Houston, TXThe inadequate preflight planning preparation & the improper inflight planning/decision by the PIC when he failed to refuel the aircraft which resulted in a total loss of power in both engines.NTSB ATL89FA213Accident · 6 fatalField investigationFinal reportBeech 100 · Mayfield, KYFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness, the adverse weather conditions, and the tree.NTSB CHI87LA210Accident · No injuriesLimited investigationFinal reportBeech 100 · Batesville, INThe aircraft was approaching hillenbrand airport when the pilot noticed a thunderstorm cell moving in on the airport. The pilot elected to expedite into hillenbrand. During the approach the landing gear was never placed in the extended position. The pilot…NTSB ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…NTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALNTSB MIA75AM030Accident · 2 fatalClosedBeech 100 · Birmingham, AL