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 ERA26LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Weston, CTThe in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.NTSB WPR26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Paynesville, MNOn June 30, 2026, about 1745 central daylight time, a Beech A36, N8095F, was substantially damaged when it was involved in an accident at Paynesville Municipal Airport (PEX), Paynesville, Minnesota. The private pilot and one passenger were not injured. The…NTSB WPR26FA130Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Olympic Valley, CAOn March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal…NTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26FA114Accident · 2 fatalClass 3 · FieldPreliminary reportBeech A36 · Murchison, TXOn February 11, 2026, about 1726 central standard time, a Beech A36 airplane, N3215U, sustained substantial damage when it was involved in an accident near Murchison, Texas. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was…NTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title…NTSB CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB ERA25LA307Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Wirt County, WVOn August 8, 2025, about 1757 eastern daylight time, a Beech A36, N60357, was substantially damaged when it was involved in an accident in Wirt County, West Virginia. The commercial pilot and three passengers were not injured. The airplane was operated as a…NTSB GAA25WA230AccidentClass 5 · ForeignBeech A36 · Montevideo, UruguayNTSB WPR25LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Coolin, IDOn July 8, 2025, about 1840 Pacific daylight time, a Beech A36, N41VH, was substantially damaged when it was involved in an accident near Coolin, Idaho. The pilot and passenger sustained minor injuries. The airplane was operated under Title 14 Code of Federal…NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB ERA25LA169Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Fredericksburg, VAOn April 9, 2025, about 1505 eastern daylight time, a Beech A36, N2Z, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot and the pilot rated passenger sustained minor injuries. The airplane was operated…NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA25LA088Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Naples, FLOn January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was…NTSB ERA25FA080Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · East Aurora, NYOn December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.NTSB CEN25LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Pineville, LAThe airplane’s collision with a stake on a closed runway. Contributing to the accident was the pilot’s inadequate preflight planning and failure to see the closed runway markings.NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA24LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Cullman, ALThe pilot’s decision to depart in an area of developing convective weather, which resulted in an unanticipated wind shift during the initial climb after takeoff, a loss of climb performance, and the subsequent forced landing.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB ERA24LA165Accident · Serious injuriesClass 4 · LimitedFinal reportBeech A36 · Cleveland, OHThe pilot’s failure to maintain control of the airplane during landing, resulting in a hard, bounced landing.NTSB ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.NTSB ERA24LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Griffin, GAThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.NTSB WPR24FA054Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Topock, AZThe failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a…NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.NTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.NTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…NTSB CEN23LA419Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · El Dorado, ARA loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB ERA23LA363Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Frankfort, KYA total loss of engine power for reasons that could not be determined.NTSB CEN23LA344Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Oberlin, KSThe blockage of the left fuel tank vent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident of the pilot’s failure to use his checklist to address the loss of engine power.NTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.NTSB CEN23LA224Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Oklahoma City, OKA loss of engine power during approach for landing for undetermined reasons.NTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA23FA113Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · North Castle, NYThe pre-ignition/detonation damage to the No. 4 piston for reasons that could not be determined, which allowed the crankcase to become pressurized and resulted in oil exhaustion and subsequent catastrophic internal engine failure.NTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.NTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…NTSB ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…NTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.NTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.NTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.NTSB CEN22LA233Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Amarillo, TXThe loss of engine power due to a leak in the fuel control assembly. Contributing to the accident was the inadequate maintenance of the fuel control assembly.NTSB CEN22LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Heavner, OKA total loss of engine power due to oil exhaustion which resulted from improper engine maintenance.NTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.NTSB WPR22LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Tooele, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA382Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Granbury, TXThe loss of engine power for reasons that could not be determined with the available information.NTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.NTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.NTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Arcadia, FLA total loss of engine power for underdetermined reasons.
Back to Beech A36