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 ('1151214')
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 ('1151214')
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 WPR22FA196Accident · 2 fatalClass 3 · FieldFinal reportBeech 19A · Oroville, CAThe pilot’s failure to maintain proper airspeed during a turn and his exceedance of the airplane’s critical angle of attack, which resulted in an accelerated stall. Contributing to the accident was the improper placement of the fuel selector, which resulted…NTSB ANC17LA042Accident · No injuriesLimited investigationFinal reportBeech 19A · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the right main landing (MLG) tire impacting a rock and the subsequent loss of directional control and collapse of the right MLG.NTSB WPR17FA170Accident · 4 fatalField investigationFinal reportBeech 19A · Waipi'o, HIThe pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.NTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN09CA136Accident · No injuriesData collectionFinal reportBeech 19 · Lafayette, INThe pilot's inadvertent encounter with icing conditions during initial climb. Contributing to the accident were the lack of visibility during the landing due to an ice covered windscreen, and the structural ice that adversely affected the flight…NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.NTSB CHI06LA006Accident · No injuriesLimited investigationFinal reportBeech 19A · Jackson, MIThe student pilot's inadvertent porpoise during landing, which resulted in a loss of control and a collision with a sign.NTSB FTW03LA191Accident · No injuriesLimited investigationFinal reportBeech 19A · Fredericksburg, TXA partial loss of engine power due to a rich mixture and reduced airflow to the engine. Contributing factors were the owner's failure to obtain an annual inspection, and improper maintenance procedures used in the installation of the air filter.NTSB LAX03LA120Accident · No injuriesLimited investigationFinal reportBeech 19A · Coalinga, CAThe pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.NTSB CHI94LA213Accident · No injuriesLimited investigationFinal reportBeech 19 · Ionia, MIthe pilot's improper use of the throttle control. A factor related to the accident was the improper flare.NTSB CHI93LA344Accident · No injuriesLimited investigationFinal reportBeech 19A · Troy, MOThe pilot's use of improper fuel in the airplane. Wet turf on the runway was a related factor.NTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.NTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.NTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.NTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.NTSB CHI88LA124Accident · No injuriesLimited investigationFinal reportBeech B-19A · Lacon, ILA hard landing made by the student pilot after attempting to recover from a bounced landing.NTSB NYC88LA019Accident · Minor injuriesLimited investigationFinal reportBeech 19A · Buena, NJa loss of electrical power for undetermined reasons, which necessitated a precautionary landing. Factors were rain, clouds, dark night, and the pole. This report was modified on February 9, 2005.NTSB DEN87LA143Accident · No injuriesLimited investigationFinal reportBeech 19A · Erie, COThe instructor (CFI) was instructing the student plt, who was the new owner of the acft. The CFI rprtd the acft was 'very close to gross weight due to having so much fuel aboard and the density altitude was high.' He estd the density altitude was 7600 ft. drg…NTSB LAX86LA228Accident · Minor injuriesLimited investigationFinal reportBeech A19 · Taylor, AZThe acft collided with wires after a loss of alt during the initial climb while on a night VFR flt. The plt indicated that it took 3/4 of the rwy to get airborne and the acft did not seem to climb with full pwr applied. The plt decided to return to the arpt…NTSB NYC86LA120Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Plymouth, MAThe acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…NTSB CHI85LA252Accident · No injuriesLimited investigationFinal reportBeech BE-19A · Appleton, WIThe left main landing gear collapsed following a loss of directional control during landing. The landing was made on rwy 21 with winds from 240 degs at 18 KTS gusting to 30 KTS. The plt reported the acft drifted left during the landing and side loads on the…NTSB MIA84LA175Accident · No injuriesLimited investigationFinal reportBeech 19A · Winter Haven, FLThe acft collided with a fence during a forced landing after the eng lost power. The plt stated that he ran out of fuel.NTSB ATL84IA117Incident · No injuriesIncident investigationFinal reportBeech 19A Sport III · Atlanta, GAThe student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright.NTSB ATL84LA103Accident · No injuriesLimited investigationFinal reportBeech 19A · Mayersville, MSThe plt circled the airstrip prior to landing and believed the landing area in suitable condition. During the landing right main landing gear mired in a soft spot and the landing gear collapsed.NTSB NYC83FA245Accident · 4 fatalField investigationFinal reportBeech 19A · New Cumberland, PAAn operations manager stated that 3 persons came to buy a sight-seeing. Pleasure ride & the plt selected the Beech 19A. During its takeoff, witnesses observed the acft over the end of the rwy in a nose high attitude, but with very little climb rate. According…NTSB FTW82DQD01Accident · Minor injuriesClosedBeech 19A · Sunland Park, NMNTSB FTW81DPD42Accident · No injuriesClosedBeech 19A · Lewisville, TXNTSB MIA81FA115Accident · 4 fatalClosedBeech 19A · Horseshoe Bch, FLNTSB SEA81DYE28Accident · No injuriesClosedBeech B23 · Ocean Shores, WANTSB MIA80DLD60Accident · No injuriesClosedBeech 19A · Inverness, FLNTSB LAX80DVM29Accident · No injuriesClosedScorpion 133 · Santa Cruz, CANTSB CHI79DEE52Accident · No injuriesClosedBeech BE-19A · Schaumburg, ILNTSB OAK78FVG46Accident · No injuriesClosedBeech 19A · Butte City, CANTSB MKC78FER41Accident · Serious injuriesClosedBeech A23-19 · Inver Grv Hts, MNNTSB FTW78FPA16Accident · Minor injuriesClosedBeech A23-19 · Ivanhoe, TXNTSB DEN77FA044Accident · 2 fatalClosedBeech 19A · Wheatland, WYNTSB LAX77FA009Accident · 1 fatalClosedBeech 19A · Grand Canyon, AZNTSB FTW76FPA25Accident · Serious injuriesClosedBeech 19A · Plano, TXNTSB SEA76AS027Accident · 1 fatalClosedBeech 19A · Port Orchard, WANTSB SEA76FYG17Accident · Serious injuriesClosedBeech 19A · Quincy, WANTSB NYC75FNE26Accident · Serious injuriesClosedBeech A23 · Simsbury, CTNTSB CHI75DEP34Accident · No injuriesClosedBeech A23-19 · Delavan, WINTSB LAX75FUQ17Accident · No injuriesClosedBeech B19A · Simi, CANTSB CHI75DEE13Accident · No injuriesClosedBeech 23-19A · Kankakee, ILNTSB CHI74FEC49Accident · No injuriesClosedBeech 19A · Toledo, OHNTSB LAX74FUM32Accident · Serious injuriesClosedBeech A23-19 · San Diego, CANTSB CHI74FEK24Accident · No injuriesClosedBeech 19A · Columbus, OH
Back to Beech 19A