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 ('1152913', '1153928')
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 ('1152913', '1153928')
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 WPR26FA186Accident · 4 fatalClass 3 · FieldPreliminary reportBeech C90 · Lincoln, NMOn May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the…NTSB ERA26FA010Accident · 2 fatalClass 3 · FieldPreliminary reportBeech C90 · Fort Worth, TXOn October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA154Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Temple, TXThe failure of the left main landing gear down lock to engage and subsequent collapse of the left main landing gear.NTSB CEN23LA126Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Bismark, NDThe ground vehicle driver’s failure to see and maintain clearance from the airplane while conducting ground operations.NTSB GAA22WA320Accident · No injuriesClass 5 · ForeignBeech C90 · Bucaramanga, ColombiaNTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…NTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.NTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB CEN18LA047Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Rockford, ILThe pilot's inadequate preflight planning and his decision to depart without the required fuel reserve, which resulted in fuel exhaustion during a night approach and subsequent loss of engine power.NTSB WPR15LA253Accident · No injuriesLimited investigationFinal reportBeech C90 · Las Vegas, NVThe jet flight crew's use of an inappropriate checklist to resolve a parking brake hydraulic system pressure anomaly, which resulted in the airplane rolling down a slight incline and colliding with a parked twin-engine turboprop airplane. Contributing to the…NTSB ERA15LA293Accident · Serious injuriesLimited investigationFinal reportBeech C90B · Georgetown, KYUndetermined based on the available evidence.NTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.NTSB WPR14LA102Accident · No injuriesLimited investigationFinal reportBeech C90 · Columbia, CAThe pilot’s unstabilized night visual approach, which resulted in a hard landing and the collapse of all three landing gear.NTSB CEN14FA035Accident · 2 fatalField investigationFinal reportBeech C90 · Springdale, ARA total loss of power to both engines due to fuel exhaustion. Also causal were the pilot’s reliance on the fuel totalizer rather than the fuel quantity gauges to determine the fuel on board and his improper fuel planning.NTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.NTSB ERA11LA330Accident · No injuriesLimited investigationFinal reportBeech C90 · Camden, SCThe pilot's in-flight decision to continue toward his destination, through known significant weather, when safer alternatives were available.NTSB CEN11IA180Incident · No injuriesIncident investigationFinal reportHawker Beechcraft C90 · Evansville, INThe peel chip-type failure of the co-pilot's window during initial climb.NTSB NYC07LA245Accident · No injuriesLimited investigationFinal reportBeech C-90 · Bloomingdale, GAA loss of engine power due to fuel exhaustion as a result of the pilot's improper preflight planning and preparation. Contributing to the accident was the pilot's reliance on inaccurate fuel gauges.NTSB LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.NTSB MIA04FA049Accident · 2 fatalField investigationFinal reportBeech C90 · Homestead, FLThe pilot's inadequate in-flight planning/decision which resulted in an encounter with rain showers and turbulence, a loss of aircraft control, and overstress of the airframe.NTSB FTW02LA008Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Dallas, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.NTSB NYC01FA127Accident · Serious injuriesField investigationFinal reportBeech C90 · Islip, NYThe pilot’s failure to activate the fuel transfer pumps in accordance with the check list, which resulted in fuel exhaustion.NTSB LAX01FA018Accident · No injuriesField investigationFinal reportBeech C90 · Van Nuys, CAThe failure of the pilot of the other airplane to correctly set a new transponder code and an anomaly in ATC software that precluded the controller from manually overriding the resulting inhibition of displayed data. Factors in the accident were impaired…NTSB NYC00FA067Accident · 4 fatalField investigationFinal reportBeech C-90 · Somerset, KYthe failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…NTSB DEN99IA136Incident · No injuriesIncident investigationFinal reportBeech C90A · Denver, COSee cause/factor narrative for DEN 99-I-A136A.NTSB MIA99FA188Accident · 2 fatalField investigationFinal reportBeech C90 · Munson, FLThe poor in-flight weather evaluation by the pilot-in-command and his operation of the airplane at an indicated airspeed greater than the design maneuvering speed (Va) in a thunderstorm contrary to the pilot's operating handbook resulting in an in-flight…NTSB IAD98FA027Accident · 2 fatalField investigationFinal reportBeech C-90 · Newton, WVThe pilot inadequate management of the fuel system which resulted in fuel starvation to both engines. Factors in the accident were the pilot's concern about maintenance being completed prior to executing a scheduled flight later in the day, and operating the…NTSB CHI97FA047Accident · Minor injuriesField investigationFinal reportBeech C90 · Rhinelander, WIthe pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.NTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.NTSB MIA92GA107Accident · 2 fatalFinal reportBeech C90 · St. Augustine, FLThe pilot's failure to properly adhere to the published instrument approach procedure which resulted in descent below the minimum descent altitude. Factors which contributed to the accident were the low ceiling and fog.NTSB FTW90FA069Accident · 2 fatalField investigationFinal reportBeech C-90 · Burlington, NCThe double engine power loss due to fuel starvation, the pilot's failure to follow procedures and directives by not engaging the right fuel transfer pump, and the inadvertent stall during the forced landing approach. A factor was the pilot's failure to refuel…NTSB ATL90FA024Accident · 4 fatalField investigationFinal reportBeech C90 · Gadsden, ALFailure of the pilots of both aircraft to maintain adequate visual lookout to see-and-avoid the other aircraft.NTSB ATL90FA001Accident · 2 fatalField investigationFinal reportBeech C90 · Chamblee, GAMalfunction of one or more flight instruments for an undetermined reason, failue of the pilot to maintain control of the aircraft with partial panel instruments after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft.…NTSB SEA89FA154Accident · 3 fatalField investigationFinal reportBeech C90 · Gold Beach, ORThe pilot's failure to initiate a go-around after emerging from a fog bank on a short final which resulted in inadequate airspeed and a stall. Contributing to the accident was the pilot's poor judgement in attempting the VFR approach in IMC conditions.NTSB ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…NTSB DEN86FA163Accident · 1 fatalField investigationFinal reportBeech C90A · Jackson, WYThe plt departed olathe, KS, en route to Jackson, WY. The plt radioed the denver efas and reported his position as 56 miles northwest of casper, WY. There was no further radio communication with N114CM. The plt's wife stated after the accident that the plt…NTSB ATL86FA032Accident · 2 fatalField investigationFinal reportBeech C90 · East Greenwich, RIThe acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer…NTSB NYC85FA064Accident · 2 fatalField investigationFinal reportBeech G90 · St. Mary'S, PAThe acft crashed during a log DME approach. According to ATC the acft crashed after making a procedure turn at the faf. The winds in the area were being called 250 degrees at 10 KTS gusting to 28 knts. A caution on the apch plate has a remark,-'precipitious…NTSB ATL85LA076Accident · No injuriesLimited investigationFinal reportBeech C90 · Winston Salem, NCDuring takeoff roll, at rotation, acft contacted a large dog which was on the rwy. Plt had good visibility except for light condition. Acdt occurred at night. Arpt perimeter is fenced but there are many gates, some of which remain open at night. Many dogs…NTSB ATL84IA134Incident · No injuriesIncident investigationFinal reportBeech C90 · Herndon, VAThe acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…NTSB SEA80DYP11Accident · No injuriesClosedBeech C90 · Ellensburg, WANTSB CHI79FA065Accident · 1 fatalClosedBeech C-90 · Indianapolis, INNTSB FTW79FA042Accident · 1 fatalClosedBeech C90 · Houston, TXNTSB FTW79FA038Accident · 1 fatalClosedBeech C-90 · Houston, TXNTSB CHI77FA073Accident · 2 fatalClosedBeech C90 · Pontiac, ILNTSB IAD76AI028Accident · 6 fatalClosedBeech C90 · Charleston, WVNTSB MKC75AK052Accident · 1 fatalClosedBeech C90 · Grand Rapids, MN
Back to Beech C90