NTSB investigations, CA
10 cases where the sequence of events included Inflight upset.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 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\" = '271' 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" = '271' 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 WPR25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportLockheed C-130A · Daggett, CAAn inflight upset due to an improperly secured load that resulted in serious injuries.NTSB WPR22LA284Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier BD-100-1A10 · San Francisco, CAAn inflight upset resulting in serious injury to the cabin attendant following an autopilot disconnect for reasons that could not be determined based on the available information.NTSB WPR19LA135Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Oxnard, CAThe pilot’s inability to maintain control of the helicopter while maneuvering at a low altitude due to reasons that could not be determined based on available evidence.NTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB WPR13LA233Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164D · Butte City, CAThe pilot's failure to maintain airplane control after an encounter with wake turbulence while maneuvering at low altitude. Contributing to the accident was the pilot’s fatigue due to extended hours of wakefulness and high workload.NTSB WPR12FA203Accident · 1 fatalField investigationFinal reportM Squared Breese · Whitewater, CAThe pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.NTSB WPR11FA239Accident · 1 fatalField investigationFinal reportBrantly B-2B · Weaverville, CAThe student pilot's decision to fly in windy conditions that exceeded his capabilities, which resulted in his subsequent loss of helicopter control. Contributing to the accident was his lack of flight experience in the accident helicopter.NTSB WPR11IA213Incident · No injuriesIncident investigationFinal reportCessna 421B · Truckee, CAFatigue failure of the right flap extend cable during the landing approach.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.