NTSB investigations: Beech A24R, 1983
4 cases on aircraft the registry lists as Beech A24R. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 5 |
| 1974 | 5 |
| 1975 | 3 |
| 1978 | 3 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 5 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2017 | 2 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151252'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151252'))
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 NYC84FHM02Accident · Minor injuriesFinal reportBeech A24R · Spring Valley, NYThe acft went off the end of the rwy during an aborted takeoff after the engine backfired and ran rough. The plt closed the throttle as he discontinued the takeoff. Before the acft could be stopped it went off the rwys end and down an embankment. Post…NTSB CHI83LA349Accident · No injuriesLimited investigationFinal reportBeech A24R · Verona, WIThe acft lost power during cruise and was damaged in an off arpt forced landing. During the landing roll in a field, acft contacted a fence and collapsed the nose gear. Examination of the bendix fuel injector SN30479, model RSA-5AD1 revealed that the fuel…NTSB NYC83LA151Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Montauk, NYThe acft landed short of the runway and collided with an embankment breaking the nose gear. The pilot stated the final approach was flown low and about 70 mph. At about 10-20 ft above the ground the acft started to sink and the pilotsaid he applied back…NTSB LAX83LA161Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Upland, CAWhile on final apch to land, the plt saw 2 other acft taxi onto the rwy & began taking off. After the 2nd acft had pulled onto the rwy, the plt decided to go around. However as the acft on the rwy accelerated, there appeared to be sufficient room to land, so…