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 ('1151538')
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 ('1151538')
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 FTW97FA199Accident · 3 fatalField investigationFinal reportBeech V35 · Shawnee, OKThe pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.NTSB FTW97FA174Accident · 2 fatalField investigationFinal reportBeech V35 · Lake George, COThe pilot-in-command's failure to maintain control of the airplane. A factor was the terrain-induced turbulence.NTSB ATL97FA054Accident · 3 fatalField investigationFinal reportBeech V35 · Marco Island, FLinadvertent flight by the pilot into adverse weather conditions (severe thunderstorms), which led the design stress limits of the airplane being exceeded, subsequent in-flight break-up of the airplane, and an uncontrolled collision with water.NTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…NTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…NTSB FTW95LA353Accident · No injuriesLimited investigationFinal reportBeech 35N · Creede, COFailure by the pilot to follow the checklist and lower the landing gear.NTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.NTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.NTSB LAX94FA048Accident · 4 fatalField investigationFinal reportBeech V-35 · Shaver Lake, CAAn in-flight breakup of the airplane following the pilot's continued VFR flight into IMC conditions during which directional control of the airplane was not maintained, and the design limits of the airplane were exceeded. The pilot's inadequate evaluation of…NTSB FTW92FA024Accident · 1 fatalField investigationFinal reportBeech V35TC · Jasper, TXThe pilot's failure to continue a normal climb after takeoff due to spatial disorientation. A factor was the dark night condition.NTSB NYC92FA025Accident · 2 fatalField investigationFinal reportBeech V35B · Newfield, NJInflight collision with the ground for undetermined reasons.NTSB LAX91LA330Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Minden, NVThe pilot's failure to properly adjust the mixture setting prior to landing to ensure the continued operation of the engine.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB CHI90LA080Accident · No injuriesLimited investigationFinal reportBeech V35 · West Chicago, ILFailure of the pilot to extend the gear, which resulted in an inadvertent wheels-up landing.NTSB CHI90LA042Accident · No injuriesLimited investigationFinal reportBeech V35 · Cable, WIThe pilot's failure to adequately compensate for crosswind conditions. Contributing to the accident was the gusty, crosswind conditions which existed.NTSB FTW90LA035Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Crosbyton, TXImproper overhaul of the aircraft engine by maintenance personnel that led to the complete loss of engine oil due to an undertorqued oil cooler assembly. Factors in the accident were the failure of maintenance personnel to detect the condition during the…NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.NTSB LAX89FA294Accident · 1 fatalField investigationFinal reportBeech V35TC · Fort Jones, CAThe failure of the pilot to maintain sufficient altitude.NTSB BFO89FA060Accident · 1 fatalField investigationFinal reportBeech V35TC · Charlottesville, VAImproper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.NTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.NTSB FTW88LA138Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Sayre, OKThe pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…NTSB MIA88LA100Accident · No injuriesLimited investigationFinal reportBeech V-35 · Fernandina Bch, FLWhile on a personal flt, the acft landed gear up. The plt stated that he lowered it. He also stated that the gear warning horn was inoperative. Operational check of the landing gear revealed no discrepancies except for an improperly adjusted warning horn &…NTSB LAX87LA246Accident · No injuriesLimited investigationFinal reportBeech V35 · Clearlake, CADuring a cross country flight the engine experienced a loss of power. The plt made a forced landing on a road where during the landing roll the acft collided with a fence and eventually came to rest in a ditch. Inspection of the engine revealed extensive…NTSB CHI87FA133Accident · 1 fatalField investigationFinal reportBeech V35-TC · Mount Vernon, ILThe acft was on a test flt after a top-overhaul had just been completed. Mechanics rprtd that before the flt, the eng had been properly rigged & operated normally drg run-up. Drg initial climb after takeoff, witnesses said the eng lost power. The plt…NTSB DEN86LA257Accident · No injuriesLimited investigationFinal reportBeech V35 · Albuquerque, NMThe plt landed hard at the abq municipal arpt. The plt said he had runaway trim causing loss of control. The pax felt the plt lost control due to temporary physical incapacitation. Exam of the flt control system revealed no evidence of a flt control system…NTSB LAX86FA127Accident · 1 fatalField investigationFinal reportBeech V35-B · Irvine, CAThe pilot had executed the ILS rwy 19R approach and then requested a missed approach, stating that he 'had a localizer problem'. On the second attempt he was cleared to land and then was twice issued a low altitude alert. The pilot was further issued…NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…NTSB FTW83FA387Accident · 4 fatalField investigationFinal reportBeech V35 · Conchas, NMIt was reported that the plt had been giving rides to various family members & the acft was observed flying in the area of Conchas lake on several occasions. It was also reported that the acft had 'buzzed' boats on the lake several times during the day. The…NTSB MIA83FA123Accident · Serious injuriesField investigationFinal reportBeech V35TC · Destin, FLThe acft collided with a powerline, crashed & burned after the engine lost power on the final approach. The acft was using fuel from a tank that was less than half full. The acft had made a go-around and during the pattern was observed to be oscillating from…NTSB MIA83LA041Accident · No injuriesLimited investigationFinal reportBeech 35 · Titusville, FLThe pilot reported that before landing, he extended the landing gear and observed a safe down and locked indication. He stated that as he applied brakes at about 45 KTS, the gear warning horn sounded and the gear collapsed. Also, he positively stated that the…NTSB ATL82DA191Accident · No injuriesFinal reportBeech V35 · Huntington, WVBefore departing st louis, MO, attempts to restart the engine were unsuccessful until an auxiliary power unit was used. The aircraft took off at 1746, and about one hour later, the pilot noticed that the ammeter indicated a discharge. The flight was…NTSB DEN82DA093Accident · No injuriesFinal reportBeech V35A · Colorado Spring, COThe pilot stated, the engine run-up was normal and the mixture was leaned at 1700 RPM to obtain initial EGT movement off the bottom of the guage. He reported taking off uphill on runway 03. He noted that the acceleration was slow, but attributed it to the…NTSB MKC82FCG09Accident · No injuriesClosedBeech V35 · East Lynne, MONTSB MIA81FLA15Accident · No injuriesClosedBeech V-35 · Daytona Beach, FLNTSB ATL81FKJ10Accident · No injuriesClosedBeech V35TC · Eufaula, ALNTSB LAX80FUA18Accident · Minor injuriesClosedBeech V35TC · Newport Beach, CANTSB MIA80DLA20Accident · No injuriesClosedBeech V35 · St.Simon Is, GANTSB MIA80FA037Accident · 3 fatalClosedBeech V35 · Valdosta, GANTSB CHI80FEC09Accident · No injuriesClosedBeech V35 · Detroit, MINTSB MKC79FTG13Accident · No injuriesClosedBeech V35 · Bismarck, NDNTSB CHI79FEP48Accident · Minor injuriesClosedBeech V35 · Beloit, WINTSB MKC79DCQ04Accident · No injuriesClosedBeech V35 · Liberal, KSNTSB FTW78FA080Accident · 1 fatalClosedBeech V35 · Alexandria, LANTSB CHI78FEI34Accident · Serious injuriesClosedBeech V35 · Aurora, OHNTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSNTSB DEN78FTC24Accident · No injuriesClosedBeech V35 · Jackson Hole, WYNTSB CHI78FEM19Accident · Minor injuriesClosedBeech V35 · East Jordan, MINTSB OAK78FVA46Accident · No injuriesClosedBeech V35 · Fresno, CANTSB MKC77FA018Accident · No injuriesClosedBeech V-35 · Lutesville, MO
Back to Beech V35