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 ('1152802')
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 ('1152802')
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 WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB LAX04LA159Accident · No injuriesLimited investigationFinal reportBeech 65 · Sedona, AZan explosion of the left outboard wing, resulting from a leaking fuel line and the ignition of the flammable fuel/air mixture in the outboard wing bays; the source of ignition energy for the explosion could not be determined. A factor in the accident was an…NTSB MIA97LA215Accident · No injuriesLimited investigationFinal reportBeech 65 · Atlantic Ocean (Atlantic Ocean)Failure of the aircraft to maintain altitude for undetermined reasons following loss of power in one engine.NTSB IAD96LA102Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Campbellsville, KYthe pilot's inadequate preflight preparation, his failure to remove the control lock, and his failure to abort the takeoff.NTSB NYC95MA220Accident · 12 fatalMajor investigationFinal reportBeech 65 · West Point, VAThe pilot's inadequate preflight/preparation, his failure to ensure proper weight and balance of the airplane, and his failure to obtain/maintain minimum control speed, which resulted in a loss of aircraft control after loss of power in one engine. A factor…NTSB MIA95LA206Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Caribbean SeaLoss of engine power for undetermined reasons. Contributing to the accident was the inability of the pilot to feather the propeller.NTSB MIA93FA031Accident · 5 fatalField investigationFinal reportBeech 65 · Orlando, FLThe pilot's failure to feather the propeller to maintain altitude following a loss of power of the left engine. The power loss was due to an improperly maintained fuel system. In addition, the right engine lost power for an undetermined reason(s).NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB LAX91FA282Accident · 6 fatalField investigationFinal reportBeech 65 · Pioneer, CAImproper emergency procedures by the pilot, when he inadvertently shut down the left engine after encountering a partial loss of power in the right engine. Factors related to the accident were: improper installation of the right engine's #6 exhaust valve seat…NTSB BFO91FA053Accident · Serious injuriesField investigationFinal reportBeech B65 · California, MDThe loss of power in one engine for undetermined reasons.NTSB BFO90LA001Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Friendly, MDThe pilot's improper use of his fuel supply, which resulted in fuel starvation and loss of power in the left engine. A factor related to the accident was the pilot's lack of familiarity with the aircraft.NTSB MIA89WA142Accident · No injuriesForeign investigationBeech 65 · Nassau, BahamasNTSB SEA89FA015Accident · 2 fatalField investigationFinal reportBeech 65 · Elko, NVApprox 10 min after t/o, the pilot stated he was returning to land due to a problem. On final the acft rolled inverted and descended nose down into a residence. Engine exam revealed a failed supercharger intermediate drive shaft gear resulting in loss of…NTSB FTW88LA015Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Covington, LADuring initial climb from takeoff, the left engine failed for unknown reasons. The plt stated that right rudder and aileron inputs were ineffective to stop the acft from rolling left and the acft contacted the ground as he was retarding pwr on the right eng.NTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.NTSB FTW86FA059Accident · 1 fatalField investigationFinal reportBeech 65 · Montague, TXThe pilot was observed in the area for several minutes while he was performing steep climbs and descents, low passes, and buzzing. Witnesses reported power was removed from both engines simultaneously, as if the throttles were retarded, followed by a loud…NTSB BFO86FID02Accident · No injuriesFinal reportBeech BE65 · Wakefield, VAThe acft landed short of the rwy after loss of power on both engines. Contact with a dirt bank sheared the landing gear and the acft slid onto & down the rwy for about 436 ft before stopping. The plt said the fuel gauges were 1/4 on mains and 1/8 on avg…NTSB MIA85FA057Accident · No injuriesField investigationFinal reportBeech 65 · Marathon, FLAccording to the plt, aprx 20 min after departure at 4,000 to 5,000 ft the left eng failed followed 10 min later by a power loss in the right eng. During the desc the right eng restarted momentarily but only ran for about 1 min. The plt ditched near a…NTSB FTW84LA249Accident · No injuriesLimited investigationFinal reportBeech 65 · Zapata, TXAccording to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…NTSB FTW84FA190Accident · 1 fatalField investigationFinal reportBeech 65 · Jennings, LAA popping or backfiring sound was heard by several people who later observed the acft flying at low altitude on what appeared to be a final approach to rwy 13 at Jennings arpt (located about 75 mi sw of the departure point.) No radios were onboard the acft so…NTSB MIA82DA182Accident · No injuriesFinal reportBeech 65 · Andros Is, BahamasWhile en route at 9000 ft MSL at night, the right engine reportedly lost power and was feathered. The pilot reported that the left engine had a partial loss of power and the aircraft would not maintain altitude. Communication was maintained with miami center…NTSB NYC82DA052Accident · No injuriesFinal reportPiper PA-38-112 · Allentown, PAThe student pilot was practicing takeoffs and landings on runway 25 in crosswind conditions. The wind was from 330 degrees at 14 knots. On one of the landings, the aircraft bounced during touchdown. The pilot reportedly added a small amount of power for a…NTSB FTW82FPA02Accident · No injuriesClosedBeech 65 · Rockwall, TXNTSB DEN81FA007Accident · 3 fatalClosedBeech 65 · Sula, MTNTSB FTW80DRG71Accident · No injuriesClosedBeech 65 · Mission, TXNTSB MIA80FA099Accident · 6 fatalClosedBeech 65 · Clearwater, FLNTSB ATL80FA064Accident · Serious injuriesClosedBeech B65 · Kenessaw, GANTSB MIA80FA077Accident · 4 fatalClosedBeech 65 · Ft.Pierce, FLNTSB IAD80FA017Accident · 7 fatalClosedBeech A65 · Lexington, KYNTSB MIA79FAQ96Accident · 1 fatalClosedBeech 65 · Preston, GANTSB MIA79FA090Accident · 1 fatalClosedBeech 65 · Boca Raton, FLNTSB FTW79DPG32Accident · No injuriesClosedBeech 65 · Waldron, ARNTSB MIA79FA058Accident · 2 fatalClosedBeech 65 · Arcadia, FLNTSB MIA79DKT44Accident · No injuriesClosedBeech 65 · Belle Glade, FLNTSB MIA79FKT33Accident · No injuriesClosedBeech 65 · South Bay, FLNTSB CHI79FEE20Accident · No injuriesClosedBeech 65 · Wheeling, ILNTSB MIA78DA117Accident · 2 fatalClosedBeech 65 · Missing AircraftNTSB UNK78X0116Accident · Serious injuriesClosedBeech 65 · Zamora, MexicoNTSB IAD78FA047Accident · No injuriesClosedBeech B65 · Norfolk, VANTSB NYC77FHJ34Accident · No injuriesClosedBeech 65 · Islip, NYNTSB FTW77FQG13Accident · No injuriesClosedBeech 65 · Amarillo, TXNTSB FTW75DRG60Accident · No injuriesClosedBeech 65 · Brownsville, TXNTSB MIA75FKG15Accident · No injuriesClosedBeech 65 · Atlanta, GANTSB MKC75FER08Accident · No injuriesClosedBeech 65 · Minneapolis, MNNTSB CHI74FEV47Accident · No injuriesClosedBeech 65 · Springfield, ILNTSB IAD74AI045Accident · 4 fatalClosedBeech 65 · Williamstown, WVNTSB MIA74AM056Accident · 5 fatalClosedBeech 65 · Jacksonville, FLNTSB MIA73FKT96Accident · No injuriesClosedBeech 65 · Palm Beach, FLNTSB DEN73FQA30Accident · No injuriesClosedBeech 65 · Santa Fe, NM
Back to Beech 65