NTSB investigations: Beech C24R
12 cases on aircraft the registry lists as Beech C24R, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2004 | 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 ('1151254')
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\" = 353))
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 ('1151254')
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" = 353))
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 NYC07FA200Accident · Serious injuriesField investigationFinal reportBeech C24R · Niceville, FLThe pilot’s inadequate preflight inspection of the fuel quantity.NTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.NTSB MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.NTSB NYC99LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-24R · Farmingdale, NYThe pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.NTSB FTW97LA294Accident · No injuriesLimited investigationFinal reportBeech C24R · Pollock, LAThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB ATL90LA140Accident · No injuriesLimited investigationFinal reportBeech C24R · Brunswick, NCEngine malfunction for undetermined reasons. A factor in the accident was the unseen ditch with which the airplane collided.NTSB MIA87LA101Accident · No injuriesLimited investigationFinal reportBeech C24R · Milton, FLThe acft crashed in a river aprx 1 mile west of his alternate landing location after the eng quit while descending for an apch, due to fuel exhaustion.NTSB DEN84LA304Accident · No injuriesLimited investigationFinal reportBeech C24R · Bismarck, NDPlt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were…NTSB ATL83LA143Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Waycross, GADuring flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly…NTSB DEN82DA172Accident · No injuriesFinal reportBeech C24R · Palisade, COAccording to the pilot, the flight departed the arapahoe airport with the fuel tanks half full because of passenger load factor. As the aircraft approached within 45 miles of the destination airport, the pilot switched from the right fuel tank to the left…NTSB NYC82FA199Accident · 3 fatalField investigationFinal reportBeech C24R · Trenton, NJDuring an approach to the mercer county airport at Trenton, n.j., the aircraft lost power and landed off airport in trees. The fuel selector was found positioned between left tank and off. The pilot attempted to fly to the runway, but unable. The aircraft…