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 ('1151242')
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 ('1151242')
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 CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.NTSB CHI98LA317Accident · No injuriesLimited investigationFinal reportBeech C23 · North Platte, NEthe pilot's not compensating for wind conditions and failure to maintain control of the aircraft. A factor was the crosswind.NTSB LAX98LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Avalon, CAThe failure of the pilot to maintain an adequate airspeed during the landing, which resulted in a stall/mush and hard landing.NTSB LAX98LA142Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulare, CAThe malfunction of the nose wheel steering for undetermined reasons.NTSB CHI98LA092Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe pilot's improper raising of flaps and not maintaining directional control of the aircraft during the go-around sequence.NTSB CHI98LA039Accident · No injuriesLimited investigationFinal reportBeech C23 · Cameron, MOthe pilot's failure to maintain directional control of the airplane in the landing flare. A factor relating to this accident was the crosswind.NTSB LAX98LA035Accident · No injuriesLimited investigationFinal reportBeech C23 · Corona, CAThe loss of engine power for undetermined reasons. A factor was the rough terrain that resulted in a nose over during the landing roll.NTSB CHI98LA024Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's excessive pull-up and the flight instructor's inadequate supervision during a simulated engine failure after takeoff, resulting in a stall/mush onto the runway.NTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.NTSB LAX97FA328Accident · 4 fatalField investigationFinal reportBeech C23 · Torrance, CAThe failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.NTSB FTW97LA301Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Terlingua, TXThe inadvertent stall by the pilot-in-command. A factor was the sudden wind shift.NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.NTSB ATL97FA060Accident · 1 fatalField investigationFinal reportBeech C23 · Athens, GApilot impairment of judgment and performance, due to alcohol; and his failure to maintain sufficient altitude or clearance from obstacles, while maneuvering at low altitude at night. Darkness was a related factor.NTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB CHI96LA315Accident · No injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe instructor pilot delayed the remedial action and failed to maintain adequate supervision. The slow airspeed maintained by the student pilot was a factor.NTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI96LA212Accident · No injuriesLimited investigationFinal reportBeech C23 · Ainsworth, NEthe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and the pilot's selection of an unsuitable landing area for the forced landing.NTSB LAX96FA236Accident · 3 fatalField investigationFinal reportBeech C23 · Los Angeles, CAcompany maintenance personnel's inadequate service of the magneto system, and their failure of to replace the electric fuel boost pump, which led to a malfunctioning right magneto and an inoperative fuel boost pump. The inoperative fuel boost pump made it…NTSB ATL96LA041Accident · No injuriesLimited investigationFinal reportBeech 23 · Mc Coll, SCthe pilot's failure to maintain aircraft control.NTSB NYC95LA183Accident · No injuriesLimited investigationFinal reportBeech C23 · Dublin, NHThe loss of engine power due to improper major overhaul of the engine by the reuse of worn piston pins. The rough/ uneven terrain in the emergency landing area was a factor.NTSB CHI95LA162Accident · No injuriesLimited investigationFinal reportBeech C23 · Lake Ann, MIthe pilot's inadequate preflight planning/preparation and improper short field landing procedures. Factors associated with the accident were the wet terrain, a tailwind, and the pilots lack of recent experience.NTSB LAX95LA177Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Red Bluff, CAthe separation of the throttle linkage due to improper installation, and the pilot's misjudgement of the glide path necessary to reach the runway prior to shutting down the engine.NTSB CHI95LA343Accident · 1 fatalLimited investigationFinal reportBeech C23 · Waukegan, ILThe pilot's VFR flight into instrument meteorolical conditions.NTSB NYC95LA073Accident · No injuriesLimited investigationFinal reportBeech 23 · Plymouth, NHThe pilot's failure to maintain runway alignment during the aborted takeoff. Factors related to the accident were: the adverse runway conditions and snowbank beside the runway.NTSB NYC95LA057Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Warwick, NYthe pilot allowed the airplane to get too low on the approach, during a simulated engine out landing, which resulted in impacting high bushes, and landing short of the runway.NTSB CHI95LA091Accident · No injuriesLimited investigationFinal reportBeech 23 · Hutchinson, KSinadequate preflight planning by the pilot. Contributing factors to this accident were the pilot selecting the wrong runway for takeoff and the tailwind condition.NTSB NYC95LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Rochester, NHThe pilot's inadequate inflight planning/decision and inadvertently turning the ignition switch to the off position. A factor was the ignition switch stuck in the off position.NTSB ATL95FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Statesboro, GAThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…NTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…NTSB BFO94LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Easton, MDThe flight instructor's inadequate supervision, resulting in a hard landing and a subsequent collapse of the nose gear. Also causal to the accident, was the student pilot's improper raising of the wing flaps during the landing flare.NTSB LAX94FA266Accident · 3 fatalField investigationFinal reportBeech C23 · Lakeport, CAFailure of the pilot to maintain adequate airspeed during go-around from an aborted landing, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's misjudgment of speed and distance to the runway while on final approach,…NTSB CHI94LA187Accident · No injuriesLimited investigationFinal reportBeech C-23 · Gary, INImproper preflight planning and preparation by the pilot-in-command which resulted in fuel exhaustion. A factor associated with the accident was the delay in emergency procedures by the pilot-in-command.NTSB ATL94LA096Accident · No injuriesLimited investigationFinal reportBeech 23-C23 · Knightdale, NCThe pilot's improper landing flare that resulted in the collapse of the nose landing gear.NTSB ATL94LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Collegedale, TNThe pilot's failure to compensate for wind conditions during a crosswind landing. The crosswind was a factor.NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB CHI94LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Aurora, NEan inadequate fuel supply for the flight and the pilot's failure to refuel while en route. A factor related to the accident was the soft terrain on which the airplane was landed.NTSB CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.NTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.NTSB SEA93LA180Accident · No injuriesLimited investigationFinal reportBeech C23 · Lakeview, ORA fractured exhaust valve. The rough terrain was a factor.NTSB MIA93FA163Accident · 3 fatalField investigationFinal reportBeech C23 · St Petersburg, FLFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's lack of familiarity with the airport, and his selection of the wrong runway.NTSB NYC93LA135Accident · No injuriesLimited investigationFinal reportBeech C23 · Montgomery, NYA power loss due to a collapsed air duct and a consequent blockage of induction air, which resulted in a forced landing and an on ground collision with a ditch.NTSB MIA93LA139Accident · No injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe pilot-in-command's improper landing flare, which resulted in the aircraft bouncing and entering a porpoise maneuver. Contributing to the accident was his failure to recover from the bounced landing and perform a go-around.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB FTW93LA130Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Searcy, ARThe pilot's improper flare and his improper recovery for a bounced landing. The crosswind and the pilot's improper compensation for the wind were factors.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.NTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.NTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.NTSB CHI92LA150Accident · No injuriesLimited investigationFinal reportBeech C23 · Saginaw, MIThe first pilot's improper recovery from a bounced landing. A factor in the accident was the first pilot's lack of experience in the aircraft type.NTSB ATL92LA070Accident · No injuriesLimited investigationFinal reportBeech C-23 · Dalton, GAThe pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.
Back to Beech C23