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 ('1152915')
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 ('1152915')
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 CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB ERA19LA123Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · Latrobe, PAA landing gear collapse due to the separation of the actuator pinion bearing support from the actuator, which resulted in the failure of the actuator shaft.NTSB LAX08MA277Accident · 10 fatalMajor investigationFinal reportBeech A100 · Moab, UTThe pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.NTSB LAX08FA026Accident · 2 fatalField investigationFinal reportBeech A100 · Chino, CAThe pilot's failure to maintain a positive climb rate during an instrument takeoff. Contributing to the accident was the low visibility.NTSB CHI06LA062Accident · No injuriesLimited investigationFinal reportBeech A100 · Sault Ste Marie, MIThe inadequate in-flight decision to continue the approach to land, directional control not maintained, and the contaminated runway. Contributing factors were flight to destination alternate not performed, a notice to airman not issued by airport personnel…NTSB ATL03LA081Accident · No injuriesLimited investigationFinal reportBeech A100 · Carrollton, GAThe pilot misjudged the approach and touchdown airspeeds that resulted in the overrun of the runway during a landing. Factors were the wet runway and hydroplaning conditions.NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB FTW02LA172Accident · No injuriesLimited investigationFinal reportBeech BE-100-A100 · Little Rock, ARThe malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.NTSB FTW98FA074Accident · 2 fatalField investigationFinal reportBeech A100 · Colo Springs, COFailure of the pilot to follow IFR Procedures and maintain the minimum descent altitude (MDA). A related factor was fog.NTSB NYC94FA148Accident · 1 fatalField investigationFinal reportBeech A100 · Williamstown, MAthe pilot's failure to maintain minimum control speed after an undetermined loss of engine power, which resulted in an inadvertent stall at too low of an altitude to allow recovery.NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB NYC89LA103Accident · No injuriesLimited investigationFinal reportBeech A100 · Johnstown, PAFailure of the down lock plate, which allowed the landing gear to collapse.NTSB MIA87LA027Accident · Minor injuriesLimited investigationFinal reportBeech A100 · Brooksville, FLThe pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…NTSB ATL86LA019Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Sylacauga, ALDuring takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted.NTSB FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…NTSB MIA78FKJ53Accident · Serious injuriesClosedBeech 100 · Muscle Shoals, ALNTSB CHI78FEI03Accident · No injuriesClosedCessna 210 · Vienna, OHNTSB MIA75AM016Accident · 6 fatalClosedBeech A100 · Hilton Head Is, SC
Back to Beech A100