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 ('1153406')
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 ('1153406')
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 ERA25LA083Accident · No injuriesClass 4 · LimitedFinal reportBeech B95A · Murray, KYThe pilot’s failure to lower the landing gear before touchdown, which resulted in a gear-up landing. Contributing was the designated pilot examiner’s inadequate monitoring and lack of remedial action.NTSB CHI04FA290Accident · 3 fatalField investigationFinal reportBeech B95A · Burlington, WIThe improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…NTSB NYC02LA017Accident · Minor injuriesLimited investigationFinal reportBeech B95A · Pittstown, NJThe pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.NTSB FTW00LA047Accident · Serious injuriesLimited investigationFinal reportBeech BE-95A · Big Lake, TXthe pilot-in-command's failure to maintain directional control of the airplane during the aborted landing. Contributing factors were the crosswind, turbulence, and the pilot's lack of total experience in the make and model of aircraft.NTSB MIA00WA045Accident · 1 fatalForeign investigationBeech B95A · Maizal, Dominican RepublicNTSB MIA99FA140Accident · 1 fatalField investigationFinal reportBeech B95A · Fountain, FLThe pilot's inadequate preflight inspection of the airplane that resulted in a loss of engine power because of fuel vent blockage and his selection of unsuitable terrain for the forced landing.NTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…NTSB LAX98FA113Accident · 4 fatalField investigationFinal reportBeech B95A · Little River, CAthe pilot's inadvertent visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation.NTSB MIA95WA110Accident · No injuriesForeign investigationBeech B95A · Freeport, BahamasNTSB CHI94FA340Accident · 1 fatalField investigationFinal reportBeech E95A · Poplar Grove, ILAircraft control not maintained by the pilot when he began his turn from base leg to final approach. Factors associated with this accident were the fatigue failure of a propeller blade, improper maintenance overhaul of the propeller, and a material defect in…NTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.NTSB MIA86LA125Accident · Minor injuriesLimited investigationFinal reportBeech B95A · St. Augustine, FLThe pilot in command did not assure that the fuel selector for the left engine was selected and in the detent prior to takeoff. On the initial climb the fuel selector moved slightly and the left engine failed due to fuel starvation. The pilot then did not…NTSB NYC85FA155Accident · 1 fatalField investigationFinal reportBeech B95A · Readington, NJPapers were observed to fly out of the acft during takeoff. The acft was observed to 'waver' with the gear down & crash to the ground several minutes later. An exam of the cabin door revealed that it had popped open in flt.NTSB DEN80FTC03Accident · Minor injuriesClosedBeech B95A · Rock Springs, WYNTSB MIA79DKT77Accident · No injuriesClosedBeech B95A · Opa Locka, FLNTSB NYC78FA034Accident · 5 fatalClosedBeech B95A · Onchiota, NYNTSB IAD77DKM33Accident · Minor injuriesClosedCessna 120 · Bryson City, NCNTSB IAD77FIA08Accident · No injuriesClosedBeech B95A · Weyers Cave, VANTSB FTW77DJP05Accident · Minor injuriesClosedBeech B95A · Ardmore, OKNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLNTSB MIA76AM104Accident · 2 fatalClosedBeech B95A · Defuniak Sprgs, FLNTSB NYC75AN100Accident · No injuriesClosedTradewind 18 · Islip, NYNTSB CHI75IC016Incident · No injuriesClosedBeech B95A · West Chicago, ILNTSB MKC73FCJ20Accident · No injuriesClosedBeech B95A · Lincoln, NENTSB FTW71DPM24Accident · Serious injuriesClosedBeech B-95A · Mexico City, MexicoNTSB CHI71AC036Accident · 4 fatalClosedBeech B95A · Bergholz, OHNTSB OAK70DVM14Accident · No injuriesClosedBeech B95A · Morro Bay, CANTSB MKC70I0141Incident · No injuriesClosedBeech B95A · Oskaloosa, IANTSB SEA69D0138Accident · No injuriesClosedBeech B95A · Hailey, IDNTSB NYC69D0121Accident · No injuriesClosedBeech B95A · Stratford, CTNTSB MIA68A0065Accident · 2 fatalClosedBeech B95 · Marion, ALNTSB DEN66A0036Accident · 5 fatalClosedBeech B95A · Beaver, UTNTSB DEN66D0147Accident · No injuriesClosedBeechcraft 95-55 · Logan, UTNTSB MKC66A0017Accident · 4 fatalClosedBeechcraft B-95 · Newton, KSNTSB UNK64X3487Accident · No injuriesClosedBeechcraft B95A · Gozad, NE
Back to Beech B95A