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_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 ('1151532')
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 ('1151532')
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 LAX96FA049Accident · 1 fatalField investigationFinal reportBeech S35 · Oxnard, CAfailure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…NTSB LAX96FA042Accident · 4 fatalField investigationFinal reportBeech S35 · Kneeland, CAfailure of the pilot to correct a descending spiral and perform a missed approach, after becoming spatially disoriented and deviating from the planned ILS approach procedure. Factors relating to the accident were: darkness, and the pilot's excessive…NTSB SEA95LA050Accident · No injuriesLimited investigationFinal reportBeech S-35 · Wolf Point, MTThe loss of power due to lost oil pressure and a failed connecting rod. Factors include fence posts and dusk lighting conditions which limited visibility.NTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.NTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.NTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.NTSB LAX93FA246Accident · 4 fatalField investigationFinal reportBeech S35 · Lovelock, NVThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the adverse weather conditions and mountainous terrain.NTSB CHI93LA120Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Lee'S Summit, MOThe pilot's improper procedures during ground operations.NTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.NTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.NTSB MIA92LA027Accident · 1 fatalLimited investigationFinal reportBeech BE-35 · St. Petersburg, FLThe passenger's loss of balance resulting from a previous impairment.NTSB LAX91FA040Accident · 2 fatalField investigationFinal reportBeech S-35 · Kingman, AZProper altitude not maintained. Contributing to the accident was: the lack of supplemental oxygen on board the aircraft, pilot fatigue, improper use of the auto pilot, and pilot complacency.NTSB MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.NTSB FTW90LA073Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Carrollton, TXStarvation induced power loss caused by the pilot's improper selection/management of the appropriate fuel tank. Contributing to the accident was the pilot's poor inflight planning which resulted in running a fuel tank dry.NTSB CHI89LA158Accident · No injuriesLimited investigationFinal reportBeech S35 · Lindon, MIThe restricted movement of the ruddervator control due to undetermined reasons.NTSB ATL89FA149Accident · 1 fatalField investigationFinal reportBeech S35 · Russellville, KYImproper planning/decision by the pilot, his continued flight into an area of known adverse weather, and his failure to maintain control of the aircraft. Contibuting factors were: the dark night, the adverse weather conditions, and the pilot's overconfidence…NTSB MIA89FA100Accident · 2 fatalField investigationFinal reportBeech S35 · Daytona Beach, FLThe pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…NTSB NYC89LA069Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Bridgeport, CTThe improper fuel selector position and loss of power to the engine due to fuel exhaustion.NTSB DEN89IA028Incident · No injuriesIncident investigationFinal reportBeech S-35 · Matheson, COThe private plt and a friend were enroute for a hunting trip. Thirty miles east of a refueling stop, the pilot heard a loud knock. Oil covered the windscreen and the engine seized. The plt looked out the side window vent to select a forced landing area. A…NTSB FTW88FA063Accident · 2 fatalField investigationFinal reportBeech S35 · Lake Charles, LAAcft crashed into a lake shortly after being vectored onto the final approach course for an ILS at 1,500'. Two current IFR plts were on board. Wx at the time was 500' ovc with 10 miles vis and no convective activity or turbulence reported in the area. No…NTSB CHI87DEC04Accident · 2 fatalFinal reportBeech S35 · Pontiac, MIAcft was making a low pass about 200 ft AGL over rwy 27L to allow ATCT personnel to inspect landing gear position after reporting landing gear difficulties. After twr personnel informed the plt that the gear appeared to be down, the plt requested to land on…NTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…NTSB MKC87LA052Accident · No injuriesLimited investigationFinal reportBeech B-35 · Butler, MOThe PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The…NTSB NYC86LA090Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Laconia, NHDuring cruise flt, the acft eng failed & oil covered the windshield & side windows. Subsequently, the acft crash landed into wooded terrain while in a wings level attitude at low speed. Tests showed the eng crankshaft had failed from fatigue. The fatigue…NTSB FTW86FA024Accident · 1 fatalField investigationFinal reportBeech S35 · Pampa, TXDrg arrival, N6843Q was cleared for an NDB rwy 17 apch. The plt's last radio call was at 1949 CST, when he acknowleged radar svc was terminated & freq chg was approved. When the acft did not arrive, a search was initiated. At 2335, after fog had lifted, the…NTSB MKC85FA040Accident · 3 fatalField investigationFinal reportBeech S35 · Hot Springs, ARThe acft collided with trees & crashed on the east side of west mountain after the plt had made an ILS rwy 5 apch & overflew the arpt. The last wx observation before the accident was: partial obscuration, ceiling 300 ft, visibility 1 mi. The decision height…NTSB LAX84LA322Accident · No injuriesLimited investigationFinal reportBeech S35 · Kayenta, AZThe plt reported that during takeoff, he raised the nose, the acft began climbing and immediately thereafter, the stall warning horn sounded. He then lost control, the acft descended & crashed into terrain south of the rwy. The plt said that he over rotated…NTSB LAX84LA003Accident · No injuriesLimited investigationFinal reportBeech S35 · Elgin, AZWhile taking off from a dirt, ranch strip, the plt elected to use tracks that were worn in the vegetation beside the strip. He believed that these tracks had been formed by other acft & thought the takeoff would be smoother if he used them. However, the…NTSB CHI83LA376Accident · No injuriesLimited investigationFinal reportBeech S35 · Austin, MNThe plt started to takeoff on rwy 35 with a wind from 300 deg at 19, gusting 25 KTS. During the takeoff roll, the right door popped open & the acft veered to the left. Reportedly, the plt intended to continue the takeoff (to circle, land & fix the door).…NTSB NYC83FA204Accident · 2 fatalField investigationFinal reportBeech S35 · Wiscasset, METhe acft was observed taking off on a foggy night with a low overcast sky condition. Shortly after taking off, the plane was observed to turn at low alt, then enter a nose down attitude. The acft crashed & the non-instrument rated plt & passenger were fatally…NTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…NTSB FTW82DA135Accident · No injuriesFinal reportBeech S-35 · Jonesboro, ARThe pilot had completed his run-up in preparation for takeoff when he noticed smoke coming from behind the instrument panel and he exited the aircraft. The instrument panel was destroyed by fire before fire fighting equipment could extinguish the fire. No…NTSB MIA81FKA07Accident · Minor injuriesClosedBeech S35 · St. Thomas, VINTSB LAX81FA037Accident · 4 fatalClosedBeech S35 · Casa Grande, AZNTSB MIA81FLD22Accident · No injuriesClosedBeech S35 · Sanford, FLNTSB LAX81FUJ02Accident · Serious injuriesClosedBeech S35 · Chandler, AZNTSB MIA80FKT56Accident · Minor injuriesClosedBeech 60 · Pompano Beach, FLNTSB FTW80FA067Accident · 1 fatalClosedBeech S35 · Board Camp, ARNTSB MKC80FCG09Accident · No injuriesClosedBeech S35 · Springfield, MONTSB LAX79DUK21Accident · No injuriesClosedBeech S35 · Elfrida, AZNTSB MIA80FA051Accident · 1 fatalClosedBeech S35 · Horseshoe Bch, FLNTSB IAD79FKM07Accident · Serious injuriesClosedBeech S35 · Franklin, NCNTSB SEA78FYA19Accident · Serious injuriesClosedBeech S35 · Yellow Pine, IDNTSB LAX78FA045Accident · 1 fatalClosedBeech S35 · Palmdale, CANTSB MKC78FA034Accident · 5 fatalClosedBeech S-35 · Audubon, IANTSB NYC78FA035Accident · 4 fatalClosedBeech S35 · Carrabassett, MENTSB DEN78FA031Accident · 3 fatalClosedBeech S35 · Aurora, CONTSB CHI77FEX38Accident · No injuriesClosedBeech S35 · Indianapolis, IN
Back to Beech S35