NTSB investigations: Beech C23, NM
8 cases on aircraft the registry lists as Beech C23. 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1983 | 1 |
| 1988 | 1 |
| 2008 | 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 c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151242'))
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 c."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151242'))
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 DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DEN88LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Gallup, NMThe private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and…NTSB FTW83LA312Accident · Serious injuriesLimited investigationFinal reportBeech C-23 · Albuquerque, NMThe aircraft impacted 2.2 miles off the departure end of runway 35 at coronada airport. Witnesses stated the aircraft used almost all of the 4020 ft runway before becoming airborne and the aircraft achieved an altitude of only 20 feet. Investigation revealed…NTSB DEN79FQA32Accident · No injuriesClosedBeech C23 · Albuquerque, NMNTSB DEN79DQG03Accident · No injuriesClosedBeech C-23 · Clovis, NMNTSB DEN78FQA48Accident · No injuriesClosedBeech C23 · Grants, NMNTSB DEN77FA055Accident · 2 fatalClosedBeech C-23 · Miami, NMNTSB DEN76FQA61Accident · No injuriesClosedBeech 23 · Albuquerque, NM