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 ('1151240')
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 ('1151240')
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 CEN24LA105Accident · No injuriesClass 4 · LimitedFinal reportBeech B23 · Blytheville, ARThe pilot’s improper descent path which resulted in a bounced landing and loss of control.NTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.NTSB CEN19TA205Accident · Serious injuriesClass 3Final reportBeech 23 · Vaiden, MSThe pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA17LA215Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Ocean Isle Beach, NCThe pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.NTSB GAA16CA494Accident · No injuriesData collectionFinal reportBeech B23 · Raleigh, NCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR15LA132Accident · No injuriesLimited investigationFinal reportBeech B23 · Flagstaff, AZThe pilot's failure to maintain directional control during landing.NTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…NTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.NTSB MIA06CA040Accident · No injuriesData collectionFinal reportBeech BE23 · Palatka, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB NYC06LA045Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Chaplin, CTA complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB LAX05LA247Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Fallbrook, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB IAD03LA037Accident · No injuriesLimited investigationFinal reportBeech 23 · Cincinnati, OHThe second pilot's inadequate flare and the pilot/owner's lack of remedial action, which resulted in a hard landing. A factor was the wind gusts.NTSB FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB CHI97LA224Accident · Serious injuriesLimited investigationFinal reportBeech B-23 · Watertown, WIa loss of engine power due to undetermined reason(s).NTSB MIA97LA008Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the improper planning/decision of the pilot of the Cessna 210 to depart the traffic pattern on the downwind leg rather than on the upwind leg as…NTSB LAX96LA302Accident · No injuriesLimited investigationFinal reportBeech B23 · Modesto, CAfuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.NTSB FTW96LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · Strasburg, COThe pilot's delayed application of carburetor heat. A factor was the unsuitable terrain.NTSB CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.NTSB LAX95LA203Accident · No injuriesLimited investigationFinal reportBeech B23 · Mariposa, CAthe pilot's premature liftoff and his failure to attain and maintain sufficient airspeed during the intial climb which resulted in an inadvertent stall/mush back onto the runway. The pilot's failure to maintain directional control as the aircraft touched down…NTSB CHI94LA164Accident · No injuriesLimited investigationFinal reportBeech B23 · Faribault, MNa hard landing as a result of the flight instructor's delayed remedial action. A factor associated with the accident is the student pilot's improper flair.NTSB MIA93LA084Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Village Of Golf, FLThe pilot-in-command's improper movement of the fuel selector valve resulting in fuel starvation, forced landing, and an in-flight collision with terrain.NTSB NYC92LA023Accident · No injuriesLimited investigationFinal reportBeech B23 · Bombay, NYFailure of the pilot to use all the available take off area.NTSB SEA91LA113Accident · No injuriesLimited investigationFinal reportBeech B23 · Spanish Fork, UTThe pilot did not adequately recover from a bounced landing. Factors to the accident were: a poorly planned approach, and the pilot's lack of total flight experience.NTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.NTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.NTSB LAX89FA001Accident · 1 fatalField investigationFinal reportBeech B23 · Scottsdale, AZThe pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.NTSB BFO88LA087Accident · No injuriesLimited investigationFinal reportBeech B23 · Roanoke, VAThe plt said the acft bounced twice during the landing. The apch speed was 75 to 80 KTS. The left main gear collapsed on the second bounce. The nose gear collapsed on the final touchdown. The acft slid off the left side of he rwy. The plt reported no…NTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.NTSB NYC88LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Mansfield, MAAccording to the plt, the winds were from the south-southwest at 15 to 20 KTS. He rprtd that drg the landing roll on rwy 22, he applied full right rudder against the prevailing wind, but the acft veered left with the application of brakes. Subsequently, it…NTSB MKC87LA166Accident · No injuriesLimited investigationFinal reportBeech B23 · Creston, IAThe PIC had planned his flt with departure originating in Iowa city, Iowa. Scattered thunderstorms were fcst and the PIC delayed his departure for abt 3 hrs. Aft assessing wx fm several sources the PIC dptd for Creston, Iowa around 9 pm LCL time. The flt…NTSB CHI87LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Danville, ILThe plt landed long and downwind on a sod farm strip. The acft ran off the departure end of the fld and struck trees.NTSB SEA87LA050Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Alderwood Manor, WAThe pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to…NTSB CHI87LA007Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lake Village, INThe plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…NTSB SEA85LA085Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Las Vegas, NVA forced landing was made due to fuel exhaustion. A landing was made short of the runway onto rough terrain during which time the gear collapsed. The plt's route of flight wasvery close to airport's having fuel available, but the plt elected to continue to…NTSB CHI84LA192Accident · No injuriesLimited investigationFinal reportBeech 23 · Put-In-Bay, OHDuring the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but…NTSB MKC84LA134Accident · No injuriesLimited investigationFinal reportBeech BE23 · Richmond, KSWhile in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident…NTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…NTSB NYC84LA031Accident · No injuriesLimited investigationFinal reportBeech B23 · West Dover, VTThe plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still…NTSB ATL83FA013Accident · 1 fatalField investigationFinal reportBeech B-23 · Lexington, SCThe aircraft crashed in a corn field shortly after takeoff. The aircraft was owned by the pilot who was fatally injured in the accident. The weather was VMC and no system malfunction could be found. The aircraft was seen flying at low altitude prior to the…NTSB NYC82DA223Accident · No injuriesFinal reportBeech B23 · West Yarmouth, MAAbout 30 min after takeoff, the engine lost power at about 1000 ft AGL when the pilot added power to climb. He was unable to restart the engine and elected to land along the shoreline. During the approach, the aircraft collided with power lines. Reportedly,…NTSB NYC82DA142Accident · Minor injuriesFinal reportBeech B23 · North Castle, NYAircraft was ditched and sank in a reservoir in 20 feet of water after the engine failed in flight. The crankshaft was found to be fractured when aircraft was raised. Oil had sprayed on the windshield. Avco-lycoming part number that failed was 74968 serial…NTSB FTW82FA152Accident · 2 fatalField investigationFinal reportBeech B23 · Roanoke, TXWitnesses reported that the aircraft appeared to takeoff and climb normally until it reached an altitude of about 100 ft AGL. It then pitched up abruptly to about a 70 deg nose high attitude. After the pitch-up, the aircraft climbed to about 175 to 200 ft…NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…NTSB FTW81FQA38Accident · No injuriesClosedBeech B23 · Taos, NMNTSB ATL81FA052Accident · 4 fatalClosedBeech B23 · Mobile, ALNTSB NYC80FNE22Accident · Minor injuriesClosedBeech B23 · Hopedale, MANTSB CHI80FEM26Accident · No injuriesClosedBeech B-23 · Onaway, MINTSB SEA79FA050Accident · 4 fatalClosedBeech B23 · Neihart, MTNTSB CHI79FEG22Accident · Serious injuriesClosedBeech B23 · Waynesville, OHNTSB LAX79FA056Accident · 2 fatalClosedBeech B23 · Oxnard, CA
Back to Beech B23