NTSB investigations: Beech C-45H, 1967
22 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 | 8 |
|---|---|
| 1965 | 20 |
| 1966 | 10 |
| 1967 | 22 |
| 1968 | 10 |
| 1969 | 11 |
| 1970 | 13 |
| 1971 | 8 |
| 1972 | 10 |
| 1973 | 10 |
| 1974 | 7 |
| 1975 | 4 |
| 1976 | 5 |
| 1977 | 9 |
| 1978 | 6 |
| 1979 | 7 |
| 1981 | 3 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 6 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2004 | 2 |
| 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 year(c.\"eventDate\") = 1967
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 year(c."eventDate") = 1967
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 CHI68A0055Accident · No injuriesClosedBeech C45H · Chicago, ILNTSB CHI68F0500Accident · No injuriesClosedBeech C-45 · Waterford, MINTSB MIA68F0350Accident · No injuriesClosedBeech C-45H · Miami, FLNTSB OAK68A0047Accident · 3 fatalClosedBeech C-45H · Sanger, CANTSB OAK68D0192Accident · Minor injuriesClosedBeech C-45H · Lanai, HINTSB CHI68A0041Accident · 1 fatalClosedBeech C-45H · Aurora, WINTSB NYC68A0054Accident · No injuriesClosedBeech D18S · Jamaica, NYNTSB DEN68A0018Accident · 3 fatalClosedBeech C-45H · Farmington, NMNTSB UNK67X0149Accident · 4 fatalClosedBeech C-45 · Danang, VMNTSB LAX68A0006Accident · 2 fatalClosedPiper PA-28 · Sepulveda, CANTSB MIA68A0007Accident · No injuriesClosedBeech C-45H · Ponce, PRNTSB UNK67X0131Accident · No injuriesClosedBeech C-45 · Udorn, ThailandNTSB DEN68F0001Accident · No injuriesClosedBeech C-45 · Saratoga, WYNTSB DEN67A0067Accident · 1 fatalClosedBeech C-45H · Lake City, CONTSB CHI67A0112Accident · 9 fatalClosedBeech C-45H · Lexington, KYNTSB MIA67D0476Accident · No injuriesClosedBeech C-45 · St.Maarten (Atlantic Ocean)NTSB MKC68F0239Accident · No injuriesClosedBeech C-45 · Portage D-Siox, MONTSB OAK67D0245Accident · No injuriesClosedBeech C-45H · Pacific Ocean (Pacific Ocean)NTSB DIA67A0011Accident · 2 fatalClosedBeech C-45H · Middletown, DENTSB FTW67A0095Accident · No injuriesClosedBeech C-45H · New Orleans, LANTSB UNK67X0113Accident · No injuriesClosedBeech C-45 · Xuan Loc, VMNTSB FTW67D0442Accident · No injuriesClosedBeech C-45H · Tulsa, OK