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 ('1151604')
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 ('1151604')
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 CHI01LA021Accident · No injuriesLimited investigationFinal reportBeech A36 · Quincy, ILthe evasive maneuver not possible by the pilot and the deer on the runway. A factor was the dark night.NTSB ANC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-A36 · Nondalton, AKThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB ATL00LA074Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Clarksville, TNThe pilot's failure to follow published instrument approach procedures, and collided with a tree while executing a missed approach. Factors were low clouds, fog and a tree.NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.NTSB NYC00LA125Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Nassawadox, VAA loss of engine power caused by detonation of the #2 piston.NTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.NTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).NTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…NTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.NTSB DEN00LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe student pilot's excessive remedial action (banking to realign the airplane with the runway). Factors were the student pilot flaring the airplane prematurely and failing to maintain directional control, and the flight instructor's inadequate supervision of…NTSB LAX99LA219Accident · No injuriesLimited investigationFinal reportBeech A-36 · Van Nuys, CAThe failure of the pilot to verify that the alternator was activated after engine start, subsequently resulting in a total electrical failure; and his inadequate emergency procedures for manual extension of the landing gear following the electrical failure.NTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.NTSB ATL99LA075Accident · No injuriesLimited investigationFinal reportBeech 36 · Williamston, NCThe pilot's inadequate evaluation of winds that resulted in the loss of directional control during an attempted takeoff with a tailwind. A factor was the tailwind condition.NTSB MIA99LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Courtland, ALThe failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…NTSB ANC98LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · New Stuyahok, AKThe pilot's failure to extend the landing gear prior to landing. Factors associated with this accident were the pilot's interference with his normal habit pattern, turbulence, and the crosswind condition during landing.NTSB IAD98FA094Accident · 1 fatalField investigationFinal reportBeech A-36 · Amelia, OHthe pilot's loss of control in flight due to spatial disorientation. A related factor was the fog.NTSB FTW98FA276Accident · 2 fatalField investigationFinal reportBeech A36 · Nephi, UTThe improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…NTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…NTSB IAD98FA054Accident · 4 fatalField investigationFinal reportBeech A36 · Davis, WVThe pilot's spatial disorientation, his subsequent loss of control of the airplane, and his overload of the horizontal stabilizer during a recovery attempt. Factors include the pilot's continued flight into icing conditions, his lack of airspeed control, and…NTSB FTW98LA213Accident · No injuriesLimited investigationFinal reportBeech A-36 · Ruidoso, NMInadvertent post departure stall. A factor was high gusty winds.NTSB CHI98FA107Accident · 4 fatalField investigationFinal reportBeech A-36 · New Lebanon, INThe pilot's flight into known icing conditions. Contributing factors were the degraded aircraft performance, the pilot's inability to maintain the proper descent rate, trees, and the dark night condition.NTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.NTSB LAX98FA095Accident · 2 fatalField investigationFinal reportBeech A36 · San Gorgonio Mo, CAThe pilot's inability to maintain altitude due to an encounter with adverse winds and downdrafts on the lee side of a mountain. Also causal was the pilot's inadequate weather evaluation, which precipitated his intentional flight into an area of known adverse…NTSB IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.NTSB CHI97FA218Accident · 7 fatalField investigationFinal reportBeech A-36 · Chicago, ILthe pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.NTSB LAX97FA177Accident · 5 fatalField investigationFinal reportBeech A36TC · Truckee, CAfailure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…NTSB MIA97WA135Accident · 4 fatalForeign investigationBeech A-36 · Pitts Town, BahamasNTSB CHI97FA084Accident · 4 fatalField investigationFinal reportBeech A36 · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.NTSB IAD97WA088Accident · No injuriesForeign investigationBeech A-36 · Lebury, United KingdomNTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB ATL97FA030Accident · 2 fatalField investigationFinal reportBeech A36 · Pensacola, FLThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the subsequent loss of engine power. A factor was low ceilings.NTSB FTW97FA067Accident · 6 fatalField investigationFinal reportBeech A36 · Chacon, NMThe pilot's failure to maintain altitude and clearance from the high, mountainous terrain. Factors were; high wind, turbulence, and mountain wave conditions.NTSB MIA97LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Walnut Cove, NCfailure of the pilot/owner (PIC) to either go around while there was sufficient runway remaining or apply adequate braking to stop the aircraft before overrunning the runway. Factors relating to the accident were: the pilot/owner's misjudgment of distance and…NTSB NYC96FA163Accident · 1 fatalField investigationFinal reportBeech A36 · Roanoke, VAthe pilot's failure to follow the published instrument approach procedures, and his delayed missed approach, which resulted in an inflight collision with mountainous terrain.NTSB MIA96LA208Accident · 1 fatalLimited investigationFinal reportBeech A36 · Atlantic Ocean (Atlantic Ocean)an inflight collision with the terrain (water) for undetermined reason(s). Factors relating to the accident were: failure of the pilot to obtain a preflight weather briefing, his failure to obtain in-flight weather avoidance assistance, and his resultant…NTSB NYC96FA113Accident · No injuriesField investigationFinal reportBeech A36 · Meriden, CTthe pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…NTSB NYC96LA102Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olean, NYthe pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.NTSB LAX96LA191Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Page, AZthe pilot's inadequate compensation for a gusty crosswind condition, and his failure to obtain and maintain an adequate airspeed during the takeoff initial climb in a high density altitude situation, which resulted in an inadvertent stall/mush. Related…NTSB FTW96FA181Accident · 1 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKthe pilot's delay in aborting the landing and his failure to obtain/maintain sufficient airspeed during the aborted landing, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's improper…NTSB FTW96FA120Accident · 1 fatalField investigationFinal reportBeech A36 · Katy, TXa loss of control due to pilot incapacitation for undetermined reasons. A factor related to the pilot's injuries was the lack of shoulder harness restraint.NTSB NYC96FA027Accident · 1 fatalField investigationFinal reportBeech A36 · Atlantic City, NJthe pilot's failure to maintain control of the airplane. A factor was the pilot's diverted attention due to an open aft cargo door.NTSB SEA96FA012Accident · Serious injuriesField investigationFinal reportBeech A-36 · Newport, ORthe pilot's inadvertent shut-off of the fuel mixture control. Factors contributing to the accident were: the pilot's failure to perform adequate remedial action to regain engine power, his lack of familiarity with the accident airplane, and his failure to…NTSB LAX96FA004Accident · 3 fatalField investigationFinal reportBeech A-36 · Beaver Dam, AZThe pilot's improper use of the fuel selector valve, which resulted in fuel starvation; and her failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW96LA002Accident · No injuriesLimited investigationFinal reportBeech A36 · Cotulla, TXThe pilot's delay in aborting the takeoff. A factor was the pilot's improper use of the aircraft performance data.NTSB FTW95FA407Accident · 1 fatalField investigationFinal reportBeech A36 · Brady, TXthe pilot's improper decision to attempt a night landing without the visual cues necessary to establish runway alignment. Factors were the dark night light condition, the inoperative runway edge lights, and the failure of airport management to issue a NOTAM…NTSB LAX95FA341Accident · Minor injuriesField investigationFinal reportBeech A36 · Van Nuys, CAthe pilot's fuel mismanagement and failure to assure that an adequate supply of fuel was available. His lack of familiarity with the airplane's fuel system, overcofidence, the dark night, and the lack of a suitable landing area were factors in the accident.NTSB FTW95LA388Accident · No injuriesLimited investigationFinal reportBeech A36 · Broomfield, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper alignment with the runway after lift-off. A factor relating to the accident was: the unfavorable wind condition (gusty crosswind).NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB LAX95FA249Accident · 2 fatalField investigationFinal reportBeech A-36 · Hanford, CAUndetermined.NTSB SEA95FA137Accident · 2 fatalField investigationFinal reportBeech A36 · Brinnon, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the terrain. Factors in the accident were the mountains and the clouds.
Back to Beech A36