Skip to content

Fatal NTSB investigations: Beech H-18

21 cases on aircraft the registry lists as Beech H-18. 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

19672026

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151012')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151012'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151012'))
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 DEN07FA059Accident · 1 fatalField investigationFinal reportBeech H-18 · Great Bend, KSThe pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.Feb 9, 2007 · N45GM · Destroyed NTSB FTW02FA195Accident · 1 fatalField investigationFinal reportBeech H-18 · Tatum, NMThe failure of the pilot to maintain clearance.Jul 1, 2002 · N835K · Destroyed NTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.Feb 26, 1992 · N347G · Destroyed NTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…Jun 11, 1989 · N34AP · Destroyed NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…Apr 1, 1988 · N989B · Destroyed NTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…Sep 22, 1987 · N5850S · Destroyed NTSB FTW86FA004Accident · 2 fatalField investigationFinal reportBeech H18 · Oklahoma City, OKAtr plt departing arpt under VMC experienced failure of the right eng shortly after lift-off. The acft yawed right followed by a steep right roll, contacting power lines with the right wing and subsequently impacted the ground. A post-crash fire destoyed the…Nov 5, 1985 · N1461G · Destroyed NTSB NYC84FA113Accident · 1 fatalField investigationFinal reportBeech H-18 · Morrisonville, NYThe plt landed on the ice and snow covered rwy after loading 1512 lbs of cargo in freezing drizzle conditions, he taxied for takeoff for an IFR departure shortly after rotation, the right wing dropped and the acft touched down back onthe rwy. Visual exam of…Mar 20, 1984 · N218X · Destroyed NTSB NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…Nov 25, 1983 · N105PE · Destroyed NTSB LAX81FA042Accident · 2 fatalClosedBeech H18 · Newhall, CAJan 28, 1981 · N787Q · Destroyed NTSB NYC81FA010Accident · 1 fatalClosedBeech H18 · Troxelville, PANov 18, 1980 · N701CC · Destroyed NTSB MKC80FA023Accident · 1 fatalClosedBeech H18 · Olathe, KSFeb 15, 1980 · N729F · Destroyed NTSB FTW79FA015Accident · 1 fatalClosedBeech H18 · Brownsville, TXNov 20, 1978 · N204CC · Destroyed NTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILMar 25, 1978 · N58JM · Destroyed NTSB OAK76AP043Accident · 1 fatalClosedBeech H18 · Pacific Ocean (Pacific Ocean)Feb 11, 1976 · N1900G · Destroyed NTSB IAD75AI038Accident · 2 fatalClosedBeech H18 · St Augustine, FLDec 31, 1974 · N500MM · Destroyed NTSB CHI75AC033Accident · 1 fatalClosedBeech H18 · Iron Mtn, MIOct 17, 1974 · N72FA · Destroyed NTSB CHI75AC001Accident · 1 fatalClosedBeech H18 · Iron Mtn, MIJul 3, 1974 · N73FA · Destroyed NTSB OAK74AP053Accident · 11 fatalClosedBeech H18S · Hilo, HIApr 11, 1974 · N28358 · Destroyed NTSB CHI73AC059Accident · 2 fatalClosedBeech H18S · Bloominton, ILDec 21, 1972 · N800G · Destroyed NTSB CHI68A0053Accident · 7 fatalClosedBeech H18 · Madison, WIDec 10, 1967 · N390R · Destroyed