NTSB investigations, AK
8 cases where the first occurrence was “Nose down”.
Cases per year
| 1989 | 1 |
|---|---|
| 1993 | 2 |
| 1994 | 3 |
| 1996 | 1 |
| 2001 | 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\" = 290)
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" = 290) 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 ANC01LA038Accident · No injuriesLimited investigationFinal reportForney F-1A · Whittier, AKThe pilot's inadequate preflight planning/preparation, and his selection of unsuitable terrain for landing. A factor in the accident was snow-covered terrain.NTSB ANC96IA085Incident · No injuriesIncident investigationFinal reportChampion 7GCBC · Naknek, AKThe inadequate visual lookout of the vehicle driver, and the inadequate visual lookout of the pilot. A factor was the State of Alaska's failure to provide taxiway hazard warning signs which would alert vehicles of the active aerodrome.NTSB ANC95LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Unalakleet, AKThe pilot's inadequate compensation for a crosswind condition. A crosswind was a factor in the accident.NTSB ANC94LA118Accident · No injuriesLimited investigationFinal reportCessna 150J · Talkeentna, AKThe unsuitable takeoff area selected. A factor was the soft spot in the airstrip's surface.NTSB ANC94FA089Accident · No injuriesField investigationFinal reportAerospatiale AS-350 · Juneau, AKThe pilot's selection of unsuitable landing terrain. A factor was the crevasse in the ice.NTSB ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.NTSB ANC93LA078Accident · No injuriesLimited investigationFinal reportCessna 206G · Igiugig, AKThe pilot in command selected unsuitable terrain for landing.NTSB ANC89LA127Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Alexander Creek, AKThe pilot failed to maintain control of the aircraft during the landing flare/touchdown. Turbulence was a contributing factor.