NTSB investigations: Arctic S-1B2, 1988
2 cases on aircraft the registry lists as Arctic S-1B2. 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
| 1979 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2017 | 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0790208'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0790208'))
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 ANC88LA116Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Hartman River, AKThe pilot had just taken off from a sand bar. During climb-out on the downwind leg, he felt the engine was not producing the proper power because the airspeed was dropping and the climb had stopped. He made a left turn and crash landed on the sand bar to…NTSB ANC88LA107Accident · 2 fatalLimited investigationFinal reportArtic S-1B2 · Kotzebue, AKThe airplane crashed at 2700 feet m.s.l. in a box canyon while maneuvering at low level & scouting for sheep. The top of the ridge was approximately 3200 feet m.s.l. the investigation revealed that the pilot was trying to outclimb the ridge when the airplane…