NTSB investigations: Beech C-45H

6 cases on aircraft the registry lists as Beech C-45H, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Beech C-45H per year, 1982–2026: 6 cases
1982	2
1984	1
1991	2
1993	1

Where

Open the map

Latest cases

Query with SQL

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 ('1151018', '1151019') 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

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 ('1151018', '1151019')
      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 ('1151018', '1151019')
    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

Run 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 FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.Apr 6, 1993 · N492DM · Destroyed NTSB FTW92LA003Accident · No injuriesLimited investigationFinal reportBeech C-45H · Edinburg, TXPower loss due to a loss of oil pressure for undetermined reasons. A factor was the lack of suitable terrain for forced landing.Oct 6, 1991 · N166ZA · Substantial damage NTSB LAX91LA228Accident · No injuriesLimited investigationFinal reportBeech C-45H · Lake Elsinore, CAFuel starvation due to an improper modification of the fuel system and the pilot's failure to ensure that the aircraft was airworthy prior to flight.May 29, 1991 · N9903Z · Substantial damage NTSB DEN85LA018Accident · No injuriesLimited investigationFinal reportBeech C-45H · Heber City, UTWhile in cruise flt, plt noted gradual left eng oil press drop from normal 70 PSI to 20 PSI. Plt shut down left eng, feathered prop and diverted to alternate airport. En route to alternate plt attempted to restart left eng to avoid single-engine landing. Plt…Oct 25, 1984 · N9561Z · Substantial damage NTSB ANC82DA100Accident · No injuriesFinal reportBeech C45H · Near Deering, AKThe aircraft slid wheels up into a lake during a one-engine forced landing. The aircraft sank and was not recovered but all the occupants were able to reach shore uninjured. The pilot said the left engine lost power during cruise and he elected to shut it…Sep 27, 1982 · N3120G NTSB FTW82DA093Accident · 1 fatalFinal reportBeech C-45H · Mcallen, TXAbout 18 minutes after takeoff, the pilot radioed that the no. 2 engine had lost power and that he was returning to land at Mcallen, TX. While approaching to land, the aircraft crashed in an open field about 400 yards short of the runway and 115 feet right of…Mar 15, 1982 · N9846Z · Destroyed