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 ('1153005')
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 ('1153005')
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 FTW98FA215Accident · 1 fatalField investigationFinal reportBeech 76 · Frisco, TXThe pilot's failure to maintain control resulting in an inadvertent stall while performing simulated single engine maneuvers during a practical test for a multiengine rating.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB BFO94FA120Accident · 2 fatalField investigationFinal reportBeech 76 · Elizabeth, PA1) The failure of the pilot-in-command (CFI) to provide adequate supervision of the dual student during a simulated single-engine approach, and 2) his failure to perform remedial action. This led to a loss of aircraft control in close proximity to the ground.…NTSB LAX94LA092Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Avalon, CAThe pilot's failure to see and avoid the powerlines. A related factor was the pilot's poor judgment in flying at low altitude.NTSB LAX94LA029Accident · No injuriesLimited investigationFinal reportBeech 76 · Livermore, CAthe dual student's improper use of the throttle and the flight instructor's inadequate supervision of the flight.NTSB LAX94LA021Accident · No injuriesLimited investigationFinal reportBeech 76 · Scottsdale, AZthe flight instructor's failure to adequately supervise the flight, follow proper procedures/directives regarding leaning and clearing the idling engine, and his delay in applying power to the idling engine. The fouled spark plugs were a factor in this…NTSB SEA93LA172Accident · No injuriesLimited investigationFinal reportBeech 76 · Portland, ORJamming of the nose landing gear assembly and the pilot-in-command not maintaining the proper glidepath during the nose gear up landing.NTSB ATL93LA035Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Savannah, GAThe pilot's poor preflight and inflight planning.NTSB LAX92FA389Accident · 2 fatalField investigationFinal reportBeech 76 · Mount Shasta, CAThe pilot's improper en route decision to alter his course and to proceed over a mountainous area with inadequate altitude to clear the rising terrain.NTSB NYC92LA178Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Nantucket, MAThe pilot's failure to use carburetor heat, resulting in carburetor ice and loss of engine power and subsequent forced landing in the ocean.NTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.NTSB LAX91LA328Accident · No injuriesLimited investigationFinal reportBeech 76 · Sacramento, CAA fatigue failure of the landing gear strut due to an inadequate design by the manufacturer. Contributing to the accident was maintenance personnel not having completed an inspection of the gear strut, in accordance with the manufacturer's service bulletin.NTSB FTW90LA134Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Gainsville, TXFuel exhaustion due to inadequate planning by the pilot.NTSB MIA90LA079Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Boca Raton, FLImproper remedial action by the pilot. A factor related to the accident was: loss of engine power in the right engine due to an undetermined reason.NTSB FTW90LA076Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Mesquite, TXThe flight instructor's (cfi's) poor planning/decision, and his inadequate supervison of flight.NTSB LAX88FA264Accident · 1 fatalField investigationFinal reportBeech 76 · Portola Valley, CAWhile dining with friends with whom he resided, the pilot told them that he was 'going flying'. At the completion of the flight he would fly over the house before he returned to palo alto airport (pao). The pilot twice circled the residence which is abt 7…NTSB MIA86LA191Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Ft Lauderdale, FLThe plt stated that just as he rotated the acft for takeoff, the cabin door popped open. The acft then struck the ground hard in a nose down attitude, sheared off the main landing gear and slid to a stop on the runwy. According to the emergency procedures in…NTSB SEA86LA101Accident · No injuriesLimited investigationFinal reportBeech 76 · Troutdale, ORThe acft was substantially damaged during a hard landing performed by the multi-enging student during a dual instructional flt.NTSB DEN85LA220Accident · No injuriesLimited investigationFinal reportBeech 76 · Sula, MTPlt stated that he overflew airstrip to 'make sure it was clear.' During the landing roll, he saw shrubbery on the rwy and attempted evasive action. The acft veered left and the left main gear rolled into a drainage ditch and the left wing contacted a fence…NTSB DEN85LA071Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Grand Forks, NDOn Sunday 1/27/85 at approximately 0849 MST, a Beech DUCHESSN1850S, on lease to the university of north dakota crashed after takeoff from the Grand Forks airport, Grand Forks, ND.the student pilot and certified flight instructore were not injured. Two…NTSB NYC84LA112Accident · No injuriesLimited investigationFinal reportBeech 76 · Pittsburgh, PADuring the takeoff portion of a touch-&-go, the student plt forgot to raise the flaps. The instructor (CFI) yelled at the student '...the flaps', & at the same time, reached for the flaps with his right hand under the control wheel. Subsequently, the left…NTSB NYC84FA090Accident · 1 fatalField investigationFinal reportBeech 76 · Beverly, MAA commercially rated plt (student) was receiving multi-eng training from an instructor plt (CFI). The student stated that on final apch to landing, he noticed the airspeed was slow when the CFI shut down the right eng by using the mixture control. The acft…NTSB NYC83FA144Accident · 1 fatalField investigationFinal reportBeech 76 · Moultonboro, NHAfter making an instrument acph to laconia, NH, the plt landed, phoned his wife & advised her of his intention to fly to Moultonboro, NH. After taking off, he advised Moultonboro UNICOM that he had departed laconia & was over a nearby lake, but was having a…NTSB MIA83LA124Accident · No injuriesLimited investigationFinal reportBeech 76 · Pensacola, FLThe acft was landed with the gear retracted after a door opened during takeoff. The pilot stated that at about 100 feet AGL after the gear had been retracted the pilots door came open. According to the pilot the acft became erratic with thedoor banging…NTSB LAX82DA363Accident · No injuriesFinal reportBeech 76 · Big Sur, CAReportedly, a small flock of birds were encountered while cruising at 8000 ft MSL. One or more of the birds struck the cowling and windshield which resulted in a hole in the top right side of the windshield. The pilot diverted and landed at monterey, CA…NTSB SEA82DYK03Accident · Minor injuriesClosedBeech 76 · Sutherlin, ORNTSB DEN81FA012Accident · 1 fatalClosedBeech 76 · Morgan, UTNTSB MKC80DCD24Accident · No injuriesClosedBeech 76 · Sioux City, IANTSB FTW80DPG08Accident · No injuriesClosedBeech 76 · Hot Springs, ARNTSB CHI80FEE08Accident · Minor injuriesClosedBeech 76 · West Chicago, ILNTSB LAX78FA044Accident · 2 fatalClosedBeech 76 · Ramoma, CA
Back to Beech 76