NTSB investigations: Beech C23, TN
10 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 |
|---|---|
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2026 | 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\" = 'TN' 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" = 'TN' 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 ERA26LA128Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C23 · Knoxville, TNThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collision with a ditch.NTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.NTSB MIA00FA177Accident · 2 fatalField investigationFinal reportBeech C23 · Smyrna, TNThe failure of the dual student to maintain airspeed following total loss of engine power resulting in an inadvertent stall and subsequent uncontrolled descent. Also, inadequate supervision by the CFI for her failure to note the position of the fuel selector…NTSB ATL94LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Collegedale, TNThe pilot's failure to compensate for wind conditions during a crosswind landing. The crosswind was a factor.NTSB ATL91LA027Accident · No injuriesLimited investigationFinal reportBeech 23C · Dunlap, TNThe pilot's failure to use the carburetor heat properly, which resulted in the formation of carburetor ice, followed by a complete loss of engine power. Factors to this accident were carburetor icing conditions and the rough and uneven terrain at the crash…NTSB ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB ATL82DA048Accident · No injuriesFinal reportBeech C-23 · Nashville, TNThe accident occurred while the pilot was making a touch and go landing on his second supervised solo flight. After touchdown on his first landing, the pilot inadvertently pulled back on the control yoke while adding power and raising the flaps. The nose…NTSB IAD77FA035Accident · 1 fatalClosedBeech C23 · Knoxville, TN