NTSB investigations: Beech C-45H, 1966
10 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\") = 1966
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") = 1966
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 FTW67A0054Accident · No injuriesClosedBeech C-45H · El Paso, TXNTSB OAK67F0134Accident · Serious injuriesClosedBeech C-45H · Honolulu, HINTSB SEA67F0131Accident · No injuriesClosedBeech C-45H · Lakeview, ORNTSB LAX67D0064Accident · No injuriesClosedBeech D18 · Van Nuys, CANTSB OAK67D0025Accident · No injuriesClosedBeech D18S · San Jose, CANTSB OAK66F0263Accident · No injuriesClosedBeech C-45H · Honolulu, HINTSB MIA66A0120Accident · 1 fatalClosedBeech D18S · Taylorsville, NCNTSB UNK66X0136Accident · 12 fatalClosedBeech C-45H · Nogales, MexicoNTSB NYC66F0493Accident · No injuriesClosedBeechcraft C45H · Windsor Locks, CTNTSB OAK66D0174Accident · No injuriesClosedBeechcraft C45H · San Francisco, CA