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 ('1152744')
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 ('1152744')
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 MIA91FA069Accident · 4 fatalField investigationFinal reportBeech 58P · Lantana, FLThe pilot in commands failure to maintain airspeed while performing a go around resulting in the airplane stalling and colliding with the ground in an uncontrolled descent.NTSB BFO90FA002Accident · 1 fatalField investigationFinal reportBeech 58P · Nokesville, VAImproper installation of the elevator trim actuators, and subsequent jamming of the elevator trim in a nose down trim position.NTSB MKC89LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Cedar Rapids, IAThe failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.NTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…NTSB MIA88FA107Accident · 2 fatalField investigationFinal reportBeech 58P · Dunedin, FLFlt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…NTSB SEA88LA043Accident · 2 fatalLimited investigationFinal reportBeech 58P · Ketchikan, AKAcft collided with trees 1400 ft short of rwy during ILS approach. The acft was left of centerline and about 100 ft below glideslope at that time. Witnesses heard sounds of increased power and impact. When the approach clearance was given the wx was 1000 ft…NTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…NTSB NYC87LA004Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Derry, PAThe flight suffered an engine power loss while in cruise flight due to fuel starvation. The pilot stated that a pretakeoff check of fuel gauges was made and they all indicated fuel on board.NTSB DEN85LA199Accident · No injuriesLimited investigationFinal reportBeech 58P · Buena Vista, COThe left engine failed during takeoff at an altitude of about 40 ft AGL. During the forced landing, the plt used incorrect emergency procedures and failed to maintain lateral and directional control of the acft. Inspection of the acft revealed a disintegrated…NTSB FTW85LA227Accident · No injuriesLimited investigationFinal reportBeech 58P · Abilene, TXThe plt stated he made a normal landing and the gear folded during the rollout. Another plt who was waiting at the end of the rwy for takeoff observed the landing and stated the landing gear was extended too late and was still in transit (not fully down) when…NTSB CHI85LA089Accident · No injuriesLimited investigationFinal reportBeech 58P · Grand Rapids, MIAt 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…NTSB MIA85LA063Accident · No injuriesLimited investigationFinal reportBeech 58P · Deland, FLN41Q was taxiing to the ramp after landing. As N41Q taxied behind N3707N, who was starting the rt engine, propwash caused plt of N41Q to lose directional control of the acft. Prop of N41Q contacted the left elevator of N3707N.NTSB CHI85IA073Incident · No injuriesIncident investigationFinal reportBeech 58P · Akron, OHDuring arrival at medina, OH, the plt discovered that the NDB was inop, so he diverted to the Akron fulton arpt. He was vectored for a localizer apch to rwy 25. During the apch, he descended to the min descent alt (mda) of 512 ft AGL. When he had the arpt in…NTSB DEN84FA089Accident · 2 fatalField investigationFinal reportBeech 58P · Durango, COWhen the plt called the fss at 1341 MST, he stated he had already received some 'real time' wx & requested only the wx at Durango & farmington, NM. He filed an IFR flt plan to Durango & took off at 1437. Drg arrival, the plt attempted to get into VFR…NTSB NYC84FHD01Accident · Serious injuriesFinal reportBeech 58P · Cheswold, DEThe plt reported that the western 1/3 of rwy 9 consisted of rough chat rock & packed soil. The remaining rwy surface consisted of asphalt. The plt elected to make a no-flap takeoff, using all of the rwy. He stated that due to the rough rwy surface, up…NTSB NYC83LA240Accident · No injuriesLimited investigationFinal reportBeech 58P · Lebanon, NHAccording to the plt there was a sudden power fluctuation at(rotation speed). The plt then aborted the takeoff but couldnot stop the acft before departing the rwy.NTSB NYC83FA228Accident · Serious injuriesField investigationFinal reportBeech 58PA · Danbury, CTInbound to Danbury the plt was advised that the arpt was closed, & was given the last wx which was an hour old. The acft was observed to pass over the arpt 300-400 ft AGL & circle to land rwy 8. The acft turned base & final in a tight turn with the gear down.…NTSB MKC82DA115Accident · No injuriesFinal reportBeech 58P · Fullerton, NEThe pilot pulled up to avoid a collision with a truck on final approach. He landed midfield on a 2350 foot wet grass runway and ran off the end of the runway into rough terrain.NTSB ATL82DA084Accident · Minor injuriesFinal reportBeech 58 · Ridgeland, SCThe pilot stated that during landing, the left brake was inoperative. When he realized the problem, there was insufficient runway remaining to stop or go-around. At the end of the runway was a deep drop-off. Therefore the pilot used the right brake, and…NTSB MIA81DLA33Accident · No injuriesClosedBeech 58P · Jacksonville, FLNTSB LAX81FA085Accident · 4 fatalClosedBeech 58P · Redding, CANTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GANTSB CHI81FEE19Accident · Minor injuriesClosedBeech 58P · West Chicago, ILNTSB FTW79DRD22Accident · No injuriesClosedBeech 58P · Prairieville, LANTSB FTW79FA058Accident · 6 fatalClosedBeech BE-58P · Turpin, OKNTSB FTW79FQG16Accident · Serious injuriesClosedBeech 58P · Amarillo, TXNTSB CHI79FA027Accident · 1 fatalClosedBeech 58P · Waukesha, WINTSB IAD78IA085Incident · No injuriesClosedBeech B-58 · Washington, DCNTSB FTW78FPJ21Accident · No injuriesClosedBeech 58P · Prague, OKNTSB MIA78FA030Accident · 4 fatalClosedBeech B-58P · Tylertown, MSNTSB IAD77DKM27Accident · Minor injuriesClosedBeech 58P · Winston Salem, NCNTSB IAD77FKW18Accident · Serious injuriesClosedBeech 58P · Knoxville, TN
Back to Beech 58P