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 DEN08LA163Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Duncan, OKA total loss of engine power due to the fatigue failure of the engine crankshaft. Contributing to the accident were the improper maintenance to the engine crankshaft, improper reassembly of the engine, and failure to follow the engine manufacturer's overhaul…NTSB CHI08LA273Accident · No injuriesLimited investigationFinal reportBeech C23 · Grayslake, ILThe inadequate flare by the student pilot and the inadequate supervision and delayed go-around performed by the flight instructor. Contributing to the accident were the student pilot's failure to attain/maintain a stabilized approach.NTSB DEN08CA133Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe student pilot's failure to maintain control of the airplane. Contributing to the accident were the flight instructor's inadequate supervision, turbulence, airspeed was not maintained, and compensation for the wind conditions was inadequate.NTSB MIA08CA153Accident · No injuriesData collectionFinal reportBeech C23 · Winter Haven, FLThe student pilot's improper recovery from a bounced landing.NTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB LAX08CA075Accident · No injuriesData collectionFinal reportBeech C23 · Marble Canyon, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed during the flare. Contributing to the accident were wind gusts and a crosswind.NTSB CHI07CA304Accident · Minor injuriesData collectionFinal reportBeech C23 · Carrollton, OHThe partial loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.NTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.NTSB LAX06LA111Accident · Minor injuriesLimited investigationFinal reportBeech C23 · San Jose, CAfuel starvation due to the pilot's improper fuel system management and failure to select the proper fuel tank. A factor was the rough, uneven terrain.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB LAX06CA052Accident · No injuriesData collectionFinal reportBeech C23 · Holbrook, AZThe student pilot's abrupt flare and failure to maintain airspeed, which resulted in a stall. The flight instructor's inadequate supervision of the flight was also causal.NTSB CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.NTSB LAX05CA297Accident · No injuriesData collectionFinal reportBeech C23 · Jiggs, NVthe pilot's encounter with a downdraft.NTSB LAX05CA169Accident · No injuriesData collectionFinal reportBeech C23 Sundowner · San Martin, CAthe pilot's improper landing flare that resulted in a porpoise and a hard landing.NTSB ATL05LA047Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roseboro, NCThe overload fracture of the engine oil cooler for undetermined reasons.NTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA183Accident · 1 fatalLimited investigationFinal reportBeech C23 · Morrilton, ARThe pilot's inadequate preflight planning/preparation to assure adequate takeoff performance to clear obstacles.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.NTSB MIA03LA112Accident · No injuriesLimited investigationFinal reportBeech C23 · Ormond Beach, FLThe pilot's inadequate preflight and his failure to refuel the airplane before departure resulting in the total loss of engine power due to fuel exhaustion and a hard landing during the subsequent forced landing.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB DEN03LA042Accident · No injuriesLimited investigationFinal reportBeech C23 · Pagosa Springs, COthe pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. Contributing factors were the student pilot's improper flare, the instructor's inadequate remedial actions, and terrain conditions.NTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.NTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.NTSB LAX02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Oak Shores, CAthe number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.NTSB CHI02LA101Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kahoka, MOThe improper soft field takeoff/procedure by the pilot. Contributing factors were the night condition and the inadequate planning/decision by the pilot.NTSB IAD02LA035Accident · Serious injuriesLimited investigationFinal reportBeechcraft C23 · Wilmington, DEthe flight instructor's improper fuel management which resulted in fuel starvation. A factor in the accident was the flight instructor's failure to follow the published checklist procedures.NTSB NYC02LA057Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Point Pleasant, WVAn inadvertent collision with a deer while landing at dusk. A factor in the accident was the dusk light condition.NTSB CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.NTSB MIA02LA013Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Athens, GAthe pilot misjudged the ailment of the airplane on the active runway, inadvertently taking off from a parallel taxiway, and subsequently departing the hard surface into a 40 foot drop off. A factor in this accident was a dark night, and the pilot's total…NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB MIA00FA177Accident · 2 fatalField investigationFinal reportBeech C23 · Smyrna, TNThe failure of the dual student to maintain airspeed following total loss of engine power resulting in an inadvertent stall and subsequent uncontrolled descent. Also, inadequate supervision by the CFI for her failure to note the position of the fuel selector…NTSB IAD00LA031Accident · No injuriesLimited investigationFinal reportBeech 23 · Selinsgrove, PAThe student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB CHI00LA001Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Greenwood, INundetermined.NTSB CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.NTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.NTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.NTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB MIA99LA139Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Apex, NCthe pilot's failure to maintain control of the airplane resulting in the airplane drifting, and subsequently impacting with trees.
Back to Beech C23