NTSB investigations: Beech A23-24, 1982
3 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\") = 1982
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") = 1982
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 ATL82DA129Accident · No injuriesFinal reportBeech A23-24 · Kingston, TNDuring takeoff, the engine lost power at about 300 ft AGL and the pilot ditched the plane in a lake. After the ditching, the pilot egressed from the plane and enter a fishing boat that pulled up alongside. Shortly after that, the plank sank. After the…NTSB NYC82DA066Accident · No injuriesFinal reportBeech A23-24 · Lock Haven, PAWhile taxiing for takeoff the left wing of the aircraft collided with the nose of a parked Piper twin. The pilot stated that during his instrument scan he noticed that the alternator failed to show a charge and that this may have distracted his attention as…NTSB FTW82DA040Accident · No injuriesFinal reportBeech A23-24 · Hobbs, NMThe pilot attempted to takeoff on a runway with icy patches, lost control and slid off the side into a snowbank. The pilot did not possess any type of pilots certificate due to the fact that he could not pass a medical examination.