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 ('1153007')
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 ('1153007')
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 SEA87FA124Accident · 2 fatalField investigationFinal reportBeech 77 · Spokane, WAOn takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled…NTSB MKC87LA041Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Arkadelphia, ARThe student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the…NTSB ANC86LAG05Accident · Minor injuriesFinal reportBeech BE77 · Hope, AKThe acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.NTSB SEA85LA062Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Pasco, WAPlt made full flap apch at idle pwr while practicing a short field landing. Plt stated apch originally was high and later became low. Plt delayed adding pwr and acft touched down 130 ft short of the rwy. Acft bounced and contacted the ground again nose wheel…NTSB LAX85LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · San Martin, CAOn a night pleasure flt the afct's alternator went off line. The plt elected to make an immediate landing at the arpt he was overflying rather than flying to a fld which had operating rwy lights. The fld he was over had a plt-controlled lighting system, but…NTSB CHI85LA012Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Cincinnati, OHThe plt reported that during a landing, he flared too high, the acft entered a high rate of descent & touched down hard. He reported that the nose gear became bent, the acft went off the left side of the rwy & struck a culvert.NTSB NYC84LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · West Mifflin, PAThe acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy.NTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…NTSB CHI84LA072Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Covington, INThe acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained…NTSB CHI84FA054Accident · 1 fatalField investigationFinal reportBeech 77 · Sidney, OHThe aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported…NTSB ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…NTSB NYC83LA134Accident · No injuriesLimited investigationFinal reportBeech 77 · W. Mifflin, PAThe acft landed about 20 ft short of the runway shearing the nose gear and damaging the prop. The student pilot said he encountered a 'small' windshear and he over reacted on the controls causing the acft to contact the ground short of the runway surface.NTSB SEA83FA093Accident · 2 fatalField investigationFinal reportBeech 77 · Renton, WAThe acft was taking off for a 1 hour engine run-in following a top overhaul. After liftoff the engine began a gradual power loss and rough running. The pilot was trying turning back to the runway to land when total power loss occurred. The acft had turned 45…NTSB FTW82DA234Accident · No injuriesFinal reportBeech 77 · Jackson, LAWhile in the vicinity of Jackson, LA, the instructor pilot (ip) had the student make a simulated forced landing. The landing was to be to a full stop on the Jackson airport. According to the initial modification, the student allowed the aircraft to drift left…NTSB MIA82DA108Accident · No injuriesFinal reportBeech 77 · Jacksonville, FLAs the nosewheel touched down during the landing roll, the instructor noted that the wheel was skidding. This was verified when he raised the nosewheel off the ground and the skidding stopped. As the plane decelerated and the nose inevitably dropped, the…NTSB ATL82FKQ06Accident · 2 fatalClosedBeech 77 · Brandon, MSNTSB ATL82DID01Accident · No injuriesClosedBeech 77 · Boones Mill, VANTSB FTW81FPA21Accident · No injuriesClosedBeech 77 · Mckinney, TXNTSB FTW81DRD32Accident · No injuriesClosedBeech 77 · Grand Isle, LANTSB FTW81FPG32Accident · No injuriesClosedBeech 77 · Carlisle, ARNTSB NYC81FFA16Accident · Serious injuriesClosedBeech 77 · Oneonta, NYNTSB FTW81FA002Accident · Serious injuriesClosedBeech 77 · Lonoke, ARNTSB FTW80DRD38Accident · No injuriesClosedBeech 77 · Grand Isle, LA
Back to Beech 77