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 ('1150538')
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 ('1150538')
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 WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.NTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.NTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.NTSB CEN17LA301Accident · No injuriesLimited investigationFinal reportBeech D17S · Colorado Springs, COThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.NTSB GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.NTSB GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.NTSB WPR13CA031Accident · No injuriesData collectionFinal reportBeech D17S · Van Nuys, CAThe pilot of another airplane did not maintain a proper visual lookout during taxi, which resulted in an on-ground collision.NTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.NTSB CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB SEA99LA127Accident · No injuriesLimited investigationFinal reportBeech D17S · Arco, IDFuel starvation which resulted in a loss of power. The pilot's improper management of fuel was a factor.NTSB LAX98LA015Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Chino, CAfuel starvation resulting from the pilot's inadequate in-flight planning and improper fuel management. Contributing factors were the nighttime conditions and the rough/uneven terrain.NTSB CHI94LA235Accident · No injuriesLimited investigationFinal reportBeech 17 · Elgin, NEthe pilot's failure to maintain clearance with the road sign. Factors in the accident were the sign and the failure of the landing gear to extend into the full down and locked position.NTSB LAX92LA391Accident · No injuriesLimited investigationFinal reportBeech D17S · Reno, NVThe pilots failure to maintain directional control during landing rollout. Contributing to the accident was a variable tailwind condition and the soft, rough nature of the terrain.NTSB LAX92LA339Accident · No injuriesLimited investigationFinal reportBeech D17S · Bishop, CAThe pilot's failure to maintain directional control; improper use of the rudder and excessive braking. Contributing to this accident was the pilot's lack of experience in the accident airplane make and model.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.NTSB LAX89DUM04Accident · No injuriesFinal reportBeech D175 · El Cajon, CAInadequate visual lookout by the pilot of the other aircraft (N9645H).NTSB DEN88FA114Accident · 2 fatalField investigationFinal reportBeech D-17S · Wheatland, WYThe witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…NTSB ATL87LA048Accident · No injuriesLimited investigationFinal reportBeech D-17-S · Louisville, KYFollowing a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation…NTSB FTW84LA236Accident · No injuriesLimited investigationFinal reportBeech D17S · Stratford, TXThe pilot stated after the accident that the engine failure occurred as the acft climbed through 6500 feet. According to the plt the no. 1 cylinder separated from the radial eng. The acft nosed over during the landing on unimproved terrain.NTSB FTW81FQD26Accident · Minor injuriesClosedBeech D17S · Canutillo, TXNTSB LAX80FVD31Accident · Minor injuriesClosedBeech D-17S · San Rafael, CANTSB SEA79DYK18Accident · Minor injuriesClosedBeech D-17S · Sisters, ORNTSB FTW78FPD27Accident · No injuriesClosedBeech D-17S · Ranger, TXNTSB FTW78DPG49Accident · No injuriesClosedBeech D-17S · Fort Smith, ARNTSB FTW76AF104Accident · 2 fatalClosedBeech D-17S · Amarillo, TXNTSB NYC75DHD03Accident · No injuriesClosedBeech D17S · Medford, NJNTSB FTW73DPD40Accident · No injuriesClosedBeech D17S · Arlington, TXNTSB LAX71FUJ50Accident · No injuriesClosedBeech D-17S · Phoenix, AZNTSB MIA71AM013Accident · 2 fatalClosedBeech D17S · Sterrett, ALNTSB ANC70DAG12Accident · Minor injuriesClosedBeech D-17S · Aniak, AKNTSB MIA70F0204Accident · No injuriesClosedBeech D17S · Lawrenceville, GANTSB SEA69F0257Accident · Minor injuriesClosedBeech D17S · Aurora, ORNTSB DEN69D0178Accident · No injuriesClosedBeech D-17S · Cheyenne, WYNTSB DIA69A0018Accident · 1 fatalClosedBeech D-17S · Glenville, WVNTSB CHI69F0156Accident · No injuriesClosedBeech D-17S · New Knoxvill, OHNTSB DIA68D0191Accident · Minor injuriesClosedBeech D-17S · Banner Elk, NCNTSB OAK68D0245Accident · No injuriesClosedBeech D-17S · Campbell, CANTSB LAX68D0120Accident · No injuriesClosedBeech D-17S · Yucaipa, CANTSB FTW67F0443Accident · No injuriesClosedBeech D-17S · Fort Worth, TXNTSB DEN66F0297Accident · No injuriesClosedBeech D-17S · Phoenix, AZNTSB OAK66D0143Accident · No injuriesClosedBeechcraft D-17S · Ft Worth, TXNTSB LAX66F0073Accident · Minor injuriesClosedBeechcraft D17S · Mojave, CANTSB UNK64X4100Accident · No injuriesClosedBeech D17S · Burwell, NENTSB UNK64X2703Accident · No injuriesClosedBeechcraft 17 · Lake Villa, ILNTSB UNK64X2500Accident · No injuriesClosedBeechcraft D18S · Hardin, MT
Back to Beech D17S