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 ('1151604')
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 ('1151604')
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 LAX84LA430Accident · No injuriesLimited investigationFinal reportBeech A36 · Van Nuys, CAThe acft landed 'gear up' during practice takeoffs and landings. The plt stated that he 'forgot' to extend the landing gear prior to landing. The tower had given him instructions to 'make a short approach.' No mechanical problems were reported.NTSB ATL84FA184Accident · 1 fatalField investigationFinal reportBeech A36 · Fayette, ALThe acft collided with the ground in a near vertical nose down attitude after being observed by witnesses to pitch down during cruise flt. This acft & plt flew earlier in the day with an instructor who had to recover control of the acft after the plt allowed…NTSB CHI84LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Minneapolis, MNThe acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare.NTSB ATL84FA106Accident · 2 fatalField investigationFinal reportBeech A36 · Hamilton, ALThe acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…NTSB LAX84FA183Accident · No injuriesField investigationFinal reportBeech A36 · Santa Monica, CAThe plt stated that after takeoff, the electrical sys failed as he retracted the gear. He elected to return to the arpt & land. Shortly thereafter, the eng lost power. He further stated that he hand cranked the gear to the down position & received a light…NTSB DEN84FA076Accident · 2 fatalField investigationFinal reportBeech A36 · Columbus, NMThe plt took off at night in the company of plts flying 2 other acft, a Cessna 150 & a Piper PA-22. N719K, a Beech A36 bonanza, was flying ahead of the other 2 acft. The plt of 1 of the other acft stated that the bonanza plt would usually fly at a slower…NTSB LAX84LA156Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Victorville, CAThe acft landed gear up during a forced landing after the engine quit on takeoff. The plt thinks he left the fuel selector in an improper position after showing a customer the alternate location of the tip tank indicator switch.NTSB ATL84FA078Accident · 2 fatalField investigationFinal reportBeech BE-36 · St. Catherines, GAThe plt received a wx briefing at 1037 EST before departing on an IFR x-country. At 1051, a severe thunderstorm warning (#537) was issued by the national wx svc. When the plt requested an IFR clearance at 1107, he was advised of the frontal activity. About 3…NTSB FTW84LA097Accident · No injuriesLimited investigationFinal reportBeech A-36 · Harrison, ARThe acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the…NTSB MKC84FA036Accident · No injuriesField investigationFinal reportBeech A36 · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…NTSB ATL84FA059Accident · 3 fatalField investigationFinal reportBeech A36 · Gulfport, MSPrior to the approach the plt was advised that the wx was sky obscured & visibility 1/4 mi in fog. The plt acknowledged 'roger we'll come on in and give it a shot.' The acft collided with trees about 500 ft short of the middle marker. It was reported that the…NTSB ATL84AA053Accident · 6 fatalFinal reportBeech A36 · Armuchee, GAThe acft collided with trees and higher terrain which was adjacent to the VOR approach path. The weather was described by witnesses as stormy with heavy rains and high winds. Some of the occupants of the accident acft were airsick according to the plts radio…NTSB MKC84LA023Accident · No injuriesLimited investigationFinal reportBeech A-36 · Satanta, KSThe pilot said he was approaching to land and was low on approach. As the aircraft crossed the end of the runway, the left main gear touched down, striking what was described as a curb about 1 foot from the edge of the runway, substantially damaging the left…NTSB CHI84LA038Accident · No injuriesLimited investigationFinal reportBeech A36 · Columbus, OHOn the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a…NTSB ATL84LA022Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Greensboro, NCThe acft lost power during the climb to cruise. The plt made a forced landing and collided with trees. The fuel selectorwas on the empty left tank. The right tank contained 20 gallons of fuel. The plt did not check the fuel selector prior to takeoff and did…NTSB LAX83LA440Accident · No injuriesLimited investigationFinal reportBeech A36 · Redding, CAReportedly, during the landing roll, the acft settled while the gear was in transit. At that time, the flaps were in the down position & were damaged. According to the plt, the gear lights were green. Later, he said that something may have gone wrong with the…NTSB FTW83FA310Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKPrior to takeoff the plt was advised the winds were from 180 deg at 20 KTS gusting to 27 KTS. During takeoff from rwy 17THE plt advised the tower that he was 'bringing it around to land on 30.' When asked if he was experiencing any difficulties the plt…NTSB ATL83LA192Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Stanton, KYWhile on final apch to land, the eng lost power when the acft was at aprx 300 ft AGL. The plt stated that he switched fuel tanks & retracted the landing gear & flaps in an effort to reach the rwy. When he saw that he could not glide to the rwy, he turned to…NTSB CHI83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Minonk, ILThe plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from…NTSB DEN83AA105Accident · 3 fatalFinal reportBeech A36 · Rock Springs, WYThe aircrew of a Cessna 340, N5415M, were scheduled for an air taxi check ride with an inspector at jackson, WY, later in the afternoon. They had planned to takeoff from Rock Springs, WY, practice a few instrucment apchs at Rock Springs, then proceed to…NTSB FTW83FA060Accident · 4 fatalField investigationFinal reportBeech A36 · Carlsbad, TXThe pilot and passengers had departed the san angelo airport at about 1800 CST on the day of the accident. They stopped at midland, TX where they borrowed a courtesy car and drove to a restaurant. Later, the aircraft departed on a return flight. At about 2320…NTSB ATL83LA056Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Holly Springs, MSThe acft was at 4,000 ft in cruise flight when the eng failed. The acft crashed 1/4 mi short of an arpt. The right wing bladder was completely torn in two & the left wing bladder contained a minute amount of fuel. There was reportedly a lot of fuel spillage…NTSB FTW83FA054Accident · 2 fatalField investigationFinal reportBeech A36 · Midland, ARWhen the plt filed his VFR flt plan he was observed using an IFR enroute chart. About 7 minutes after takeoff the plt requested a frequency to call for a clearance to climb on top of the overcast. Approximately 5 minutes later, as the plt was giving his…NTSB ANC83LA013Accident · No injuriesLimited investigationFinal reportBeech A36 · Fort Yukon, AKDuring a night approach to runway 03 at Fort Yukon, AK, the pilot neglected to activate the runway lights, as prescribed on the jeppeson approach chart, and mistook a row of white lights on buildings as the runway lights. Upon landing on a parking ramp the…NTSB FTW82DA369Accident · No injuriesFinal reportBeech A36 · Shawnee, OKLanding gear collapsed during landing roll.NTSB LAX82DA266Accident · No injuriesFinal reportBeech A36 · Grand Canyon, AZThe aircraft dragged a wingtip during an aborted takeoff and swerved off the runway. The density altitude was 8200 feet. The pilot said he could not maintain a climb so he lowered the landing gear to abort the takeoff and lost control of the aircraft. The…NTSB FTW82DA283Accident · No injuriesFinal reportBeech A36 · Port O'Connor, TXThe pilot decided to land at an airstrip that he had landed at about 3 years previously. Before landing, he made a 500 ft pass over the strip. He reported that the sun and glare were bright. He saw white spots on the strip, but thought they were filled-in…NTSB ATL82DA165Accident · Minor injuriesFinal reportBeech A36 · Myrtle Beach, SCAs the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was…NTSB MKC82FA075Accident · Serious injuriesField investigationFinal reportBeech A36 · Smithville, MOThe plt reported a loss of power & unable to reach the arpt. The acft collided with trees during the forced landing & then landed hard, gear up, in a farmyard. Examination revealed that the left fuel tank was empty. The right fuel tank was full & the fuel…NTSB ATL82FKG10Accident · 2 fatalFinal reportBeech A36 · Darien, GAThe pilot filed a VFR flight plan, but did not activate it after takeoff. While en route, he encountered deteriorating weather and obtained an IFR clearance. As he continued, he entered an area of thunderstorms, turbulence, and heavy rain. As the pilot was…NTSB DEN82FTM09Accident · 1 fatalFinal reportBeech A36 · St. George, UTThe aircraft was on a flight from las vegas, Nevada to St. George, Utah when it flew past the destination and struck the side of a mountain. The crash site was located about 15 miles beyond the destination at an elevation of about 7600 ft MSL. The site was…NTSB FTW82DRG15Accident · Minor injuriesClosedBeech A-36 · Portland, TXNTSB ANC82DA003Accident · Minor injuriesClosedBeech A36 · Quinhagak, AKNTSB NYC81FHJ19Accident · No injuriesClosedBeech A36 · White Plains, NYNTSB FTW81DPJ41Accident · No injuriesClosedBeech A36 · Stillwater, OKNTSB LAX81DVA43Accident · No injuriesClosedBeech A36 · Bakersfield, CANTSB FTW81FA077Accident · 1 fatalClosedBeech A36 · Houston, TXNTSB SEA81FA021Accident · 2 fatalClosedBeech A36 · Eugene, ORNTSB LAX81FA034Accident · 6 fatalClosedBeech A36 · Peach Springs, AZNTSB MKC81FA013Accident · No injuriesClosedBeech A36 · Kaizer, MONTSB LAX81IA011Incident · No injuriesClosedBeech A36 · Oroville, CANTSB NYC80FNC36Accident · Minor injuriesClosedBeech A36 · Laconia, NHNTSB LAX80DUG51Accident · No injuriesClosedBeech A36 · Upland, CANTSB DEN80FTM35Accident · No injuriesClosedBeech A-36 · America Fork, UTNTSB LAX80FA100Accident · 1 fatalClosedBeech A36 · Los Banos, CANTSB LAX80DUJ64Accident · No injuriesClosedBeech A-36 · Parker, AZNTSB IAD80DKM14Accident · No injuriesClosedBeech A36 · Albemarle, NCNTSB DEN80DTM11Accident · No injuriesClosedBeech A36 · Huntington, UTNTSB FTW80FRG33Accident · No injuriesClosedBeech A-36 · Los Fresnos, TXNTSB FTW80FRA20Accident · Minor injuriesClosedBeech A36 · Bryan, TX
Back to Beech A36