NTSB investigations: Bellanca 17-30A, 1986
5 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
| 1969 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 8 |
| 1974 | 12 |
| 1975 | 9 |
| 1976 | 8 |
| 1977 | 15 |
| 1978 | 7 |
| 1979 | 6 |
| 1980 | 10 |
| 1981 | 6 |
| 1982 | 5 |
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 7 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 5 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 1986
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 year(c."eventDate") = 1986
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 LAX87FA200Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Flagstaff, AZThe plt & his wife desired to return to their Flagstaff, AZ, home following a weekend at stockton, CA., & they departed sck in VFR weather conditions. The weather at the destination arpt had been below VFR minimums all morning & it was forecast to remain poor…NTSB CHI86LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grosse Ile, MIThe pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway.NTSB BFO86FA027Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Riverdale, MDAircraft's engine sputtered and quit while the aircraft was climbing through 400 feet after departure. In an attempt to turn back to the runway the pilot stalled the aircraft and it descended out of control crashing into trees and the ground. Post crash…NTSB MIA86LA107Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ft. Lauderdale, FLThe non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'…NTSB CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…