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 ('1152919')
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 ('1152919')
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 GAA26WA145Accident · No injuriesForeign investigationBeech B100 · Panama City, PanamaNTSB WPR26FA040Accident · 2 fatalClass 3 · FieldPreliminary reportBeech B100 · Coral Springs, FLOn November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA24LA360Accident · No injuriesClass 4 · LimitedFinal reportBeech B100 · Jesup, GAA hard landing short of the runway threshold, which resulted in a collapse of the left main landing gear and subsequent runway excursion during landing.NTSB CEN21LA132Accident · No injuriesClass 3 · LimitedFinal reportBeech B100 · Lubbock, TXThe failure of the right-side window inner pane for reasons that could not be determined based on available evidence.NTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN16LA187Accident · No injuriesLimited investigationFinal reportBeech B100 · Dexter, MOA collapse of the right main landing gear for reasons that could not be determined because of the damage to the landing gear system.NTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.NTSB WPR13FA073Accident · 2 fatalField investigationFinal reportBeech B100 · Libby, MTThe noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…NTSB CEN10FA028Accident · 4 fatalField investigationFinal reportBeech B100 · Benavides, TXThe pilot's failure to avoid severe weather, and the air traffic controller's failure to provide adverse weather avoidance assistance, as required by Federal Aviation Administration directives, both of which led to the airplane's encounter with a severe…NTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN09LA388Accident · Serious injuriesLimited investigationFinal reportBeech B100 · Rapid City, SDThe flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.NTSB LAX98IA096Incident · No injuriesIncident investigationFinal reportBeech 100 · Reno, NVIce formation around the elevator control cables due to plugged limbers and a water drain hole.NTSB ATL98FA009Accident · 1 fatalField investigationFinal reportBeech B100 · Madison, MSthe pilot's failure to maintain control of the aircraft due to spatial disorientation. A related factor was: the instrument weather conditions.NTSB LAX97LA132Accident · No injuriesLimited investigationFinal reportBeech 100 · San Carlos, CAthe pilot's improper flare, which resulted in a hard landing; his improper adjustment of the landing gear warning horn squat switch(es); and his decision to attempt flight with known equipment deficiencies.NTSB BFO93LA069Accident · No injuriesLimited investigationFinal reportBeech B100 · Clarksburg, WVThe pilot's failure to maintain adequate clearance from the hangar. Contributing to the accident was the dark night.NTSB FTW93LA040Accident · No injuriesLimited investigationFinal reportBeech B100 · Uvalde, TXThe pilots failure to go around. A factor was his resultant long landing and delayed flare.NTSB CHI92FA032Accident · 3 fatalField investigationFinal reportBeech B100 · Romeo, MIThe pilot in command's improper inflight decision and the minimum descent altitude disregarded during an instrument approach.NTSB SEA89LA061Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35J · Spokane, WAThe failure of the pilot to maintain directional control and runway alignment during the landing roll. Factors related to the accident were: light conditions at dawn, snow and ice on the runway, and the runway lights.NTSB FTW86LA131Accident · No injuriesLimited investigationFinal reportBeech B-100 · Houston, TXThe pilot was unable to get a green light for the left main gear prior to landing and finally had to make an emergency landing on the nose and right main gear. The aircraft was substantially damaged when it veered off the runway on the landing roll out.…NTSB NYC86LA018Accident · No injuriesLimited investigationFinal reportBeech BE-95-100 · Grove City, PAAfter turning on to final for rwy 270 transition/upgrade pilot observed he was high. Power was then reduced aircraft was then on short final a power adjustment was made causing aircraft to land 400/500 feet pass rwy threshold. On contact with rwy nose gear…NTSB FTW84MA076Accident · 8 fatalMajor investigationFinal reportBeech B100 · Midland, TXThe acft crashed while completing a charter flt that began at 1220 CST on 11/25/83 to transport a tv sports film crew. The flt began at Midland, TX & proceeded to fort worth & wichita falls, TX, then began a return flt to Midland. During arrival, the plt…NTSB MIA83FA203Accident · Serious injuriesField investigationFinal reportScarboro COUGAR-1 · Lantana, FLDuring a touch & go takeoff the engine quit. The pilot entered a steep turn to return to the airport and crashed into trees. Post accident investigation revealed only 1/2 pt of automotive fuel was in the acft.NTSB NYC79FFA38Accident · No injuriesClosedEnstrom F-28A · Newcomb, NY
Back to Beech B100