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 ('1380108')
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 ('1380108')
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 CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportBoeing 75 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.NTSB CEN21FA424Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75 · Delta, COThe pilot’s loss of control during an aerobatic maneuver, resulting in the airplane impacting terrain.NTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.NTSB CEN13CA457Accident · No injuriesData collectionFinal reportStearman A75 · Appleton, WIThe pilot’s inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB SEA07LA213Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Spokane, WAThe locking/seizing of a main landing gear brake mechanism during the landing roll.NTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI04LA243Accident · 1 fatalLimited investigationFinal reportBoeing A75 · Wisconsin Rapid, WIThe pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.NTSB CHI03LA274Accident · No injuriesLimited investigationFinal reportBoeing A-75 · La Crosse, WIThe total loss of engine power due to a fatigue fracture of the engine's crankshaft. A factor was the corn crop.NTSB CHI01LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman A-75 · Marissa, ILThe pilot's manuever to avoid obstructions and his failure to abort takeoff. The pilot's failure to establish adequate climb, and the transmission wire are contributing factors.NTSB LAX00LA119Accident · No injuriesLimited investigationFinal reportStearman A-75 · Imperial, CAThe failure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB DEN99FA109Accident · 1 fatalField investigationFinal reportBoeing Stearman A75 · Carpenter, WYPilot incapacitation for unknown reasons.NTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).NTSB FTW94LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75 · Comfort, TXThe pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.NTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB SEA91LA102Accident · Minor injuriesLimited investigationFinal reportBoeing A-75 · Seattle, WAThe pilot did not maintain directional control during the landing roll. The factor to the accident was: the pilot's remedial action was inadequate.NTSB FTW89DRA05Accident · Minor injuriesFinal reportBoeing A75 · East Bernard, TXWater in fuel from improper servicing of the aircraft and improper preflight by the pilot. The tailwind & soft/wet terrain were contributing factors.NTSB LAX89LA090Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Huntington Bch, CAThe pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors.NTSB LAX86LA215Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Angels Camp, CANumerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportBoeing A75 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB FTW82FRA19Accident · 1 fatalFinal reportBoeing A75 · Chapell Hill, TXDuring a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.NTSB MIA80DLD73Accident · No injuriesClosedBoeing A75 · Williston, FLNTSB MKC79FER62Accident · Serious injuriesClosedBoeing A75 · Austin, MNNTSB MKC79DCG62Accident · No injuriesClosedBoeing A75 · Effingham, KSNTSB OAK78FVM11Accident · No injuriesClosedBoeing A75 · Sn Jun Batsta, CANTSB LAX77DUJ97Accident · No injuriesClosedBoeing E75 · Marana, AZNTSB FTW77DRJ11Accident · No injuriesClosedBoeing A75 · Marksville, LANTSB FTW77FFA22Accident · 1 fatalClosedBoeing E75N1 · Beaumont, TXNTSB OAK76FVA92Accident · 1 fatalClosedBoeing A75 · Parlier, CANTSB OAK76DVA79Accident · No injuriesClosedBoeing A75 · Tulare, CANTSB OAK76FJA02Accident · 1 fatalClosedBoeing A75N1 · Koloa, HINTSB SEA76FYA09Accident · Serious injuriesClosedBoeing PT-17 · Idaho Falls, IDNTSB LAX75FVA63Accident · Serious injuriesClosedBoeing A75 · Wasco, CANTSB FTW75DRA23Accident · No injuriesClosedBoeing A75 · Nome, TXNTSB OAK75FVG55Accident · 1 fatalClosedBoeing A75 · Williams, CANTSB FTW75DRJ25Accident · Minor injuriesClosedBoeing A75 · Tallulah, LANTSB FTW75FQG32Accident · No injuriesClosedBoeing A75 · Roaring Sprgs, TXNTSB OAK75IP019Incident · No injuriesClosedBoeing 747 · Honolulu, HINTSB SEA75DYA09Accident · No injuriesClosedBoeing A75 · Shelley, IDNTSB MIA75DKJ07Accident · No injuriesClosedBoeing A75 · Marion, ALNTSB FTW74DRA41Accident · Minor injuriesClosedBoeing A75 · El Campo, TXNTSB OAK74FVA48Accident · Minor injuriesClosedStearman A75 · Visalia, CANTSB OAK74FVA44Accident · No injuriesClosedBoeing A75 · Kerman, CANTSB OAK74FVG27Accident · No injuriesClosedBoeing A75 · Clarksburg, CANTSB FTW74DPM08Accident · No injuriesClosedBoeing A75 · Coleman, OKNTSB FTW74DPG08Accident · No injuriesClosedBoeing A75 · Conway, ARNTSB FTW74FRA01Accident · No injuriesClosedBoeing A75 · Winnie, TXNTSB OAK73DVA63Accident · Minor injuriesClosedBoeing A75N1 · Kingsburg, CANTSB FTW73FRD27Accident · No injuriesClosedBoeing A75 · Crowley, LA
Back to Boeing A75