NTSB investigations: Beech 23
12 cases on aircraft the registry lists as Beech 23, where the first occurrence was “Loss of engine power”. 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
| 1986 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151202')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151202')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB MIA03LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Punta Gorda, FLA loss of engine power for undetermined reasons.NTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.NTSB CHI99LA142Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Houghton Lake, MIThe loss of engine power for undetermined reasons.NTSB SEA98LA133Accident · No injuriesLimited investigationFinal reportBeech 23 · Oakville, WALoss of power due to the failure of an exhaust valve, and overloading of the landing gear. Factors include the failure of maintenance personnel to verify proper compliance with an Airworthiness Directive related to the exhaust valve, and soft terrain.NTSB CHI96FA209Accident · 2 fatalField investigationFinal reportBeech 23 · Fulton, MOthe inadequate intake valve springs on the #1 cylinder.NTSB ATL96LA007Accident · No injuriesLimited investigationFinal reportBeech 23 · Newnan, GAa loose fuel line fitting, which resulted in a fuel leak and premature emptying of the left fuel tank; failure of the pilot to follow the checklist (select the fullest fuel tank for landing); fuel starvation; and subsequent Loss of engine power, while on…NTSB LAX95LA333Accident · No injuriesLimited investigationFinal reportBeech 23 · Las Vegas, NVthe loss of engine power for undetermined reasons. The soft and rough nature of the terrain available for the forced landing was a factor in the accident.NTSB CHI91LA275Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Jenison, MIFailure of the pilot to perform remedial action during fuel system carburetor icing.NTSB ATL89LA221Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Hatteras, NCLoss of engine power for an unknown reason.NTSB CHI88DEC01Accident · Minor injuriesFinal reportBeech 23 · Brighton, MIThe unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…NTSB CHI87LA028Accident · No injuriesLimited investigationFinal reportBeech 23 · Laporte, INThe plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto…