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 ('1152730')
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 ('1152730')
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 CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.NTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB WPR19FA086Accident · 3 fatalClass 3 · FieldFinal reportBeech D55 · Stallion Springs, CAThe pilot’s continued visual flight into instrument meteorological conditions associated with mountain obscuration conditions, which resulted in controlled flight into rising terrain. Contributing to the accident was the pilot’s failure to obtain a weather…NTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.NTSB CEN17LA104Accident · No injuriesLimited investigationFinal reportBeech D55 · Columbus, OHThe partial loss of left engine power during takeoff and initial climb, which led to a hard landing in gusting crosswind conditions. The reason for the loss of engine power could not be determined because postaccident examination of the left engine revealed…NTSB ERA14CA463Accident · No injuriesData collectionFinal reportBeech D55 · Hazleton, PAThe brake application for unknown reasons resulting in rupture of the left main landing gear tire and tube, and subsequent loss of directional control.NTSB ERA13FA348Accident · 3 fatalField investigationFinal reportBeech D55 · Conway, SCThe pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper…NTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoNTSB NYC08LA008Accident · 1 fatalLimited investigationFinal reportBeech D55 · St.CroixThe non-instrument rated pilot's decision to continue VFR flight into IMC conditions subsequently leading to a loss of control. Contributing to the accident was the pilot's lack of instrument experience, the weather conditions, and the night lighting…NTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…NTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.NTSB LAX00LA026Accident · No injuriesLimited investigationFinal reportBeech D55 · Corona, CAThe pilot's failure to maintain directional control of the aircraft during takeoff.NTSB FTW96FA373Accident · 1 fatalField investigationFinal reportBeech D55 · Corsicana, TXThe pilot's failure to maintain minimum control airspeed which resulted in the loss of control. Factors were the bent collar of the left main fuel tank refueling neck which resulted in fuel siphoning from the tank in flight, the pilot's failure to follow…NTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…NTSB FTW95LA200Accident · No injuriesLimited investigationFinal reportBeech D55 · Norman, OKThe pilot's inadvertent retraction of the landing gear, resulting in a gear up landing.NTSB MIA95FA107Accident · 2 fatalField investigationFinal reportBeech 55-E55 · Daytona Beach, FLThe failure of the pilot-in-command to manage the fuel available in flight by improperly selecting the fuel selectors to fuel available in other tanks, resulting in both engines losing power. Contributing to the accident was the lack of suitable terrain for…NTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.NTSB FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.NTSB ATL91FA026Accident · Serious injuriesField investigationFinal reportBeech D-55 · Greer, SCFuel starvation. A contributing factor was the pilot's failure to follow normal fuel system operational procedures which resulted in the total loss of engine power.NTSB MKC89FA116Accident · 2 fatalField investigationFinal reportBeech D55 · Greenwood, INInadequate preflight and improper use of the fuel system, which resulted in fuel starvation, and improper use of emergency procedures. Factors related to the accident were: self induced pressure by the pilot to meet an arrival time, his failure to extend the…NTSB MKC88FA183Accident · 3 fatalField investigationFinal reportBeech D55 · N. Little Rock, ARThe pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…NTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…NTSB LAX87FA039Accident · 2 fatalField investigationFinal reportBeech D55 · Livermore, CAWitnesses stated that the aircraft started the takeoff roll, became airborne at about 1000 feet down the runway, climbed to an altitude of about 50 feet, rolled to the left and crashed inverted onto a parallel taxiway at about mid field. There was no fire.…NTSB MIA84LA223Accident · Minor injuriesLimited investigationFinal reportBeech D-55 · Atlantic Ocean (Atlantic Ocean)The plt stated that he set the throttles for 45 percent power after climbing to 1500 ft MSL. After about 4 hrs of flight the left eng failed followed by a right engine failure moments later. The acft was ditched and never recoveredbecause it sank into the…NTSB LAX84LA159Accident · No injuriesLimited investigationFinal reportBeech D55 · Monterey, CAAccording to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it…NTSB MKC83FA108Accident · Serious injuriesField investigationFinal reportBeech D55 · Gardner, KSThe plt was cleared for an ILS rwy 35 approach & given the Kansas city downtown arpt (23 mi NE) wx as 900 ft broken & 6 mi visibility. The tower was closed & the control zone was not in effect raising minimums. The plt stated his ILS glide slope indication…NTSB MKC83LA058Accident · No injuriesLimited investigationFinal reportBeech D55 · Cape Girardeau, MOThe aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…NTSB ATL83MA084Accident · 7 fatalClass 1 · MajorFinal reportBeech D55 · Cherry Point, NCThe two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area…NTSB LAX82DA124Accident · No injuriesFinal reportBeech D55 · Napa, CAThe pilot stated that he rotated the aircraft at about 90 knots during takeoff and at about 30 feet AGL the engine lost power. It started again briefly but then stopped and an emergency landing was made approximately 2000 feet from the approach end of runway…NTSB NYC82FHD25Accident · No injuriesClosedBeech 55 · West Chester, PANTSB NYC80FA092Accident · Serious injuriesClosedBeech D-55 · Keene, NHNTSB NYC80DA083Accident · No injuriesClosedBeech D55 · Buffalo, NYNTSB MKC80FCD18Accident · No injuriesClosedBeech 95-D55 · Mason City, IANTSB FTW79FPA31Accident · No injuriesClosedBeech D55 · Dallas, TXNTSB CHI79DEC38Accident · No injuriesClosedBeech D-55 · Troy, MINTSB OAK79DVA22Accident · No injuriesClosedBeech D55 · Visalia, CANTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCNTSB MIA78FKJ18Accident · No injuriesClosedBeech D-55 · Mobile, ALNTSB FTW78FA022Accident · 2 fatalClosedBeech D55 · El Campo, TXNTSB NYC77FA080Accident · Minor injuriesClosedBeech D55 · Flushing, NYNTSB FTW77FRJ12Accident · No injuriesClosedBeech D55 · Natchitoches, LANTSB MIA77FLG04Accident · No injuriesClosedBeech D55 · Charleston, SCNTSB LAX77DVA08Accident · No injuriesClosedBeech D55 · Bakersfield, CANTSB FTW77FPG03Accident · No injuriesClosedBeech D55 · Hot Springs, ARNTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MINTSB SEA76FYC64Accident · No injuriesClosedBeech D55 · Hillsboro, ORNTSB IAD76AI030Accident · 2 fatalClosedBeech D55 · Front Royal, VANTSB NYC76FNA19Accident · No injuriesClosedBeech D55 · Warwick, RINTSB ANC75AA080Accident · 3 fatalClosedBeech D55 · Cordova, AKNTSB SEA75FYC29Accident · No injuriesClosedBeech D55 · Hermiston, OR
Back to Beech D55