NTSB investigations: Bellanca 17-30A, NM
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
| 1975 | 1 |
|---|---|
| 1976 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1996 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2014 | 1 |
| 2025 | 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\" = 'NM' 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" = 'NM' 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 WPR25FA279Accident · 1 fatalClass 3 · FieldPreliminary reportBellanca 17-30A · Moriarty, NMOn September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…NTSB CEN14CA151Accident · No injuriesData collectionFinal reportBellanca 17 30A · Santa Rosa, NMThe pilot's mismanagement of the available fuel supply which resulted in a loss of engine power and subsequent emergency landing.NTSB DEN00LA174Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Las Cruces, NMThe pilot's failure to maintain lateral clearance with terrain. Factors were the confined area used for takeoff, and the high vegetation alongside the road.NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB FTW96LA106Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Belen, NMprevious damage, looseness of the main landing gear, and inadequate maintenance.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…NTSB FTW81FQA31Accident · Minor injuriesClosedBellanca 17-30 · Chacon, NMNTSB DEN79FA042Accident · 1 fatalClosedBellanca 17-30A · Ruidoso, NMNTSB DEN77FA023Accident · 3 fatalClosedBellanca 17-30A · San Mateo, NMNTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMNTSB DEN77FA010Accident · 2 fatalClosedBellanca 17-30A · Taos, NMNTSB DEN76DQD10Accident · No injuriesClosedBellanca 17-30A · Chamberino, NM