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 ('1151604')
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 ('1151604')
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 NYC91FA025Accident · 2 fatalField investigationFinal reportBeech A36 · Bradford, PAThe pilot's failure to maintain adequate terrain clearance while maneuvering to land during an instrument approach. Factors related to the accident were: the pilot's failure to obtain a weather briefing prior to departure, his delayed decision to make an…NTSB ATL91FA008Accident · 2 fatalField investigationFinal reportBeech A36 · Georgetown, SCThe pilot-in-command's loss of consciousness during flight. The reason for the loss of consciousness could not be determined.NTSB FTW90FA176Accident · 2 fatalField investigationFinal reportBeech 36 · Baird, TXThe pilot-in-command failed to maintain control of the airplane while flying in severe weather and instrument meteorological conditions. The adverse weather conditions were a factor.NTSB NYC90LA141Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Lawrence, MAThe failure of the pilot to maintain control of the airplane with an open door. Factors related to the accident was the failure of the pilot to maintain airspeed and the door opening at liftoff.NTSB CHI90FA146Accident · 4 fatalField investigationFinal reportBeech A36 · Gaylord, MIThe pilot's inadequate airspeed, while maneuvering (turning) after takeoff, which resulted in a stall/mush. Factors related to the accident were: the pilot's improper planning/decision, failure to maintain weight and balance limits, and adverse wind…NTSB ATL90LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Hahira, GAThe failure of the right main landing gear tire on landing the failure of the pilot to detect an existing cut on the right main landing gear tire during preflight.NTSB LAX90FA138Accident · 3 fatalField investigationFinal reportBeech A36 · Kneeland, CAThe pilot's improper use of IFR procedures by failing to maintain the minimum descent altitude for the segment of the approach that he was flying. The hilly/mountainous terrain was a related factor.NTSB ATL90LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Nashville, NCA loss of engine power for undetermined reasons. A factor related to the accident was the ditch the airplane contacted.NTSB CHI90FA028Accident · 3 fatalField investigationFinal reportBeech A36 · Shell Lake, WIThe pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…NTSB CHI90LA024Accident · No injuriesLimited investigationFinal reportBeech A36 · Angola, INFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness and adverse weather conditions.NTSB ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.NTSB DEN89LA194Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Santa Fe, NMImproper use of the mixture control by the pilot during takeoff which resulted in fuel starvation. Rough/uneven terrain contributed to the aircraft damage.NTSB ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.NTSB NYC89FA177Accident · 7 fatalField investigationFinal reportBeech A36 · Salisbury Twp, PAThe failure of both pilots to see and avoid each other. A contributing factor to the accident was that neither pilot was heard over the radio announcing their position and intentions.NTSB MIA89FA178Accident · 1 fatalField investigationFinal reportBeech A36 · Shelby, MSFailure of the pilot to maintain adequate airspeed while maneuvering back to the runway which resulted in an inadvertentstall. Contributing factors were: failure of the pilot to insure the cabin door (on the passenger's side) was properlyclosed and secured…NTSB DEN89FA141Accident · 1 fatalField investigationFinal reportBeech A36 · South Lake Taho, CAThe pilot's falure to maintain adequate airspeed after takeoff due to diverted attention toward an open acft door.NTSB LAX89LA146Accident · No injuriesLimited investigationFinal reportBeech A36 · Sacramento, CAFailure of the number four piston assembly. A factor related to the accident was: the soft/uneven terrain in the emergency landing area.NTSB ATL89LA133Accident · No injuriesLimited investigationFinal reportBeech A36 · Macon, GAThe pilot delayed remedial action when the imminent loss of electrical power was observed. Additionally, the pilot's failure to execute the appropriate emergency procedure and manually lower the landing gear, resulted in its collapse upon landing.…NTSB ATL89LA108Accident · No injuriesLimited investigationFinal reportBeech A36 · Chamblee, GAThe inattention of the pilot which resulted in the inadvertent retraction of the landing gear during the landing roll.NTSB NYC89FA086Accident · 6 fatalField investigationFinal reportBeech A36 · Glen Falls, NYFailure of both pilots to see-and-avoid each other. Related factors were: failure of the Beech aircrew to make a normal left turn out of traffic and the Stinson pilot's visual perception due to sunglare.NTSB NYC89LA078Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Kennebunk, METhe pilot's failure to assure the fuel selector was properly positioned which resulted in fuel starvation and the subsequent forced landing.NTSB NYC89FA059Accident · 1 fatalField investigationFinal reportBeech A36 · Bridgeport, CTTwice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…NTSB NYC89FA056Accident · 3 fatalField investigationFinal reportBeech A36 · Harrison, NYThe plt was clrd for an IFR departure from rwy 16 in instrument meteorological conditions (IMC). His departure clnc was to climb on rwy heading to 800 ft, then turn right to a heading of 320 deg. When the acft took off, tower psnl did not have visual contact…NTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…NTSB FTW89FA023Accident · 2 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKThe plt was briefed on flt prctns for IFR conds, tstms & ocnl mod rime icing. Drg the climb, he told ATC he was having trouble with his vacuum & was disoriented. ATC clrd him for altitudes he could use & bgn providing no-gyro vectors. A wxcheck revealed there…NTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.NTSB MKC88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Marion, IAWhile attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed…NTSB DEN88LA148Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Craig, COWhile on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,…NTSB SEA88LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Wenatchee, WAAirframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had…NTSB DEN88FA090Accident · 4 fatalField investigationFinal reportBeech A36 · Colorado Spring, COAfter takeoff the acft failed to climb sufficiently to clear a utility pole one-half mile off the end of the runway. The acft collided with the pole and crashed in a residential street. The plt and three pax were fatally injured and the acft was consumed by…NTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…NTSB ATL88FA104Accident · 2 fatalField investigationFinal reportBeech A36 · Bow, KYThe pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…NTSB LAX88DUM03Accident · Minor injuriesFinal reportBeech A36 · Ramona, CADuring a test flight for certification of wing tip tanks, while performing spins, the aircraft entered a flat spin. The pilot was unable to regain control and exited the aircraft and parachuted to safety. The aircraft collided with the terrain shortly…NTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…NTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…NTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…NTSB ATL87FA101Accident · Serious injuriesField investigationFinal reportBeech A36 · Dalton, GAOn t/o at 1st power change PIC noted loss of performance. He turned left to downwind leg for landing. PIC and ground witnesses said eng quit and acft crashed into trees and ground. Post crash fire destroyed acft. PIC rpted taking fuel sample before t/o with…NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…NTSB DEN87LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · Taos, NMThe plt was making a night VFR landing approach to rwy 22 at Taos, new Mexico, when the acft struck some high voltage power transmission lines running perpendicular to the rwy. The plt was able to maintain control of the acft and landed it successfully. The…NTSB LAX86LA342Accident · No injuriesLimited investigationFinal reportBeech A-36 · Visalia, CAThe airplane departed monterey airport, monterey, CA on a VFR night flight. The plt entered the downwind leg for runway 30 and observed an airplane depart on the runway at what she thought was about midfield. The airplane had departed from the runway…NTSB ATL86LA136Accident · No injuriesLimited investigationFinal reportBeech A36 · Swansboro, NCThe plt reported that the acft touched down about 700 ft down the 2700 ft sod rwy. The rwy was wet from rain and braking action was nil. The plt elected to stay on the rwy and continue braking efforts. The acft slid off the rwy end into a drainage ditch. The…NTSB MKC86LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Mountain Home, ARThe PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of…NTSB CHI86FA035Accident · 2 fatalField investigationFinal reportBeech BE 36 · Odell, ILThe plt departed on an IFR flight into known icing conditions after receiving three complete weather briefings clearly indicating the icing conditions with numerous plt reports of icing. Aprx 40 minutes after departure the plt reported he had about an inch of…NTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…NTSB FTW85LA336Accident · No injuriesLimited investigationFinal reportBeech A36 · Conroe, TXAcft was substantially damaged during an off-arpt emergency landing following an eng failure. During landing roll acft collided with a fence and the gear collapsed. Investigation revealed about 13 gallons of fuel in right fuel tank and none in the left tank.…NTSB FTW85LA199Accident · No injuriesLimited investigationFinal reportBeech A-36 · Afton, OKThe acft was ditched in 60 to 80 ft deep water following a loss of pwr shortly after takeoff. The plt was picked up by a bass boat shortly before the acft sank. The acft was recovered more than a month later and an examination of the eng was not performed.NTSB FTW85IA149Incident · No injuriesIncident investigationFinal reportBeech A36 · Dfw Airport, TXDrg arr, a Beech A36, N2057A, was vectored for an ILS rwy 17L apch while a hvy Boeing 747 was being vectored for an ILS rwy 18R apch. The ATC arrival controller (ctlr) stated he had 'staggered' the A36 bhnd the 747 with at least 3 mi sepn. After the A36 was…NTSB ATL85LA093Accident · Minor injuriesLimited investigationFinal reportBeech A36 · New Albany, MSPIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The…NTSB FTW84LA380Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXFailure to complete both the takeoff and landing check-lists resulted in taking off with the elevator trim improperly set and the gear-up landing. According to the plt, as the acft was cleaned-up after takeoff from rwy 17R the nose became very heavy. The…NTSB LAX84LA461Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Livermore, CAThe plt visually checked the fuel tanks during his pre-flt & estimated 10-20 gals of fuel remaining in both the left & right tanks. He said that the start, taxi & run-up were performed while using the right rank. He reported that the right fuel gage reading…
Back to Beech A36