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 ('1151204')
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 ('1151204')
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 ERA21FA237Accident · 1 fatalClass 3 · FieldFinal reportBeech A23 · Pinnacle, NCThe flight instructor’s mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 23 · Spruce Pines, NCThe pilot's failure to familiarize himself with the wind conditions at the destination airport and his failure to attain the proper touchdown point during landing, which resulted in a long, tailwind landing and subsequent runway overrun.NTSB WPR20CA205Accident · No injuriesClass 4 · Data collectionFinal reportBeech 23 · Sedona, AZThe pilot's inability to maintain a climb after an attempted takeoff in high density altitude conditions, which resulted in a forced landing on a road and subsequent landing gear collapse.NTSB ERA19TA276Accident · No injuriesClass 3Final reportBeech 23 · Panama City, FLA total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.NTSB CEN19LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Fort Smith, ARA total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.NTSB CEN18LA220Accident · No injuriesLimited investigationFinal reportBeech A23 · Sedalia, MOThe pilot’s loss of directional control during the landing rollout due to the unexpected wind shift, which resulted in a runway excursion.NTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.NTSB ERA13LA285Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Oxford, NCThe failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation.NTSB CEN13LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Grand Isle, NEThe student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.NTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB ERA11CA309Accident · Minor injuriesData collectionFinal reportBeech A23 · Greene, NYThe pilot's decision to continue a visual approach with low visibility and in heavy rain and his subsequent failure to maintain clearance from trees.NTSB ERA11CA275Accident · No injuriesData collectionFinal reportBeech A23 · Hammonton, NJThe pilot's failure to maintain directional control during the aborted takeoff.NTSB SEA08CA049Accident · No injuriesData collectionFinal reportBeech A23 · Death Valley, CAThe pilot's improper flare during landing.NTSB CHI06LA149Accident · No injuriesLimited investigationFinal reportBeech A23 · Troy, MIThe improper flare and improper recovery from a bounced landing by the unknown pilot.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…NTSB ATL04CA136Accident · Serious injuriesData collectionFinal reportBeech A23 · Columbia, TNThe pilot's failure to maintain clearance from trees during climb and the pilot's failure to execute a go-around before completing the approach to land.NTSB NYC04CA019Accident · Serious injuriesData collectionFinal reportBeech A23 · Salem, NJThe pilot's delay in aborting the takeoff after his failure to obtain a proper climb rate. Factors related to the accident were the tailwind conditions, and the wet turf runway.NTSB ATL03LA084Accident · No injuriesLimited investigationFinal reportBeech A23 · Brunswick, GAMaintenance personnel's failure to secure the fitting on a fuel line, which resulted in a loss of engine power.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB CHI02CA182Accident · No injuriesData collectionFinal reportBeech A-23-23 · Monroe, MIThe pilot misjudging the flare, and his loss of directional control during landing. The soft terrain was a factor.NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.NTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.NTSB NYC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lincoln Park, NJThe pilot-in-command's failure to maintain directional control while taxiing.NTSB NYC00FA094Accident · 1 fatalField investigationFinal reportBeech A23 · Akron, OHThe pilot's improper decision to operate the airplane with known deficiencies. A factor in this accident was the inability of the engine to attain full power for undetermined reasons.NTSB NYC00LA059Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Blacksburg, VAThe pilot in command's failure to recover from a bounced landing.NTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.NTSB SEA99FA112Accident · 1 fatalField investigationFinal reportBeech A23 · Eatonville, WAImproper fuel management which led to fuel starvation.NTSB MIA99LA190Accident · No injuriesLimited investigationFinal reportBeech A23 · Pinehurst, NCThe flight crew's improper fuel management resulting in engine loss of power due to fuel starvation and damage to the airplane due to collision with trees in the subsequent forced landing.NTSB MIA99LA115Accident · No injuriesLimited investigationFinal reportBeech A23 · Homestead, FLThe pilots improper decision not to land straight ahead after sustaining a reported loss of engine power on initial take off climb with sufficient runway remaining, and improper recovery from a bounced landing resulting in a subsequent in-flight collision…NTSB FTW97LA056Accident · No injuriesLimited investigationFinal reportBeech A23 · Conway, ARthe pilot's inadequate compensation for the crosswind during the landing, and his failure to remain clear of the tree during the attempted go-around. The crosswind and the proximity of the small tree were related factors.NTSB ATL96LA131Accident · No injuriesLimited investigationFinal reportBeech A23 · Tarboro, NCfatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.NTSB CHI95LA206Accident · Serious injuriesLimited investigationFinal reportBeech 23A · Spearfish, SDThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.NTSB BFO95LA012Accident · No injuriesLimited investigationFinal reportBeech A23 · Campbellsville, KYthe mechanic's improper maintenance adjustment, which involved the misalignment of the fuel selector handle with the fuel selector valve. Related factors are the pilot's inadequate fuel management, and the rough/uneven terrain.NTSB BFO94LA157Accident · No injuriesLimited investigationFinal reportBeech A-23 · Felton, DEThe pilot's improper recovery from a bounced landing and failure to maintain directional control. A factor is the pilot's failure to do a go around.NTSB NYC93LA161Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Morgantown, WVThe pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.NTSB CHI93LA269Accident · 1 fatalLimited investigationFinal reportBeech A23 · Boyceville, WIthe failure of the pilot to attain the proper touchdown point, and his failure to perform a go-around.NTSB ATL93LA052Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Mebane, NCThe pilot's mismanagement of the fuel supply which resulted in fuel starvation to the engine.NTSB LAX92LA250Accident · No injuriesLimited investigationFinal reportBeech A-23 · Willows, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot misjudged the flare altitude and failed to maintain the proper airspeed.NTSB NYC92LA017Accident · No injuriesLimited investigationFinal reportBeech A23 · Fairfield, NJThe loss of engine power for undetermined reason's which resulted in a forced landing on unsuitable terrain.NTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.NTSB CHI90FA250Accident · 1 fatalField investigationFinal reportBeech A23A · St Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall/spin.NTSB CHI90LA175Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Tecumseh, MIA loss of engine power due to unknown reasons.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB MKC88LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Crete, NEThe student pilot said he lost control shortly after liftoff while attempting a soft field takeoff. The acft made an uncontrolled descent to the terrain on a farm field adjacent the airstrip, causing substantial damage to the acft, but no injuries to the…NTSB MIA88FA144Accident · Serious injuriesField investigationFinal reportBeech A-23 · Fort Myers, FLThe private pilot experienced an engine failure on final approach and executed a forced landing to a wooded area and crashed. The pilot said he had flown about 2.0 hours on the right tank and did not switch to the left tank prior to landing. Another pilot had…NTSB LAX88FA114Accident · 2 fatalField investigationFinal reportBeech A23 · Big Bear City, CAThe passenger told friends that the pilot was going to perform some aerobatic maneuvers near the lodge where they were staying. The other residents in the lodge reported that the airplane flew very low over the house and proceeded towards the east. After…NTSB CHI87LA196Accident · No injuriesLimited investigationFinal reportBeech A23 · Longville, MNThe student plt rprtd that as he rounded out to land, the acft nosed down & impacted nosewheel first. Subsequently, the nose gear collapsed & the acft skidded to a stop. After coming to rest, a fire erupted, which spread & subsequently destroyed the acft.NTSB BFO87LA035Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Ravenswood, WVThe pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the…
Back to Beech A23