NTSB investigations: Beech C-45H, TX
18 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 3 |
| 1973 | 3 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1982 | 1 |
| 1991 | 1 |
| 1993 | 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\" = 'TX' 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" = 'TX' 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 FTW93LA257Accident · 1 fatalLimited investigationFinal reportBeech C-45H · Fentress, TXInadvertent deployment of the skydiver's reserve parachute for undetermined reasons.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.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…NTSB FTW77DRG60Accident · No injuriesClosedBeech C-45 · Del Rio, TXNTSB FTW77FRG31Accident · No injuriesClosedBeech C45H · San Benito, TXNTSB FTW76FRA29Accident · No injuriesClosedBeech D18S · Pearland, TXNTSB FTW75HF017Accident · No injuriesClosedBeech C-45H · Euless, TXNTSB FTW74AF047Accident · 1 fatalClosedBeech C-45H · Dallas, TXNTSB FTW74AF045Accident · Serious injuriesClosedBeech C-45H · Waco, TXNTSB FTW74AF008Accident · No injuriesClosedBeech C-45H · Dallas, TXNTSB FTW72FQD15Accident · No injuriesClosedBeech C-45H · Marfa, TXNTSB FTW72AF008Accident · No injuriesClosedBeech C-45H · Dallas, TXNTSB FTW71AF038Accident · No injuriesClosedBeech E18 · Waco, TXNTSB FTW71AF006Accident · No injuriesClosedBeech C-45H · Dallas, TXNTSB FTW69A0047Accident · No injuriesClosedBeech C-45H · Midland, TXNTSB FTW67A0054Accident · No injuriesClosedBeech C-45H · El Paso, TXNTSB FTW66A0034Accident · No injuriesClosedBeechcraft C45H · Killeen, TXNTSB UNK65X1046Accident · No injuriesClosedBeechraft C45H · Boerne, TX