NTSB investigations: Bellanca 17-30A, CA
20 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 per year
| 1972 | 1 |
|---|---|
| 1973 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2012 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 WPR26LA240Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Santa Paula, CAThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB WPR12LA185Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Cloverdale, CAThe pilot’s improper fuel management, which resulted in a loss of engine power during climb due to fuel starvation.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 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 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 LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.NTSB LAX90FA233Accident · Minor injuriesField investigationFinal reportBellanca 17-30A · Ojai, CAStructural damage sustained by the Bellanca, N39843, as a result of encountering wake turbulence during a near-collision with a navy F-14A.NTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.NTSB LAX89LA333Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Palo Alto, CAA loss of engine power due to fuel starvation. The fuel starvation was the result of vane particles from the deteriorated electric fuel pump restricting the upstream flow of fuel.NTSB LAX84LA485Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Bishop, CAThe plt of the Bellanca said he saw a sailplane in front of him in the traffic pattern and pulled up to avoid a collision. The Bellanca stalled and even though it was partially recovered 500 ft before ground contact, the plt said he cut the engine and landed…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…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…NTSB LAX80FVM31Accident · No injuriesClosedBellanca 17-30A · Palo Alto, CANTSB LAX80FUM08Accident · No injuriesClosedBellanca 17-30A · El Cajon, CANTSB OAK79DV960Accident · No injuriesClosedBellanca 17-30A · Fall River Mil, CANTSB LAX77FUQ43Accident · No injuriesClosedBellanca 17-30A · Lancaster, CANTSB LAX75FUA29Accident · No injuriesClosedBellanca 17-30 · Long Beach, CANTSB LAX74FUQ12Accident · Serious injuriesClosedBellanca 17-30A · Ridgecrest, CANTSB LAX73DUG39Accident · Minor injuriesClosedBellanca 17-30A · Mountn Pass, CANTSB LAX72DVA46Accident · No injuriesClosedBellanca 17-30A · Shafter, CA