NTSB investigations: Bellanca 17-30A, OH
13 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
| 1974 | 1 |
|---|---|
| 1977 | 1 |
| 1980 | 2 |
| 1981 | 2 |
| 1983 | 1 |
| 1984 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2014 | 1 |
| 2017 | 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\" = 'OH' 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" = 'OH' 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 CEN17LA081Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Kidron, OHMaintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.NTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.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 IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.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.…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…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…NTSB CHI81FEK30Accident · Minor injuriesClosedBellanca 17-30A · Newark, OHNTSB CHI81FE113Accident · Minor injuriesClosedBellanca 17-30A · Bucyrus, OHNTSB CHI80FA032Accident · No injuriesClosedBellanca 17-30A · Bellefontaine, OHNTSB CHI80DEG08Accident · No injuriesClosedBellanca 17-30A · Greenville, OHNTSB CHI77FEI23Accident · Serious injuriesClosedBellanca 17-30 · Toledo, OHNTSB CHI74FEG14Accident · Serious injuriesClosedBellanca 17-30A · Blue Ash, OH