NTSB investigations: Interstate S-1B1, AK
6 cases on aircraft the registry lists as Interstate S-1B1. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1976 | 1 |
| 1986 | 1 |
| 1999 | 1 |
| 2002 | 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 c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1850302'))
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 c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1850302'))
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 ANC02LA026Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Big Lake, AKThe separation of the exhaust system stack from the heat exchanger. A factor associated with the accident was an engine compartment fire.NTSB ANC99LA030Accident · Minor injuriesLimited investigationFinal reportInterstate S-1B1 · Anchorage, AKFuel starvation resulting from the pilot not understanding the fuel system procedures, and selecting the improper fuel selector position.NTSB ANC87LA007Accident · 1 fatalLimited investigationFinal reportInterstate S-1B1 · Eureka Creek, AKThe pilot lost control of the aircraft on landing & it collided with a large metal sluice box that was located beside the runway. At the time of the accident, the wind was from the northeast & was gusty. The dirt ruway was frozen, rough &rutted.NTSB ANC76FAG94Accident · No injuriesClosedInterstate S1B1 · Wasilla, AKNTSB ANC72AA037Accident · 1 fatalClosedInterstate S-1B1 · Skwentna, AKNTSB ANC71DAG62Accident · No injuriesClosedInterstate S-1B1 · Talkeetna, AK