NTSB investigations: Beech D18S, 1984
2 cases on aircraft the registry lists as Beech D18S. 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 | 17 |
|---|---|
| 1965 | 19 |
| 1966 | 24 |
| 1967 | 23 |
| 1968 | 10 |
| 1969 | 19 |
| 1970 | 21 |
| 1971 | 8 |
| 1972 | 16 |
| 1973 | 12 |
| 1974 | 12 |
| 1975 | 10 |
| 1976 | 11 |
| 1977 | 10 |
| 1978 | 9 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2007 | 1 |
| 2016 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151004'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151004'))
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 ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…NTSB FTW84LA317Accident · No injuriesLimited investigationFinal reportBeech D-18S · Mcallen, TXThe PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main…