NTSB investigations: Beech C-45H, MI

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

19672026

NTSB investigations: Beech C-45H, MI per year, 1967–2026: 11 cases
1967	1
1969	1
1972	1
1973	1
1974	1
1975	1
1976	1
1977	1
1979	1
1995	1
1996	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."eventStateOrRegion" = 'MI' 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 ('1151018', '1151019')) 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.\"eventStateOrRegion\" = 'MI' 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 ('1151018', '1151019'))
  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" = 'MI' 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 ('1151018', '1151019'))
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 CHI96LA243Accident · No injuriesLimited investigationFinal reportBeech C-45H · Marshall, MIfailure of the pilot to maintain directional control during the takeoff roll, which resulted in an inadvertent ground swerve. The crosswind (quartering headwind) was a related factor.Jul 14, 1996 · N9772Z · Substantial damage NTSB CHI95LA075Accident · No injuriesLimited investigationFinal reportBeech C45H · New Hudson, MIThe owner/pilot's inadequate maintenance practices which resulted in a loss of engine power shortly after takeoff and the pilot's inadequate emergency procedure after the power loss occurred. Related factors are trees, diminished airspeed and abrupt touchdown.Jan 24, 1995 · N618K · Substantial damage NTSB CHI79FA076Accident · 4 fatalClosedBeech C-45H · Hastings, MISep 15, 1979 · N600NA · Destroyed NTSB CHI77FA070Accident · Minor injuriesClosedBeech C-45H · Ypsilanti, MIAug 31, 1977 · N125TF · Destroyed NTSB CHI76AC078Accident · 1 fatalClosedBeech C-45H · Detroit, MIJul 9, 1976 · N34CB · Destroyed NTSB CHI75AC052Accident · No injuriesClosedBeech C-45H · Detroit, MIJan 15, 1975 · N45437 · Substantial damage NTSB CHI74AC068Accident · No injuriesClosedBeech C-45H · South Haven, MIFeb 9, 1974 · N9929Z · Substantial damage NTSB CHI74AC046Accident · Serious injuriesClosedBeech C-45H · Plymouth, MIDec 5, 1973 · N9909Z · Destroyed NTSB CHI72FEM43Accident · No injuriesClosedBeech C-45H · Freeland, MIJan 14, 1972 · N118X · Substantial damage NTSB CHI70F0176Accident · No injuriesClosedBeech C-45H · Jackson, MIJul 23, 1969 · N9800H · Destroyed NTSB CHI68F0500Accident · No injuriesClosedBeech C-45 · Waterford, MIDec 16, 1967 · N9800H · Substantial damage