Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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" DESC

Run 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 CHI84LA293Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Richmond Hts, OHThe aircraft was being flown back from an annual inspection. The pilot stated after the accident that he experienced a loss of power while on downwind leg for landing on rwy 23. The pilot attempted a landing on rwy 5 but the acft landed 1500 feet short.…Jul 13, 1984 · N93752 · Substantial damage NTSB CHI84LA223Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Marysville, OHPlt stated a loss of pwr occurred en route at 7000 ft MSL and during the forced landing flare pwr was regained. Plt elected to climb because the field being used for the landing was insufficient. At alt of 1500 MSL, loss of pwr occurredonce again. Acft…Jun 8, 1984 · N4187B · Substantial damage NTSB ATL84FA164Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Painter, VAAfter encountering low ceilings, the plt attempted a precautionary ldg. Upon realizing lights from the ground were on a house, a go-around was initiated with a climbing left turn. The acft then flew into trees one fourth to one half mile from the house.May 7, 1984 · N11JJ · Destroyed NTSB DEN84LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Angel Fire, NMAfter making a x-country flt from Oklahoma city, ok to Angel Fire, NM, the plt landed on a snow covered rwy at an elevation of 8382 ft. during the landing, the acft bounced, drifted to the left side of the rwy, then hit a 3-1/2 ft snowbank. The plt reported…Jan 10, 1984 · N93656 · Substantial damage NTSB FTW84FA083Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Hebbronville, TXThe flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised…Dec 3, 1983 · N4097B · Destroyed NTSB LAX83LA291Accident · 1 fatalLimited investigationFinal reportBellanca 17-31A · Ducor, CAThe acft crashed into the side of a hill at 1900 feet MSL while on a photographic mission. The top of the mountain that was struck is 2412 feet MSL. The pilot was fatally injured in the crash and ground fire following impact. According to his secretary he was…Jun 18, 1983 · N8838V · Destroyed NTSB FTW83LA285Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Clifton, TXOn final apch to land, the plt saw 2 buzzards & added power while maneuvering to avoid theem, then continued the apch. This resulted in landing beyond the intended touchdown point. The middle of the rwy was higher than either end; therefore, the plt was…Jun 18, 1983 · N28008 · Substantial damage NTSB ATL83LA153Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Shelbyville, TNThe acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running…Mar 25, 1983 · N28190 · Destroyed NTSB CHI83LA142Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, OHThe plt had purchased the acft on 2/28/83. From that date until the day of the accident on 3/16/83, he had problems with the landing gear. When he attempted to retract the gear after takeoff on the day of the accident, the indicators showed that the gear had…Mar 16, 1983 · N93571 · Substantial damage NTSB LAX83FA050Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Williams, AZThe original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…Nov 25, 1982 · N14748 · Destroyed NTSB DEN82FTI17Accident · No injuriesFinal reportBellanca 17-30A · Browning, MTAcft landed with the gear up.Aug 24, 1982 · N14695 · Substantial damage NTSB LAX82DUG11Accident · No injuriesFinal reportBellanca 300A · Lucerne, CAThe owner of the aircraft reported that there was a gradual loss of engine power. The plane was landed on a dirt road; however, there was insufficient room to stop before reaching the end of the road. The owner reported that he swerved to avoid a dead end…Apr 25, 1982 · N93747 · Substantial damage NTSB NYC82DA034Accident · No injuriesFinal reportBellanca 17-30A · Factoryville, PADuring the previous flight, there was a landing gear malfunction. A mechanic checked the gear and a decision was made to fly the plane with the gear down to another airport for maintenance. During the subsequent flight, the "gear down" speed was not exceeded.…Feb 14, 1982 · N14908 · Substantial damage NTSB FTW82FRJ07Accident · Minor injuriesFinal reportBellanca 17-30A · Homer, LADuring an IFR flight at 5000 ft MSL, the engine began running rough. The pilot attempted to restore power, but eventually, the engine began to windmill with no apparent thrust. Unable to maintain altitude, the pilot descended through a cloud layer and broke…Jan 2, 1982 · N14779 · Destroyed NTSB NYC82FGM03Accident · No injuriesClosedBellanca 17-30A · Seven Springs, PAOct 15, 1981 · N93647 · Destroyed NTSB CHI81FEK30Accident · Minor injuriesClosedBellanca 17-30A · Newark, OHSep 20, 1981 · N14744 · Substantial damage NTSB DEN81FTG14Accident · Minor injuriesClosedBellanca 17-30A · Williston, NDJul 23, 1981 · N8797V · Substantial damage NTSB FTW81FQA31Accident · Minor injuriesClosedBellanca 17-30 · Chacon, NMMay 14, 1981 · N7396V · Substantial damage NTSB CHI81FE113Accident · Minor injuriesClosedBellanca 17-30A · Bucyrus, OHApr 17, 1981 · N6615V · Destroyed NTSB FTW81FA021Accident · 2 fatalClosedBellanca 17-30A · Iraan, TXJan 6, 1981 · N6606V · Destroyed NTSB FTW81DQD12Accident · No injuriesClosedBellanca 17-30A · El Paso, TXDec 21, 1980 · N4087B · Substantial damage NTSB LAX81FA009Accident · Minor injuriesClosedBellanca 17-30A · Phoenix, AZOct 23, 1980 · N28088 · Destroyed NTSB MKC81FCA01Accident · Serious injuriesClosedBellanca 17-30A · Fenton, MOOct 9, 1980 · N8856V · Substantial damage NTSB NYC80DHA32Accident · No injuriesClosedBellanca 17-30 · Pottstown, PASep 20, 1980 · N8863V · Substantial damage NTSB ATL80FID24Accident · Serious injuriesClosedBellanca 17-30A · Tappahannock, VAJul 6, 1980 · N14700 · Substantial damage NTSB LAX80FVM31Accident · No injuriesClosedBellanca 17-30A · Palo Alto, CAMay 16, 1980 · N4241B · Substantial damage NTSB CHI80FA032Accident · No injuriesClosedBellanca 17-30A · Bellefontaine, OHMar 28, 1980 · N39897 · Substantial damage NTSB IAD80FA023Accident · 2 fatalClosedBellanca 17-30A · Morrisville, NCFeb 12, 1980 · N28027 · Destroyed NTSB CHI80DEG08Accident · No injuriesClosedBellanca 17-30A · Greenville, OHFeb 1, 1980 · N93650 · Substantial damage NTSB LAX80FUM08Accident · No injuriesClosedBellanca 17-30A · El Cajon, CAJan 10, 1980 · N28204 · Substantial damage NTSB CHI80FEP08Accident · No injuriesClosedBellanca 17-30A · Viroqua, WIDec 18, 1979 · N14703 · Substantial damage NTSB FTW80FPA02Accident · No injuriesClosedBellanca 17-30A · Dallas, TXNov 11, 1979 · N8270R · Destroyed NTSB NYC79FA092Accident · 1 fatalClosedBellanca 17-30A · Hanover, PASep 9, 1979 · N102CB · Destroyed NTSB OAK79DV960Accident · No injuriesClosedBellanca 17-30A · Fall River Mil, CAJun 24, 1979 · N4159B · Substantial damage NTSB DEN79FA042Accident · 1 fatalClosedBellanca 17-30A · Ruidoso, NMMay 29, 1979 · N39877 · Substantial damage NTSB FTW79FA046Accident · 1 fatalClosedBellanca 17-30A · Bryans Corner, OKFeb 11, 1979 · N28175 · 2 aircraft · Destroyed NTSB FTW79DQG08Accident · No injuriesClosedBellanca 17-30A · Halfway, TXNov 19, 1978 · N4059B · Substantial damage NTSB MIA79DLD12Accident · No injuriesClosedBellanca 17-30A · Orlando, FLNov 2, 1978 · N39832 · Substantial damage NTSB MIA78FKJ78Accident · No injuriesClosedBellanca 300 · Pensacola, FLAug 19, 1978 · N39842 · Substantial damage NTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WIJul 12, 1978 · N93627 · Destroyed NTSB SEA78FYM42Accident · Serious injuriesClosedBellanca 17-30 · Toledo, ORJul 6, 1978 · N8814V · Substantial damage NTSB MIA78FA065Accident · 2 fatalClosedBellanca 17-30A · Gulfport, MSApr 11, 1978 · N39817 · Destroyed NTSB FTW78DQG19Accident · No injuriesClosedBellanca 17-30 · Plainview, TXMar 8, 1978 · N6606V · Substantial damage NTSB MIA78FKG07Accident · Serious injuriesClosedBellanca 17-30A · Marietta, GANov 30, 1977 · N6611V · Destroyed NTSB MKC78DER09Accident · No injuriesClosedBellanca 17-30A · Lakeville, MNNov 16, 1977 · N117L · Destroyed NTSB FTW77FQG59Accident · No injuriesClosedBellanca 17-30A · Lubbock, TXSep 30, 1977 · N6603V · Substantial damage NTSB MIA77FLA44Accident · 1 fatalClosedBellanca 17-30A · Jacksonville, FLAug 4, 1977 · N14761 · Destroyed NTSB LAX77FUQ43Accident · No injuriesClosedBellanca 17-30A · Lancaster, CAJul 25, 1977 · N665JR · Substantial damage NTSB CHI77FEP45Accident · No injuriesClosedBellanca 17-30A · Milwaukee, WIJul 18, 1977 · N39867 · Substantial damage NTSB UNK77X0105Accident · 1 fatalClosedBellanca 17-30A · Brightwood, ORMay 23, 1977 · N8866V · Destroyed