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 ('1151524')
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 ('1151524')
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 ATL88LA205Accident · No injuriesLimited investigationFinal reportBeech K35 · Greensboro, NCThe flight was climbing to 11,000 feet with an instrument flight clearance when a propeller blade separated from the hub. The blade was subsequently recovered from the yard of a local resident. The fracture examination disclosed that the cracking originated…NTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CANTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNNTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…NTSB MIA88FA049Accident · 1 fatalField investigationFinal reportBeech K-35 · Crescent City, FLThe pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel…NTSB CHI87FA198Accident · 2 fatalField investigationFinal reportBeech B35 · Martinsville, INShortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only).NTSB ATL87FA082Accident · 1 fatalField investigationFinal reportBeech K35 · Arden, NCPlt departed charleston, SC for raleigh earlier in the day. While at raleigh he discussed pending legislation with assoc. He departed raleigh about 2228 EST in wx of indef 100 and 1/2 mile visibility. His destination was forecast to have occasional ceilings…NTSB LAX87FA016Accident · No injuriesField investigationFinal reportBeech K35 · Bakersfield, CAThe flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated the…NTSB DEN86LA173Accident · No injuriesLimited investigationFinal reportBeech K35 · Kim, COThe plt reports that he was cruising at 9,500 ft MSL when he encountered low broken clouds. He decided to descend below the clouds to assure remaining VFR. The plt said he retarded the throttle and descended to 7,000 ft MSL (1,000 ft AGL). When the throttle…NTSB FTW86FRG02Accident · Serious injuriesFinal reportBeech K35 · Austin, TXThe acft stalled & crashed during a go-around attempt. The plt/owner was flying the acft from the left seat with the mechainc, who had just completed an annual inspection on the acft, seated in the co-plts seat. The mechanic received serious injuries when the…NTSB CHI86LA010Accident · Serious injuriesLimited investigationFinal reportBeech K35 · New Lisbon, WIAccording to the plt, acft preflight, engine runup and warm up were normal. Takeoff and initial climb up to approx 300 ft AGL were normal also. At this point the engine quit and the plt performed a forced landing in a clover field below him. The acft was…NTSB FTW86LA005Accident · No injuriesLimited investigationFinal reportBeech K35 · El Paso, TXThe plt stated his straight-in landing final apch was smooth. The airspeed had decreased from 80 to 65 KTS & the acft's wheels were only inches above the rwy when the right wing suddenly lifted and caused the acft to veer left and touch down on the dirt…NTSB LAX84LA162Accident · No injuriesLimited investigationFinal reportBeech K35 · Flagstaff, AZCruising at 10,500 ft the number 5 cylinder separated from the engine ass'y causing the loss of power. During the forced ldg roll the acft collided with a snow covered log collapsing the nose gear. The engine was overhauled in 1980. 1,239 hrs of operation had…NTSB NYC84FA032Accident · 2 fatalField investigationFinal reportBeech K35 · Stockholm, NJAt 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…NTSB NYC83FA141Accident · 4 fatalField investigationFinal reportBeech K35 · Ridgefield, CTShortly after takeoff, several witnesses heard unusual sounds from the acft. One stated that he heard a sputtering noise & the eng stopped, then it restarted, but was not smooth. The other 2 witnesses heard a backfiring or sputtering noise. Subsequently, the…NTSB ATL83LA177Accident · No injuriesLimited investigationFinal reportBeech K35 · Fitzgerald, GAThe acft made a forced landing in an open field off the airport after the engine quit at about 300 ft AGL during a go- around. The pilot who was being checked out in this acft by an instructor was trained in a C-172 which has differences in the fuel system.…NTSB FTW83LA160Accident · No injuriesLimited investigationFinal reportBeech K35 · Torreon, NMThe pilot, who was not certificated, stated that prior to departure he received a wx briefing by telephone from the fss. Enroute, after making several heading changes to avoid wx he found himself surrounded by low ceiling and precipitation. He decided to make…NTSB ATL83FA129Accident · 2 fatalField investigationFinal reportBeech K35 · Birmingham, ALThe acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…NTSB LAX83FUJ07Accident · 1 fatalFinal reportBeech K35 · Tucson, AZThe acft crashed into rising terrain left wing tip first. The pilot had made a radio call saying he was landing due to smoke in the cockpit at 1517 MST. At 1523 MST the acft crashed off arpt on an upslope with a 30 degree incline. Examination of the wreckage…NTSB FTW82DA383Accident · No injuriesFinal reportBeechcraft K35 · Houston, TXPilot stated that he lifted the nose off the runway too soon and the aircraft became airborne but would not climb or accelerate. The aircraft drifted to the left and collided with a canal dirt bank.NTSB FTW81FA137Accident · 2 fatalClosedBeech K35 · Albuquerque, NMNTSB LAX81FUG46Accident · No injuriesClosedBeech K35 · Temecula, CANTSB LAX81DVA41Accident · No injuriesClosedBeech K35 · Groveland, CANTSB ATL81FKJ12Accident · No injuriesClosedBeech K35 · Wetumpka, ALNTSB FTW81DQD08Accident · No injuriesClosedBeech K35 · Alpine, TXNTSB LAX81FA014Accident · 1 fatalClosedBeech K35 · Big Bear Lake, CANTSB DEN80FTE62Accident · Serious injuriesClosedBeech K35 · Pagosa Springs, CONTSB IAD80IA015Incident · No injuriesClosedBeech K35 · Washington, DCNTSB LAX79DVA60Accident · No injuriesClosedBeech K35 · Oakdale, CANTSB LAX79DUG49Accident · No injuriesClosedBeech K-35 · Barstow, CANTSB ANC79DAG64Accident · No injuriesClosedBeech K35 · Talkeetna, AKNTSB IAD78FLJ21Accident · Serious injuriesClosedBeech K35 · Morrisville, NCNTSB CHI78DEI22Accident · No injuriesClosedBeech K35 · Pittsfield, OHNTSB SEA78FA032Accident · 1 fatalClosedBeech K35 · Wenatchee, WANTSB NYC77FHJ17Accident · No injuriesClosedBeech K35 · Mattituck, NYNTSB LAX77FA028Accident · 4 fatalClosedBeech K35 · Big Bear City, CANTSB CHI77FEP19Accident · Minor injuriesClosedBeech K35 · Clintonville, WINTSB CHI77FA023Accident · 1 fatalClosedBeech K35 · Delaware Twp, INNTSB CHI77DEA02Accident · No injuriesClosedBeech 35 · Indianapolis, INNTSB OAK76AP028Accident · 2 fatalClosedBeech K35 · S.Lake Tahoe, CANTSB MIA75FKJ36Accident · Serious injuriesClosedBeech K35 · Jasper, ALNTSB MIA75FKG51Accident · No injuriesClosedBeech K35 · Dalton, GANTSB CHI75DEM21Accident · Minor injuriesClosedBeech K35 · Gaylord, MINTSB MIA75AM015Accident · 2 fatalClosedBeech K35 · Missing AircraftNTSB MIA74AM087Accident · 1 fatalClosedBeech K35 · Jasper, GANTSB MKC74AK027Accident · Serious injuriesClosedBeech 35 · Charles City, IANTSB CHI73FEM51Accident · No injuriesClosedBeech K35 · Grand Ledge, MINTSB NYC73FNC56Accident · Serious injuriesClosedBeech K35 · West Dover, VTNTSB DEN73AD075Accident · 1 fatalClosedBeech K35 · Salt Lake City, UTNTSB MKC73DCA16Accident · No injuriesClosedBeechcraft K35 · Cardenas, Mexico
Back to Beech K35