NTSB investigations: Beech C23, CT
7 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
| 1977 | 1 |
|---|---|
| 1980 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2007 | 1 |
| 2016 | 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\" = 'CT' 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" = 'CT' 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 ERA16CA308Accident · No injuriesData collectionFinal reportBeech C23 · Simsbury, CTThe student pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.NTSB NYC90LA190Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Burlington, CTThe CFI failed to maintain a safe sink rate resulting in an undershoot of the runway.NTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…NTSB NYC81FNE01Accident · No injuriesClosedBeech C23 · Ellington, CTNTSB NYC77FNE26Accident · Serious injuriesClosedBeech C23 · East Haddam, CT