NTSB investigations, AK
6 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1996 | 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\" = 410)
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" = 410) 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 ANC96FA072Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-11-F · Anchorage, AKthe pilot's improper in-flight planning/decision, which allowed the airplane (MD-11) to encounter wake turbulence from a larger/heavy jet airplane (Boeing 747), while on a short final approach for landing on a close-by/parallel runway with a staggered…NTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.NTSB ANC90FA079Accident · No injuriesField investigationFinal reportCessna 195 · Anchorage, AKThe pilot's failure to follow wake turbulence avoidance procedures.NTSB ANC88FA019Accident · Minor injuriesField investigationFinal reportCessna 402B · Anchorage, AKDrg arr in hvy traffic, reeve flt 726 (Boeing 727) & wilburs flt 304 (Cessna 402B, N969JW) recd radar adzys for visual apchs to rwys 6L & 6R, respectively. Subsequently, both flts were clrd to lnd. At 1555:04, the LCL twr ctlr transmitted that the wnd at the…NTSB ANC87LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · King Salmon, AKThe pilot was cleared to taxi his airplane into position and to hold behind a cherokee six airplane. After the cherokee six departed, he was cleared for takeoff. Immediately after lift off at 10 to 15 feet above the runway, the pilot stated the airplane went…NTSB ANC83LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Anchorage, AKShortly after departure the flt received radar vectors placing it near a VFR reporting point located 4 mi past the departure end of rwy 32 & 2 mi east of the rwy centerline. Traffic advisories were issued by approach control indicating a beoing 747 climbing…