NTSB investigations: Beech C-45H, FL
16 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.
Cases per year
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 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\" = 'FL' 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" = 'FL' 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" 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 MIA98IA006Incident · No injuriesIncident investigationFinal reportBeech 18 [C-45H] · Orlando, FLthe failure of the landing gear chain from the main landing gear torque shaft to the nose gear box coming off the sprocket, causing the landing gear to be out of sequence between the main gear and the nose gear.NTSB MIA92LA019Accident · No injuriesLimited investigationFinal reportBeech C-45H · Fort Lauderdale, FLHard landing due to failure of the pilot-in-command to maintain the proper descent rate. Contributing to the accident was the turbulence encountered during the apch.NTSB MIA89FA124Accident · Serious injuriesField investigationFinal reportBeech C-45H · Tampa, FLFuel contamination of the left engine fuel system which resulting in a failure of the left engine.NTSB MIA83FA062Accident · Serious injuriesField investigationFinal reportBeech C45H · Leesburg, FLThe acft crashed into a lake during a forced landing after the engines quit. The PIC had gone for a local flt with a plt/passenger. After a few minutes of flt he announced that they did not have any fuel. The acft was on an approach to return when both…NTSB MIA79DKT16Accident · No injuriesClosedBeech 18 · Palm Beach, FLNTSB MIA76AM109Accident · 2 fatalClosedBeech C-45H · W Palm Beach, FLNTSB MIA75DLD43Accident · No injuriesClosedBeech C-45H · Palma Sola, FLNTSB MIA74FKT68Accident · No injuriesClosedBeech C-45H · Naples, FLNTSB MIA74FKT11Accident · No injuriesClosedBeech C-45H · Indiantown, FLNTSB MIA73FKT50Accident · Serious injuriesClosedBeech C45H · Opa Locka, FLNTSB MIA72IM074Incident · No injuriesClosedBeech C-45H · Jacksonville, FLNTSB MIA70FLD31Accident · No injuriesClosedBeech C-45H · Daytona Beach, FLNTSB MIA70A0010Accident · No injuriesClosedBeech C-45H · Patrick Afb, FLNTSB MIA69D0069Accident · No injuriesClosedBeech D18 · Ft.Lauderdale, FLNTSB MIA68F0350Accident · No injuriesClosedBeech C-45H · Miami, FLNTSB MIA65D0068Accident · No injuriesClosedBeechcraft D-18S · Miami, FL