NTSB investigations: Beech H-18, 1983
3 cases on aircraft the registry lists as Beech H-18. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 2 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 4 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 6 |
| 1982 | 1 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1997 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 2 |
| 2009 | 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151012'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151012'))
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 NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…NTSB LAX83LA427Accident · Serious injuriesLimited investigationFinal reportBeech H18S · Kailua-Kona, HIAbout 1 min after takeoff, between 400-500 ft MSL & during the first power reduction, the right eng backfired. Followingsome more violent backfires the RPM went to zero. The right eng was restarted but the same result occurred. The plt attempted to feather…NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…