NTSB investigations: Beech A36, 1985
6 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\") = 1985
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") = 1985
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 CHI86FA035Accident · 2 fatalField investigationFinal reportBeech BE 36 · Odell, ILThe plt departed on an IFR flight into known icing conditions after receiving three complete weather briefings clearly indicating the icing conditions with numerous plt reports of icing. Aprx 40 minutes after departure the plt reported he had about an inch of…NTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…NTSB FTW85LA336Accident · No injuriesLimited investigationFinal reportBeech A36 · Conroe, TXAcft was substantially damaged during an off-arpt emergency landing following an eng failure. During landing roll acft collided with a fence and the gear collapsed. Investigation revealed about 13 gallons of fuel in right fuel tank and none in the left tank.…NTSB FTW85LA199Accident · No injuriesLimited investigationFinal reportBeech A-36 · Afton, OKThe acft was ditched in 60 to 80 ft deep water following a loss of pwr shortly after takeoff. The plt was picked up by a bass boat shortly before the acft sank. The acft was recovered more than a month later and an examination of the eng was not performed.NTSB FTW85IA149Incident · No injuriesIncident investigationFinal reportBeech A36 · Dfw Airport, TXDrg arr, a Beech A36, N2057A, was vectored for an ILS rwy 17L apch while a hvy Boeing 747 was being vectored for an ILS rwy 18R apch. The ATC arrival controller (ctlr) stated he had 'staggered' the A36 bhnd the 747 with at least 3 mi sepn. After the A36 was…NTSB ATL85LA093Accident · Minor injuriesLimited investigationFinal reportBeech A36 · New Albany, MSPIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The…