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 ('1154002')
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 ('1154002')
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 CEN26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 99 · Belleville, MIOn September 10, 2026, about 1545 eastern daylight time, a Beech 99 airplane, N799CZ, and a Diamond DA20 airplane, N84VV were involved in a ground collision accident at the Willow Run Airport, Belleville, Michigan. N799CZ received minor damage and N84VV…NTSB GAA18CA187Accident · No injuriesData collectionFinal reportBeech 99 · King Salmon, AKThe pilot’s failure to maintain an adequate approach path and runway centerline during the initial landing, which resulted in a hard landing to the left of the runway and damage to the landing gear and wing.NTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.NTSB CHI07CA049Accident · No injuriesData collectionFinal reportBeech 99 · Mosinee, WIThe pilot encountering the unsuitable terrain during the landing. Factors were the dark night and the snowbank.NTSB LAX06CA285Accident · Serious injuriesData collectionFinal reportBeech 99 · Lodi, CAthe failure of the skydiver to correctly follow procedures and directives on exiting the airplane properly, which resulted in his collision with the horizontal stabilizer.NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB SEA04FA166Accident · 2 fatalField investigationFinal reportBeech BE-99 · Neihart, MTThe pilot's failure to maintain adequate terrain clearance during cruise, which resulted in the in-flight collision with mountainous terrain. Dark night conditions and mountainous terrain were contributing factors.NTSB CHI04LA042Accident · No injuriesLimited investigationFinal reportBeech 99 · Mosinee, WIThe pilot's failure to maintain the proper descent rate and his inadequate flare.NTSB SEA99LA003Accident · Minor injuriesLimited investigationFinal reportBeech 99 · Missoula, MTThe pilot-in-command's delayed remedial action in response to the co-pilot's improper landing flare, and the co-pilot's application of excessive (full nose-up) trim during the landing flare as taught in the operator's initial aircrew training program. Factors…NTSB LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.NTSB ANC92FA006Accident · No injuriesField investigationFinal reportBeech BE-99 · Allakaket, AKWas the pilot-in-command misjudged the proper touchdown point on the runway. Contributing to the accident was the snow-covered terrain and a snowbank.NTSB NYC87FA085Accident · No injuriesField investigationFinal reportBeech 99 · Oneonta, NYThe flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the…NTSB NYC86LA005Accident · No injuriesLimited investigationFinal reportBeech BE-99 · Albany, NYA Beech BE-99 N336PL experienced a landing gear collapse while landing on runway 01 at Albany county airport and was substantially damaged. On initial approach to the airport the gear selector was put in the down position, only two green gear lights were…NTSB ATL85FA213Accident · No injuriesField investigationFinal reportBeech 99 · Louisville, KYWhile enroute to 8000 ft, both eng lost all power. The plts attempted return to the departure a/p was unsuccessful. He made an emerg ldg on the interstate highway. All landing gear was damaged. The fuel tanks were empty. There were conflicting fuel quantity…NTSB CHI84IA224Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Chicago, ILLanding gear extended but not locked. Crew could not rectify situation by using normal and emergency gear extension procedures. Gear collapsed on touchdown. Investigation disclosed a fatigue crack in rt main gear hydraulic actuator allowing a loss of…NTSB ATL84LA120Accident · No injuriesLimited investigationFinal reportBeech 99 · Myrtle Beach, SCThe acft was landed with the landing gear up. The plt said that the sun was shining on the instrument panel and he thought he saw 3 green lights. After the acft stopped on the rwy the red light in the gear handle was on and the warninghorn was sounding. He…NTSB CHI84IA114Incident · No injuriesIncident investigationFinal reportBeech 99 · Champaign, ILThe plt reported that during arrival to the destination arpt, he heard a loud bang & the acft began rolling to the right. He reported that he was unable to control the roll with the ailerons, so he reduced power on the left eng & applied left rudder. The crew…NTSB CHI84FA076Accident · No injuriesField investigationFinal reportBeech BE-99 · Galesburg, ILThe main gear retracted while the acft was being taxied to the taxioff position. Investigation revealed that a landing gear maintenance valve PN22400-1, SN19 manufactured by airright inc had corroded and was allowing stray voltage to cyclethe landing gear…NTSB ATL82IA109Incident · No injuriesIncident investigationFinal reportBeech BE-99 · Asheville, NCDuring takeoff on a regularly scheduled passenger flight the aircraft sustained a total engine failure and flameout on the right engine. After securing the engine, the crew executed an uneventful single engine landing without further damage to the aircraft or…NTSB NYC82AA028Accident · Serious injuriesFinal reportBeech 99 · Groton, CTAfter crossing the mondi intersection inbound for an ILS rwy 5 apch, the captain felt that a proper descent was not possible due to a strong tailwind & their present altitude. They turned & proceeded outbound to loose altitude. The crewthen established…NTSB CHI80FEP09Accident · No injuriesClosedBeech 99 · La Crosse, WINTSB CHI79FA052Accident · 2 fatalClosedBeech 99 · Chicago, ILNTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WANTSB NYC76AN122Accident · Minor injuriesClosedBeech 99 · Ellsworth, MENTSB NYC76AN089Accident · Serious injuriesClosedBeech 99 · Wappinger Fls, NYNTSB SEA75AS037Accident · Minor injuriesClosedBeech 99 · Spokane, WANTSB SEA75IS028Incident · No injuriesClosedBeech 99 · Wenatchee, WANTSB MKC74IK067Incident · No injuriesClosedBeech 99 · Fort Dodge, IANTSB FTW74AF076Accident · 6 fatalClosedBeech 99 · Galveston, TXNTSB MIA74FKG67Accident · No injuriesClosedBeech 99 · St Simons Isl, GANTSB ANC77FM028Accident · 12 fatalClosedBeech 99A · Johnstown, PANTSB NYC72IN125Incident · No injuriesClosedBeech 99A · Philadelphia, PANTSB CHI72AC042Accident · No injuriesClosedBeech 99 · Cleveland, OHNTSB NYC72AN059Accident · 4 fatalClosedBeech B99 · Bath, PANTSB OAK72IP010Incident · No injuriesClosedBeech 99 · Oakland, CANTSB MIA71IM112Incident · No injuriesClosedBeech 99 · Brunswick, GANTSB UNK71X0103Accident · No injuriesClosedBeech 99 · Trinidad, ChadNTSB IAD70AI063Accident · No injuriesClosedBeech 99 · Hagerstown, MDNTSB DCA70A0001Accident · 14 fatalClosedBeech B99 · Monroe, GANTSB SEA69A0061Accident · 2 fatalClosedBeech 99 · Pasco, WANTSB CHI69A0087Accident · No injuriesClosedBeech 99 · Danville, ILNTSB MIA69A0043Accident · No injuriesClosedBeech 99 · Orlando, FLNTSB MIA69A0041Accident · No injuriesClosedBeech 99 · Ft Lauderdale, FLNTSB CHI69F0452Accident · No injuriesClosedBeech B99 · Hamilton, INNTSB NYC69A0046Accident · No injuriesClosedBeech B-99 · Hazelton, PA
Back to Beech 99