NTSB investigations, CA
9 cases where the sequence of events included Windshear or thunderstorm.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2021 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '390' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '390' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46R-350T · Tehachapi, CAThe pilot’s encounter with mountain wave activity with severe turbulence, which resulted in a loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a preflight weather briefing.NTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.NTSB GAA16CA228Accident · No injuriesData collectionFinal reportBeech C23 · Yucca Valley, CAThe pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.NTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.NTSB WPR14CA097Accident · No injuriesData collectionFinal reportCameron Balloons US A-400 · Napa, CAFailure to maintain clearance from obstacles during a descent that resulted in an inadvertent collision with a pole.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB WPR10CA175Accident · No injuriesData collectionFinal reportBeech 23 · Twenty Nine Palms, CAThe pilot's encounter with a wind shear/downdraft that exceeded the climb performance capabilities of the airplane during initial climb.NTSB LAX08CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Lake Tahoe, CAThe pilot's inadequate compensation for the wind and density altitude conditions and failure to attain and maintain an adequate airspeed that resulted in a stall/mush.NTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.