Fatal NTSB investigations: Bellanca 17-31A
17 cases on aircraft the registry lists as Bellanca 17-31A. 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 | 2 |
|---|---|
| 1973 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 3 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1990 | 1 |
| 1995 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220435', '1250031'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220435', '1250031'))
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 FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.NTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).NTSB BFO85FA067Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Woodbridge, VAThe acft departed saratoga springs, NY, en route to manassas, VA. Wx was VFR and as the acft approached gaithersburg, MD, at 2132 LCL the plt contacted dulles apch for vectors through the area to manassas. The acft was issued a heading to manassas. Shortly…NTSB SEA85FA084Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Yamhill, ORWitnesses observed the acft apch the airstrip with excessive speed. Touchdown on the rwy was beyond the halfway point & the acft bounced back into the air. Power was applied for an apparent go-around. The acft cleared tall trees at the end of the runway, but…NTSB LAX84LAMS3Accident · 1 fatalFinal reportBellanca 17-31A · CABetween may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…NTSB ATL83FA176Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Waverly, GAThe acft crashed into trees during an instrument approach at night in stormy weather. Both the CFI, seated in the front left seat, & the new owner of the acft, were fatally injured. An IFR flt plan was filed & the CFI had obtained 2 wx briefings prior to…NTSB CHI81FA060Accident · 1 fatalClosedBellanca 17-31A · Grundy County, ILNTSB LAX80FA058Accident · 2 fatalClosedBellanca 17-31A · Long Beach, CANTSB OAK78FA052Accident · 3 fatalClosedBellanca 17-31A · San Jose, CANTSB MIA78FA102Accident · 2 fatalClosedBellanca 17-31A · Lake City, FLNTSB UNK78X0124Accident · 2 fatalClosedBellanca 14-19 · L Mrcds, NiueNTSB IAD76AI082Accident · 3 fatalClosedBellanca 17-31A · Jacksonville, NCNTSB MKC76AK031Accident · 3 fatalClosedBellanca 17-31A · Garrison, IANTSB DEN73AD034Accident · 2 fatalClosedBellanca 17-31A · Aurora, CONTSB NYC73AN106Accident · 1 fatalClosedBellanca 17-31A · Dover, DENTSB SEA72AS048Accident · 3 fatalClosedBellanca 17-31A · Onalaska, WANTSB CHI72AC064Accident · 2 fatalClosedCessna 150G · Springfield, OH