NTSB investigations: Beech A36, 2004
8 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\") = 2004
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") = 2004
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 LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.NTSB CHI05FA020Accident · 3 fatalField investigationFinal reportBeech A36 · Downing, MOThe pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.NTSB SEA04FA188Accident · Serious injuriesField investigationFinal reportBeech A-36 · Auburn, WAThe pilot's failure to abort the takeoff early enough to allow him to stop the aircraft before it went off the departure end of the runway. Factors include the pilot's inadequate preflight procedures, water contamination in the fuel, a partial loss of power,…NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.NTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.NTSB IAD04LA018Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Bedford, MAThe mechanic's failure to properly torque the engine-driven fuel pump's return line B-nut fitting.NTSB DEN04LA040Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.