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 ('1153404')
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 ('1153404')
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 WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB WPR18LA023Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B95 · Las Vegas, NVThe flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing.NTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.NTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.NTSB LAX02LA033Accident · No injuriesLimited investigationFinal reportBeech B95 · Henderson, NVthe loss of engine power in the left engine for undetermined reasons. A contributing factor was the check pilot's failure to completely configure the airplane for a single engine go-around in a timely way.NTSB MIA00FA260Accident · 1 fatalField investigationFinal reportBeech B-95 · Odessa, FLthe pilot's failure to maintain Vmc, which resulted in a loss of control, and collision with the ground. Contributing to the accident was the pilot's decision to feather a propeller powered by an operational engine, while at a low altitude.NTSB FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB MIA95LA123Accident · Serious injuriesLimited investigationFinal reportBeech B95 · Leakesville, MSThe failure of the pilot-in-command to operate the aircraft in accordance with manufacturer's limitations resulting in fuel starvation and a total loss of power in both engines.NTSB FTW95FA087Accident · 3 fatalField investigationFinal reportBeech B95 · Hot Springs, ARThe pilot's failure to follow IFR and missed approach procedures.NTSB CHI94FA076Accident · 2 fatalField investigationFinal reportBeech 95 · Chesterfield, MOincorrect installation of the fuel selector valves during mandatory service bulletin modification which resulted in fuel starvation to both engines and failure of the pilot-in-command to maintain aircraft control during emergency descent. A factor was…NTSB LAX92FA156Accident · 3 fatalField investigationFinal reportBeech B95 · Devore, CAThe pilot's failure to maintain an adequate altitude while flying over mountainous terrain. Factors related to the accident were: the low clouds, dark night, and mountainous terrain.NTSB NYC92LA056Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Caldonia, NYThe pilot's improper use of carburetor heat which resulted in a loss of engine power. A factor relating to the accident was weather conducive to carburetor icing.NTSB CHI90LA227Accident · Minor injuriesLimited investigationFinal reportBeech BE 95 · Faribault, MNThe pilot's improper inflight decision and his improper execution of the chosen emergency procedure.NTSB LAX90FA082Accident · 3 fatalField investigationFinal reportBeech 95-55 · Chico, CAThe failure of the pilots of N790T and N721L to see and avoid each other. Factors which contributed to the accident were: the pilot of the C-182P, N790T, was disoriented and improperly entered the traffic pattern due to recent marijuana use; the pilot of the…NTSB CHI88LA225Accident · Minor injuriesLimited investigationFinal reportBeech B-95 · Alma, MIDuring approach to landing the pilot entered a steep (45 degree bank) left turn from base to final. The pilot stated that he did not realize it at the time, but this action unported the fuel line to the left engine, causing the engine to fail due to fuel…NTSB MIA88FA224Accident · 2 fatalField investigationFinal reportBeech 95 · Destin, FLPlt reported arpt in sight and was cleared for visual approach. Witnesses reported seeing acft on left downwind & said it flew into a thundershower. The flt was not heard from again. The acft's wreckage was found in the bay 1 1/4 miles north of the runway.…NTSB MKC88LA093Accident · No injuriesLimited investigationFinal reportBeech 95 · Shell Knob, MOThe pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing.NTSB FTW83FA303Accident · 2 fatalField investigationFinal reportBeech BH-125 · Houston, TXThe Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The…NTSB NYC82DA105Accident · No injuriesFinal reportBeech B95 · Farmingdale, NYAfter being newly painted at prospectville, PA, the plane was being flown to Farmingdale, NY where the pilot received a special VFR clearance. According to the pilot, the gear was lowered on the downwind leg for runway 19, but an abnormal noise was heard and…NTSB MKC82FA058Accident · 1 fatalField investigationFinal reportBeech B95 · Climax Springs, MOApproximately 8 min after takeoff the acft was observed at a very low altitude. It started a right turn that gradually steepened until the wings were almost vertical. After almost two turns the wings leveled for an instant, then the right wing & nose dropped…NTSB MIA81DLD67Accident · No injuriesClosedBeech B95 · Sanford, FLNTSB MIA81DLA38Accident · No injuriesClosedBeech 95B · Tallahassee, FLNTSB MIA77RA041Accident · 2 fatalClosedBeech B95 · Gun Cay, Burkina FasoNTSB IAD76AI050Accident · 2 fatalClosedBeech D95A · Gaithersburg, MDNTSB MIA75FKA07Accident · No injuriesClosedBeech B95 · Arecibo, PRNTSB MIA75FKG04Accident · No injuriesClosedBeech B95 · Carrollton, GANTSB NYC74AN115Accident · 1 fatalClosedBeech B95 · Tahawus, NYNTSB MKC74DCJ44Accident · No injuriesClosedBeech B95 · S Sioux City, NENTSB DEN74AD037Accident · 2 fatalClosedBeech B95 · Rangely, CONTSB IAD74DLQ22Accident · No injuriesClosedBeech 19 · Falmouth, KYNTSB UNK73X0124Accident · Minor injuriesClosedBeech B95 · San Inez, MexicoNTSB SEA73FYE39Accident · Serious injuriesClosedBeech B95 · Eatonville, WANTSB FTW73FRD14Accident · No injuriesClosedBeech B95 · New Orleans, LANTSB MIA73AM007Accident · 2 fatalClosedBeech B95 · Shelby Sprngs, ALNTSB NYC72AN093Accident · 3 fatalClosedBeech B95 · Mt Tabor, VTNTSB MKC72DCQ31Accident · No injuriesClosedBeech B95 · Salina, KSNTSB MIA72DKT24Accident · No injuriesClosedBeech B95 · Opa Locka, FLNTSB FTW71FPD56Accident · No injuriesClosedBeech B95 · Fort Worth, TXNTSB SEA71FDA13Accident · No injuriesClosedBeech B-95 · Forsyth, MTNTSB FTW70FPG30Accident · Serious injuriesClosedBeech B95 · Harrison, ARNTSB MIA69A0097Accident · 1 fatalClosedBeech B95 · Missing AircraftNTSB SEA68A0051Accident · 3 fatalClosedBeech B95 · Wilsonville, ORNTSB CHI68D0354Accident · No injuriesClosedBeech 95 · Joliet, ILNTSB CHI67F0561Accident · 2 fatalClosedBeech B95 · Bloomington, INNTSB FTW67A0072Accident · 2 fatalClosedBeech B95 · Checotah, OKNTSB CHI67D0421Accident · No injuriesClosedBeech B95 · Napoleon, OHNTSB DEN66A0065Accident · 2 fatalClosedBeech B95 · Salt Flat, TXNTSB NYC66A0081Accident · 3 fatalClosedBeech B95A · Erie, PANTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CO
Back to Beech B95