NTSB investigations: Bellanca 17-30A
8 cases on aircraft the registry lists as Bellanca 17-30A, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220433')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 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 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 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 FTW92FA145Accident · 4 fatalField investigationFinal reportBellanca 17-30A · El Campo, TXThe pilot's failure to maintain adequate airspeed.NTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.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 DEN82FTI17Accident · No injuriesFinal reportBellanca 17-30A · Browning, MTAcft landed with the gear up.