NTSB investigations: Beech A36, 1987
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\") = 1987
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") = 1987
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 DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…NTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…NTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…NTSB ATL87FA101Accident · Serious injuriesField investigationFinal reportBeech A36 · Dalton, GAOn t/o at 1st power change PIC noted loss of performance. He turned left to downwind leg for landing. PIC and ground witnesses said eng quit and acft crashed into trees and ground. Post crash fire destroyed acft. PIC rpted taking fuel sample before t/o with…NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…NTSB DEN87LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · Taos, NMThe plt was making a night VFR landing approach to rwy 22 at Taos, new Mexico, when the acft struck some high voltage power transmission lines running perpendicular to the rwy. The plt was able to maintain control of the acft and landed it successfully. The…