NTSB investigations: Beech A36, 1997
7 cases on aircraft the registry lists as Beech A36. 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 5 |
| 1978 | 8 |
| 1979 | 13 |
| 1980 | 14 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 13 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 12 |
| 1989 | 14 |
| 1990 | 7 |
| 1991 | 10 |
| 1992 | 13 |
| 1993 | 15 |
| 1994 | 10 |
| 1995 | 12 |
| 1996 | 10 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 4 |
| 2000 | 10 |
| 2001 | 5 |
| 2002 | 5 |
| 2003 | 16 |
| 2004 | 8 |
| 2005 | 13 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 12 |
| 2009 | 12 |
| 2010 | 9 |
| 2011 | 9 |
| 2012 | 10 |
| 2013 | 11 |
| 2014 | 8 |
| 2015 | 14 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 11 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 12 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 6 |
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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604'))
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") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604'))
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 IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.NTSB CHI97FA218Accident · 7 fatalField investigationFinal reportCessna 172P · Chicago, ILthe pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.NTSB LAX97FA177Accident · 5 fatalField investigationFinal reportBeech A36TC · Truckee, CAfailure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…NTSB MIA97WA135Accident · 4 fatalForeign investigationBeech A-36 · Pitts Town, BahamasNTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.NTSB IAD97WA088Accident · No injuriesForeign investigationBeech A-36 · Lebury, United KingdomNTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.