NTSB investigations: Bellanca 17-30, MO
7 cases on aircraft the registry lists as Bellanca 17-30. 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
| 1968 | 1 |
|---|---|
| 1982 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2012 | 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\" = 'MO' 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 ('1220432', '1250020'))
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" = 'MO' 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 ('1220432', '1250020'))
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 CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.NTSB CHI96LA158Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOa total loss of power due to the pilot's inadequate preflight planning and preparation and subsequent fuel exhaustion. A factor was the pilot's lack of experience in the airplane.NTSB CHI95LA224Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOThe collapse of the left main landing gear for an undetermined reason.NTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.NTSB MKC90LA004Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Gainesville, MOThe pilot's failure to compensate for wind conditions and to maintain runway alignment during the landing approach. Contributing to the accident was the turbulent conditions.NTSB MKC82FA110Accident · Serious injuriesField investigationFinal reportBellanca 17-30 · Columbia, MOThe plt stated he did not refuel or visually verify fuel quantity prior to departing Kansas city. The flt to st. louis was on the left tank. As the acft approached the Columbia, MO VOR at an altitude of 3000 ft MSL the eng failed. The pilot stated he…NTSB MKC69A0004Accident · 2 fatalClosedBellanca 17-30 · Lees Summit, MO