NTSB investigations: Beech A23-24, 1986
4 cases on aircraft the registry lists as Beech A23-24. 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
| 1966 | 8 |
|---|---|
| 1967 | 18 |
| 1968 | 14 |
| 1969 | 13 |
| 1970 | 5 |
| 1971 | 11 |
| 1972 | 9 |
| 1973 | 4 |
| 1974 | 5 |
| 1975 | 7 |
| 1976 | 4 |
| 1977 | 4 |
| 1978 | 6 |
| 1979 | 4 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 1 |
| 1986 | 4 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 3 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 3 |
| 2007 | 1 |
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226'))
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 DEN87LA026Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Vernal, UTThe plt attempted to land on a dirt road near two oil rigs. He said he made several low passes to view the road surface. During the landing roll, the wheels of the acft dug into the soft surface. A loss of control occurred which resulted in the acft traveling…NTSB ATL87FA004Accident · Serious injuriesField investigationFinal reportBeech A-23-24 · Meldrim, GAThe pilot flight planned a total time enroute of 2HRS. 45 min. The aircraft fuel endurance was four hours. The pilot used about 1 hr. 15 min. Attempting to complete an instrument procedure. Sav was VFR throughout the entire flight and prior to the accident.…NTSB ATL86LA198Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Lake City, SCDuring landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway…NTSB SEA86LA123Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Sunnyside, WAAfter completing several touch and goes, the pilot lost control of the aircraft on landing rollout due to a light gusting crosswind. The pilot was unable to avoid departing the runway to the left striking a four foot embankment collapsing the nose gear.