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 ('1153402')
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 ('1153402')
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 ERA26LA045Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edgewater, FLThe pilot’s failure to extend the landing gear prior to landing.NTSB WPR24LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Yuma, AZAeroelastic flutter of the rudder control surface during the takeoff initial climb for reasons that could not be determined based on the available evidence, which resulted in the fracture of the rudder trim control rod end in flight.NTSB CEN23LA243Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edna, TXThe pilot’s failure to maintain directional control during a precautionary off-field landing.NTSB WPR23LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Bremerton, WAFailure of the down limit and down indicator switch and the warning horn switch assemblies, which prevented the landing gear from extending and at the same time providing a false indication that the landing gear was extended.NTSB CEN10LA188Accident · Serious injuriesLimited investigationFinal reportBeech 95 · Eden Prairie, MNThe fatigue failure of an intake valve spring on the right engine, which resulted in a partial loss of engine power on takeoff.NTSB LAX06CA119Accident · No injuriesData collectionFinal reportBeech 95 · Kingman, AZthe flight instructor's failure to perform the before landing checklist and extend the landing gear prior to touchdown. A contributing factor was the pilot's diverted attention with another airplane that had departed from the opposite runway.NTSB LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.NTSB LAX03FA074Accident · 1 fatalField investigationFinal reportBeech 95 · Rancho Cucamong, CAThe fracture and separation of a propeller blade during cruise flight due to fatigue and corrosion pits in the blade pilot bore, and an improper overhaul of the separated propeller by repair station personnel. Factors contributing to the accident were the…NTSB LAX03FA057Accident · 1 fatalField investigationFinal reportBeech 95 · Tucson, AZa loss power in the right engine due to an excessively rich mixture that was the result of the pilot's failure to secure the priming control prior to takeoff. Also causal was the pilot's failure to follow the single engine procedures specified in the…NTSB LAX02LA047Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in the gear-up landing.NTSB LAX00LA218Accident · No injuriesLimited investigationFinal reportBeech 95 · Sun Valley, AZThe certified flight instructor's (pilot-in-command) inadequate supervision of his dual student, who prematurely retracted the landing gear.NTSB LAX99LA095Accident · No injuriesLimited investigationFinal reportBeech 95 · Henderson, NVa loss of power in one engine due to the student pilot inadvertently selecting the off position on one fuel selector valve while accomplishing the prelanding checklist. The instructor's inadequate supervision of the flight was also causal.NTSB MIA98LA171Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) on final approach resulting in an inadvertent stall.NTSB NYC98LA096Accident · No injuriesLimited investigationFinal reportBeech C-50 · Ford, VAA loss of engine power simultaneously on both engines as reported by the pilot, for undetermined reasons.NTSB FTW97LA157Accident · No injuriesLimited investigationFinal reportBeech BE-95 · San Antonio, TXThe failure of the right main gear due to improper repair by the company maintenance personnel.NTSB FTW96TA021Accident · No injuriesFinal reportBeech 95 · Albuquerque, NMThe pilot's improper inflight decision to make a landing on an unlit runway and his failure to maintain directional control of the airplane. Factors were the inoperative runway lights, bright lights from surrounding areas, and the pilot's attention being…NTSB NYC95LA059Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Millbrook, NYThe pilot's failure to manually extend the landing gear which resulted in the landing gear collapsing. A factor was the intermittent loss of electrical power.NTSB CHI94FA002Accident · 2 fatalField investigationFinal reportBeech 95 · Roodhouse, ILwas the inadequate supervision by the flight instructor which resulted in the inadvertent stall/spin by the student.NTSB CHI91FA291Accident · 2 fatalField investigationFinal reportBeech 95 · Killdeer, NDThe pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…NTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.NTSB LAX91LA123Accident · No injuriesLimited investigationFinal reportBeech B95 · Riverside, CAFailure of the pilot to follow the emergency gear extension procedure to fully extend the landing gear. Contributing to the accident was the failure of the pilot to monitor the condition of the electrical power system, leading to the complete loss of…NTSB ATL91FA035Accident · 1 fatalField investigationFinal reportBeech B95 · Austell, GAThe loss of engine power which resulted from the pilot's failure to properly use the carburetor heat. The pilot failed to maintain flying speed during the emergency descent which resulted in a stall on final approach. A factor in the accident was weather…NTSB FTW90LA025Accident · No injuriesLimited investigationFinal reportBeech 95 · Floydada, TXFailure of the propeller attachment bolts due to fatigue in four of the bolts and overload in another. A contributing factor was the loss of electrical power and the deteriorated airplane control/preformance.NTSB LAX89FA050Accident · 1 fatalField investigationFinal reportBeech 95 · Milpitis, CAThe pilot failed to maintain altitude while performing a maneuver.NTSB LAX87FA331Accident · 3 fatalField investigationFinal reportBeech 95 · Monterey, CAThe coml plt was rcvg mult-eng dual instrn in a Beech 95. After tkof, the aircrew began practicing inst apchs. After making an ILS rwy 10 apch to enter left traffic for rwy 28, the flt was clrd onto a south downwind to be sequenced to follow a psa BAE-146.…NTSB ATL86LA246Accident · No injuriesLimited investigationFinal reportBeech 95 · Springfield, TNThe instructional flt had been in the air for about 45 min when the instructor told the plt to return to the arpt and land. Upon entering the traffic pattern the plt was told to make a touch and go landing. He completed two of these maneuvers and was…NTSB MIA86LA116Accident · No injuriesLimited investigationFinal reportBeech BE-95 · Hollywood, FLThe acft had not been flown in over 2 yrs & the last annual inspection was performed 1-25-83. The acft had to be jump started due to a dead battery. During ldg roll-out, the gear collapsed. An exam of the bottom of the acft revealed damage consistent with the…NTSB FTW85LA253Accident · Serious injuriesLimited investigationFinal reportBeech 95 · New Braunfels, TXThe instructer pilot and student single engine rated pilot were practicing single eng full stop landings. The acft was on final apch with the right eng shut down and the prop feathered. A vehicle was observed near the rwy. The instructor directed a go-around.…NTSB NYC84FA234Accident · 2 fatalField investigationFinal reportBeech 95 · Shelter Island, NYAcft level abt 3000 ft. engines sputtered. Acft descended in uncontrolled attitude. Tach 6.9 hrs since last fueling. Acft did not have shoulder harness or metal to metal seat belt buckle for pilot and copilot seats. Pilot biennial and medical not currentNTSB CHI82DA111Accident · Serious injuriesFinal reportBeech 95 · Pontiac, MIIt was dark and the temperature was about 20 degrees when the pilot and two passengers arrived at the plane. The pilot had started the right engine before the passengers arrived, but the left engine failed to start in the cold temperature. The pilot was…NTSB DEN82FA011Accident · 4 fatalClosedBeech 95 · Cedar City, UTNTSB ATL82FLJ02Accident · Serious injuriesClosedPiper PA-24 · Chapel Hill, NCNTSB CHI82FA002Accident · 1 fatalClosedBeech B95A · Bedford Park, ILNTSB LAX80FA127Accident · 4 fatalClosedBeech 95 · Rubidoux, CANTSB MKC80FCG06Accident · Serious injuriesClosedBeech B-95 · Leawood, KSNTSB MKC79DA053Incident · No injuriesClosedBeech 95 · St Charles, MONTSB MIA79FA093Accident · 1 fatalClosedBeech 95 · Leesburg, FLNTSB OAK79AA020Accident · 4 fatalClosedBeech 95 · Elko, NVNTSB MIA79FA005Accident · 3 fatalClosedBeech 95 · Madison, ALNTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTNTSB IAD77FA054Accident · 3 fatalClosedBeech 95 · Fletcher, NCNTSB MIA77FLA05Accident · No injuriesClosedBeech B95 · Gainesville, FLNTSB NYC77FA002Accident · 1 fatalClosedBeech B95A · Frankfort, NYNTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MINTSB NYC76DFA41Accident · No injuriesClosedBeech 95 · Wallkill, NYNTSB FTW76AF095Accident · 3 fatalClosedBeech 95 · Ardmore, OKNTSB MIA76AM069Accident · 2 fatalClosedBeech B95 · Fort Pierce, FLNTSB CHI75AC061Accident · 2 fatalClosedBeech 95 · Waterford, WINTSB MKC75AK041Accident · 1 fatalClosedBeech 95 · Cape Girardeau, MONTSB NYC75FGM20Accident · No injuriesClosedBeech A95 · Farmingdale, NY
Back to Beech 95