NTSB investigations: Bellanca 17-30A
255 cases on aircraft the registry lists as Bellanca 17-30A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, newest first
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220433'))
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220433'))
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 DFW07FA039Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Jay, OKThe loss of engine power for undetermined reasons and the pilot's improper decision to extend the landing gear for the water landing. Contributing factors were the prevailing night conditions and the lack of suitable terrain for the forced landing.NTSB DFW06CA125Accident · No injuriesData collectionFinal reportBellanca 17-A30 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA008Accident · No injuriesData collectionFinal reportBellanca 17-30A · Riverside, CAThe failure of the steering control rod during an unknown phase of the accident flight that resulted in the unavailability of steering control upon landing.NTSB DFW05CA128Accident · Serious injuriesData collectionFinal reportBellanca 17-30A · Houston, TXThe pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.NTSB ATL05CA056Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Eagleville, TNThe pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position , which resulted in a loss of engine power due to fuel starvation.NTSB DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.NTSB FTW04FA052Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe failure of flight/navigation instruments while in instrument meteorological conditions (in-cloud flight and low ceilings) resulting in spatial disorientation. A contributing factors was the prevaling instrument meteorological conditions (low ceiling and…NTSB CHI04LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Wellington, KSThe pilot not maintaining directional control during the landing roll. Factors were the dry grass and the concrete box he encountered during his excursion off the runway.NTSB MIA03LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pell City, ALThe pilot's failure to maintain directional control following landing touchdown, resulting in a runway excursion and collision with a ditch off the left side of the runway.NTSB CHI02CA253Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Ohiawa, NEThe pilot failed to verify the aircraft refueling and he did not follow emergency procedures for engine restart. Factors to the accident included fuel starvation and the fence post.NTSB LAX02LA190Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fallon, NVthe pilot's failure to attain an adequate takeoff airspeed, which resulted in a stall/mush. The high gross weight and density altitude were contributing factors.NTSB LAX02WA195Accident · Minor injuriesForeign investigationBellanca 17-30A · Puertecitos, MexicoNTSB LAX02LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Willits, CAthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors in the accident were the pilot's failure to raise the flaps and the wind shear conditions.NTSB CHI02LA070Accident · 2 fatalLimited investigationFinal reportBellanca 17-30A · Alexandria, MNThe pilot's disregard of the weather evaluation and his attempt to fly into known adverse weather without an instrument rating. Factors in the accident were the low ceiling, the low visibility, and the icing conditions.NTSB CHI02LA028Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Nevada, MOThe inadequate fuel consumtion calculations by the pilot resulting in fuel starvation during the aborted landing, and the overloaded steering link for undetermined reasons resulting in the lack of directional control during landing. Factors were the…NTSB FTW02LA022Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Clarendon, TXthe loss of engine power for undetermined reasons. Contributing factors to the accident were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.NTSB FTW01FA065Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Pampa, TXthe pilot's failure to maintain terrain clearance. Contributing factors were the dark night and the fog.NTSB NYC01LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Zanesville, OHThe pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.NTSB IAD01LA016Accident · Serious injuriesLimited investigationFinal reportBellanca BL-17-30A · Union, CTpilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB DEN00LA174Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Las Cruces, NMThe pilot's failure to maintain lateral clearance with terrain. Factors were the confined area used for takeoff, and the high vegetation alongside the road.NTSB FTW00FA208Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Houston, TXthe loss of engine power for an undetermined reason during maneuvering. Contributing factors were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…NTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.NTSB ATL00FA019Accident · 2 fatalField investigationFinal reportBellanca BL-17-30A · Monteagle, TNThe pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB FTW99LA180Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Brownfield, TXThe pilot's inadvertent stall while attempting to clear powerlines. Factors were the loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector.NTSB FTW98LA418Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Alpine, TXThe pilot's failure to maintain directional control of the airplane for undetermined reasons. A factor was the loose gravel composition of the runway.NTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.NTSB ATL98LA070Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Brewton, ALImproper maintenance procedures used to overhaul the engine, which led to the crankshaft failure. Contributing to the severity of the accident was the fence.NTSB LAX98LA132Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Prescott, AZThe pilot's failure to attain directional control after swerving off the runway and impacting a ditch.NTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.NTSB NYC97WA191Accident · 2 fatalForeign investigationBellanca 17-30A · BelgiumNTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA079Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, MIthe pilot failed to maintain directional control of the aircraft during landing. Factors included the inadequate compensation for the crosswind conditions, the crosswind, and gusts.NTSB LAX97LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Scottsdale, AZfuel exhaustion due to the pilot's improper fuel management.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.NTSB LAX97LA009Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Jackpot, NVthe pilot's inadvertent disorientation in dark night time conditions and failure to maintain a proper climbing attitude.NTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.NTSB LAX96LA211Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Fallbrook, CAfailure of the pilot to attain the proper touchdown point on the runway, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the excessive airspeed on final approach, and the short and wet condition of the…NTSB FTW96LA106Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Belen, NMprevious damage, looseness of the main landing gear, and inadequate maintenance.NTSB MIA96LA029Accident · 2 fatalLimited investigationFinal reportBellanca BL-17-30A · Kings Bay, GAa loss of control due to pilot spatial disorientation. Contributing to the accident was: the dark night condition and the pilot's improper decision to turn to an easterly heading with no ground reference lights available.NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.NTSB FTW95LA157Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Midland, TXThe pilot's failure to maintain directional control.