NTSB investigations, CA
4 cases where NTSB found Snow/slush/ice covered surface.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2021 | 1 |
| 2026 | 1 |
Where
Latest 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023015'))
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" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03023015')) 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 WPR26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Kneeland, CAThe pilot’s failure to maintain airplane control during landing roll on a snow-covered runway.NTSB WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.NTSB WPR11CA148Accident · No injuriesData collectionFinal reportCessna A150M · Grass Valley, CAThe aircraft's encounter with deep snow during the landing roll out. Contributing to the accident was the airport manager's failure to update the AWOS recording to reflect the closure of the runway due to snow.NTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.