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 ('1153604')
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 ('1153604')
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 ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…NTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12WA646Accident · No injuriesForeign investigationBeech A60 · Hyères, FranceNTSB ERA11LA361Accident · No injuriesLimited investigationFinal reportBeech A60 · Pompano Beach, FLThe pilots of both airplanes did not maintain adequate visual lookout during taxi, which resulted in an on-ground collision.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB LAX04CA212Accident · No injuriesData collectionFinal reportBeech A60 · Gualala, CAthe pilot's inadequate in-flight planning which resulted in a downwind landing. The tailwind was a contributing factor and an overrun of the runway.NTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.NTSB DEN00IA076Incident · No injuriesIncident investigationFinal reportBeech A60 · Englewood, COThe failure of a number one cylinder connecting rod bolt due to under-torquing during engine major overhaul.NTSB DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.NTSB FTW95LA119Accident · No injuriesLimited investigationFinal reportBeech 60 · Santa Rosa, NMThe failure of the right engine's turbocharger resulting in oil starvation and subsequent failure of the #5 connecting rod which penetrated the crankcase, and the failure of the left engine's turbocharger resulting in the loss of power on both engines.…NTSB FTW95FA082Accident · 3 fatalField investigationFinal reportBeech A60 · Hurley, NMThe pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…NTSB SEA93FA026Accident · 6 fatalField investigationFinal reportBeech A60 · Snoqualmie Pass, WAFailure of the pilot to maintain control of the aircraft, his failure to prevent the aircraft from exceeding the never exceed speed (vne), and subsequent exceeding of the design stress limits of the aircraft. Factors related to the accident were: weather…NTSB CHI89LA072Accident · No injuriesLimited investigationFinal reportBeech A60 · Indianapolis, INThe pilot misjudged altitude and/or distance to the runway wile on final approach to land. Factors related to the accident were: dark night and pilot fatigue.NTSB BFO89FA022Accident · 5 fatalField investigationFinal reportBeech A60 · Manassas, VAA loss of aircraft control due to the pilot's failure to maintain minimum engine control speed after a partial loss of power of the left engine for undetermined reasons. The pilot's inexperience in type of aircraft and an over maximum gross weight aircraft…NTSB MKC88LA121Accident · No injuriesLimited investigationFinal reportBeech A-60 · Lexington, MOThe pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway.NTSB LAX87FA257Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, CAPilot's failure to maintain adequate airspeed on final approach which resulted inthe aircraft stalling.NTSB FTW82FPM08Accident · Minor injuriesClosedBeech A60 · Tulsa, OKNTSB ATL81FA049Accident · Minor injuriesClosedBeech A60 · Davis, WVNTSB LAX81FVG13Accident · No injuriesClosedBeech A60 · Sacramento, CANTSB SEA81FA008Accident · 6 fatalClosedBeech A60 · Driggs, IDNTSB ATL81IA009Incident · No injuriesClosedBeech A60 · Leaksville, MSNTSB MIA79DKT73Accident · Minor injuriesClosedBeech A60 · Belle Glade, FLNTSB DEN76FTC03Accident · No injuriesClosedBeech A60 · Afton, WYNTSB OAK75AP029Accident · 5 fatalClosedBeech A60 · Mammoth Lakes, CANTSB FTW74AF003Accident · 3 fatalClosedBeech A60 · New Orleans, LANTSB DEN73FQA06Accident · No injuriesClosedBeech A60 · Roy, NMNTSB NYC68D0191Accident · No injuriesClosedBeech 65-90 · Montauk Point, NY
Back to Beech A60