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 NYC86LA144Accident · Minor injuriesLimited investigationFinal reportBeech A-23 · Charlotte, VTPilot stated that on takeoff roll it seemed longer than usual and about 1500 to 1600 feet of the runway before the aircraft began to rotate. The aircraft had climbed about 15 to 20 feet before coming to the end of the runway and over water. At about 30 feet…NTSB MIA86LA096Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lake Wales, FLThe plt stated that he landed long and was unable to stop. The acft ran off the end of the runway into a lake.NTSB FTW86LQG13Accident · No injuriesFinal reportBeech C23 · Vega, TXThe acft landed hard following a simulated short field landing over an obstacle. Power was reduced as the acft cleared the imaginary obstacle but there was a slight delay in lowering the nose to maintain airspeed. The acft was flared at a high sink rate…NTSB MKC86LA040Accident · No injuriesLimited investigationFinal reportBeech C23 · Dubuque, IAThe aircraft landed on runway 13 because the n-s runway was covered with ice. The wind was from 220 degrees at 16, gusts to 24 knots. The aircraft bounced twice during the landing and drifted left. The aircraft encountered snow along the left side of the…NTSB ATL85LA258Accident · No injuriesLimited investigationFinal reportBeech C23 · Clarksburg, WVThe pilot ran into less than VFR weather and turned around and attempted to make an airport. He became boxed in by weather all around and attempted to land on the highway. He did not make a pss over his intended landing area. When he was on short final, a car…NTSB NYC85LA165Accident · No injuriesLimited investigationFinal reportBeech C23 · Penn Yan, NYThe plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt…NTSB MKC85LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Pratt, KSStudent pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a…NTSB ATL85LA190Accident · No injuriesLimited investigationFinal reportBeech C-23 · Wilmington, NCThe student plt was making a landing at the second arpt of a x-country flt when a controller in the tower observed the acft bounce and spotted the nose gear lying on the rwy. An ELT signal was also received at that time. The student plt made a go-around and…NTSB FTW85LA073Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe acft experienced a power failure while in cruise flight at 1100 ft AGL. He stated that after switching tanks, the 'engine started twice bit failed to continue'. Investigation revealed that the left fuel tank was empty and the right tank had an…NTSB BFO85FA008Accident · No injuriesField investigationFinal reportBeech C23 · Clifton, VAShortly after leveling at the cruise altitude of 2500 ft, the pilot noted a gradual RPM decrease and resultant loss of power. Altitude could not be maintained and the pilot selected a rolling open field in which to land when he realized that reaching an…NTSB SEA84LA194Accident · No injuriesLimited investigationFinal reportBeech C-23 · Adel, ORPlt made forced landing in sagebrush covered hilly terrain following a ttl loss of pwr resulting from fuel exhaustion.NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB LAX84LA388Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chandler, AZThe student plt was on his 1st solo flt. He reported that the acft bounced during a landing, then 'started to head off to the left.' He reported that he 'came in with power & rudder' but the acft went off the rwy & hit a mound of dirt & a fence.NTSB MKC84LA127Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Bloomfield, IAAccording to FAA records, the student plt recieved a wx briefing at 1000 CST. At that time, the latest wx observation at ottumua, IA, (closest wx station to broomfield, IA) showed the wind was from 110 degs at 11 KTS. About 25 mins after the briefing, the…NTSB MKC84LA122Accident · Minor injuriesLimited investigationFinal reportBeech BE23 · Little Rock, ARThe acft crashed into trees during a forced landing. Examination of the acft fuel system after the accident showed less than 1 gallon of fuel in the right tank and about 15 gallons in the left tank. The acft was operated the entire flton the right tank and…NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB NYC84FHM04Accident · Serious injuriesFinal reportBeech C23 · Farmingdale, NJThe plt reported that 'at 450 MSL fuel pressure went to zero. The plt verified the boost pump was on, then the eng quit. He lowered the nose, switched fuel tanks. He could not make runway and saw clearing to the left of the runway. Witnesses reported hearing…NTSB ATL84LA019Accident · No injuriesLimited investigationFinal reportBeech B-23 · Topping, VAThe acft overran the departure end of the rwy and collided with a ditch during landing. The weather was VMC. According to the pilot 2 go-arounds had been made because the acft was high. On the 3rd approach a touchdown was made about 1/2 way down the 2500 ft…NTSB ANC83FA171Accident · No injuriesField investigationFinal reportBeech C-23 · Northway, AKThe acft nose gear collapsed during a forced landing after the engine quit at 300 ft AGL during takeoff. The plt stated the engine quit suddenly with and warning at 300 ft AGL. Witnesses on the arpt said they heard the engine misfiring and backfiring so badly…NTSB DEN83LA196Accident · No injuriesLimited investigationFinal reportBeech C23 · Longmont, COThe student plt, a foreign national, and the instructor plt (CFI) took off from broomfield, CO & flew to Longmont, CO where they began practicing touch & go landings. After the 3rd touch & go landing, the acft was climbing at about 300 ft AGL when the student…NTSB FTW83LA376Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Iowa Park, TXDuring a landing, the acft floated about 1/3 to 1/2 of the way down the rwy before touching down. The plt was unable to stop on the remaining rwy & the acft continued off the end & hit a ditch. An exam of the brakes revealed two discrepancies. The temp was…NTSB FTW83LA337Accident · No injuriesLimited investigationFinal reportBeech C23 · Longview, TXThe acft crashed during a forced landing after the engine quit on the downwwind leg of the traffic pattern. The flt had taken off shortly before with one tank almost full and one almost empty. The fuel selector valve was found in the 'off' position after the…NTSB FTW83LA312Accident · Serious injuriesLimited investigationFinal reportBeech C-23 · Albuquerque, NMThe aircraft impacted 2.2 miles off the departure end of runway 35 at coronada airport. Witnesses stated the aircraft used almost all of the 4020 ft runway before becoming airborne and the aircraft achieved an altitude of only 20 feet. Investigation revealed…NTSB MKC83LA144Accident · No injuriesLimited investigationFinal reportBeech C-23 · Osage Beach, MOThe acft ran off the side of the runway and continued to overrun the departure end of the runway where collision with a ditch occurred. There was evidence that the brakes were used but were not effective in stopping the acft. An FAA inspector inspected the…NTSB ATL83LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Gulfport, MSThe acft made a hard landing, collapsing the nose gear after which a fire started. The pilot had approached the arpt toohigh. The tower recognized this and asked the pilot if he needed to make a 360 degree turn. The pilot did a 360 but was still too high so…NTSB LAX83FVM08Accident · No injuriesFinal reportBeech C23 · Monterey, CAThe student pilot was on his first solo cross-country. The pilot stated that his approach was too high and too fast. The acft landed hard and bounced. As the acft hit a 2nd time the nose gear collapsed and became jammed between fuselage and runway. The…NTSB ATL83LA166Accident · No injuriesLimited investigationFinal reportBeech C-23 · Birmingham, ALThe acft nose gear collapsed during landing on a student solo flt. The student and CFI flew a dual flt first and some airwork and 3 landings were accomplished. The 1st landing after the CFI got out of the acft was nose first with a bounceand a go-around. This…NTSB ATL83LA126Accident · No injuriesLimited investigationFinal reportBeech C-23 · Florence, KYThe nose gear collapsed during landing. The acft was allowed to bounce twice and on the third touchdown the nose gear hit first and collapsed. A post impact fire was confined to the engine compartment and was extinguished by CFR personnel.NTSB ATL83FA083Accident · Serious injuriesField investigationFinal reportBeech C23 · Peachtree City, GAThe eng lost power shortly after the plt was making a takeoff. Subsequently, the acft was badly damaged during a landing in an area of relatively small trees & brush. An exam of the acft revealed there was water in the left fuel tank & carburetor. The fuel…NTSB FTW83LA067Accident · No injuriesLimited investigationFinal reportBeech C23 · Childress, TXDuring flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…NTSB MKC83LA031Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Near Vichy, MOWhile enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…NTSB NYC83FA034Accident · 2 fatalField investigationFinal reportBeech C23 · Hazleton, PAOn 11/28/82, the pilot encountered icing conditions and landed at Hazleton, PA. The aircraft was not deiced at Hazleton and icing conditions continued until the morning of 11/29/82. While departing on 11/29/82, the aircraft was observed to use more than two…NTSB MKC83LA014Accident · No injuriesLimited investigationFinal reportBeech C23 · Des Moines, IAThe pilot executed a forced landing after the engine stopped. The pilot successfully landed the aircraft on a highway, the left wing struck a pole and the aircraft came to rest in a ditch.NTSB LAX83LA010Accident · No injuriesLimited investigationFinal reportBeech C23 · Sedona, AZThe pilot reported that he entered the traffic pattern to land on runway 03 with the wind down the runway at 20, gusting 25 KTS. He made a go-around on his first approach, during the second approach, he encountered a gust of wind, landed hard and the aircraft…NTSB SEA82DA166Accident · No injuriesFinal reportBeech C23 · Yakima, WAThe aircraft was on the last leg of a flight from California to Yakima, Washington. It had not been refueled during a stop at goldendale, Washington. While descending toward Yakima, the pilot reported to the tower that he was out of fuel. During a forced…NTSB LAX82DA340Accident · Serious injuriesFinal reportBeech C23 · Bear Valley, CAThe pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with…NTSB NYC82DA224Accident · Minor injuriesFinal reportBeech C23 · Hammonton, NJThe aircraft lost power at 300 feet after takeoff. The pilot stated he changed the fuel selector and tried a restart. The aircraft began to stall, but the pilot lowered the nose, then rotated to settle into trees. The aircraft flipped inverted. No malfunction…NTSB FTW82DA365Accident · Serious injuriesFinal reportBeech 23 · Fort Worth, TXThe plt stated the stall warning sounded every time he tried to climb & the acft settled into trees. The acft was 7 lbs over max gross weight requiring 2,369 ft to clear a 50 ft obstacle.NTSB ATL82IA245Incident · No injuriesIncident investigationFinal reportBeech C23 · Duluth, GADuring preflight, the pilot found the right aileron front push-pull rod end broken. This defect would have precluded aileron control. Metallurgical examination of the fracture revealed that the part had failed due to reverse bending fatigue as a result of…NTSB FTW82DA317Accident · No injuriesFinal reportBeech C23 · Afton, OKDuring arrival, the pilot landed on runway 36 with a reported tail wind of 10 KTS to 12 KTS. He stated that during the landing, his airspeed was a little too fast and the aircraft bounced. On the second bounce, the aircraft landed on its nose gear and the…NTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…NTSB FTW82FRG34Accident · 1 fatalFinal reportBeech C23 · Port Aransas, TXWitnesses observed the acft on a high final approach to rwy 12 when a go-around was initiated over the rwy at approximately 150 to 200 ft AGL. The acft started a steep banked right turn to a downwind position. The bank continued and the acft descended rapidly…NTSB FTW82DA308Accident · No injuriesFinal reportBeech C23 · Roaring Springs, TXDuring a landing in calm wind conditions, the aircraft continued off the end of the runway and struck a fence. The pilot stated that he had trouble lowering the flaps and that the brakes would not operate properly. During a subsequent inspection, the brakes…NTSB NYC82DA157Accident · No injuriesFinal reportBeech C23 · Pittsburgh, PAThe pilot misjudged his flare and made a hard landing. Sebsequently, the aircraft bounced and came down on right gear which broke off and the aircraft then skidded to a stop on the runway.NTSB NYC82DA158Accident · No injuriesFinal reportBeech C23 · Millbrook, NYWhile on final approach for landing, the student lowered the flaps from 25 degrees to full down, then told the instructor that he as using an unusual amount of back pressure. The instructor checked the trim, it was full nose up at 75 KTS. The instructor then…NTSB LAX82DA257Accident · No injuriesFinal reportBeech C23 · Little River, CAWhile on a solo cross-country, the student attempted to land in a 16 kt, 70 deg crosswind at ukiah, CA. The plane bounced 3 times and drifted off the runway into the dirt knocking out a runway edge light. The student made a go-around and proceeded to Little…NTSB CHI82DA210Accident · No injuriesFinal reportBeech C23 · Strongville, OHThe pilot reported that he had landed long in calm wind conditions at dusk. He stated that he could not stop, and to avoid going off the end of the runway, he tried to ground loop to the left. The aircraft entered a run-up area at the end of the runway where…NTSB FTW82DA215Accident · No injuriesFinal reportBeech C23 · Brinkley, ARDuring a short field takeoff the pilot abruptly raised the nose of the aircraft. The aircraft drifted to the right and stalled. The aircraft crashed in an adjacent wheat field.NTSB ATL82DA135Accident · Minor injuriesFinal reportBeech C23 · Churchville, MDThe pilot stated that he lowered the nose of the aircraft during the approach to expedite his touchdown. He also stated that he did not apply brakes immediately because the aircraft was not firmly on the ground. When he realized he would be unable to stop on…NTSB CHI82DA132Accident · No injuriesFinal reportBeech BE-23 · West Chicago, ILThe pilot stated that during landing flare the aircraft dropped rapidly striking the runway on the main gear. It then bounced back into the air and landed on the nose gear which collapsed.
Back to Beech C23