Skip to content

NTSB investigations · 265

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1151004') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1151004')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1151004')
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 GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Oct 23, 2016 · N644B · Substantial damage NTSB ANC07LA032Accident · No injuriesLimited investigationFinal reportBeech D18S · Levelock, AKThe pilot's misjudged flare, which precipitated a hard landing, and damage to the main landing gear, resulting in a main landing gear collapse during the landing roll. A factor contributing to the accident was the overload failure of the main landing gear…Apr 26, 2007 · N502CK · Substantial damage NTSB MIA00WA080Accident · Minor injuriesForeign investigationBeech D18S · Bimini, BahamasFeb 2, 2000 · N122V · Substantial damage NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.Jan 11, 2000 · N1827M · Substantial damage NTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.Jun 25, 1997 · N765D · Destroyed NTSB MIA96WA170Accident · No injuriesForeign investigationBeech D18S · Rock Sound, BahamasJun 29, 1996 · N354T · Substantial damage NTSB FTW96LA057Accident · Serious injuriesLimited investigationFinal reportBeech D18S · Loveland, COThe second pilot's failure to compensate for wind conditions and his improper recovery from a bounced landing, and the pilot-in-command's inadequate supervision of the flight. Factors were the second pilot's lack of landing experience in the airplane…Nov 30, 1995 · N8603A · Destroyed NTSB CHI94LA323Accident · No injuriesLimited investigationFinal reportBeech D18S · Mt Pleasant, MIthe improper fuel selector position by the pilot-in-command which resulted in fuel starvation. A factor was rough/uneven terrain.Sep 9, 1994 · N666S · Substantial damage NTSB ANC93LA127Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Kodiak, AKThe pilot's improper in flight planning/decision. A factor was the partial loss of power on one engine.Jul 25, 1993 · N2053D · Substantial damage NTSB FTW93LA001Accident · No injuriesLimited investigationFinal reportBeech D18S · Brookston, TXSmoke trailing from the left engine for an undetermined reason(s). Factors contributing to the accident were unsuitable terrain conditions.Oct 1, 1992 · N90460 · Substantial damage NTSB LAX92LA042Accident · No injuriesLimited investigationFinal reportBeech D18S · Hilo, HIThe aircraft's lack of single engine performance to maintain altitude after the engine lost power. Factors related to the accident were: displacement/mechanical interference within the accessory drive gear system of the left engine, failure of the left engine…Nov 10, 1991 · N4193 · Substantial damage NTSB DEN91LA073Accident · No injuriesLimited investigationFinal reportBeech D18-S · Englewood, COThe loss of directional control by the pilot. Factors were: the cross, failure of the pilot to lock the tail wheel, and the pilot's disregard of crosswind limitations.May 18, 1991 · N44623 · Substantial damage NTSB MIA88WA136Accident · No injuriesForeign investigationBeech D18S · St Maarten Isl., British Virgin IslandsMar 31, 1988 · N126M · Substantial damage NTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…Nov 15, 1987 · N802H · Substantial damage NTSB MIA87FA259Accident · 2 fatalField investigationFinal reportBeech D18S · Miami, FLWitnesses observed the aircraft taxi to the end of runway 27R and positioned so the tail was out in the overrun area. Witnesses further stated the aircraft appeared to take an overly long takeoff roll before lifting off. After lift off, the aircraft pitched…Sep 25, 1987 · N76Q · Destroyed NTSB LAX87LA265Accident · No injuriesLimited investigationFinal reportBeech D18S · Riverside, CAThe acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…Jul 11, 1987 · N99CP · Substantial damage NTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…Jul 5, 1987 · N132E · Destroyed NTSB MIA86IA211Incident · No injuriesIncident investigationFinal reportBeech D18S · Ft. Lauderdale, FLFlight experienced collapse of the right main landing gear during landing roll when the bolt which attaches the upper end of the drag leg failed in fatigue. Company maintenance personnel did not remove this bolt regularly for inspection. Beech aircraft…Jul 17, 1986 · N76Q · Minor damage NTSB MIA86LA088Accident · No injuriesLimited investigationFinal reportBeech D-18S · Pascagoula, MSThe plt stated that he sensed a loss of pwr on one eng after takeoff, just prior to gear retraction. He elected to remove all pwr and land straight ahead on the remaining rwy. The acft went off the end of the rwy and entered a wet grass area. The acft could…Mar 2, 1986 · N4446K · Substantial damage NTSB ATL85FA283Accident · 1 fatalField investigationFinal reportBeech D18S · Huntington, WVThe acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…Sep 25, 1985 · N25Q · Destroyed NTSB ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…Dec 13, 1984 · N8517Z · Destroyed NTSB FTW84LA317Accident · No injuriesLimited investigationFinal reportBeech D-18S · Mcallen, TXThe PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main…Jul 20, 1984 · N113B · Substantial damage NTSB FTW84FA086Accident · 1 fatalField investigationFinal reportBeech D18S · Brownsville, TXThe plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…Dec 6, 1983 · N44609 · Destroyed NTSB ATL83LA300Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Revenswood, WVAfter returning from a sport parachuting flt, the plt landed on rwy 3 with a 5-KT, right x-wind. He stated that the touchdown was normal, but when the tailwheel came down at aprx 40 KTS, the acft started to turn to the left. He corrected with right rudder &…Jul 30, 1983 · N483B · Substantial damage NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…Mar 18, 1983 · N80017 · 2 aircraft · Substantial damage NTSB CHI83LA093Accident · No injuriesLimited investigationFinal reportBeech D18S · Plymouth, INPilot landed the aircraft with the landing gear up. He said he put the gear selector down but after landing the lever was up. He also mistook gear up warning horn for a stall warning. No malfunctions were reported.Jan 28, 1983 · N113B · Substantial damage NTSB FTW82DA250Accident · No injuriesFinal reportBeech D18S · Belen, NMThe pilot stated that during flight, the left engine began leaking oil and the cockpit filled with smoke. He shut down the left engine, but stated that the propeller would not completely feather due to the loss of oil. While approaching to land at a nearby…Jun 26, 1982 · N3962 · Substantial damage NTSB ATL82IA154Incident · No injuriesIncident investigationFinal reportBeech 18 · Macon, GAAccording to the pilot, the flight was being conducted under ferry flight provisions. The flight was issued a takeoff clearance for runway 05,with reported surface winds of 320 degrees at 10 knots. The copilot started the takeoff roll and was unable to…Jun 6, 1982 · N171DC · Minor damage NTSB FTW82DA211Accident · No injuriesFinal reportBeech D18S · Beeville, TXThe pilot and three passengers departed on a pleasure flight. The pilot stated that after climbing several hundred feet and while at 110 mph, the right propeller went into high pitch following a propeller governor failure. This resulted in a loss of engine…Jun 3, 1982 · N7510 · Substantial damage NTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…Feb 26, 1982 · N8517Z · Substantial damage NTSB LAX81IA015Incident · No injuriesClosedBeech D18S · Long Beach, CANov 18, 1981 · N104J · Minor damage NTSB CHI82FEI01Accident · No injuriesClosedBeech D18S · Concord, OHOct 30, 1981 · N8962A · Substantial damage NTSB FTW81DRJ35Accident · No injuriesClosedBeech D18S · Simsboro, LASep 12, 1981 · N123J · Substantial damage NTSB MIA81FKT81Accident · No injuriesClosedBeech D18S · Palm Beach, FLAug 27, 1981 · N25V · Substantial damage NTSB ATL81FKG10Accident · Serious injuriesClosedBeech D18 · Claxton, GAMar 2, 1981 · N80162 · Substantial damage NTSB MIA80DLE07Accident · Serious injuriesClosedBeech D18S · Frostproof, FLSep 28, 1980 · N704D · Destroyed NTSB LAX80DJY01Accident · Minor injuriesClosedBeech D18S · Yap-W.Caroline Is (Pacific Ocean)Jul 18, 1980 · N1824D · Destroyed NTSB LAX80FJA19Accident · Minor injuriesClosedBeech D18S · Honolulu, HIJun 22, 1980 · N191U · Substantial damage NTSB LAX80FA033Accident · 2 fatalClosedBeech D18S · Honolulu, HIJan 8, 1980 · N641E · Destroyed NTSB LAX80FUG07Accident · Minor injuriesClosedBeech D18S · Corona, CANov 14, 1979 · N8611A · Destroyed NTSB MIA79FA129Accident · No injuriesClosedBeech D18S · Sumter, SCSep 28, 1979 · N646B · Substantial damage NTSB IAD79FA050Accident · 1 fatalClosedBeech D-18 · Charleston, WVMay 25, 1979 · N1812D · Destroyed NTSB IAD79FA040Accident · No injuriesClosedBeech D-18S · Louisville, KYMar 15, 1979 · N80204 · Substantial damage NTSB MIA79FA041Accident · 2 fatalClosedBeech D-18S · Kenansville, FLJan 16, 1979 · N80W · Destroyed NTSB CHI79FEC05Accident · No injuriesClosedBeechcraft D-18S · Flint, MINov 3, 1978 · N80369 · Destroyed NTSB LAX78FUA32Accident · No injuriesClosedBeech D18S · Long Beach, CASep 28, 1978 · N603RD · Substantial damage NTSB DCA78AA024Accident · 6 fatalClosedBeech D18S · San Juan, PRSep 26, 1978 · N500L · Destroyed NTSB CHI78FA055Accident · Minor injuriesClosedBeech D18S · Chicago, ILAug 8, 1978 · N79R · Destroyed NTSB LAX78FUJ50Accident · No injuriesClosedBeech D18S · Grand Canyon, AZMay 2, 1978 · N118L · Substantial damage NTSB MIA78FA076Accident · 2 fatalClosedBeech D-18S · Ocala, FLApr 30, 1978 · N800WM · Destroyed

Back to Beech D18S