NTSB investigations: Beech 95-B55 (T42A), 1987
5 cases on aircraft the registry lists as Beech 95-B55 (T42A). 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
| 1964 | 4 |
|---|---|
| 1965 | 10 |
| 1966 | 9 |
| 1967 | 12 |
| 1968 | 9 |
| 1969 | 8 |
| 1970 | 9 |
| 1971 | 8 |
| 1972 | 3 |
| 1973 | 11 |
| 1974 | 6 |
| 1975 | 8 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 5 |
| 1979 | 8 |
| 1980 | 11 |
| 1981 | 5 |
| 1982 | 7 |
| 1983 | 9 |
| 1984 | 9 |
| 1985 | 5 |
| 1986 | 9 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 7 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 6 |
| 2026 | 2 |
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 ('1152706'))
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 ('1152706'))
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 FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…NTSB ATL87FA268Accident · 5 fatalField investigationFinal reportBeech 95-B55 · Manteo, NCWitness observed acft settle into ocean during low level cruise flt adjacent to beach. Wx was ovrcst, indistinct horizon & calm sea. IFR flt plan had been filed but no contact was made with ATC. Engines and propeller examination did not reveal a mechanical…NTSB SEA87IA139Incident · No injuriesIncident investigationFinal reportBeech 55 · Rigby, IDDuring descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed…NTSB ATL87LA129Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He…NTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…