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 ('1152012')
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 ('1152012')
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 WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.NTSB ERA12FA062Accident · 2 fatalField investigationFinal reportBeech D-45 · Williston, FLThe flight instructor's failure to maintain airspeed in changing wind conditions during a steep climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor’s ostentatious display close to the ground.NTSB FTW03TA087Accident · Serious injuriesFinal reportBeech T-34B · Hammond, LAThe pilot's inadequate inflight planning/decision resulting in fuel exhaustion and the loss of engine power. A contributing factor was the night light conditions.NTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.NTSB LAX02LA077Accident · No injuriesLimited investigationFinal reportBeech T-34B/D-45 · San Simeon, CAthe pilot's inadequate preflight of the airplane in which he failed to close the fuel drain resulting in a fuel leak and fuel exhaustion.NTSB LAX01FA178Accident · 2 fatalField investigationFinal reportBeech D45 · Julian, CAThe pilot's selection of an insufficient altitude over rising mountainous terrain and his failure to maintain adequate terrain clearance.NTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.NTSB CHI00FA003Accident · 1 fatalField investigationFinal reportBeech T-34 · Oswego, ILthe visual lookout not obtained by the pilot of the Beech T-34 and the inadequate procedure by the Lima Lima Flying Squadron. The delayed entry into the maneuver by the pilot of the Beech D-45 was a contributing factor.NTSB LAX99LA202Accident · No injuriesLimited investigationFinal reportBeech D-45 · Lake Berryessa, CALoss of engine power due to a loose adjustment nut on the engine driven fuel pump that allowed for a decrease in fuel flow and fuel pressure, and the subsequent failure of the electric fuel boost pump due to loose bearings decreasing fuel flow and fuel…NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB MIA97FA034Accident · 2 fatalField investigationFinal reportBeech D-45 · Poplarville, MSthe noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…NTSB ATL91LA037Accident · No injuriesLimited investigationFinal reportBeech T-34B · Cartersville, GAThe dual student allowed the airplane to stall because of improper use of the throttle, which resulted in a touch down short of the proper point. A factor in the accident was the inadequate supervision by the flight instructor.NTSB BFO87LA002Accident · No injuriesLimited investigationFinal reportBeech D-45 (T-34B) · Patuxent River, MDThe purpose of the flt. Was to check out the 11800 hour former naval aviator who stated he had previous experience in T-34B'S. The CFI, who had over 3000 hours, 173 in make and model but less as an instructor, stated he briefed the student on procedures and…NTSB LAX84LA419Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Laveen, AZDuring flt on the downwind leg of the traffic pattern the plt inadvertantly knocked the ignition switch to the 'off' position. Since the prop stopped and the acft was not equipped with a starter, the acft engine could not be restarted. The acft landed 20 ft…NTSB LAX82FVA13Accident · 1 fatalFinal reportBeech T-34B · Lemoore, CAThe T-34 pilot entered a downwind behind a Cessna 150 aircraft. When the T-34 pilot was abeam the approach end of runway 32R, he was cleared for a touch and go. By this time, the Cessna 150 was on the runway. The Cessna pilot requested a 180 degree turn to…NTSB LAX80FUA20Accident · Minor injuriesClosedBeech T-34B · Newport Beach, CANTSB LAX78DUQ36Accident · No injuriesClosedBeech D45 · China Lake, CANTSB FTW78FPA14Accident · Minor injuriesClosedBeech D45 · Cedar Hills, TXNTSB MIA77FLA13Accident · No injuriesClosedBeech T-34B · Jacksonville, FLNTSB LAX77FA008Accident · 1 fatalClosedBeech D-45 · Avalon, CANTSB MKC76FCG07Accident · Minor injuriesClosedBeech D45 · Olathe, KSNTSB MIA75DLA08Accident · No injuriesClosedBeech D45 · Jacksonville, FLNTSB CHI74FEP44Accident · 1 fatalClosedBeech T34B · Wautoma, WINTSB OAK72DVA54Accident · No injuriesClosedBeech T-34B · Hanford, CANTSB LAX72FUJ18Accident · No injuriesClosedBeechcraft T-34B · Yuma, AZNTSB MIA71DKD08Accident · No injuriesClosedBeech T-34B · Arlington, TNNTSB IAD70DLJ03Accident · Minor injuriesClosedBeech T-34B · New Bern, NCNTSB FTW70DPA14Accident · No injuriesClosedLuscombe 8A · Cedar Hill, TXNTSB UNK69X0125Accident · 1 fatalClosedBeech T-34B · Atsugi Nas, JANTSB FTW69A0082Accident · 2 fatalClosedBeech T-34B · Bishop, TXNTSB UNK68X0109Accident · No injuriesClosedBeech D45 · Manila (Pacific Ocean)NTSB CHI67A0617Accident · No injuriesClosedBeech D45 · Negaunee, MINTSB MKC66F0249Accident · Minor injuriesClosedBeechcraft T-34 · Dearborn, MONTSB LAX66D0115Accident · No injuriesClosedBeechcraft A45 · Santa Ana, CANTSB UNK65X1330Accident · No injuriesClosedBeechraft T34B · Corpus Christi, TXNTSB UNK65X1197Accident · No injuriesClosedBeechraft T34B · Jacksonville, FLNTSB UNK65X0609Accident · No injuriesClosedBeechcraft T34 · Arlington, TXNTSB UNK64X3470Accident · No injuriesClosedBeechcraft D45 · New Orleans, LANTSB UNK64X1287Accident · No injuriesClosedBeechcraft D45 · Ft Worth, TXNTSB UNK64X0981Accident · No injuriesClosedBeechcraft B45 · Corpus Christi, TXNTSB UNK64X0810Accident · No injuriesClosedBeechcraft D45 · Corpus Christi, TXNTSB UNK64X0620Accident · No injuriesClosedBeechcraft T34 · Jacksonville, FL
Back to Beech D-45