NTSB investigations, AK
19 cases where the first occurrence was “Missing aircraft”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1986 | 2 |
| 1990 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 420)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 420) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ANC06FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 690A · Anchorage, AKUndetermined; the airplane and its occupants are missing.NTSB ANC04FAMS2Accident · 5 fatalMissing aircraftFinal reportde Havilland DHC-2 · Sitka, AKReason for occurrence is undetermined. The airplane is missing.NTSB ANC03FAMS1Accident · 2 fatalMissing aircraftFinal reportAlon A-2 (Aircoupe) · Ketchikan, AKUndetermined. .NTSB ANC01FAMS1Accident · 2 fatalMissing aircraftFinal reportChampion 8GCBC · Juneau, AKUndetermined. Missing airplane.NTSB ANC99FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Chitina, AKUndetermined.NTSB ANC99FAMS1Accident · 2 fatalMissing aircraftFinal reportPiper PA-24-260 · Juneau, AKUndetermined. Missing aircraft.NTSB ANC97FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 182F · Talkeetna, AKUndetermined.NTSB ANC96FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman G21-G · Dutch Harbor, AKUndetermined.NTSB ANC95FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 206 · Kenai, AKUndetermined.NTSB ANC92FAMS3Accident · 2 fatalMissing aircraftFinal reportBeech 35 · Missing, AKMissing aircraft due to undetermined causes and factorsNTSB ANC92FAMS2Accident · 5 fatalMissing aircraftFinal reportCessna 340 · Yakutat, AKMissing aircraft due to undetermined causes.NTSB ANC91GAMS1Accident · 3 fatalFinal reportGulfstream Aerospace 690C · Deadhorse, AKMissing aircraft.NTSB ANC86LA062Accident · 3 fatalLimited investigationFinal reportLake LA-4-200 · Lake Clark, AKThe aircraft crashed in Lake Clark, Alaska, and sank into 170 feet of water. There were no witnesses to the accident; the aircraft was not recovered.NTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…NTSB ANC84FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-12 · Anchorage, AKThe acft departed on 9-27-84 and was reported missing the following day. USAF rcc conducted 140 unsuccessful search missions. No wreckage was ever discovered. Both occupants are presumed to have been fatally injured.NTSB ANC84FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna U206G · AKPlt received 2 wx briefings before the one hour fourty five minute flt. Plt was advised of adverse wx conditions in mountains with high winds and frequent low visibility. Icing conditions were also forecast btw 9,000 and 13,000 ft. the acft is still missing…NTSB ANC84LAMS1Accident · 5 fatalFinal reportCessna 401 · Anchorage, AKAt 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…NTSB ANC84FA013Accident · 4 fatalField investigationFinal reportCessna 206 · Kenai, AKThe acft departed nondalton, AK at aprx 1135 yst on a flt to Kenai, AK. At aprx 1215 yst, the plt report that he was over west forelands & requested the Kenai wx. About 4 min later, he requested a df steer to the Kenai arpt. A short time later, radio contact…NTSB ANC82DAG59Accident · 3 fatalFinal reportCessna 180 · Missing Acft, AKAircraft disappeared on this flight of 9/7/82. No flight plan was filed but it is believed pilot was on round robin from lake hood to two lakes and return.