NTSB investigations: Bellanca 17-30A, 1995
4 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\") = 1995
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") = 1995
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 MIA96LA029Accident · 2 fatalLimited investigationFinal reportBellanca BL-17-30A · Kings Bay, GAa loss of control due to pilot spatial disorientation. Contributing to the accident was: the dark night condition and the pilot's improper decision to turn to an easterly heading with no ground reference lights available.NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.NTSB FTW95LA157Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Midland, TXThe pilot's failure to maintain directional control.