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 ('1151242')
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 ('1151242')
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 CHI92LA107Accident · No injuriesLimited investigationFinal reportBeech C23 · Ozark, MOThe CFI pilot-in-command's failure to provide adequate supervision of a dual student. A factor contributing to the accident was the student pilot's failure to maintain airspeed.NTSB LAX92LA123Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fullerton, CAWas the pilot's poorly planned approach. Contributing to this accident was the prevailing haze/smoke, the pilot's failure to attain a proper glidepath, proper touch down point and excessive final approach airspeed.NTSB ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB FTW92FA045Accident · 4 fatalField investigationFinal reportBeech C23 · Dewitt, ARThe pilot's attempt to land in IMC conditions and her subsequent loss of control during climb out due to spatial disorientation. A factor was the pilot's disregard of the pre-flight weather briefing.NTSB FTW92FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Angleton, TXThe pilot's failure to maintain aircraft control. Factors were his lack of total instrument time, his VFR flight into instrument conditions and spatial disorientation.NTSB CHI92LA024Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Burlington, IAThe pilot having an improper fuel tank selector position.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB NYC91LA191Accident · No injuriesLimited investigationFinal reportBeech C-23 · Williamstown, MAEngine failure as a result of improper engine overhaul performed by other maintenance personnel. A factor was the lack of suitable terrain.NTSB NYC91LA137Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chesapeake, OHThe pilot's failure to maintain an adequate airspeed that would preclude a stall. Contributing to the accident was the opened door.NTSB CHI91LA167Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Cottage Grove, MNThe pilot in command's improper pre flight planning and preparation. Factors contributing to this accident were the pilot in command's lack of familiarity with the airplane and improper fuel consumption calculations.NTSB LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…NTSB DEN91FA072Accident · Serious injuriesField investigationFinal reportBeech C23 · Boulder, COInadvertent stall/mush due to the passengers's delay in relinquishing aircraft control, and inadequate supervision of the flight by the pilot in command. Factors were: mixture not leaned, and a high density altitude takeoff with a slight quartering tailwind.NTSB MIA91WA088Accident · No injuriesForeign investigationBeech C23 · Alice Town, BahamasNTSB ATL91LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Concord, NCThe pilot's inadequate preflight planning in that he disregarded the crosswind limit in the pilot's operating handbook. Factors were the wet runway and the ravine at the end of the runway.NTSB ATL91LA027Accident · No injuriesLimited investigationFinal reportBeech 23C · Dunlap, TNThe pilot's failure to use the carburetor heat properly, which resulted in the formation of carburetor ice, followed by a complete loss of engine power. Factors to this accident were carburetor icing conditions and the rough and uneven terrain at the crash…NTSB NYC90LA190Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Burlington, CTThe CFI failed to maintain a safe sink rate resulting in an undershoot of the runway.NTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.NTSB NYC90LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Philadelphia, PAThe failure of the pilot to ensure sufficient fuel was on board for the intended flight, resulting in a power loss due to fuel exhaustion. Factors related to the accident were unsuitable terrain, and the failure of the pilot to divert in a timely manner.NTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB MIA89FA233Accident · 4 fatalField investigationFinal reportBeech C23 · Barranquitas, PRImproper in-flight planning/decision by the pilot and his failure to maintain adequate flying speed, which resulted in a stall and subsequent impact with the terrain. Contributing factors were: operation of the aircraft by the pilot with excessive gross…NTSB LAX89LA271Accident · No injuriesLimited investigationFinal reportBeech C23 · S Lake Tahoe, CAThe aircraft's encounter with a downdraft during takeoff. Contributing factors were related to the high density altitude condition which existed and the aircraft's deteriorated takeoff performance capability.NTSB MKC89FA165Accident · 2 fatalField investigationFinal reportBeech C23 · Neligh, NEFailure of the pilot to maintain adequate airspeed after intiating a steep climbing maneuver from low altitude. Factors related to the accident were: the pilot's lack of total flying experience and lack of sufficient altitude.NTSB MKC89LA054Accident · No injuriesLimited investigationFinal reportBeech C-23 · Greenfield, IAThe pilot's failure to assure an an adequate supply of fuel was on board in order to complete the flight.NTSB ATL89LA060Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Gilbertsville, KYDuring preflt inspection fuel was noted to be up to the slots in the tab for the reduced fuel indicators, or 20 gal each tank. A 3 hour, dark night, cross country was flown to destination. PIC said acft arrived with about 5 gal fuel remaining in each tank. On…NTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…NTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.NTSB DEN88LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Gallup, NMThe private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and…NTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…NTSB BFO88LA043Accident · No injuriesLimited investigationFinal reportBeech C23 · Manassas, VAThe plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the…NTSB ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB MKC88LA063Accident · No injuriesLimited investigationFinal reportBeech C23 · Sullivan, MOWhen the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he…NTSB LAX88LA127Accident · No injuriesLimited investigationFinal reportBeech C23 · Placerville, CAJust after touch-down, the pilot stated that a deer darted out in front of the aircraft. The pilot did not have time to avoid colliding with the animal.NTSB MKC88LA053Accident · No injuriesLimited investigationFinal reportBeech 23 · Grain Valley, MOWhile practicing soft field takeoffs, the student pilot stated that he overrotated, establishing too high a nose up attitude. The aircraft entered a departure stall, followed by uncontrolled descent to the terrain.NTSB BFO88LA019Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roanoke, VAThis was the stu plt fifth training session where he did solo touch & go landings. During this session he made ten landings without incident. Six landings were made with his instr aboard followed by four solo landings. According to the stu during the flare…NTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB LAX88LA041Accident · No injuriesLimited investigationFinal reportBeech C23 · Fallbrook, CAThe student pilot was on his first solo flight in the Beech C23 aircraft. On landing the pilot pulled back on the elevator control and the aircraft began to porpoise. The aircraft touched down hard and the nose gear collapsed. The aircraft slid off the side…NTSB NYC88LA012Accident · No injuriesLimited investigationFinal reportBeech C23 · Bedford, MAA Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…NTSB LAX87LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Mammoth Lakes, CADuring a pleasure flight, just after take-off, the engine experienced a partial loss of power when the plt positioned the carb heat control to full cold. The plt stated that in order to obtain full power, during the runup he would position the carb heat to…NTSB SEA87LA140Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Deer Park, WADuring initial climb, at about 100 feet AGL, a loss of power occurred. The pilot made a shallow turn to avoid obstacles and landed in a plowed field. During landing roll the nose gear and right main gear collapsed, dragging the right wing. No reason could be…NTSB CHI87LA173Accident · No injuriesLimited investigationFinal reportBeech C23 · Monticello, ILThe acft ran off end of the rwy after the eng lost power drg a practice short fld takeoff. According to the instructor (CFI), there was insufficient rwy remaining to stop the acft drg the aborted takeoff. Maintenance psnl could not duplicate the eng prblm…NTSB LAX87LA253Accident · No injuriesLimited investigationFinal reportBeech C23 · Brownsville, CADuring a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the…NTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…NTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…NTSB MKC87LA053Accident · No injuriesLimited investigationFinal reportBeech C23 · Grain Valley, MOThe plt reported that the preflight eng run-up was satisfactory. Shortly after takeoff, the eng faultered briefly and the plt attempted a landing back on the rwy. Upon establishing a point to land, the eng responded and the acft overshot the intended landing…NTSB ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…NTSB MKC86LA143Accident · No injuriesLimited investigationFinal reportBeech C23 · Cheney, KSThe pilot stated that the aircraft was barely airborne as it reached the end of the airstrip, on the takeoff roll. At this point he encountered crosswind conditions and the aircraft mush/stalled and impacted the ground. Post-accident computations reveal that…NTSB MIA86LA195Accident · No injuriesLimited investigationFinal reportBeech C23 · Pompano Beach, FLThe plt stated that on approach he noted that he had no left rudder control and during landing roll, the aircraft veered off the left side of the runway collapsing the nose gear. Post crash examination of the nose gear revealed that the nose wheel steering…NTSB ATL86LA175Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fuquay-Varina, NCThe flt was a practical flt test for a commercial plt certificate. At aprx 3,000 ft the plt examiner initiated a simulated forced landing. The applicant spiraled to a modified downwind and base leg. The applicant said everything was fine until on final apch…NTSB DEN86FA160Accident · Serious injuriesField investigationFinal reportBeech C23 · Lamar, CODuring the takeoff climb, the plt's door came open. The pvt plt with 2 hours flying experience in C-23 acft made a close in traffic pattern to return for landing. During the turn from base leg to final the nose of the acft suddenly dropped and the acft…
Back to Beech C23